Queries and updates data in hundreds of SaaS apps and databases with SQL through one hosted MCP server, for agents in Claude, Copilot Studio, n8n and other MCP clients.
Use it now
Keep it with up to 9 other tools you're setting up, then share them all as one link.
Try this first
Ask your assistant, with CData Connect AI connected:
- Dataset Search
Use CData Connect AI to search datasets and fields: ‹what you're looking for›
- Metadata Browsing
Use CData Connect AI to list connections, schemas, tables and columns: ‹what you need›
- SQL Queries
Use CData Connect AI to run SELECT queries against connected data sources: ‹what you need›
Connect it over MCP
{
"mcpServers": {
"cdata-connect-ai": {
"url": "https://mcp.cloud.cdata.com/mcp"
}
}
}claude mcp add --transport http cdata-connect-ai https://mcp.cloud.cdata.com/mcp
In Grok, ChatGPT and other assistants, add a custom connector with the address https://mcp.cloud.cdata.com/mcp (how, step by step).
It may ask you to sign in to CData Software or for a key when you add it; the setup guide says which.
Setup guide: docs.cloud.cdata.com/en/Quick-Start-Guide
Compare
Press Compare to add it to the tray at the bottom of the window, then pick up to 2 others anywhere on the site.
- Access
- MCP
- Auth
- OAuth 2.0
- Skills
- 5
Skills
Dataset Search
Searches datasets and fields that match a natural-language question, returning fully qualified names, field descriptions and join hints.
Metadata Browsing
Lists connections, schemas, tables and columns with getCatalogs, getSchemas, getTables and getColumns to map a data source before querying it.
SQL Queries
Runs SELECT queries against connected data sources with queryData and returns CSV results, using fully qualified [Catalog].[Schema].[Table] names.
Row Inserts and Updates
Inserts and updates rows in a connected table with execute_insert and execute_update; the ops URL parameter can hide both for read-only use.
Stored Procedures
Lists stored procedures and their parameters, then executes them for a chosen catalog and schema with getProcedures and executeProcedure.
