{"type":"mcp_server","name":"mcp-server-starrocks","description":"The StarRocks MCP Server bridges AI assistants and StarRocks databases, enabling direct SQL execution and database exploration without complex setup. It offers tools for querying and resources for database introspection.","category":"Database","language":"Python","stars":180,"forks":4,"owner":"StarRocks","github_url":"https://github.com/StarRocks/mcp-server-starrocks","homepage":null,"setup":"## Setup\n\nMCP server config:\n\n```json\n{\n  \"mcpServers\": {\n    \"mcp-server-starrocks\": {\n      \"command\": \"uv\",\n      \"args\": [\n        \"run\",\n        \"--with\",\n        \"mcp-server-starrocks\",\n        \"mcp-server-starrocks\"\n      ],\n      \"env\": {\n        \"STARROCKS_HOST\": \"default localhost\",\n        \"STARROCKS_PORT\": \"default 9030\",\n        \"STARROCKS_USER\": \"default root\",\n        \"STARROCKS_PASSWORD\": \"default empty\"\n      }\n    }\n  }\n}\n```\n\nIf mcp-server-starrocks is not installed as python package(in dev env), can run using local dir:\n\n```json\n{\n  \"mcpServers\": {\n    \"mcp-server-starrocks\": {\n      \"command\": \"uv\",\n      \"args\": [\n        \"--directory\",\n        \"path/to/mcp-server-starrocks\",\n        \"run\",\n        \"mcp-server-starrocks\"\n      ],\n      \"env\": {\n        \"STARROCKS_HOST\": \"default localhost\",\n        \"STARROCKS_PORT\": \"default 9030\",\n        \"STARROCKS_USER\": \"default root\",\n        \"STARROCKS_PASSWORD\": \"default empty\"\n      }\n    }\n  }\n}\n```","tools":"## Available Tools\n\n1.  `read_query` (Execute a SELECT query or commands that return a ResultSet)\n2.  `write_query` (Execute an DDL/DML or other StarRocks command that do not have a ResultSet)\n3.  `starrocks:///databases` (Lists all databases in StarRocks)\n4.  `starrocks:///{db}/{table}/schema` (Gets the schema of a table using SHOW CREATE TABLE)\n5.  `starrocks:///{db}/tables` (Lists all tables in a specific database)\n6.  `proc:///{+path}` (System internal information exposed by StarRocks similar to linux /proc)","faq":null,"created_at":"2025-03-05T10:48:25+00:00","updated_at":"2025-03-28T11:13:51+00:00","source_url":"https://model-context-protocol.com/servers/starrocks-ai-assistant-database-sql-server","related_articles":[]}