SingleStore MCP ServerSingleStore MCP Server

Remote

Integrate natural language processing with SingleStore to effortlessly manage your data and perform complex operations. Use this server to interact with your databases and execute SQL queries through a user-friendly interface. Simplify your workflow and enhance productivity with seamless access to your data resources.

Tools

workspace_groups_info

List all workspace groups accessible to the user in SingleStore. Returns detailed information for each group: - name: Display name of the workspace group - deploymentType: Type of deployment (e.g., 'PRODUCTION') - state: Current status (e.g., 'ACTIVE', 'PAUSED') - workspaceGroupID: Unique identifier for the group - firewallRanges: Array of allowed IP ranges for access control - createdAt: Timestamp of group creation - regionID: Identifier for deployment region - updateWindow: Maintenance window configuration Use this tool to: 1. Get workspace group IDs for other operations 2. Plan maintenance windows Related operations: - Use workspaces_info to list workspaces within a group - Use execute_sql to run queries on workspaces in a group

workspaces_info

List all workspaces within a specified workspace group in SingleStore. Returns detailed information for each workspace: - createdAt: Timestamp of workspace creation - deploymentType: Type of deployment (e.g., 'PRODUCTION') - endpoint: Connection URL for database access - name: Display name of the workspace - size: Compute and storage configuration - state: Current status (e.g., 'ACTIVE', 'PAUSED') - terminatedAt: Timestamp of termination if applicable - workspaceGroupID: Workspacegroup identifier - workspaceID: Unique workspace identifier Use this tool to: 1. Monitor workspace status 2. Get connection details for database operations 3. Track workspace lifecycle Required parameter: - workspaceGroupID: Unique identifier of the workspace group Related operations: - Use workspace_groups_info first to get workspacegroupID - Use execute_sql to run queries on specific workspace

organization_info

Retrieve information about the current user's organization in SingleStore. Returns organization details including: - orgID: Unique identifier for the organization - name: Organization display name

list_of_regions

List all available deployment regions where SingleStore workspaces can be deployed for the user. Returns region information including: - regionID: Unique identifier for the region - provider: Cloud provider (AWS, GCP, or Azure) - name: Human-readable region name (e.g., Europe West 2 (London),US West 2 (Oregon)) Use this tool to: 1. Select optimal deployment regions based on: - Geographic proximity to users - Compliance requirements - Cost considerations - Available cloud providers 2. Plan multi-region deployments

View 14 more tools

Installation

Login to configure client

Configuration

Monthly Tool Calls

110

Local

No

Published

3/18/2025