Apache Superset
π βοΈ π π πͺ π§ - Full-featured Apache Superset MCP server with 135+ tools for dashboards, charts, da
What is Apache Superset?
Apache Superset is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to π βοΈ π π πͺ π§ - full-featured apache superset mcp server with 135+ tools for dashboards, charts, da
π βοΈ π π πͺ π§ - Full-featured Apache Superset MCP server with 135+ tools for dashboards, charts, da
This server falls under the Analytics category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- MCP protocol support
Use Cases
Maintainer
Works with
Installation
PIP
pip install mcp-supersetManual Installation
pip install mcp-supersetConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Apache Superset
The Apache Superset MCP Server (mcp-superset) provides AI assistants with comprehensive programmatic access to Apache Superset through 137 MCP tools spanning dashboards, charts, databases, datasets, SQL Lab, security, scheduling, and auditing. It authenticates to your Superset instance using standard credentials, then lets AI clients create and publish dashboards, run SQL queries, manage user permissions, schedule reports, and export assets β all through natural language. Data analysts and platform engineers use it to automate routine Superset administration and accelerate dashboard development workflows.
Prerequisites
- Python 3.10 or higher with pip or uv installed
- A running Apache Superset instance (self-hosted or cloud) with admin credentials
- Superset Management API accessible over HTTP/HTTPS
- An MCP-compatible client such as Claude Desktop or Cursor
Install mcp-superset
Install the mcp-superset package from PyPI using pip or uv. The uvx command can also run it without a permanent install.
pip install mcp-superset
# or with uv:
uv pip install mcp-supersetSet required environment variables
Configure the three required environment variables pointing to your Superset instance. These are used to authenticate every API request.
export SUPERSET_BASE_URL=https://superset.example.com
export SUPERSET_USERNAME=admin
export SUPERSET_PASSWORD=your_passwordTest the server via stdio
Run the server in stdio mode to confirm it can authenticate to your Superset instance before wiring it up to a client.
mcp-superset --transport stdioConfigure your MCP client
Add the server to claude_desktop_config.json. Pass credentials via the env block so the server authenticates automatically on each client startup.
{
"mcpServers": {
"superset": {
"command": "uvx",
"args": ["mcp-superset", "--transport", "stdio"],
"env": {
"SUPERSET_BASE_URL": "https://superset.example.com",
"SUPERSET_USERNAME": "admin",
"SUPERSET_PASSWORD": "your_password"
}
}
}
}Restart your MCP client and verify
Restart Claude Desktop. The 137 Superset tools should appear in the connected tools list. Try listing dashboards to confirm connectivity.
Apache Superset Examples
Client configuration
claude_desktop_config.json entry for mcp-superset using uvx with credentials passed as environment variables.
{
"mcpServers": {
"superset": {
"command": "uvx",
"args": ["mcp-superset", "--transport", "stdio"],
"env": {
"SUPERSET_BASE_URL": "https://superset.example.com",
"SUPERSET_USERNAME": "admin",
"SUPERSET_PASSWORD": "your_password"
}
}
}
}Prompts to try
Example prompts for managing Apache Superset through your AI client.
- "List all published dashboards and tell me which ones haven't been viewed in 30 days"
- "Run this SQL query against the production database: SELECT count(*) FROM orders WHERE status='pending'"
- "Create a new bar chart showing monthly revenue from the sales dataset"
- "Add a Row Level Security rule to the orders table that filters by department for the Sales role"
- "Export the 'Executive Summary' dashboard as a ZIP file"Troubleshooting Apache Superset
Authentication fails with 401 or 403 errors
Verify SUPERSET_USERNAME and SUPERSET_PASSWORD are correct and the user has admin privileges. If using LDAP authentication, set SUPERSET_AUTH_PROVIDER=ldap in your environment.
Destructive operations (delete, permission changes) are blocked
This is by design β mcp-superset requires explicit confirmation for destructive operations. When prompted for confirmation by Claude, respond affirmatively to proceed.
SQL Lab queries are blocked with DDL/DML errors
The server blocks DDL (CREATE, DROP, ALTER) and DML (INSERT, UPDATE, DELETE) statements in SQL Lab by default as a safety measure. Use Superset's native SQL Lab UI for schema changes.
Frequently Asked Questions about Apache Superset
What is Apache Superset?
Apache Superset is a Model Context Protocol (MCP) server that π βοΈ π π πͺ π§ - full-featured apache superset mcp server with 135+ tools for dashboards, charts, da It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Apache Superset?
Install via pip with: pip install mcp-superset. Then configure your AI client to connect to this MCP server.
Which AI clients work with Apache Superset?
Apache Superset works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Apache Superset free to use?
Yes, Apache Superset is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.
Apache Superset Alternatives β Similar Analytics Servers
Looking for alternatives to Apache Superset? Here are other popular analytics servers you can use with Claude, Cursor, and VS Code.
OpenMetadata
β 14.0kOpenMetadata is a unified metadata platform for data discovery, data observability, and data governance powered by a central metadata repository, in-depth column level lineage, and seamless team collaboration.
Superset
β 10.9kAn MCP server that provides AI assistants with full access to Apache Superset instances, enabling interaction with dashboards, charts, datasets, databases, and SQL execution capabilities.
Horizon
β 4.4kπ‘ Your own AI-powered news radar. Generates daily briefings in English & Chinese. | η¨ AI ζε»Ίδ½ δΈε±ηζ°ι»ι·θΎΎ
MCP Server Chart
β 4.1kEnables generation of 25+ types of charts and data visualizations using AntV, including bar charts, line charts, maps, mind maps, and specialized diagrams like fishbone and sankey charts. Supports both statistical charts and geographic visualizations
Muapi CLI
β 997Official CLI for muapi.ai β generate images, videos & audio from the terminal. MCP server, 14 AI models, npm + pip installable.
Weather MCP Server
β 907Weather Data Fetcher MCP server built with Node.js, MCP SDK, and Zod. Provides weather details like temperature and forecast for cities such as Noida and Delhi via a registered tool. Simplifies API integration, enabling structured responses for clien
Browse More Analytics MCP Servers
Explore all analytics servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Apache Superset in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Apache Superset?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.