SingleStore icon

SingleStore

Facilitates interaction with SingleStore databases, enabling querying, schema exploration, and ER diagram generation.

About

The SingleStore MCP server provides a suite of tools designed to simplify interaction with SingleStore databases. It allows users to list tables, execute custom SQL queries, retrieve detailed table information including schema and sample data, and generate Mermaid ER diagrams of the database schema. The server supports SSL connections and offers both MCP and SSE protocols for flexible integration with various client applications.

Key Features

  • Executes custom SQL queries
  • Supports SSL with automatic CA bundle fetching
  • Provides detailed table information including schema and sample data
  • Includes comprehensive error handling
  • Lists all tables in the database
  • Generates Mermaid ER diagrams of the database schema
  • 3 GitHub stars

Use Cases

  • Generating ER diagrams to visualize the database schema
  • Automating database schema exploration and documentation
  • Querying tables in a SingleStore database for specific data
Craft Better Prompts with AnyPrompt