SingleStore MCP Server

Name: SingleStore MCP Server
Author: singlestore-labs

@singlestore-labs

Repository Homepage

About SingleStore MCP Server

MCP server for interacting with SingleStore Management API and services

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp-server-singlestore": {
      "command": "uvx",
      "args": [
        "singlestore-mcp-server",
        "init",
        "--client=claude-desktop"
      ]
    }
  }
}

Tools

Retrieve details about the current user

Retrieve details about the user's current organization

Choose from available organizations (only available when API key environment variable is not set)

Set the active organization (only available when API key environment variable is not set)

Retrieve details about the workspace groups accessible to the user

Retrieve details about the workspaces in a specific workspace group

Resume a suspended workspace

List all starter workspaces accessible to the user

Create a new starter workspace

Terminate an existing starter workspace

Retrieve a list of all regions that support workspaces

Retrieve a list of shared tier regions

Execute SQL operations on a connected workspace

Create a new notebook file in SingleStore Spaces

Upload a notebook file to SingleStore Spaces

Create a scheduled job from a notebook

Retrieve details of an existing job

Delete an existing job

List files and folders in a Stage deployment's file system

Get a file from Stage by path

Create a folder in Stage

Upload a file to Stage with text content

Move or rename a file or folder in Stage

Delete a file or folder from Stage

Overview

What is SingleStore MCP Server?

The SingleStore MCP Server implements the Model Context Protocol (MCP) to enable seamless integration between large language models and SingleStore. It allows users to interact with SingleStore using natural language through any compatible MCP client, making complex operations easier.

How to use SingleStore MCP Server?

Install with uvx singlestore-mcp-server start or use automatic setup commands like uvx singlestore-mcp-server init --client=claude-desktop. No API keys or environment variables are needed – authentication is handled via browser OAuth. For Docker, an API key is required. The server works with Claude Desktop, Claude Code, Cursor, VS Code, Windsurf, Gemini CLI, LM Studio, Goose, and Qodo Gen.

Key features of SingleStore MCP Server

Run SQL queries on connected workspaces
Manage workspaces (resume, create, terminate starter workspaces)
Create, upload, and manage notebook files
Create and manage scheduled jobs from notebooks
Perform file operations on Stage deployments
Retrieve user and organization information
Switch organizations when not using an API key

Use cases of SingleStore MCP Server

Query SingleStore databases via natural language in an MCP client
Automate workspace lifecycle management (create, resume, terminate)
Upload and schedule notebooks for recurring tasks
Manage files and folders in Stage deployments
Retrieve and organize workspace group and region information

FAQ from SingleStore MCP Server

What are the prerequisites?

Python >= 3.10.0, uvx installed, and an MCP client (e.g., VS Code, Cursor, Claude Desktop).

Do I need an API key or token?

No. The server automatically handles authentication via browser OAuth when started. An API key is required only when running the server in Docker.

Which MCP clients are supported?

Claude Desktop, Claude Code, Cursor, VS Code, Windsurf, Gemini CLI, LM Studio, Goose, and Qodo Gen are explicitly supported.

Can I run the server in Docker?

Yes, but OAuth is not supported in Docker containers, so you must provide an API key via the MCP_API_KEY environment variable.

What tools are available for organization management?

The choose_organization and set_organization tools are only available when the API key environment variable is not set, allowing interactive organization selection during OAuth.

Comments

More Other MCP servers

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K