Listing and describing tables is the usual starting point and the query tool does the work; what is unusual here is the ER diagram, which turns a database you have never seen into something readable at a glance before you write any SQL.
Four tools over a SingleStore database: list the tables, describe one, run a query, and render the schema as a Mermaid ER diagram.
- Every table in the database
- A table's schema, with sample data alongside it
- A custom SQL query, with results returned to the conversation
- A Mermaid ER diagram of the database schema
A reachable SingleStore database and its five connection settings - host, port, user, password and database name - as environment variables. The connection uses SSL with the SingleStore CA bundle, which the server fetches from the portal itself. Node, and a build from the repository.
One command plus a key — npx -y @smithery/cli install @madhukarkumar/singlestore-mcp-server --client claude, then supply credentials