Execute SQL queries on databases within a workspace group using SingleStore MCP Server. Retrieve formatted results, metadata, and execution status while adhering to strict read-only query restrictions for security.
Retrieve detailed information on available deployment regions for SingleStore workspaces, including region ID, provider, and name, to optimize placements based on proximity, compliance, cost, and provider preferences.
Generate and customize Jupyter notebooks for Python and Markdown tasks, ensuring unique names and valid JSON content for streamlined data analysis and integration with SingleStore databases.
Retrieve and manage virtual workspaces in SingleStore. Lists workspace details like ID, name, connection endpoints, and status to access databases and monitor availability.
Retrieve detailed information about all accessible workspace groups in SingleStore, including IDs, deployment types, states, IP ranges, and maintenance windows, to plan operations and manage resources effectively.
An implementation of the Model Context Protocol (MCP) server for SingleStore that enables natural language interaction with SingleStore databases through compatible LLM clients like Claude Desktop and Cursor.
A server for interacting with SingleStore databases, enabling table querying, schema descriptions, and ER diagram generation with secure SSL support and TypeScript safety.
Display all files and notebooks in a shared SingleStore workspace, including metadata like name, path, timestamps, size, and permissions. Use to manage, verify, and organize workspace contents efficiently.
Schedule automated execution of SingleStore notebooks for tasks like ETL workflows, data aggregation, reporting, and maintenance. Supports one-time or recurring runs with optional snapshot backups.
Set the organization for all subsequent API calls in SingleStore MCP Server. Use this after logging in to select the target organization by ID or name, ensuring all API requests align with the chosen organization.
Retrieve a list of organizations accessible to your account for managing queries. Use this tool to view organization details, verify permissions, and select the correct context for database interactions.
Retrieve the current user's UUID for constructing personal resource paths. Returns a unique identifier to reference user-specific data efficiently in the SingleStore MCP Server environment.
Retrieve the organization's unique identifier (project ID) for constructing paths or references to shared resources. Cache the ID to optimize performance for multiple API calls.
Retrieve detailed workspace information within a specified group, including deployment type, status, endpoints, and configurations in SingleStore MCP Server.
Create and configure a new virtual workspace in SingleStore, including database setup and user access credentials. Streamlines workspace creation, database initialization, and user account management in one process.
Execute read-only SQL queries on a SingleStore starter workspace to retrieve formatted results, column metadata, row count, and execution status securely. Use only SELECT statements to ensure data integrity.
Retrieve the complete path of a notebook by its name and location, formatted for API operations. Essential for creating scheduled jobs using the returned path.
Retrieve detailed information about a scheduled notebook job, including job ID, name, description, timestamps, execution counts, config settings, and metadata by specifying the job's UUID.
Access a catalog of pre-built notebook templates in SingleStore Spaces to streamline workflows like data loading, query optimization, and machine learning. Includes names, descriptions, download links, and usage metrics.
Access execution history and performance metrics of scheduled notebook jobs using job ID. Track status, start/end times, and execution details for improved job monitoring and analysis.
Monitor and analyze resource consumption and cost trends by retrieving detailed billing and usage metrics for your organization over specified time intervals (hourly, daily, monthly).