# CData Connect Cloud MCP Server

Enable AI agents to query and manage cloud-connected data sources using SQL, metadata introspection, and stored procedures. Integrate with AI workflows to enhance data-driven decision making.

## Quick Start

```bash
# Connect this server (installs CLI if needed)
npx -y @smithery/cli@latest mcp add CDataSoftware/connectcloud-mcp-server

# Browse available tools
npx -y @smithery/cli@latest tool list CDataSoftware/connectcloud-mcp-server

# Get full schema for a tool
npx -y @smithery/cli@latest tool get CDataSoftware/connectcloud-mcp-server queryData

# Call a tool
npx -y @smithery/cli@latest tool call CDataSoftware/connectcloud-mcp-server queryData '{}'
```

## Tools (12)

- `queryData` — Execute SQL queries against connected data sources and retrieve results
- `execData` — Execute stored procedures against connected data sources
- `getCatalogs` — Retrieve a list of available connections from CData Connect Cloud.  The connection names should be used as catalog name…
- `getColumns` — Retrieve a list of available database columns from CData Connect Cloud for a specific catalog, schema, and table
- `getExportedKeys` — Retrieve a list of foreign key relationships from CData Connect Cloud for a specific catalog, schema, and table
- `getImportedKeys` — Retrieve a list of foreign key relationships from CData Connect Cloud for a specific catalog, schema, and table
- `getIndexes` — Retrieve a list of indexes from CData Connect Cloud for a specific catalog, schema, and table
- `getPrimaryKeys` — Retrieve a list of primary keys from CData Connect Cloud for a specific catalog, schema, and table
- `getProcedureParameters` — Retrieve a list of stored procedure parameters from CData Connect Cloud for a specific catalog, schema, and procedure
- `getProcedures` — Retrieve a list of stored procedures from CData Connect Cloud for a specific catalog and schema
- `getSchemas` — Retrieve a list of available database schemas from CData Connect Cloud for a specific catalog.  Use the `getTables` too…
- `getTables` — Retrieve a list of available database tables from CData Connect Cloud for a specific catalog and schema.  Use the `getC…

```bash
# Get full input/output schema for a tool
npx -y @smithery/cli@latest tool get CDataSoftware/connectcloud-mcp-server <tool-name>
```

---

Source: https://github.com/CDataSoftware/connectcloud-mcp-server