connectcloud-mcp-server

connectcloud-mcp-server

1
databasescloud_platformsai_chatbot

The CData Connect Cloud MCP Server is designed for data management and querying in cloud environments via CData Connect Cloud. It supports SQL execution and metadata access, allowing AI agents to interface seamlessly with diverse data sources.

🧠 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

▶️ Running the Server

  • Use ts-node for live development
  • Build and start in production

🧰 Available Tools

Data Operations

  • SQL query execution
  • Procedure execution

Metadata Operations

  • Catalog, schema, table, column retrieval

🤖 Usage with LLMs

Compatible with AI agents implementing the Model Context Protocol.

📄 License

Licensed under the MIT License.