singlestore-mcp-server
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.
The SingleStore MCP Server is designed to facilitate seamless interaction with SingleStore databases through the Model Context Protocol. It offers a suite of tools that allow users to list tables, execute SQL queries, describe table schemas, and generate ER diagrams using Mermaid. The server supports both MCP and SSE protocols, enabling integration with various platforms and real-time data streaming. It ensures secure connections with SSL support and provides robust error handling and TypeScript type safety. The server is compatible with Node.js environments and requires access to a SingleStore database.
Features
- List all tables in the database
- Execute custom SQL queries
- Get detailed table information including schema and sample data
- Generate Mermaid ER diagrams of database schema
- SSL support with automatic CA bundle fetching
Tools
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
