接入你的智能体
發布者自己的指令。不是 PlugMCP 端點。
用我們的金鑰與日誌託管一份副本。
uvx mcp-superset==0.2.3Claude Code 沒有本機指令的安裝連結。複製下方指令並在終端機中執行。
SUPERSET_BASE_URL=<value> SUPERSET_USERNAME=<value> SUPERSET_PASSWORD=<secret> claude mcp add bintocher-mcp-superset -- uvx mcp-superset==0.2.3在終端機中執行。
{ "mcpServers": { "bintocher-mcp-superset": { "command": "uvx", "args": [ "mcp-superset==0.2.3" ], "env": { "SUPERSET_BASE_URL": "<value>", "SUPERSET_USERNAME": "<value>", "SUPERSET_PASSWORD": "<secret>" } } }}claude_desktop_config.json
遠端 URL 還是本機指令? 兩種安裝方式的差異
A comprehensive Model Context Protocol (MCP) server for Apache Superset. Gives AI assistants (Claude, GPT, etc.) full control over your Superset instance — dashboards, charts, datasets, SQL Lab, users, roles, RLS, and more — through 137 tools.
Key differentiators:
--host, --port, --transport, --env-file)# From PyPI
pip install mcp-superset
# With uv (recommended)
uv pip install mcp-superset
# Run without installing (uvx)
uvx mcp-superset
Create a .env file in the current directory, or set environment variables:
# Required
SUPERSET_BASE_URL=https://superset.example.com
SUPERSET_USERNAME=admin
SUPERSET_PASSWORD=your_password
# Optional
SUPERSET_AUTH_PROVIDER=db # db (default) or ldap
SUPERSET_MCP_HOST=127.0.0.1 # Server host (default: 127.0.0.1)
SUPERSET_MCP_PORT=8001 # Server port (default: 8001)
SUPERSET_MCP_TRANSPORT=streamable-http # streamable-http (default), sse, or stdio
When Superset is behind SSO (OAuth/OIDC/SAML), password login via the REST API is unavailable. Instead, supply a browser session cookie:
Copy the cookie from your browser's dev tools (Application → Cookies →
your Superset domain → session). The MCP server sends it on every request
and fetches CSRF tokens with it. The session cannot be renewed server-side,
so when it expires you must paste a fresh value and restart the server.
Two things worth checking before you use this mode:
session. Instances that set
SESSION_COOKIE_NAME in superset_config.py use a different name (s, for
example). Use the name shown in dev tools and set SUPERSET_SESSION_COOKIE_NAME
accordingly./api/v1/. Where the
REST API is configured for JWT only, requests carrying a valid session cookie
still return 401 {"msg": "Missing Authorization Header"} - refreshing the
cookie will not help, and JWT mode is the only option there.Treat the cookie as a credential: it grants full access to your Superset
account for the lifetime of the session. Keep it in .env (which is
gitignored), not in shell history or committed config.
# Using CLI (after pip install)
mcp-superset
# Run without installing
uvx mcp-superset
# Using Python module
python -m mcp_superset
# With uv from source
uv run mcp-superset
# With custom settings
mcp-superset --host 0.0.0.0 --port 9000 --transport sse
# With custom .env file
mcp-superset --env-file /path/to/.env
# Using stdio transport (for Claude Desktop, Cursor, etc.)
mcp-superset --transport stdio
Add to your project's .mcp.json:
{
"mcpServers": {
"superset": {
"type": "http",
"url": "http://localhost:8001/mcp"
}
}
}
Then start the server: mcp-superset or uvx mcp-superset.
Add to claude_desktop_config.json:
{
"mcpServers": {
"superset": {
"command": "uvx",
"args": ["mcp-superset", "--transport", "stdio"],
"env": {
"SUPERSET_BASE_URL": "https://superset.example.com",
"SUPERSET_USERNAME": "admin",
"SUPERSET_PASSWORD": "your_password"
}
}
}
}
{
"mcpServers": {
"superset": {
"command": "uvx",
"args": ["mcp-superset", "--transport", "stdio"],
"env": {
"SUPERSET_BASE_URL": "https://superset.example.com",
"SUPERSET_USERNAME": "admin",
"SUPERSET_PASSWORD": "your_password"
}
}
}
}
Any MCP-compatible client can connect via:
http://<host>:<port>/mcphttp://<host>:<port>/ssemcp-superset --transport stdioThe server includes extensive built-in protections to prevent accidental data loss or misconfiguration.
Destructive operations require explicit confirmation parameters:
DROP, DELETE, UPDATE, INSERT, TRUNCATE, ALTER, CREATE, GRANT, REVOKE (SQL comments are stripped before checking)rls_update requires both roles and tables to prevent silent data wipeNATIVE_FILTER-<uuid> formatgranularity_sqla (required for dashboard time filters)superset-mcp/
├── pyproject.toml # Package configuration
├── .env.example # Environment variable template
├── LICENSE # MIT License
├── README.md # This file
├── README_RU.md # Russian documentation
├── CHANGELOG.md # Version history
└── src/mcp_superset/
├── __init__.py # Package init with __version__
├── __main__.py # CLI entry point with argparse
├── server.py # FastMCP server setup and configuration
├── auth.py # JWT authentication (login, refresh, CSRF)
├── client.py # HTTP client (auto-auth, retry, RISON pagination)
├── models.py # Pydantic models
└── tools/
├── __init__.py # register_all_tools()
├── helpers.py # Auto-sync datasource_access logic
├── dashboards.py # Dashboard + filter tools (20)
├── charts.py # Chart tools (11)
├── databases.py # Database tools (18)
├── datasets.py # Dataset tools (11)
├── queries.py # SQL Lab + saved query tools (13)
├── security.py # User, role, permission, RLS, bulk operations (26)
├── groups.py # Group management tools (9)
├── audit.py # Permissions audit tool (1)
├── tags.py # Tag tools (7)
└── system.py # Reports, annotations, logs, assets (21)
sst_*) is not implemented in SupersetAdd to your superset_config.py:
from datetime import timedelta
# Increase JWT token lifetime (default is 15 min)
JWT_ACCESS_TOKEN_EXPIRES = timedelta(hours=1)
JWT_REFRESH_TOKEN_EXPIRES = timedelta(days=30)
# Max API page size
FAB_API_MAX_PAGE_SIZE = 100
git clone https://github.com/bintocher/mcp-superset.git
cd superset-mcp
# Create virtual environment and install in editable mode
uv venv
uv pip install -e ".[dev]"
# Copy and configure .env
cp .env.example .env
# Edit .env with your Superset credentials
# Run from source
uv run python -m mcp_superset
# Or with CLI
uv run mcp-superset --port 8001
uv run python test_all_tools.py
These are handled automatically by the MCP server, but useful to know when debugging:
MIT — Stanislav Chernov (@bintocher)
MCP server for managing Apache Superset — 128+ tools for dashboards, charts, datasets, SQL Lab, access control
{ "mcpServers": { "bintocher-mcp-superset": { "command": "uvx", "args": [ "mcp-superset==0.2.3" ], "env": { "SUPERSET_BASE_URL": "<value>", "SUPERSET_USERNAME": "<value>", "SUPERSET_PASSWORD": "<secret>" } } }}工具
尚無工具清單。遠端伺服器會在首次健康檢查後取得工具清單。
常見問題
在本頁複製適用於 Cursor、Claude Desktop、Claude Code 或 VS Code 的 stdio 設定。它使用發布者的安裝方式,而不是 PlugMCP 代理伺服器。
發布者列出了以下環境變數:SUPERSET_BASE_URL, SUPERSET_USERNAME, SUPERSET_PASSWORD。
MCP Superset 透過 stdio 在本機執行。
上次檢查時間:2026-10-28。 MCP server for managing Apache Superset — 128+ tools for dashboards, charts, datasets, SQL Lab, access control