CData Connect Cloud MCP Server - MCP Server

🧠 CData Connect Cloud MCP Server

Node.js Version

License

Docker

CData Connect Cloud

smithery badge

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)
📈 Retrieve and download query execution logs

🛠 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 MIT License.