メインコンテンツへスキップ

Documentation Index

Fetch the complete documentation index at: https://docs.cloud.cdata.com/llms.txt

Use this file to discover all available pages before exploring further.

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. Connect AI supports both OAuth and Basic Authentication. Basic Authentication requires the Connect AI User Id and the PAT generated on the Connect AI Settings page. See Authentication for more details.

​
MCP Tools

LLMs depend on the use of data resources to return data. The Connect AI MCP Server uses the following tools to provide data in response to natural-language questions:
  • getCatalogs—retrieve a list of available connections from Connect AI.
  • getSchemas—retrieve database schemas from Connect AI for a specific catalog. Schemas organize tables and stored procedures within a catalog.
  • getTables—retrieve database tables from Connect AI for a specific catalog and schema.
  • getColumns—retrieve a list of available database columns from Connect AI 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 Connect AI for a specific catalog and schema. Stored procedures contain executable SQL logic within a schema.
  • getProcedureParameters—retrieve parameter metadata for stored procedures from Connect AI 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.