connectcloud-mcp-server
If you are the rightful owner of connectcloud-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol (MCP) server for querying and managing data through CData Connect Cloud.
🧠 CData Connect Cloud MCP Server
A Model Context Protocol (MCP) server for querying and managing data through CData Connect Cloud. This server enables AI agents to interact with data using SQL, metadata introspection, and procedure execution.
✨ Features
- ✅ Execute SQL queries on cloud-connected data sources
- 🔄 Perform batch operations (INSERT, UPDATE, DELETE)
- ⚙️ Execute stored procedures
- 📚 Access metadata (catalogs, schemas, tables, columns)
🛠 Prerequisites
- Node.js v18 or higher
- A CData Connect Cloud account with API access
- A Personal Access Token (PAT) for authentication
⚙️ Setup
Installing via Smithery
To install CData Connect Cloud MCP Server for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install @CDataSoftware/connectcloud-mcp-server --client claude
Manual Installation
-
Clone the repository
git clone https://github.com/cdatasoftware/connectcloud-mcp-server.git cd connect-cloud-mcp-server
-
Install dependencies
npm install
-
Configure environment variables
Create a
.env
file with the following content:CDATA_USERNAME=your_username CDATA_PAT=your_personal_access_token # Optional LOG_ENABLED=false LOG_LEVEL=info CDATA_URL=https://your-test-environment-url
▶️ Running the Server
Development Mode
Use ts-node
for live development:
npm run dev
Production Mode
Build and start:
npm run build
npm start
🧰 Available Tools
🔹 Data Operations
Tool | Description |
---|---|
queryData | Execute SQL queries |
execData | Execute stored procedures |
🔹 Metadata Operations
Tool | Description |
---|---|
getCatalogs | Retrieve available catalogs |
getSchemas | List schemas in a catalog |
getTables | List tables in a schema |
getColumns | Get column metadata for a table |
getPrimaryKeys | Retrieve primary keys for tables |
getIndexes | Get index information for tables |
getImportedKeys | Retrieve foreign key columns that reference tables |
getExportedKeys | Retrieve foreign key columns referenced from tables |
getProcedures | List available procedures |
getProcedureParameters | Get procedure input/output params |
🤖 Usage with LLMs
This server is compatible with AI agents that implement the Model Context Protocol.
Example (TypeScript + MCP Agent)
const response = await agent.generateContent({
tools: [
{
name: "queryData",
parameters: {
query: "SELECT * FROM Salesforce1.Salesforce.Account LIMIT 10"
}
}
]
});
🐳 Running in Docker
Build the image
docker build -t mcp/connectcloud:latest -f Dockerfile .
🧩 Claude Desktop Integration
Add or edit this configuration to your claude_desktop_config.json
under the mcpServers
section:
🔹 From Docker
{
"mcpServers": {
"connect-cloud": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"--name", "connect-cloud-mcp",
"-e", "CDATA_USERNAME",
"-e", "CDATA_PAT",
"mcp/connectcloud"
],
"env": {
"CDATA_USERNAME": "<your-cdata-username>",
"CDATA_PAT": "<your-cdata-personal-access-token>"
}
}
}
}
Via Npx
{
"mcpServers": {
"connect-cloud": {
"command": "npx",
"args": [
"-y",
"@cdatasoftware/connectcloud-mcp-server"],
"env": {
"CDATA_USERNAME": "<your-cdata-username>",
"CDATA_PAT": "<your-cdata-personal-access-token>"
}
}
}
}
📄 License
This project is licensed under the .