SingleStore MCP Server
by madhukarkumar
A Model Context Protocol (MCP) server for interacting with SingleStore databases. This server provides tools for querying tables, describing schemas, and generating ER diagrams.
Last updated: N/A
What is SingleStore MCP Server?
The SingleStore MCP Server is a tool that facilitates interaction with SingleStore databases using the Model Context Protocol (MCP). It allows users to query tables, describe schemas, generate ER diagrams, and perform other database-related tasks.
How to use SingleStore MCP Server?
To use the server, you need to install it via Smithery or manually by cloning the repository, installing dependencies, and building the server. Configure the required environment variables for database connection. The server supports MCP and SSE protocols. Use the available tools by calling them with appropriate arguments as shown in the documentation.
Key features of SingleStore MCP Server
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
Proper error handling and TypeScript type safety
Supports both MCP and SSE protocols
Includes tools for creating tables, generating synthetic data, and optimizing SQL queries
Use cases of SingleStore MCP Server
Integrating SingleStore databases with AI tools like Claude Desktop, Windsurf, and Cursor.
Generating database schemas and ER diagrams for documentation purposes.
Executing SQL queries and analyzing table data.
Creating and populating tables with synthetic data for testing purposes.
FAQ from SingleStore MCP Server
What is the Model Context Protocol (MCP)?
What is the Model Context Protocol (MCP)?
MCP is a protocol for communication between applications and tools, enabling them to share context and data.
What are the required environment variables?
What are the required environment variables?
The required environment variables are SINGLESTORE_HOST, SINGLESTORE_PORT, SINGLESTORE_USER, SINGLESTORE_PASSWORD, and SINGLESTORE_DATABASE.
How do I enable SSE protocol support?
How do I enable SSE protocol support?
Set the SSE_ENABLED environment variable to true and optionally set the SSE_PORT variable to specify the HTTP port for the SSE server.
How do I use the MCP Inspector with this server?
How do I use the MCP Inspector with this server?
Start the server and MCP Inspector, then connect to the server's URL in the MCP Inspector, ensuring that SSE is selected as the transport type.
What are the available tools?
What are the available tools?
The available tools include list_tables, query_table, describe_table, generate_er_diagram, run_read_query, create_table, generate_synthetic_data, and optimize_sql.