CDATA_USERNAME
: Your CData Connect Cloud usernameCDATA_PAT
: Your CData Connect Cloud Personal Access Tokentest
) and joins this MCP server as an agent. Rooms will be closed if they go inactive.Tools provided by this Server | Short Description |
---|---|
execData | Execute stored procedures against connected data sources |
getCatalogs | Retrieve a list of available connections from CData Connect Cloud. |
getColumns | Retrieve a list of database columns for a specific catalog, schema, and table. |
getExportedKeys | Retrieve foreign key relationships for a specific catalog, schema, and table. |
getImportedKeys | Retrieve imported key relationships for a specific catalog, schema, and table. |
getIndexes | Retrieve a list of indexes for a specific catalog, schema, and table. |
getPrimaryKeys | Retrieve primary keys for a specific catalog, schema, and table. |
getProcedureParameters | Retrieve parameters for a specific stored procedure. |
getProcedures | Retrieve a list of stored procedures for a specific catalog and schema. |
getSchemas | Retrieve a list of available database schemas. |
getTables | Retrieve a list of available database tables for a specific catalog and schema. |
queryData | Execute SQL queries against connected data sources and retrieve results |
execData
procedure
(string
): Stored procedure name to executedefaultSchema
(string
, optional): Default schemaparameters
(object
, optional): JSON object of parameters, all names must begin with @
getCatalogs
getColumns
catalogName
(string
, optional)columnName
(string
, optional)schemaName
(string
, optional)tableName
(string
, optional)getExportedKeys
catalogName
(string
, optional)schemaName
(string
, optional)tableName
(string
, optional)getImportedKeys
catalogName
(string
, optional)schemaName
(string
, optional)tableName
(string
, optional)getIndexes
catalogName
(string
, optional)schemaName
(string
, optional)tableName
(string
, optional)getPrimaryKeys
catalogName
(string
, optional)schemaName
(string
, optional)tableName
(string
, optional)getProcedureParameters
catalogName
(string
, optional)parameterName
(string
, optional)procedureName
(string
, optional)schemaName
(string
, optional)getProcedures
catalogName
(string
, optional)procedureName
(string
, optional)schemaName
(string
, optional)getSchemas
catalogName
(string
, optional)getTables
catalogName
(string
, optional)schemaName
(string
, optional)tableName
(string
, optional)queryData
query
(string
): SQL statement(s) to execute (separated by ;
)defaultSchema
(string
, optional): Default schemaparameters
(object
, optional): JSON object of query parametersschemaOnly
(boolean
, optional): If true, return only column metadata