drio
Open app

SingleStore MCP Server

Source

SingleStore MCP server implemented in TS

Catalog onlyCatalog onlySTDIO

Overview

SingleStore MCP Server is a Model Context Protocol (MCP) server enabling secure interaction with SingleStore databases, allowing AI assistants to safely list tables, read data, and execute SQL queries through a controlled interface.

To use the SingleStore MCP Server, install it via pip, configure the necessary environment variables, and run it either as part of a system like Claude Desktop or as a standalone server.

  • Lists available SingleStore tables. - Reads table contents in various formats (BSON and JSON). - Executes SQL queries with error handling. - Supports SingleStore specific data types and functions. - Includes secure database access procedures. - Provides comprehensive logging of operations.
  1. Secure exploration of SingleStore database tables.
  2. Integration with AI tools for data querying.
  3. Logging database actions for audit and security.

Add to your AI client

Use these steps to connect SingleStore MCP Server in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.

Cursor

Add this to your .cursor/mcp.json file in your project root, then restart Cursor.

.cursor/mcp.json

{
  "mcpServers": {
    "singlestore-mcp-server-madhukarkumar": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-singlestore-mcp-server-madhukarkumar"
      ]
    }
  }
}

Claude Desktop

Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

{
  "mcpServers": {
    "singlestore-mcp-server-madhukarkumar": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-singlestore-mcp-server-madhukarkumar"
      ]
    }
  }
}

Claude Code

Add this to your project's .mcp.json file. Claude Code will detect it automatically.

.mcp.json (project root)

{
  "mcpServers": {
    "singlestore-mcp-server-madhukarkumar": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-singlestore-mcp-server-madhukarkumar"
      ]
    }
  }
}

VS Code (Copilot)

Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.

.vscode/mcp.json

{
  "servers": {
    "singlestore-mcp-server-madhukarkumar": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-singlestore-mcp-server-madhukarkumar"
      ]
    }
  }
}

Windsurf

Add this to your Windsurf MCP config file, then restart Windsurf.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "singlestore-mcp-server-madhukarkumar": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-singlestore-mcp-server-madhukarkumar"
      ]
    }
  }
}

Cline

Open Cline settings, navigate to MCP Servers, and add this server configuration.

Cline MCP Settings (via UI)

{
  "mcpServers": {
    "singlestore-mcp-server-madhukarkumar": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-singlestore-mcp-server-madhukarkumar"
      ]
    }
  }
}

FAQ

How do I secure my database with this server?

Use a dedicated SingleStore user with minimal permissions and follow best security practices like query whitelisting and regular audits.

Can it run with other AI assistants besides Claude?

Yes, the server can be configured for use with various AI systems that support MCP functionality.

What types of data can I work with?

You can handle BSON, JSON, and other SingleStore-specific data types.7:["$","div",null,{"className":"container mx-auto flex flex-col gap-4","children":["$L26","$L27",["$","$L28",null,{"currentProject":{"id":318,"uuid":"9c418efb-24f5-4a5f-bbfd-71ca9fc48e6b","name":"singlestore-mcp-server","title":"SingleStore MCP Server","description":"SingleStore MCP server implemented in TS","avatar_url":"https://avatars.githubusercontent.com/u/994508?v=4","created_at":"2024-12-13T13:18:34.894Z","updated_at":"2024-12-13T15:09:09.267Z","status":"created","author_name":"madhukarkumar","author_avatar_url":"https://avatars.githubusercontent.com/u/994508?v=4","tags":"[]","category":"research-and-data","is_featured":false,"sort":1,"url":"https://github.com/madhukarkumar/singlestore-mcp-server","target":"_self","content":"$29","summary":"$2a","img_url":"https://camo.githubusercontent.com/e957da5698ad1b130cc2ca876477d8c13885ea76fa9f51447152a8513a2a05f3/68747470733a2f2f736d6974686572792e61692f62616467652f406d616468756b61726b756d61722f73696e676c6573746f72652d6d63702d736572766572","type":null,"metadata":"{\"star\":\"2\",\"license\":\"\",\"language\":\"JavaScript\",\"is_official\":false,\"latest_commit_time\":\"2025-03-11 11:49:02\"}","user_uuid":null,"tools":null,"sse_url":null,"sse_provider":null,"sse_params":null,"is_official":false,"server_command":null,"server_params":null,"server_config":null,"allow_call":false,"is_innovation":false,"is_dxt":false,"dxt_manifest":null,"dxt_file_url":null,"is_audit":false},"randomProjects":[],"currentServerKey":"$undefined"}]]}]

Research and data