広告掲載
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.

コメント

「その他」の他のコンテンツ

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

Awesome Mlops

visenger

A curated list of references for MLOps

14.0K

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Health by Dr Brad

Dr Brad Stanfield

Health by Dr Brad works out a health plan from your own results: which screening is due at your age, and evidence-based suggestions, each with the reason and the published guideline or study behind it. Your record is one

広告掲載