SingleStore MCP Server by CData

What is SingleStore MCP Server by CData?

SingleStore MCP Server by CData is a read-only Model Context Protocol server that lets LLMs like Claude Desktop query live data in SingleStore using natural language. It wraps the CData JDBC Driver for SingleStore, exposing the database as relational SQL models through a simple MCP interface.

How to use SingleStore MCP Server by CData?

Clone the repository, build with mvn clean install, download and license the CData JDBC Driver for SingleStore, and create a .prp file with the connection properties. Configure Claude Desktop by adding the server to claude_desktop_config.json with the path to Java, the JAR, and the .prp file. Run java -jar CDataMCP-jar-with-dependencies.jar <path>.prp to start the server.

Key features of SingleStore MCP Server by CData

• Read-only access to SingleStore data via natural language queries
• Exposes tools: get_tables, get_columns, and run_query (SQL SELECT)
• Uses stdio transport – runs on the same machine as the client
• Built on CData JDBC Driver for SingleStore
• Supports all tables in the data source by default unless filtered
• MIT licensed

Use cases of SingleStore MCP Server by CData

• Query live SingleStore data without writing SQL
• Analyze business metrics (e.g., "How many open tickets do I have?")
• Explore database schema through natural language
• Integrate SingleStore insights into AI chat applications

FAQ from SingleStore MCP Server by CData

Is the server read-only?

Yes. This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities, see the free CData MCP Server for SingleStore (beta).

What dependencies are required?

Java, Maven (to build), and the CData JDBC Driver for SingleStore (must be downloaded and licensed separately).

Where does the data live?

Data remains in the SingleStore instance. The server queries it live over the JDBC connection.

What transport protocol does it use?

The server uses stdio, so it can only be used with clients that run on the same machine.

How is authentication handled?

Authentication is configured through the CData JDBC Driver’s connection string utility. OAuth flows can be triggered if the data source requires it.