What features does SingleStore MCP server provide?

Q: What features does SingleStore MCP server provide?

get_user_info: Retrieve details about the current user. No arguments required; returns user information.. organization_info: Retrieve details about the user's current organization. No arguments required; returns organization details.. choose_organization: Choose from available organizations (only available when API key environment variable is not set). No arguments required; returns a list of organizations to choose from.. set_organization: Set the active organization (only available when API key environment variable is not set). Arguments: organization_id (string). Sets the specified organization as active.. run_sql: Execute SQL operations on a connected workspace. Arguments: workspace_id, database, sql_query, and connection parameters. Returns the results of the SQL query in a structured format.. create_notebook_file: Create a new notebook file in SingleStore Spaces. Arguments: notebook_name, content (optional). Returns details of the created notebook.. upload_notebook_file: Upload a notebook file to SingleStore Spaces. Arguments: file_path, notebook_name. Returns details of the uploaded notebook.. create_job_from_notebook: Create a scheduled job from a notebook. Arguments: job configuration including notebook_path, schedule_mode, etc. Returns details of the created job.

SingleStore MCP Server 2025: Features & Setup Guide

Overview

The SingleStore MCP Server provides an MCP-powered interface to interact with the SingleStore database platform through standard MCP clients. It includes an installer and an MCP server that lets large language models and other MCP clients communicate with SingleStore using natural language, enabling easier execution of complex operations. With MCP you can use Claude Desktop, Claude Code, Cursor, Windsurf, Gemini CLI, LM Studio, Goose, Qodo Gen, or any compatible MCP client to interact with SingleStore via natural language prompts. The server supports a standard configuration with uvx for quick setup, and authentication is handled automatically via browser OAuth (no API keys or environment variables required in typical usage). Docker deployments require an API key due to OAuth flow. The server exposes tools to manage users, organizations, workspaces, and data workflows, including SQL execution and notebook and job capabilities in SingleStore Spaces. Documentation covers automatic client setup and manual configuration across multiple MCP clients, along with developer scripts for development and testing.

Features

get_user_info

Retrieve details about the current user. No arguments required; returns user information.

organization_info

Retrieve details about the user's current organization. No arguments required; returns organization details.

choose_organization

Choose from available organizations (only available when API key environment variable is not set). No arguments required; returns a list of organizations to choose from.

set_organization

Set the active organization (only available when API key environment variable is not set). Arguments: organization_id (string). Sets the specified organization as active.

run_sql

Execute SQL operations on a connected workspace. Arguments: workspace_id, database, sql_query, and connection parameters. Returns the results of the SQL query in a structured format.

create_notebook_file

Create a new notebook file in SingleStore Spaces. Arguments: notebook_name, content (optional). Returns details of the created notebook.

upload_notebook_file

Upload a notebook file to SingleStore Spaces. Arguments: file_path, notebook_name. Returns details of the uploaded notebook.