{"type":"mcp_server","name":"mcp-server-singlestore","description":"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.","category":"Database","language":"Python","stars":32,"forks":0,"owner":"singlestore-labs","github_url":"https://github.com/singlestore-labs/mcp-server-singlestore","homepage":null,"setup":"## Setup\n\n**Installing via Smithery:**\n\nTo install mcp-server-singlestore for Claude Desktop automatically via [Smithery](https://smithery.ai/server/@singlestore-labs/mcp-server-singlestore):\n\n```bash\nnpx -y @smithery/cli install @singlestore-labs/mcp-server-singlestore --client claude\n```\n\n**Clone the Repository:**\n\nTo clone the repository and set up the server locally:\n\n```bash\ngit clone https://github.com/singlestore-labs/mcp-server-singlestore.git\ncd mcp-server-singlestore\n# Install dependencies\npip install -e .\n```\n\n**Install via pip:**\n\nAlternatively, you can install the package using pip:\n\n```bash\npip install singlestore-mcp-server\n```\n\nUse command `singlestore-mcp-client` to run the server with the mcp clients or mcp inspector.\n\nThe server requires the following environment variables:\n\n```bash\n# SingleStore's management API key (required)\nSINGLESTORE_API_KEY=your_api_key_here\n\n# Database credentials (optional - can be provided as input parameters)\nSINGLESTORE_DB_USERNAME=your_db_username_here\nSINGLESTORE_DB_PASSWORD=your_db_password_here\n```","tools":"## Available Tools\n\n1.  workspace_groups_info (Retrieve details about the workspace groups accessible to the user)\n2.  workspaces_info (Retrieve details about the workspaces in a specific workspace group)\n3.  organization_info (Retrieve details about the user's current organization)\n4.  list_of_regions (Retrieve a list of all regions that support workspaces for the user)\n5.  execute_sql (Execute SQL operations on a connected workspace)\n6.  list_virtual_workspaces (List all starter workspaces accessible to the user)\n7.  create_virtual_workspace (Create a new starter workspace with a user)\n8.  execute_sql_on_virtual_workspace (Execute SQL operations on a virtual workspace)\n9.  list_notebook_samples (List all notebook samples available in SingleStore Spaces)\n10. create_notebook (Create a new notebook in the user's personal space)\n11. list_personal_files (List all files in the user's personal space)\n12. create_scheduled_job (Create a new scheduled job to run a notebook)\n13. get_job_details (Get details about a specific job)\n14. list_job_executions (List execution history for a specific job)","faq":null,"created_at":"2025-03-03T11:25:06+00:00","updated_at":"2025-03-27T11:09:52+00:00","source_url":"https://model-context-protocol.com/servers/mcp-server-singlestore-llm-natural-language","related_articles":[]}