SingleStore MCP Server

Interact with the SingleStore database platform

Local serverstdioPython

What is the SingleStore MCP server?

Interact with the SingleStore database platform. The singlestore mcp server wraps that behind the Model Context Protocol, so an assistant can use it through 14 defined tools rather than through you.

What it actually does

Model Context Protocol (MCP) is a standardized protocol designed to manage context between large language models (LLMs) and external systems. This repository provides an installer and an MCP Server for Singlestore, enabling seamless integration.

Its toolset

Everything the assistant can do here goes through one of these:

  • get_user_info — Retrieve details about the current user
  • organization_info — Retrieve details about the user's current organization
  • choose_organization — Choose from available organizations (only available when API key environment variable is not set)
  • set_organization — Set the active organization (only available when API key environment variable is not set)
  • Arguments — organization_id (string)
  • workspace_groups_info — Retrieve details about the workspace groups accessible to the user
  • workspaces_info — Retrieve details about the workspaces in a specific workspace group
  • resume_workspace — Resume a suspended workspace
  • list_starter_workspaces — List all starter workspaces accessible to the user
  • create_starter_workspace — Create a new starter workspace
  • terminate_starter_workspace — Terminate an existing starter workspace
  • list_regions — Retrieve a list of all regions that support workspaces

Configuration

You will need one environment variable: MCP_API_KEY. The server will not start without them, which is usually why the tools fail to appear on a first run. Keep credentials in your client's env block or a secrets manager rather than in a file you might commit.

  • Python >= v3.10.0 - uvx installed on your python environment - VS Code, Cursor, Windsurf, Claude Desktop, Claude Code, Goose or any other MCP client

Adding it to your client

Installation goes through your MCP client rather than a global install: point it at singlestore-mcp-server on PyPI and it is fetched when the client starts. The copy-paste blocks for Claude Desktop, Claude Code and Cursor are further down this page.

When to reach for it

Plenty of database access servers cover similar ground. The differences that matter in practice are scope of access and how much setup stands between you and a working tool call. SingleStore's toolset — get_user_info, organization_info, choose_organization and 11 more — is a fair guide to whether it matches your workflow.

SyncDev reviews every entry in this directory against the project's own documentation before publishing, and revisits them as servers change.

Caveats

  • It runs with your machine's permissions. That is convenient and also the reason to think about what you point it at before you approve a tool call.
  • With 14 tools registered it takes up a noticeable share of the context window; turn it off in projects that never touch SingleStore.
  • Missing credentials fail quietly in some clients — if no tools show up, check the environment block first.
  • MCP clients confirm each tool call by default. Leave that on until you have watched what the singlestore mcp server does with a few real requests.

Available tools

ToolWhat it does
get_user_infoRetrieve details about the current user
organization_infoRetrieve details about the user's current organization
choose_organizationChoose from available organizations (only available when API key environment variable is not set)
set_organizationSet the active organization (only available when API key environment variable is not set)
Argumentsorganization_id (string)
workspace_groups_infoRetrieve details about the workspace groups accessible to the user
workspaces_infoRetrieve details about the workspaces in a specific workspace group
resume_workspaceResume a suspended workspace
list_starter_workspacesList all starter workspaces accessible to the user
create_starter_workspaceCreate a new starter workspace
terminate_starter_workspaceTerminate an existing starter workspace
list_regionsRetrieve a list of all regions that support workspaces
list_sharedtier_regionsRetrieve a list of shared tier regions
run_sqlExecute SQL operations on a connected workspace

How to install the SingleStore MCP server

{
  "mcpServers": {
    "singlestore-mcp-server": {
      "command": "uvx",
      "args": [
        "singlestore-mcp-server",
        "start"
      ]
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Configuration

  • Python >= v3.10.0 - uvx installed on your python environment - VS Code, Cursor, Windsurf, Claude Desktop, Claude Code, Goose or any other MCP client
VariableDescriptionRequired
MCP_API_KEYCredential the server authenticates with.Yes

Example prompts to try

  • Use SingleStore to get user info.
  • Use SingleStore to organization info.
  • Use SingleStore to choose organization.

Frequently asked questions

It connects SingleStore to MCP-compatible AI assistants such as Claude and Cursor, exposing 14 tools (get_user_info, organization_info, choose_organization, and more) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with SingleStore directly.