SingleStore

SingleStore is an MCP server that connects LLM clients directly to the SingleStore database platform and management APIs. Built for database administrators, software engineers, and data teams, it enables natural language interaction with SingleStore infrastructure. Users can inspect account details, switch between active organizations, and query workspace group metadata. The server provides tools to provision starter workspaces, resume suspended instances, terminate resources, and inspect available deployment regions. Beyond management tasks, it allows clients to execute SQL statements directly against connected workspaces and retrieve structured results. It also integrates with SingleStore Spaces, supporting notebook creation, notebook file uploads, and automated job scheduling from existing notebooks. Additionally, the server facilitates Stage deployment operations by handling file system actions, including listing, uploading, reading, renaming, and deleting files within Stage environments.

Category: Databases & Data Stores

Tags: data-warehouse, relational, singlestore, SQL

Visit SingleStore

How to install and configure SingleStore

1. Ensure Python 3.10.0 or higher and uvx are installed on your system. 2. Configure your MCP client using the standard configuration. For example, add the following to your client's mcpServers settings: json { "mcpServers": { "singlestore-mcp-server": { "command": "uvx", "args": [ "singlestore-mcp-server", "start" ] } } } 3. Alternatively, run the automatic setup command for your client, such as uvx singlestore-mcp-server init --client=claude-desktop or uvx singlestore-mcp-server init --client=cursor. 4. If running in a Docker container instead of local stdio, set the MCP_API_KEY environment variable as OAuth is not supported inside containers. 5. Start your MCP client and complete the browser OAuth flow to authenticate without manual API keys.

What you can do with SingleStore

• Running SQL queries against SingleStore databases and parsing tabular results directly within conversational assistants. - Provisioning, resuming, and terminating SingleStore starter workspaces across supported cloud regions. - Uploading, managing, and executing scheduled jobs derived from SingleStore Spaces notebook files. - Reading, listing, moving, and uploading files within SingleStore Stage deployment environments. - Retrieving account profiles, organizational hierarchies, and workspace group topologies using natural language queries.

Key facts

• https://github.com/singlestore-labs/mcp-server-singlestore
• Databases & Data Stores
• data-warehouse, relational, singlestore, SQL

Part of MCP Servers

How do I install SingleStore MCP server?

You can install and register it automatically using uvx by running uvx singlestore-mcp-server init with your client flag, such as for claude-desktop, cursor, or vscode. Alternatively, you can add it manually to your client configuration using the command uvx with args singlestore-mcp-server and start. If running via Docker, pass your API key using the MCP_API_KEY environment variable.

What can SingleStore MCP server do?

It provides tools to execute SQL operations on SingleStore workspaces, manage workspace lifecycles, and fetch organization or user info. It also manages SingleStore Spaces notebook creation, uploads, and job scheduling, alongside file management in Stage deployments such as uploading, deleting, and moving files.

Which MCP clients work with SingleStore?

SingleStore MCP server works with Claude Desktop, Claude Code, Cursor, VS Code, Windsurf, Gemini CLI, LM Studio, Goose, and Qodo Gen, as well as any other client that supports the Model Context Protocol.

Is SingleStore MCP server open source?

Yes, SingleStore MCP server is open source and licensed under the MIT License on GitHub.