# SingleStore MCP Server

Interact with SingleStore databases using a standardized protocol. Execute queries, describe schemas, and generate ER diagrams effortlessly.

## Quick Start

```bash
# Connect this server (installs CLI if needed)
npx -y smithery mcp add madhukarkumar/singlestore-mcp-server

# Browse available tools
npx -y smithery tool list madhukarkumar/singlestore-mcp-server

# Get full schema for a tool
npx -y smithery tool get madhukarkumar/singlestore-mcp-server generate_er_diagram

# Call a tool
npx -y smithery tool call madhukarkumar/singlestore-mcp-server generate_er_diagram '{}'
```

## Tools (8)

- `generate_er_diagram` — Generate a Mermaid ER diagram of the database schema
- `list_tables` — List all tables in the database
- `query_table` — Execute a query on a table
- `describe_table` — Get detailed information about a table
- `run_read_query` — Execute a read-only (SELECT) query on the database
- `create_table` — Create a new table in the database with specified columns and constraints
- `generate_synthetic_data` — Generate and insert synthetic data into an existing table
- `optimize_sql` — Analyze a SQL query using PROFILE and provide optimization recommendations

```bash
# Get full input/output schema for a tool
npx -y smithery tool get madhukarkumar/singlestore-mcp-server <tool-name>
```