singlestore-mcp-server

singlestore-mcp-server

3

The SingleStore MCP Server is a Model Context Protocol server that facilitates database interactions with SingleStore. It offers robust tools for querying, schema management, and data visualization, with support for both MCP and SSE protocols.

SingleStore MCP Server

A Model Context Protocol (MCP) server designed for interactions with SingleStore databases, offering features like querying tables, describing schemas, and generating ER diagrams.

Features

  • List and retrieve schema of tables
  • Execute SQL queries
  • Generate ER diagrams
  • SSL support with automatic CA bundle fetching
  • Error handling and TypeScript type safety

Prerequisites

  • Node.js 16 or higher
  • SingleStore database access

Usage

Supports both MCP and SSE protocols for varied client integration.

Installation

Installation via Smithery with specified environment variables for database connection.

Development

Includes building, testing, and a detailed project structure.