SingleStore MCP Server by CData
@CDataSoftware
About SingleStore MCP Server by CData
This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for SingleStore (beta): https://www.cdata.com/download/download.aspx?sku=JMZK-V&type=beta
Basic information
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"{classname_dash}": {
"command": "PATH\\TO\\java.exe",
"args": [
"-jar",
"PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
"PATH\\TO\\singlestore.prp"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
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, andrun_query(SQL SELECT) - Uses
stdiotransport – 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.
More Other MCP servers
ICSS
chokcoco不止于 CSS
AutoBrowser MCP
autobrowser-aiBrowser MCP is a Model Context Provider (MCP) server that allows AI applications to control your browser
Reactive Resume
amruthpillaiA one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!
FastMCP v2 🚀
jlowin🚀 The fast, Pythonic way to build MCP servers and clients.
Activepieces
activepiecesAI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents
Comments