MCP Servers / database / SingleStore MCP Server

SingleStore MCP Server

JSON →
stdionone★ 4database

An MCP server for interacting with SingleStore databases, requiring environment variables for connection.

github ↗
Install
How to run this server
[ { "cmd": "npx -y @smithery/cli", "imports": [] } ]
server path: singlestore-mcp-server
Tools
What this server exposes
list_tables
Lists all tables in the database
query_table
Executes a custom SQL query
describe_table
Gets detailed information about a table
generate_er_diagram
Generates a Mermaid ER diagram of the database schema
run_read_query
Executes a read-only (SELECT) query on the database
create_table
Create a new table in the database with specified columns and constraints
generate_synthetic_data
Generate and insert synthetic data into an existing table
optimize_sql
Analyze a SQL query using PROFILE and provide optimization recommendations
Configuration
Environment & auth
authnone
envSINGLESTORE_HOST
envSINGLESTORE_PORT
Resources
githubhttps://github.com/madhukarkumar/singlestore-mcp-server ↗
SingleStore MCP Server — MCP Server · libregistry