Search

MCP

MCP

CData Connect Cloud supports connectivity to the Model Context Protocol (MCP), the open-source standard for connecting AI applications to external systems. It was developed by Anthropic to bridge the gap between structured data and large language models (LLMs). MCP can be used from any client integration that supports it, such as Claude, Microsoft Copilot Studio, and n8n. See AI Tools for a complete list of AI integrations.

To use MCP from a supported client tool, add the following URL to the Remote MCP Server URL field: https://mcp.cloud.cdata.com/mcp. Once you are connected to the MCP server, you can ask natural-language questions about your data.

Authentication

Authentication to MCP depends on the client integration tool. CData Connect Cloud supports both OAuth and Basic Authentication. Basic Authentication requires the CData Connect Cloud User Id and the PAT generated on the CData Connect Cloud Settings page.

See REST API for more details about authentication.

MCP Resources

LLMs depend on the use of data resources to return data. The CData Connect Cloud MCP Server uses the following resources to provide data in response to natural-language questions:

  • getCatalogs—retrieve a list of available connections from CData Connect Cloud.

  • getSchemas—retrieve database schemas from CData Connect Cloud for a specific catalog. Schemas organize tables and stored procedures within a catalog.

  • getTables—retrieve database tables from CData Connect Cloud for a specific catalog and schema.

  • getColumns—retrieve a list of available database columns from CData Connect Cloud for a specific catalog, schema, and table. This resource examines the table structure and column definitions.

  • queryData—execute SQL queries against the connected data sources and retrieve results.

  • getProcedures—retrieve stored procedures from CData Connect Cloud for a specific catalog and schema. Stored procedures contain executable SQL logic within a schema.

  • getProcedureParameters—retrieve parameter metadata for stored procedures from CData Connect Cloud for a specific catalog, schema, and procedure. Parameter metadata includes names, data types, and directions required for proper procedure execution.

  • executeProcedure—execute the stored procedure for the chosen catalog and schema.

Suggested Prompts

To get the most out of MCP integration tools, use specific, detailed prompts. If your prompts are ambiguous, the client tool, such as Microsoft Copilot Studio or Claude, may ask follow-up questions to clarify the data you want to retrieve. Refer to the CData Prompt Library for examples of specific prompts.