madhukarkumar/singlestore-mcp-server

3.3

If you are the rightful owner of singlestore-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

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

Tools

Functions exposed to the LLM to take actions

list_tables

List all tables in the database

query_table

Perform custom SQL queries

describe_table

Get detailed information about the table (including schema and sample data)

generate_er_diagram

Generate a Mermaid ER diagram of a database schema

run_read_query

Perform read-only (SELECT) query

create_table

Create a new table

generate_synthetic_data

Generate and insert synthetic data

optimize_sql

Analyze SQL queries and provide optimization suggestions

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

madhukarkumar

Claim Ownership

Verify you have write access to the repository

Repository

https://github.com/madhukarkumar/singlestore-mcp-server

GitHub Stars

Last publish date

2025-02-21

Last update date

2025-07-13

Server configs

in claude desktop

{
  "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-password",
        "SINGLESTORE_DATABASE": "your-database",
        "SSE_ENABLED": "true",
        "SSE_PORT": "3333"
      }
    }
  }
}

in windsurf

{
  "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-password",
        "SINGLESTORE_DATABASE": "your-database",
        "SSE_ENABLED": "true",
        "SSE_PORT": "3333"
      }
    }
  }
}

in cursor

{
  "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-password",
      "SINGLESTORE_DATABASE": "your-database",
      "SSE_ENABLED": "true",
      "SSE_PORT": "3333"
    }
  }
}

Top Comments

Related MCP Servers

View all databases servers →

mysql_mcp_server

4.5

by designcomputer

MySQL MCP Server is a Model Context Protocol implementation that facilitates secure interaction between AI applications and MySQL databases.

madhukarkumar/singlestore-mcp-server

Tools

list_tables

query_table

describe_table

generate_er_diagram

run_read_query

create_table

generate_synthetic_data

optimize_sql

Prompts

No prompts

Resources

No resources

Related MCP Servers

mysql_mcp_server

mcp-alchemy

mcp-clickhouse

mongodb-mcp-server

supabase-mcp

prisma

mcp-server-qdrant

mysql_mcp_server_pro

mcp-server-neon

postgres-mcp

osv-mcp

mcp-server-mysql

mcp-databricks-server

mcp-proxy

anyquery

mcp-google-sheets

airtable-mcp-server

mcp-server-milvus

atlas-mcp-server

prometheus-mcp-server

mariadb-mcp-server

mcp-mongo-server

postg-mem

mcp-server-starrocks

mssql_mcp_server

elasticsearch-mcp-server

firebase-mcp