# mcp-server-singlestore

> MCP Server

This repository offers an installer and MCP Server for SingleStore, facilitating seamless integration with LLMs through the Model Context Protocol. It enables natural language interaction with SingleStore using tools like Claude Desktop.

## Overview

- **Category:** Database
- **Language:** Python
- **Stars:** 32
- **Forks:** 0
- **Owner:** singlestore-labs
- **GitHub:** https://github.com/singlestore-labs/mcp-server-singlestore
- **Created:** 2025-03-03T11:25:06+00:00
- **Updated:** 2025-03-27T11:09:52+00:00
- **Source:** https://model-context-protocol.com/servers/mcp-server-singlestore-llm-natural-language

## Setup

## Setup

**Installing via Smithery:**

To install mcp-server-singlestore for Claude Desktop automatically via [Smithery](https://smithery.ai/server/@singlestore-labs/mcp-server-singlestore):

```bash
npx -y @smithery/cli install @singlestore-labs/mcp-server-singlestore --client claude
```

**Clone the Repository:**

To clone the repository and set up the server locally:

```bash
git clone https://github.com/singlestore-labs/mcp-server-singlestore.git
cd mcp-server-singlestore
# Install dependencies
pip install -e .
```

**Install via pip:**

Alternatively, you can install the package using pip:

```bash
pip install singlestore-mcp-server
```

Use command `singlestore-mcp-client` to run the server with the mcp clients or mcp inspector.

The server requires the following environment variables:

```bash
# SingleStore's management API key (required)
SINGLESTORE_API_KEY=your_api_key_here

# Database credentials (optional - can be provided as input parameters)
SINGLESTORE_DB_USERNAME=your_db_username_here
SINGLESTORE_DB_PASSWORD=your_db_password_here
```

## Tools

## Available Tools

1.  workspace_groups_info (Retrieve details about the workspace groups accessible to the user)
2.  workspaces_info (Retrieve details about the workspaces in a specific workspace group)
3.  organization_info (Retrieve details about the user's current organization)
4.  list_of_regions (Retrieve a list of all regions that support workspaces for the user)
5.  execute_sql (Execute SQL operations on a connected workspace)
6.  list_virtual_workspaces (List all starter workspaces accessible to the user)
7.  create_virtual_workspace (Create a new starter workspace with a user)
8.  execute_sql_on_virtual_workspace (Execute SQL operations on a virtual workspace)
9.  list_notebook_samples (List all notebook samples available in SingleStore Spaces)
10. create_notebook (Create a new notebook in the user's personal space)
11. list_personal_files (List all files in the user's personal space)
12. create_scheduled_job (Create a new scheduled job to run a notebook)
13. get_job_details (Get details about a specific job)
14. list_job_executions (List execution history for a specific job)