singlestore

MCP server from apeng-singlestore/singlestore-mcp-server

Installation

Run this command in your terminal to add the MCP server to Claude Code.

Run in terminal:

Command

claude mcp add --transport stdio apeng-singlestore-singlestore-mcp-server python -m singlestore_mcp_server \
  --env SINGLESTORE_HOST="your_workspace_host" \
  --env SINGLESTORE_PORT="3306" \
  --env SINGLESTORE_USER="your_username" \
  --env SINGLESTORE_DATABASE="your_database" \
  --env SINGLESTORE_PASSWORD="your_password"

How to use

This MCP server provides a controlled interface to interact with a SingleStore database. It exposes resources corresponding to SingleStore tables and allows clients to read table contents in formats like BSON and JSON, as well as execute SQL queries with proper error handling. The server is designed to support SingleStore-specific data types and functions, while enforcing secure access through environment-based configuration. To use it with Claude Desktop, configure an MCP entry that points to the Python-based server (python -m singlestore_mcp_server) and supply the required SINGLESTORE_* environment variables. Once running, clients can list tables, read data, and perform queries via the MCP layer without giving direct database access.

The server focuses on: listing available tables as resources, reading table data with support for multiple formats, executing SQL queries with error handling, and ensuring compatibility with SingleStore-specific features and data types. It also emphasizes secure usage, logging, and minimal-permission database credentials to reduce risk when accessed by AI assistants or automation tools.

How to install

Prerequisites:

Python 3.8+ installed on your system
Access to a SingleStore instance
Network reachability from the machine running the MCP server to the SingleStore host

Step-by-step installation:

Create and (optional) activate a Python virtual environment
- On macOS/Linux: python -m venv venv source venv/bin/activate
- On Windows: python -m venv venv venv\Scripts\activate
Install the MCP server package from PyPI pip install singlestore-mcp-server
Prepare environment variables for your SingleStore connection (see README for details)
- SINGLESTORE_HOST=your_workspace_host
- SINGLESTORE_PORT=3306
- SINGLESTORE_USER=your_username
- SINGLESTORE_PASSWORD=your_password
- SINGLESTORE_DATABASE=your_database
Run the server locally (standalone) for testing python -m singlestore_mcp_server
(Optional) Integrate with Claude Desktop or other MCP clients by configuring the mcpServers section with the appropriate command and environment bindings.

Additional notes

Notes and tips:

Never commit or share your SINGLESTORE_* credentials. Use environment variables or secret managers.
For production deployments, prefer a dedicated SingleStore user with least privileges required by the MCP server.
If you encounter connection errors, verify network access, host/port, and that the user has access to the specified database.
The MCP server supports BSON and JSON formats for table reads; adjust client requests accordingly.
Enable and review logging to monitor operations performed through the MCP interface.
If extending functionality, ensure compatibility with SingleStore data types and any special functions used by your queries.