Apache Superset MCP server

This is a helper that connects your AI assistant to Apache Superset, the tool many teams use to build dashboards and charts from their data. Once it is set up, you can ask your AI in plain words to look things up or make changes in Superset instead of clicking through the website yourself. It is handy for anyone who works with dashboards and reports but does not want to hunt through menus all day.

What this MCP server does

You ask your AI something about your Superset, like which dashboards exist or who can see a certain chart. The AI sends that request to this helper program, which talks to your Superset instance using your login details. Superset answers, and the helper passes the result back to the AI. The AI then explains it to you in the chat, in normal words. For changes, like creating a dashboard or updating a user, the same thing happens in reverse: the helper makes the change in Superset for you.

Click to zoom

What you can do with it

• List and search your dashboards, charts and datasets
• Create, copy, update or delete dashboards and charts
• Run read-only SQL queries in SQL Lab and get the results
• Manage users, roles and groups in Superset
• Set up Row Level Security so people only see their own rows
• Check who has access to which dashboards and datasets
• Export or import dashboards and charts as files

Try asking your AI

• “List all dashboards in Superset and tell me which ones are still drafts”
• “Create a new chart from the sales dataset showing revenue by month”
• “Which users have access to the Finance dashboard?”
• “Run this SQL query in SQL Lab and show me the first 20 rows”

What it gives back to you

You get answers in the chat: lists of dashboards, charts or users, details about a specific item, or the rows from a SQL query. When you ask it to change something, it tells you what it changed, like a new dashboard name or an updated user role. For exports, it can hand you a file to download. Everything shows up as normal text in your conversation, no technical steps for you to follow.

Before you start

Who it's for

Data analysts, BI teams and anyone who manages Superset dashboards, datasets or user access and wants to do it by chatting instead of clicking.