广告合作
MCP.so
登录

SingleStore MCP Server

@madhukarkumar

代码仓库

基本信息

分类

其他

传输方式

stdio

作者

madhukarkumar

关于 SingleStore MCP Server

SingleStore MCP server implemented in TS

SingleStore MCP Server 配置

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

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

SingleStore MCP Server 工具

6

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

常见问题

1

What runtime environment does the SingleStore MCP Server require?

Node.js 16 or higher and npm or yarn.

2

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.

3

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

4

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.

5

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 服务器

🚀 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

Codelf

unbug

A search tool helps dev to solve the naming things problem.

14.2K
N

Next Generation Movers: free moving quotes (remote MCP)

Next Generation Movers

Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K
广告合作