🧠 CData Connect AI MCP Server

🚨 Now Available in Connect AI 🚨

Connect AI (formerly Connect Cloud) now has a built-in Remote MCP Server (using the Streamable HTTP transport type). Learn more.

This project still allows for local installation/hosting of the MCP server using the STDIO transport type.

---

A Model Context Protocol (MCP) server for querying and managing data through CData Connect AI. 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 AI MCP Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install @CDataSoftware/connectcloud-mcp-server --client claude

Manual Installation

1. Clone the repository

git clone https://github.com/cdatasoftware/connectcloud-mcp-server.git
   cd connect-cloud-mcp-server

2. Install dependencies

npm install

3. Configure environment variables

Create a .env file with the following content:

CDATA_USERNAME=your_username
   CDATA_PAT=your_personal_access_token

   # Optional Configuration
   LOG_ENABLED=false
   LOG_LEVEL=info
   CDATA_URL=https://your-test-environment-url
   
   # Transport Configuration (default: http)
   TRANSPORT_TYPE=http  # or 'stdio' for terminal usage
   PORT=3000           # HTTP server port
   HOST=localhost      # HTTP server host

---

▶️ Running the Server

Development Mode

Use ts-node for live development:

npm run dev

Production Mode

Build and start:

npm run build
npm start

HTTP Transport Endpoints

When running with HTTP transport (default), the server provides these endpoints:

• MCP Endpoint: http://localhost:3000/mcp - Primary Model Context Protocol endpoint
• Direct Endpoint: http://localhost:3000/direct - Direct JSON-RPC endpoint without session management
• Manifest: http://localhost:3000/.well-known/mc/manifest.json - MCP discovery manifest

Using STDIO Transport

To use STDIO transport instead (for terminal/CLI usage):

TRANSPORT_TYPE=stdio npm start

---

🔍 Testing with MCP Inspector

The MCP Inspector is a visual testing tool that provides both a web UI and CLI interface for testing MCP servers. This project includes full support for the inspector.

Quick Setup Validation

Run the setup validation script to ensure everything is configured correctly:

npm run validate:inspector

This will check your configuration and provide detailed setup instructions.

Quick Start with Inspector

1. Install the inspector globally (optional but recommended):

npm install -g @modelcontextprotocol/inspector

2. Launch inspector with web UI:

npm run inspector

This opens a web interface where you can select and test different transport configurations.

Testing Different Transports

STDIO Transport

# Launch inspector with STDIO transport (starts server automatically)
npm run inspector:stdio

HTTP Transport

# Start the server first
npm run dev:http

# Then in another terminal, launch inspector
npm run inspector:http

Command Line Testing

# Quick CLI testing with STDIO transport
npm run inspector:cli

# Test specific methods directly
npm run test:inspector

Inspector Configuration

The project includes a mcp-inspector.json configuration file with pre-configured server setups:

• connectcloud-stdio: STDIO transport with automatic server startup
• connectcloud-http: Streamable HTTP transport (requires manual server start)

Available Inspector Scripts

---

🧰 Available Tools

🔹 Data Operations

🔹 Metadata Operations

---

🤖 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": "",
        "CDATA_PAT": ""
      }
    }
  }
}

Via Npx

{
  "mcpServers": {
    "connect-cloud": {
      "command": "npx",
      "args": [
        "-y",
        "@cdatasoftware/connectcloud-mcp-server"],
      "env": {
        "CDATA_USERNAME": "",
        "CDATA_PAT": ""
      }
    }
  }
}

---

📄 License

This project is licensed under the MIT License.