SingleStore MCP Server
JSON →An MCP server for interacting with SingleStore databases, requiring environment variables for connection.
Install
npx -y @smithery/cli Tools · 8
- 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
Environment variables
SINGLESTORE_HOSTSINGLESTORE_PORT
★ 4 GitHub stars