SingleStore MCP Server

Example Use Cases

• 1

  Introspect a SingleStore database schema and generate ER diagrams for documentation or analysis.

• 2

  Execute read-only SQL queries or custom queries against SingleStore and retrieve sample data or query results.

• 3

  Real-time or streaming responses (SSE) from database tools so web-based assistants can present incremental updates.

Description

This MCP server exposes a set of tools to list tables, run read queries, describe table schemas, generate Mermaid ER diagrams, create tables, insert synthetic data, and provide SQL optimization recommendations for SingleStore databases. It supports the standard MCP stdio protocol for agents and an optional SSE HTTP interface for streaming responses to web clients. The server includes SSL support with automatic SingleStore CA bundle fetching, TypeScript typings, and error handling to make integrations safer and easier.