# MCP Server Starrocks (MCP server)

> MCP Server Starrocks is an MCP server that adds database tools to AI assistants such as Claude Desktop, Claude Code and Cursor. StarRocks MCP (Model Context Protocol) Server. It has 195 GitHub stars, is released under the Apache-2.0 license and runs locally with uvx mcp-server-starrocks.

The StarRocks MCP Server acts as a bridge between AI assistants and StarRocks databases. It allows for direct SQL execution, database exploration, data visualization via charts, and retrieving detailed schema/data overviews without requiring complex client-side setup.

## Key facts

| Fact | Value |
|---|---|
| Repository | https://github.com/StarRocks/mcp-server-starrocks |
| GitHub stars | 195 |
| License | Apache-2.0 |
| Language | Python |
| Transport | stdio |
| Packages | pypi: mcp-server-starrocks |
| Remote URL | none |
| Needs API key | yes |
| Official | no |
| Works with | Claude Desktop, Claude Code, Cursor, VS Code |
| Category | Databases |
| Latest release | v0.4.0 (May 5, 2026) |
| Last commit | Sep 8, 2026 |

## Install

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "mcp-server-starrocks": {
      "command": "uvx",
      "args": [
        "mcp-server-starrocks"
      ],
      "env": {
        "STARROCKS_PASSWORD": "your-value"
      }
    }
  }
}
```

Settings > Developer > Edit Config. macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\. Restart Claude Desktop afterwards.

### Claude Code

```sh
claude mcp add --env STARROCKS_PASSWORD=your-value --transport stdio mcp-server-starrocks -- uvx mcp-server-starrocks
```

### Cursor (.cursor/mcp.json)

```json
{
  "mcpServers": {
    "mcp-server-starrocks": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-server-starrocks"
      ],
      "env": {
        "STARROCKS_PASSWORD": "your-value"
      }
    }
  }
}
```

Project file; use ~/.cursor/mcp.json to enable it in every project.

### VS Code (.vscode/mcp.json)

```json
{
  "inputs": [
    {
      "type": "promptString",
      "id": "starrocks_password",
      "description": "STARROCKS_PASSWORD",
      "password": true
    }
  ],
  "servers": {
    "mcp-server-starrocks": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-server-starrocks"
      ],
      "env": {
        "STARROCKS_PASSWORD": "${input:starrocks_password}"
      }
    }
  }
}
```

Config formats checked against the official docs on 2026-10-07.

## Environment variables

- `STARROCKS_HOST`: Shown in the README's example configuration.
- `STARROCKS_PORT`: Shown in the README's example configuration.
- `STARROCKS_USER`: Shown in the README's example configuration.
- `STARROCKS_PASSWORD` (secret): Shown in the README's example configuration.
- `STARROCKS_DB`: Shown in the README's example configuration.
- `STARROCKS_URL`: Shown in the README's example configuration.
- `STARROCKS_SSL_CA`: Shown in the README's example configuration.
- `STARROCKS_SSL_VERIFY_CERT`: Shown in the README's example configuration.
- `STARROCKS_SSL_VERIFY_IDENTITY`: Shown in the README's example configuration.

## Tools

- `read_query`
- `write_query`
- `analyze_query`
- `top_hot_tables`
- `top_bad_tables`
- `query_and_plotly_chart`
- `table_overview`
- `db_overview`

## Similar MCP servers

- [Crowdsentinel MCP Server](https://appsgit.com/mcp-servers/crowdsentinel-mcp-server): AI threat hunting & incident response for Elasticsearch/OpenSearch with endpoint & network forensics. (204 stars, GPL-3.0, needs API key)
- [MCP Neo4j Memory](https://appsgit.com/mcp-servers/mcp-neo4j-memory): MCP Neo4j Knowledge Graph Memory Server. (989 stars, MIT, official, needs API key)
- [Postgres MCP](https://appsgit.com/mcp-servers/postgres-mcp): Enterprise PostgreSQL MCP server with NL queries, hybrid search (pgvector+BM25), and web UI. (241 stars, PostgreSQL, official)
- [Argon](https://appsgit.com/mcp-servers/argon): Versioned MongoDB sandboxes for AI agents: branch, time-travel, merge, and undo over MCP. (176 stars, MIT)
- [Uteke](https://appsgit.com/mcp-servers/uteke): 🧠 The Brain for Your AI — Local-first memory engine for AI agents. (276 stars, Apache-2.0, official)
- [Schemagate](https://appsgit.com/mcp-servers/schemagate): Identity-scoped schema selection for text-to-SQL. (173 stars, Apache-2.0, needs API key)

---

Canonical page: https://appsgit.com/mcp-servers/mcp-server-starrocks
Source: appsgit (https://appsgit.com), the app store for github. Data from the GitHub API, refreshed daily.
Machine access: JSON API https://appsgit.com/api/v1/apps (OpenAPI: https://appsgit.com/openapi.json), MCP server https://mcp.appsgit.com/mcp, full index https://appsgit.com/llms-full.txt.