list_tablesLABSCO SUMMARY
The schema comes back as a diagram, not just a list of columns.
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.
What it is
Eight tools over a SingleStore database: list the tables, describe one, run a query or a read-only SELECT, render the schema as a Mermaid ER diagram, create a table, fill a table with synthetic data, and get suggestions for optimizing a query.
What you get
- 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 new table created with its columns and SingleStore shard and sort keys
- Synthetic rows generated and inserted into an existing table, in batches
- A SQL query profiled, with optimization recommendations
Requirements
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.
Setup effort
One command plus credentials — npx -y @smithery/cli install @madhukarkumar/singlestore-mcp-server --client claude, then supply credentials
USE CASES
01
Understanding how a database fits together
Render the whole schema as an ER diagram and read the relationships off it, instead of describing tables one at a time and holding the joins in your head.
02
Writing a query against unfamiliar tables
Read the schema and the sample rows first, so column names and value shapes are copied rather than guessed.
03
Answering a data question inline
Run the SQL where the question was asked and get the rows back in the same place.
04
Documenting a schema for someone else
Export the ER diagram as Mermaid and drop it straight into the document, with table detail underneath it.
8 tools
Listed in project docs. Your client may show a different list.
query_tabledescribe_tablegenerate_er_diagramrun_read_querycreate_tablegenerate_synthetic_dataoptimize_sqlBEFORE YOU INSTALL
What to know first
Tools you get
8 tools named in the project's documentation.
Requires
- node on PATH
- Node.js 16 or later
- SINGLESTORE_PASSWORD in your environment
- SINGLESTORE_USER in your environment
Where it runs
All 3 documented clients run the server on your machine.
INSTALLATION
Connect your client
Server setup
Build from source
TERMINAL
git clone https://github.com/madhukarkumar/singlestore-mcp-server.git
cd singlestore-mcp-server
npm install
npm run buildnpx
TERMINAL
npx -y @smithery/cli install @madhukarkumar/singlestore-mcp-server --client claudeMCP Clients
Claude Desktop, Windsurf, Cursor
JSON
{
"mcpServers": {
"singlestore": {
"command": "node",
"args": [
"<YOUR_PATH_TO_MCP_SERVER_SINGLESTORE>/build/index.js"
],
"env": {
"SINGLESTORE_HOST": "<YOUR_HOST>.singlestore.com",
"SINGLESTORE_PORT": "3306",
"SINGLESTORE_USER": "<YOUR_SINGLESTORE_USER>",
"SINGLESTORE_PASSWORD": "<YOUR_SINGLESTORE_PASSWORD>",
"SINGLESTORE_DATABASE": "<YOUR_SINGLESTORE_DATABASE>",
"SSE_ENABLED": "true",
"SSE_PORT": "3333"
}
}
}
}<YOUR_PATH_TO_MCP_SERVER_SINGLESTORE>/build/index.js is the absolute path to build/index.js inside your clone.
