SingleStore MCP

Name: SingleStore MCP
Author: SingleStore

by SingleStore

Real-time analytics, transactions, and vector search in a unified database via MCP

database Python Intermediate Self-hostable Verified

⭐ 100 stars 📅 Updated: 1mo ago

View on GitHub View package

Description

MCP server for interacting with the SingleStore database platform. SingleStore combines real-time analytics, transactional workloads, and vector search capabilities in a single unified database engine. This server lets AI assistants execute SQL queries, explore database schemas, manage tables, and analyze data directly. Ideal for teams running mixed workloads that need both OLTP and OLAP performance without maintaining separate systems. Supports full SQL compatibility and advanced features like vector similarity search for AI-powered applications.

✅ Best for

Teams running mixed analytical and transactional workloads who want a single database for everything including vector search

⏭️ Skip if

You only need a simple key-value store or already use a specialized vector database

💡 Use cases

Running analytical SQL queries on real-time data from AI assistants
Exploring database schemas and table structures interactively
Performing vector similarity searches for RAG and semantic retrieval
Managing and monitoring SingleStore database workloads

👍 Pros

✓ Unified platform for transactions, analytics, and vector search — no need for multiple databases
✓ Full SQL compatibility makes it easy for LLMs to generate and run queries
✓ High-performance real-time analytics on streaming and operational data
✓ Vector search built in, great for AI/ML retrieval workflows

👎 Cons

✗ Requires a SingleStore account and active database instance
✗ Cloud-hosted instances may incur costs depending on usage tier
✗ Less common than MySQL/PostgreSQL, so LLM may have less training data for SingleStore-specific syntax

🔧 Exposed tools (4 tools)

Tool	Category	Description
list_databases	discovery	List all available databases and schemas
describe_table	discovery	Get the schema and column details of a specific table
manage_schema	management	Create, alter, or drop database objects
execute_query	query	Execute a SQL query against the SingleStore database

⚡ Installation

Prerequisites:

• python v3.10+
• SingleStore database credentials (host, port, user, password)
• API key required

Check Claude Code documentation to configure this MCP server.

💡 Tips & tricks

Configure connection credentials via environment variables (SINGLESTORE_HOST, SINGLESTORE_USER, SINGLESTORE_PASSWORD). Use the execute_query tool for both read and write operations, and list_databases to discover available schemas before querying.

🔄 Alternatives

mysql-mcp

MCP server — editorial content pending

Similar functionality

postgresql-mcp