Madhukarkumar Singlestore MCP Server

🚀 SingleStore MCP Server

A SingleStore Database Model Context Protocol (MCP) server that supports secure interactions. This server enables AI assistants to list tables, read data, and execute SQL queries through a controlled interface, ensuring the security and structure of database exploration and analysis.

🚀 Quick Start

The SingleStore MCP Server is a powerful tool for interacting with SingleStore databases securely. It allows AI assistants to perform various operations on the database, such as listing tables and executing SQL queries.

✨ Features

• List available SingleStore tables as resources.
• Read message content in multiple formats, including BSON and JSON.
• Execute SQL queries with error handling.
• Support SingleStore-specific data types and functions.
• Ensure database access security through environment variables.
• Provide comprehensive logging.

📦 Installation

pip install singlestore-mcp-server

📚 Documentation

Configuration

Set the following environment variables:

SINGLESTORE_HOST=your_workspace_host
SINGLESTORE_PORT=3306  # Default port for SingleStore
SINGLESTORE_USER=your_username
SINGLESTORE_PASSWORD=your_password
SINGLESTORE_DATABASE=your_database

Usage Examples

Basic Usage

Using in Claude Desktop

Add the following content to the claude_desktop_config.json file:

{
  "mcpServers": {
    "singlestore": {
      "command": "uv",
      "args": [
        "--directory", 
        "path/to/singlestore_mcp_server",
        "run",
        "singlestore_mcp_server"
      ],
      "env": {
        "SINGLESTORE_HOST": "your_workspace_host",
        "SINGLESTORE_PORT": "3306",
        "SINGLESTORE_USER": "your_username",
        "SINGLESTORE_PASSWORD": "your_password",
        "SINGLESTORE_DATABASE": "your_database"
      }
    }
  }
}

Running as an Independent Server

# Install dependencies
pip install -r requirements.txt

# Run the server
python -m singlestore_mcp_server

Development

# Clone the repository
git clone https://github.com/yourusername/singlestore_mcp_server.git
cd singlestore_mcp_server

# Create a virtual environment
python -m venv venv
source venv/bin/activate  # or `venv\Scripts\activate` on Windows

# Install development dependencies
pip install -r requirements-dev.txt

# Run tests
pytest

SingleStore-specific Features

• Support BSON data types and operations.
• Provide native JSON processing with support for SingleStore's JSON functions.
• Support SingleStore Kai (MongoDB API compatibility).
• Handle SingleStore-specific data types correctly.

Security Considerations

• Never commit environment variables or credentials.
• Use a database user with minimal privileges.
• Consider implementing a query whitelist in a production environment.
• Monitor and log all database operations.

Security Best Practices

This MCP server requires database access to run. For security reasons:

1. Create a dedicated SingleStore user with minimal privileges.
2. Avoid hard - coding sensitive credentials in configuration files or code.
3. Regularly review and update access policies to ensure security.
4. Enable audit logging to monitor database activities.

For more detailed security recommendations, refer to the SingleStore Security Guidelines.

📄 License

This project is licensed under the LICENSE. Please refer to the relevant file for specific details.

🤝 Contribution Guidelines

If you wish to contribute to this project, please refer to the CONTRIBUTING.md file for detailed information. We welcome your improvements and fixes!