SingleStore MCP Server

Betadatabase

★70 starsTypeScriptsinglestore

About

Overview

The SingleStore MCP Server enables AI agents to interact with SingleStore (formerly MemSQL), the distributed SQL database designed for real-time analytics and transactions. It provides tools for executing queries, managing databases and tables, and leveraging SingleStore's unique features like columnstore indexes and pipeline data ingestion.

Capabilities

Tools & Capabilities

⚡query

Execute a SQL query against SingleStore

⚡list_databases

List all databases

⚡list_tables

List tables in a database

⚡describe_table

Get the schema of a table

Setup

Installation

bash

Install

npx -y @singlestore/mcp-server

Examples

Example Usage

javascript

Usage

{
  "mcpServers": {
    "singlestore": {
      "command": "npx",
      "args": ["-y", "@singlestore/mcp-server"],
      "env": {
        "SINGLESTORE_HOST": "localhost",
        "SINGLESTORE_PORT": "3306",
        "SINGLESTORE_USER": "root"
      }
    }
  }
}

Quick Info

Authorsinglestore

LanguageTypeScript

StatusBeta

Stars★ 70

Last UpdatedFeb 12, 2026