superset-mcp
Provides full access to Apache Superset instances, enabling AI assistants to manage dashboards, charts, datasets, databases, and execute SQL queries through Superset's API.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@superset-mcpshow me the top 5 dashboards by view count"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
superset-mcp
MCP (Model Context Protocol) server for Apache Superset. Gives AI assistants full access to your Superset instance — dashboards, charts, datasets, databases, and SQL execution.
Prerequisites
uv — Python package manager
Access to a running Apache Superset instance
Related MCP server: Zaturn
Setup (takes ~1 minute)
1. Clone the repo
git clone <repo-url>
cd superset-mcp2. Configure credentials
cp .env.example .envEdit .env:
SUPERSET_URL=http://your-superset-host:8088
SUPERSET_USERNAME=your-username
SUPERSET_PASSWORD=your-password3. Test it works
uv run superset-mcpYou should see the MCP server start without errors. Press Ctrl+C to stop.
Connect to your AI client
Replace /ABSOLUTE/PATH/TO/superset-mcp with the actual path where you cloned the repo.
Claude Code
Add to ~/.claude/settings.json (or project-level .claude/settings.json):
{
"mcpServers": {
"superset": {
"command": "uv",
"args": ["--directory", "/ABSOLUTE/PATH/TO/superset-mcp", "run", "superset-mcp"],
"env": {
"SUPERSET_URL": "http://your-superset-host:8088",
"SUPERSET_USERNAME": "your-username",
"SUPERSET_PASSWORD": "your-password"
}
}
}
}Or run in terminal:
claude mcp add superset -- uv --directory /ABSOLUTE/PATH/TO/superset-mcp run superset-mcpClaude Desktop
Add to ~/Library/Application Support/Claude/claude_desktop_config.json (macOS)
or %APPDATA%\Claude\claude_desktop_config.json (Windows):
{
"mcpServers": {
"superset": {
"command": "uv",
"args": ["--directory", "/ABSOLUTE/PATH/TO/superset-mcp", "run", "superset-mcp"],
"env": {
"SUPERSET_URL": "http://your-superset-host:8088",
"SUPERSET_USERNAME": "your-username",
"SUPERSET_PASSWORD": "your-password"
}
}
}
}Cursor
Add to .cursor/mcp.json in your project or ~/.cursor/mcp.json globally:
{
"mcpServers": {
"superset": {
"command": "uv",
"args": ["--directory", "/ABSOLUTE/PATH/TO/superset-mcp", "run", "superset-mcp"],
"env": {
"SUPERSET_URL": "http://your-superset-host:8088",
"SUPERSET_USERNAME": "your-username",
"SUPERSET_PASSWORD": "your-password"
}
}
}
}Available Tools
Dashboards
Tool | Description |
| List all dashboards (with optional search) |
| Get a dashboard by ID or slug |
| Get all charts in a dashboard |
| Get all datasets used by a dashboard |
| Create a new dashboard |
| Update title, layout, metadata |
| Publish a draft dashboard |
| Duplicate a dashboard |
| Delete a dashboard |
Charts
Tool | Description |
| List all charts (with optional search) |
| Get a chart by ID or UUID |
| Fetch the latest data for a chart |
| Create a new chart |
| Update chart properties |
| Delete a chart |
Datasets
Tool | Description |
| List all datasets |
| Get a dataset by ID or UUID |
| Create from a table or SQL query |
| Get existing or create new |
| Sync columns from source table |
| Update dataset properties |
| See which charts/dashboards use it |
| Delete a dataset |
Databases
Tool | Description |
| List all database connections |
| Get a database connection by ID |
| List schemas in a database |
| List tables in a schema |
| Get column info for a table |
| Get a SELECT * template for a table |
SQL
Tool | Description |
| Run a SQL query and get results |
| Pretty-print a SQL query |
| Estimate query cost (if supported) |
| List saved SQL queries |
| Save a SQL query |
Example prompts
Once connected to your AI assistant:
"List all published dashboards"
"Create a new dashboard called 'Sales Overview'"
"Show me all charts in dashboard 11"
"Run a SQL query on database 2: SELECT count() FROM orders"*
"What datasets are used by the 'Revenue' dashboard?"
"Create a bar chart using dataset 5 showing sales by region"
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Servers
- AlicenseBqualityFmaintenanceMCP server enabling AI agents to programmatically connect to and control Apache Superset instances, allowing users to manage dashboards, charts, databases, datasets, and run SQL queries through natural language interactions.Last updated60188MIT
- AlicenseAqualityCmaintenanceAn open-source MCP server that connects to various data sources (SQL databases, CSV, Parquet files), allowing AI models to execute SQL queries and generate data visualizations for analytics and business intelligence.Last updated1275MIT
- Alicense-qualityCmaintenanceAn MCP server for Apache Superset that enables AI models to manage dashboards, create charts with auto-detection, and execute SQL queries programmatically. It utilizes stateless HTTP transport to ensure compatibility with integration tools like Open WebUI.Last updated108MIT
- AlicenseAqualityCmaintenanceAn MCP server that enables AI assistants to query databases, execute SQL, and manage Metabase resources like dashboards, cards, and collections through natural language.Last updated22MIT
Related MCP Connectors
MCP server for interacting with the Supabase platform
MCP server connecting AI agents to non-custodial staking data across 130+ networks.
GibsonAI MCP server: manage your databases with natural language
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/thedeceptio/superset-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server