SingleStore MCP Server connects AI assistants to SingleStore distributed SQL databases, enabling direct database interaction through SQL queries, schema exploration, and visualization. Key capabilities include: - Execute custom SQL queries against SingleStore databases - List all tables and retrieve detailed schema information with sample data - Generate Mermaid ER diagrams for database visualization - Automatic SSL CA bundle fetching from SingleStore portal for secure connections - Support for both stdio (MCP) and Server-Sent Events (SSE) protocols

SingleStore MCP Server

[](https://smithery.ai/server/@madhukarkumar/singlestore-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.

Features

Prerequisites

Installation

Installing via Smithery

To install SingleStore MCP Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install @madhukarkumar/singlestore-mcp-server --client claude

1. Clone the repository:

git clone 
cd mcp-server-singlestore

2. Install dependencies:

npm install

3. Build the server:

npm run build

Environment Variables

Required Environment Variables

The server requires the following environment variables for database connection:

SINGLESTORE_HOST=your-host.singlestore.com
SINGLESTORE_PORT=3306
SINGLESTORE_USER=your-username
SINGLESTORE_PASSWORD=your-password
SINGLESTORE_DATABASE=your-database

All these environment variables are required for the server to establish a connection to your SingleStore database. The connection uses SSL with the SingleStore CA bundle, which is automatically fetched from the SingleStore portal.

Optional Environment Variables

For SSE (Server-Sent Events) protocol support:

SSE_ENABLED=true       # Enable the SSE HTTP server (default: false if not set)
SSE_PORT=3333          # HTTP port for the SSE server (default: 3333 if not set)

Setting Environment Variables

1. In Your Shell: Set the variables in your terminal before running the server:

   export SINGLESTORE_HOST=your-host.singlestore.com
   export SINGLESTORE_PORT=3306
   export SINGLESTORE_USER=your-username
   export SINGLESTORE_PASSWORD=your-password
   export SINGLESTORE_DATABASE=your-database
   

2. In Client Configuration Files: Add the variables to your MCP client configuration file as shown in the integration sections below.

Usage

Protocol Support

This server supports two protocols for client integration:

1. MCP Protocol: The standard Model Context Protocol using stdio communication, used by Claude Desktop, Windsurf, and Cursor. 2. SSE Protocol: Server-Sent Events over HTTP for web-based clients and applications that need real-time data streaming.

Both protocols expose the same tools and functionality, allowing you to choose the best integration method for your use case.

Available Tools

1. list_tables - Lists all tables in the database - No parameters required

   use_mcp_tool({
     server_name: "singlestore",
     tool_name: "list_tables",
     arguments: {}
   })
   

2. query_table - Executes a custom SQL query - Parameters: - query: SQL query string

   use_mcp_tool({
     server_name: "singlestore",
     tool_name: "query_table",
     arguments: {
       query: "SELECT * FROM your_table LIMIT 5"
     }
   })
   

3. describe_table - Gets detailed information about a table - Parameters: - table: Table name

   use_mcp_tool({
     server_name: "singlestore",
     tool_name: "describe_table",
     arguments: {
       table: "your_table"
     }
   })
   

4. generate_er_diagram - Generates a Mermaid ER diagram of the database schema - No parameters required

   use_mcp_tool({
     server_name: "singlestore",
     tool_name: "generate_er_diagram",
     arguments: {}
   })
   

5. run_read_query - Executes a read-only (SELECT) query on the database - Parameters: - query: SQL SELECT query to execute

   use_mcp_tool({
     server_name: "singlestore",
     tool_name: "run_read_query",
     arguments: {
       query: "SELECT * FROM your_table LIMIT 5"
     }
   })
   

6. create_table - Create a new table in the database with specified columns and constraints - Parameters: - table_name: Name of the table to create - columns: Array of column definitions - table_options: Optional table configuration ```typescript use_mcp_tool({ server_name: "singlestore", tool_name: "create_table", arguments: { table_name: "new_table", columns: [ { name: "id", type: "INT", nullable: false, auto_increment: true