singlestore-mcp-server MCP Server

A Model Context Protocol (MCP) server for interacting with SingleStore databases. This server provides tools for querying tables, describing schemas, and generating ER diagrams.

Local serverstdioMIT

What is the singlestore-mcp-server MCP Server?

singlestore-mcp-server source profile. From the maintainer documentation: “A Model Context Protocol (MCP) server for interacting with SingleStore databases. This server provides tools for querying tables, describing schemas, and generating ER diagrams.”

Local setup

The project provides a local client configuration using node. Follow the repository’s build and installation steps before copying it, and replace example paths with the paths on your own computer.

Configuration values

The example declares SINGLESTORE_HOST, SINGLESTORE_PORT, SINGLESTORE_USER, SINGLESTORE_PASSWORD, SINGLESTORE_DATABASE, SSE_ENABLED, SSE_PORT. Secret-looking values have been replaced with placeholders. Required and optional labels are shown only when the documentation states them.

Source

Project documentation · Repository · Discovery listing. This profile records the public documentation checked on 2026-10-08.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
Parameters:	query: SQL query to analyze and optimize
columns	Array of column definitions
table_options	Optional table configuration
count	Number of rows to generate (default: 100)
column_generators	Custom generators for specific columns
batch_size	Number of rows to insert in each batch (default: 1000)

How to install the singlestore-mcp-server MCP Server

{
  "mcpServers": {
    "singlestore": {
      "command": "node",
      "args": [
        "path/to/mcp-server-singlestore/build/index.js"
      ],
      "env": {
        "SINGLESTORE_HOST": "your-host.singlestore.com",
        "SINGLESTORE_PORT": "3306",
        "SINGLESTORE_USER": "your-username",
        "SINGLESTORE_PASSWORD": "YOUR_SINGLESTORE_PASSWORD",
        "SINGLESTORE_DATABASE": "your-database",
        "SSE_ENABLED": "true",
        "SSE_PORT": "3333"
      }
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

Variable	Description	Required
SINGLESTORE_HOST	Declared in the maintainer’s client configuration.	Check documentation
SINGLESTORE_PORT	Declared in the maintainer’s client configuration.	Check documentation
SINGLESTORE_USER	Declared in the maintainer’s client configuration.	Check documentation
SINGLESTORE_PASSWORD	Declared in the maintainer’s client configuration.	Check documentation
SINGLESTORE_DATABASE	Declared in the maintainer’s client configuration.	Check documentation
SSE_ENABLED	Declared in the maintainer’s client configuration.	Optional
SSE_PORT	Declared in the maintainer’s client configuration.	Optional