Happy slice of mcp pizzaMCP.pizza

superset-mcp

MCP.Pizza Chef: aptro

Sixty tools reach into a Superset installation you already run: listing and opening dashboards and charts, creating new ones, running and tidying SQL, and inspecting the databases behind it all. Several tools delete things outright, including whole dashboards, charts, and database connections. Sign-in is your Superset username and password kept in a local file rather than a key, and the sign-in token it receives is written to disk in plain form. You need a Superset of your own, and the project has been quiet for about a year.

Unmaintained · last code change about a year ago
Coding
Data

Use This MCP server To

List every dashboard and chart in my Superset Run a SQL query and summarize the results Create a new dashboard from a description I give See which tables a connected database has Tidy up old charts nobody uses any more Estimate what a heavy query will cost before running it

README

Superset MCP Integration

smithery badge

MCP server for interacting with Apache Superset, enabling AI agents to connect to and control a Superset instance programmatically.

Setup Instructions

Installing via Smithery

To install Superset Integration for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install @aptro/superset-mcp --client claude

Manual Installation

  1. Set Up Superset Locally

    Run this script to start Superset locally:

    git clone --branch 4.1.1 --depth 1 https://github.com/apache/superset && \
cd superset && \
docker compose -f docker-compose-image-tag.yml up

    Once Superset is running, you should be able to access it at http://localhost:8088 with default credentials:

    • Username: admin
    • Password: admin

  2. Clone This Repository

    Clone this repository to your local machine.

  3. Configure Environment Variables

    Create a .env file in the root directory with your Superset credentials:

    SUPERSET_BASE_URL=http://localhost:8088  # Change to your Superset URL
SUPERSET_USERNAME=your_username
SUPERSET_PASSWORD=your_password

  4. Install Dependencies

    uv pip install .

  5. Install MCP Config for Claude

    To use with Claude Desktop app:

    mcp install main.py

Usage with Claude

superset-mcp FAQ

Do I need a key or token?
No key. You put your Superset web address, username, and password into a small file, and it signs in on your behalf.
Can it delete my dashboards?
Yes. Deleting dashboards, charts, and even whole database connections are all among its tools, so give it an account with limited rights.
Do I need my own Superset already running?
Yes. It talks to a Superset you host. The instructions include a way to start one locally with Docker if you just want to try it.
Can I use this to answer a question from company data?
Yes. It can run a query against any database Superset is connected to and hand the results back for summarizing.
How hard is the setup?
This is a technical one. Expect Docker, a cloned project folder, and command-line installs before anything works.
Is it still maintained?
The last change was around a year ago. Nothing has been marked as retired, but it is not moving either.
Is my password kept safely?
It sits in a plain file beside the project, and the sign-in token it receives is written to disk unscrambled, so use a low-privilege account.