SingleStore MCP Server

Name: SingleStore MCP Server
Author: madhukarkumar

@madhukarkumar

代码仓库

关于 SingleStore MCP Server

SingleStore MCP server implemented in TS

基本信息

分类

其他

运行时

node

传输方式

stdio

发布者

madhukarkumar

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "singlestore-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@madhukarkumar/singlestore-mcp-server",
        "--client",
        "claude"
      ]
    }
  }
}

工具

query: SQL query string

table: Table name

query: SQL SELECT query to execute

table_name: Name of the table to create

table: Name of the table to insert data into

query: SQL query to analyze and optimize

概览

What is SingleStore MCP Server?

The SingleStore MCP Server is a Model Context Protocol server that provides tools for querying SingleStore databases, describing schemas, and generating ER diagrams. It supports SSL with automatic CA bundle fetching and is built with TypeScript. This server is designed for developers and data analysts who want to interact with SingleStore through MCP-compatible clients like Claude Desktop.

How to use SingleStore MCP Server?

Install via Smithery (npx -y @smithery/cli install @madhukarkumar/singlestore-mcp-server --client claude) or clone, install dependencies (npm install), build (npm run build). Set required environment variables: SINGLESTORE_HOST, SINGLESTORE_PORT, SINGLESTORE_USER, SINGLESTORE_PASSWORD, SINGLESTORE_DATABASE. For SSE support, set SSE_ENABLED=true and optionally SSE_PORT. Run with node build/index.js. Tools include list_tables, query_table, describe_table, generate_er_diagram, run_read_query, create_table, generate_synthetic_data, and optimize_sql.

Key features of SingleStore MCP Server

List all tables in the database
Execute custom SQL queries
Get detailed table information including schema and sample data
Generate Mermaid ER diagrams of database schema
Create tables with custom columns, constraints, shard keys, and sort keys
Generate and insert synthetic data into existing tables
Analyze SQL queries with profile and provide optimization recommendations
SSL support with automatic CA bundle fetching

Use cases of SingleStore MCP Server

Explore and query a SingleStore database using natural language through Claude Desktop
Automatically document database schema by generating ER diagrams
Populate test or development databases with realistic synthetic data
Improve query performance by profiling and receiving optimization suggestions
Stream real-time database results to web applications via the SSE protocol

FAQ from SingleStore MCP Server

What runtime environment does the SingleStore MCP Server require?

Node.js 16 or higher and npm or yarn.

How do I connect the server to my SingleStore database?

Set the environment variables SINGLESTORE_HOST, SINGLESTORE_PORT, SINGLESTORE_USER, SINGLESTORE_PASSWORD, and SINGLESTORE_DATABASE. The server automatically fetches the SingleStore CA bundle for SSL.

Can I use this server over HTTP instead of stdio?

Yes. Enable the SSE HTTP server by setting SSE_ENABLED=true and optionally SSE_PORT (default 3333). The server then provides endpoints like /sse, /tools, and /call-tool.

What is the difference between `query_table` and `run_read_query`?

query_table executes any custom SQL query, while run_read_query restricts execution to read-only SELECT queries only.

How can I generate synthetic data for a table?

Use the generate_synthetic_data tool with parameters for the table name, number of rows, optional column generators, and batch size. The tool supports sequence, values, and formula generator types.

其他分类下的更多 MCP 服务器

IDA Pro MCP

mrexodia

AI-powered reverse engineering assistant that bridges IDA Pro with language models through MCP.

9.9K

Unity MCP ✨

justinpbarnett

Unity MCP acts as a bridge between AI assistants and your Unity Editor. Give your LLM tools to manage assets, control scenes, edit scripts, and automate tasks within Unity.

12.2K