MCP.so
Sign In
S

SingleStore MCP Server by CData

@CDataSoftware

Repository

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

#singlestore#mcp-server#cdata

Basic information

Category

Other

Transports

stdio

Publisher

CDataSoftware

Submitted by

Cameron Leblanc

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, 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.

Comments

More Other MCP servers

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

Core Philosophy: Connect, Unify, Respond

mindsdb

Delegate anything. It comes back done.

39.4K

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

Reactive Resume

amruthpillai

A 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!

39.5K