SingleStore
An implementation of the Model Context Protocol (MCP) server for SingleStore that enables natural language interaction with SingleStore databases through compatible LLM clients like Claude Desktop and Cursor.
What is SingleStore?
SingleStore is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to implementation of the model context protocol (mcp) server for singlestore that enables natural language interaction with singlestore databases through compatible llm clients like claude desktop and cu...
An implementation of the Model Context Protocol (MCP) server for SingleStore that enables natural language interaction with SingleStore databases through compatible LLM clients like Claude Desktop and Cursor.
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- An implementation of the Model Context Protocol (MCP) server
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx singlestore-mcp-serverConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use SingleStore
The SingleStore MCP server provides a natural-language interface to SingleStore databases, allowing AI assistants like Claude to query workspaces, run SQL++ statements, manage notebooks, schedule jobs, and handle stage file storage through a conversational interface. It connects to the SingleStore portal via OAuth browser authentication, so no manual credential configuration is needed for standard installs. Teams use it to explore and operate cloud databases without switching between SQL tools and their AI assistant.
Prerequisites
- A SingleStore account with at least one workspace group and workspace
- Python 3.10+ and uvx (part of uv) installed, or Docker for containerized deployment
- An MCP client such as Claude Desktop, Cursor, or VS Code with MCP extension
- Docker and a SingleStore API key if running the containerized version
Add the server to your MCP client config
Edit your MCP client configuration file to declare the SingleStore server. For most clients uvx is the simplest launch method and no credentials are required — the server opens a browser for OAuth on first run.
{
"mcpServers": {
"singlestore-mcp-server": {
"command": "uvx",
"args": ["singlestore-mcp-server", "start"]
}
}
}Authenticate via browser OAuth
On first startup the server will open a browser window prompting you to log in to your SingleStore account and grant access. Complete this flow and return to your MCP client.
Select your workspace
Once authenticated, tell your AI assistant which workspace or workspace group to connect to. The server will list available options and let you select the target database.
Run a SQL query
Use the run_sql tool (invoked automatically by your AI assistant) to execute queries against your SingleStore workspace.
(Optional) Docker deployment with API key
For headless or CI environments where browser OAuth is unavailable, run the server in Docker and provide an API key via the MCP_API_KEY environment variable.
docker run -e MCP_API_KEY=your_api_key_here singlestore-mcp-serverSingleStore Examples
Client configuration
Standard uvx configuration for Claude Desktop. No API key is needed; OAuth handles authentication on first launch.
{
"mcpServers": {
"singlestore-mcp-server": {
"command": "uvx",
"args": ["singlestore-mcp-server", "start"]
}
}
}Prompts to try
After connecting, use these prompts to explore and operate your SingleStore databases through your AI assistant.
- "List all workspace groups in my SingleStore organization"
- "Run this query on my workspace: SELECT COUNT(*) FROM orders WHERE created_at > NOW() - INTERVAL 7 DAY"
- "Create a notebook for exploratory analysis of the customers table"
- "Schedule a job from my analytics notebook to run every Sunday at midnight"
- "Upload the file report.csv to stage storage in my current workspace"Troubleshooting SingleStore
Browser OAuth window does not open
Ensure you are running in an environment with a desktop browser available. For headless servers, switch to Docker with MCP_API_KEY instead of the uvx approach.
uvx command not found
Install uv first: 'pip install uv' or 'brew install uv'. uvx is bundled with uv and allows running Python packages in isolated environments without a separate install step.
SQL query fails with workspace not connected error
Suspended starter workspaces need to be resumed first. Ask your assistant to 'resume my workspace' and wait for it to come online before executing queries.
Frequently Asked Questions about SingleStore
What is SingleStore?
SingleStore is a Model Context Protocol (MCP) server that implementation of the model context protocol (mcp) server for singlestore that enables natural language interaction with singlestore databases through compatible llm clients like claude desktop and cursor. It connects AI assistants to external tools and data sources through a standardized interface.
How do I install SingleStore?
Follow the installation instructions on the SingleStore GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with SingleStore?
SingleStore works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is SingleStore free to use?
Yes, SingleStore is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.
SingleStore Alternatives — Similar Databases Servers
Looking for alternatives to SingleStore? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up SingleStore in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use SingleStore?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.