Apache Superset MCP server (built in)

• Lists your dashboards, with search and filters

  Shows the dashboards in your Superset, and can search or filter them by name and other details.

  Try: “Which dashboards do we have about sales?”

  Read · list_dashboards

• Shows details of one dashboard

  Gets a dashboard's title, charts, owners and settings from its ID, slug or a shared link.

  Try: “What charts are on the Q4 Sales Overview dashboard?”

  Read · get_dashboard_info

• Pulls the data behind a dashboard's charts, with its filters applied

  Fetches a limited amount of data from the charts on a dashboard, taking the dashboard's filters into account. Added after Superset 6.1.0.

  Try: “Summarise the numbers on the revenue dashboard for last month.”

  Network · get_dashboard_data

• Shows how a dashboard is laid out

  Returns the layout of a dashboard: its rows, tabs, headers and where each chart sits. Added after Superset 6.1.0.

  Try: “How is the executive dashboard organised?”

  Read · get_dashboard_layout

• Lists the datasets a dashboard's charts use

  Shows which datasets and semantic views feed the charts on a dashboard. Added after Superset 6.1.0.

  Try: “Which datasets does the marketing dashboard depend on?”

  Read · get_dashboard_datasets

• Lists your saved charts, with search and filters

  Shows the saved charts in your Superset and can search or filter them.

  Try: “Find all charts that use the orders dataset.”

  Read · list_charts

• Shows the settings of one chart

  Gets a chart's type, dataset, metrics and other settings from its ID.

  Try: “How is chart 42 configured?”

  Read · get_chart_info

• Gets the data a chart shows

  Returns the data behind a saved chart so the assistant can read or summarise it.

  Try: “What are the numbers in the weekly signups chart?”

  Network · get_chart_data

• Gets a preview of a saved chart

  Returns a preview of a saved chart, such as an image or table.

  Try: “Show me a preview of chart 15.”

  Read · get_chart_preview

• Shows the SQL a chart runs, without running it

  Returns the SQL query Superset builds for a chart, without executing it. Added after Superset 6.1.0.

  Try: “What SQL does the revenue by region chart run?”

  Read · get_chart_sql

• Lists your datasets

  Shows the SQL datasets registered in Superset, with search and filters.

  Try: “What datasets are available?”

  Read · list_datasets

• Shows a dataset's columns and metrics

  Gets a dataset's columns, saved metrics and settings.

  Try: “Show me the columns in the sales_orders dataset.”

  Read · get_dataset_info

• Answers a question from a dataset using its saved metrics

  Queries a dataset with its saved metrics, columns and filters, without writing SQL. Added after Superset 6.1.0.

  Try: “What was total revenue by region last quarter in the sales dataset?”

  Network · query_dataset

• Lists the metrics you can use

  Shows the saved metrics available across your datasets and semantic views. Added after Superset 6.1.0.

  Try: “Which revenue metrics are defined?”

  Read · list_metrics

• Lists your database connections

  Shows the databases Superset is connected to.

  Try: “Which databases is Superset connected to?”

  Read · list_databases

• Shows details of one database connection

  Gets the settings of a database connection, such as its type and what it allows.

  Try: “What kind of database is connection 3?”

  Read · get_database_info

• Gives a short paged list of databases, datasets, charts or dashboards

  Returns a compact overview of what exists in your Superset, one page at a time. Added after Superset 6.1.0.

  Try: “Give me an overview of everything in this Superset.”

  Read · get_catalog

• Queries a data source and returns a table

  Runs a query against a data source and returns the result as a table, after checking the response is safe to return. Added after Superset 6.1.0.

  Try: “Show me the top 20 rows of the orders table.”

  Network · get_table

• Runs a SQL query on one of your databases

  Runs SQL against a connected database with your SQL Lab permissions. DROP, TRUNCATE and ALTER are blocked, but other changes can run if the database allows them.

  Try: “Run SELECT region, SUM(revenue) FROM orders GROUP BY region.”

  Delete · execute_sql

• Lists recent SQL queries

  Shows the SQL query history, with search and filters. Added after Superset 6.1.0.

  Try: “What queries did I run in SQL Lab today?”

  Read · list_queries

• Shows details of one past query

  Gets the SQL, status and timing of a query from the history. Added after Superset 6.1.0.

  Try: “Why did query 812 fail?”

  Read · get_query_info

• Lists saved SQL queries

  Shows the queries saved in SQL Lab. Added after Superset 6.1.0.

  Try: “Which saved queries do we have about churn?”

  Read · list_saved_queries

• Shows one saved SQL query

  Gets the SQL and details of a saved query. Added after Superset 6.1.0.

  Try: “Show me the saved churn query.”

  Read · get_saved_query_info

• Opens SQL Lab with a query filled in

  Builds a link that opens SQL Lab with SQL and the right database already filled in.

  Try: “Open this query in SQL Lab so I can edit it.”

  Read · open_sql_lab_with_context

• Creates a link to explore data in Superset

  Builds a link that opens Superset's chart explorer with a chart set up, without saving anything.

  Try: “Give me a link to explore orders by month.”

  Read · generate_explore_link

• Lists alerts and scheduled reports

  Shows the alerts and email reports set up in Superset. Added after Superset 6.1.0.

  Try: “Which reports are emailed every Monday?”

  Read · list_reports

• Shows one alert or report schedule

  Gets the schedule, recipients and settings of an alert or report. Added after Superset 6.1.0.

  Try: “Who receives report 4?”

  Read · get_report_info

• Lists annotation layers

  Shows the annotation layers used to mark events on charts. Added after Superset 6.1.0.

  Try: “What annotation layers exist?”

  Read · list_annotation_layers

• Shows one annotation layer

  Gets the details of an annotation layer. Added after Superset 6.1.0.

  Try: “What is in the product launches annotation layer?”

  Read · get_annotation_layer_info

• Lists the notes inside an annotation layer

  Shows the individual annotations, such as marked events, in one layer. Added after Superset 6.1.0.

  Try: “List the events in the releases layer.”

  Read · list_layer_annotations

• Shows one annotation

  Gets the details of a single annotation within a layer. Added after Superset 6.1.0.

  Try: “What does annotation 7 in the releases layer say?”

  Read · get_layer_annotation_info

• Lists tags

  Shows the tags used to organise dashboards, charts and other items. Added after Superset 6.1.0.

  Try: “What tags do we use?”

  Read · list_tags

• Shows one tag

  Gets the details of a tag. Added after Superset 6.1.0.

  Try: “What is tag 12 used for?”

  Read · get_tag_info

• Lists themes

  Shows the visual themes set up in Superset. Added after Superset 6.1.0.

  Try: “Which themes are available?”

  Read · list_themes

• Shows one theme

  Gets the settings of a theme. Added after Superset 6.1.0.

  Try: “What colours does the corporate theme use?”

  Read · get_theme_info

• Finds a person's user ID from their name

  Looks up users by name so they can be used in filters, for example dashboards owned by someone. Added after Superset 6.1.0.

  Try: “Find Maria's user ID.”

  Read · find_users

• Lists users (admins only)

  Shows Superset users with search and filters. Only admins can use it. Added after Superset 6.1.0.

  Try: “List all users added this month.”

  Read · list_users

• Shows one user's details (admins only)

  Gets a user's details by ID. Only admins can use it. Added after Superset 6.1.0.

  Try: “What roles does user 5 have?”

  Read · get_user_info

• Lists roles (admins only)

  Shows the roles in Superset. Only admins can use it. Added after Superset 6.1.0.

  Try: “Which roles exist?”

  Read · list_roles

• Shows one role's details (admins only)

  Gets a role's details by ID. Only admins can use it. Added after Superset 6.1.0.

  Try: “What can the Analyst role do?”

  Read · get_role_info

• Lists row-level security rules (admins only)

  Shows the row-level security filters that limit which rows each role sees. Needs admin access. Added after Superset 6.1.0.

  Try: “Which row-level security rules apply to the sales table?”

  Read · list_rls_filters

• Shows one row-level security rule (admins only)

  Gets a row-level security filter's details by ID. Needs admin access. Added after Superset 6.1.0.

  Try: “What does RLS filter 3 restrict?”

  Read · get_rls_filter_info

• Shows statistics about your Superset

  Returns counts and other statistics for the instance, such as how many dashboards and charts exist.

  Try: “How many dashboards are in this instance?”

  Read · get_instance_info

• Previews a new chart, and saves it if you ask

  Builds a chart from a dataset and shows a preview with a link; it is only saved when you ask.

  Try: “Create a bar chart showing monthly revenue by region from the sales dataset”

  Write · generate_chart

• Changes a chart preview without saving

  Adjusts a chart preview, such as its type or metrics, without saving anything.

  Try: “Make that preview a line chart instead.”

  Write · update_chart_preview

• Changes a saved chart

  Updates the settings of an existing saved chart.

  Try: “Change chart 42 to show weekly instead of daily.”

  Delete · update_chart

• Creates a new dashboard from charts

  Makes a new dashboard and places the charts you name on it.

  Try: “Create a dashboard called 'Q4 Sales Overview' with charts 10, 15, and 22”

  Write · generate_dashboard

• Adds a chart to a dashboard

  Adds a saved chart to an existing dashboard and places it in the grid.

  Try: “Add chart 31 to the sales dashboard.”

  Write · add_chart_to_existing_dashboard

• Removes a chart from a dashboard

  Takes a chart off an existing dashboard. Added after Superset 6.1.0.

  Try: “Remove the old signups chart from the growth dashboard.”

  Delete · remove_chart_from_dashboard

• Changes a dashboard's layout, theme or details

  Updates an existing dashboard's layout, theme, styling or details such as its title. Added after Superset 6.1.0.

  Try: “Rename the dashboard to 'Sales 2026' and use the dark theme.”

  Delete · update_dashboard

• Copies a dashboard under a new name

  Makes a copy of a dashboard with a new title; charts are copied too unless you choose to share them. Added after Superset 6.1.0.

  Try: “Duplicate the sales dashboard for the EMEA team.”

  Write · duplicate_dashboard

• Sets a dashboard's filters for you

  Applies values to a dashboard's existing filters for your view, and checks with you if a value does not match. Added after Superset 6.1.0.

  Try: “Filter the sales dashboard to Germany and last quarter.”

  Write · apply_dashboard_filters

• Adds, edits or removes a dashboard's filters

  Adds, changes, removes or reorders the filters on a dashboard. Added after Superset 6.1.0.

  Try: “Add a region filter to the sales dashboard.”

  Delete · manage_native_filters

• Adds or edits text, headers and dividers on a dashboard

  Adds, updates or removes text blocks, headers and dividers in a dashboard's layout. Added after Superset 6.1.0.

  Try: “Add a header saying 'Q4 results' above the charts.”

  Delete · manage_dashboard_markdown

• Marks a dashboard as certified, or clears it

  Sets or removes a dashboard's certification badge. Added after Superset 6.1.0.

  Try: “Mark the finance dashboard as certified by the data team.”

  Write · manage_dashboard_certification

• Adds or removes dashboard owners

  Changes who owns a dashboard. Added after Superset 6.1.0.

  Try: “Make Maria an owner of the sales dashboard.”

  Delete · manage_dashboard_owners

• Changes which roles can see a dashboard

  Adds or removes the roles allowed to view a dashboard. Added after Superset 6.1.0.

  Try: “Let only the Finance role see this dashboard.”

  Delete · manage_dashboard_roles

• Registers a database table as a dataset

  Adds a physical table from a connected database as a dataset you can chart. Added after Superset 6.1.0.

  Try: “Add the orders table as a dataset.”

  Write · create_dataset

• Saves a SQL query as a dataset you can chart

  Turns a SQL query into a virtual dataset so you can build charts from it.

  Try: “Create a dataset from: SELECT region, SUM(revenue) as total_revenue FROM orders GROUP BY region”

  Write · create_virtual_dataset

• Changes a dataset's settings

  Updates an existing SQL dataset's settings. Added after Superset 6.1.0.

  Try: “Change the description of the orders dataset.”

  Delete · update_dataset

• Adds a saved metric to a dataset

  Creates a reusable metric, such as total revenue, on a dataset. Added after Superset 6.1.0.

  Try: “Add a metric for average order value to the orders dataset.”

  Write · create_dataset_metric

• Changes a saved metric

  Updates a saved metric on a dataset. Added after Superset 6.1.0.

  Try: “Change the revenue metric to exclude refunds.”

  Delete · update_dataset_metric

• Saves a SQL query to SQL Lab

  Saves a query so it appears in SQL Lab's Saved Queries list.

  Try: “Save this query as 'Monthly churn'.”

  Write · save_sql_query

• Creates a reusable theme

  Makes a new visual theme from design settings such as colours. Added after Superset 6.1.0.

  Try: “Create a theme using our brand blue.”

  Write · create_theme

• Deletes a saved chart

  Deletes a saved chart; it goes to the trash and can be restored. Added after Superset 6.1.0.

  Try: “Delete chart 42.”

  Delete · delete_chart

• Deletes a dashboard

  Deletes a dashboard; it goes to the trash and can be restored. Added after Superset 6.1.0.

  Try: “Delete the old test dashboard.”

  Delete · delete_dashboard

• Deletes a dataset

  Deletes a dataset; it goes to the trash and can be restored. Added after Superset 6.1.0.

  Try: “Delete the unused staging dataset.”

  Delete · delete_dataset

• Deletes a saved metric from a dataset

  Removes a saved metric from a dataset. Added after Superset 6.1.0.

  Try: “Delete the old revenue_v1 metric.”

  Delete · delete_dataset_metric

• Restores a deleted chart from the trash

  Brings back a chart that was deleted. Added after Superset 6.1.0.

  Try: “Restore the chart I deleted yesterday.”

  Write · restore_chart

• Restores a deleted dashboard from the trash

  Brings back a dashboard that was deleted. Added after Superset 6.1.0.

  Try: “Restore the sales dashboard from the trash.”

  Write · restore_dashboard

• Restores a deleted dataset from the trash

  Brings back a dataset that was deleted. Added after Superset 6.1.0.

  Try: “Restore the orders dataset.”

  Write · restore_dataset

• Used by the assistant behind the scenes

  Finds metrics that work with the columns already picked

  Used while building a chart to see which metrics fit the current selection. Added after Superset 6.1.0.

  Try: “Which metrics can I combine with region?”

  Read · get_compatible_metrics

• Finds columns that work with the metrics already picked

  Used while building a chart to see which columns fit the current selection. Added after Superset 6.1.0.

  Try: “Which columns can I group revenue by?”

  Read · get_compatible_dimensions

• Looks up the settings a chart type needs

  Returns the full description and examples for a chart type, so the assistant can build it correctly.

  Try: “What options does a pie chart take?”

  Read · get_chart_type_schema

• Looks up what fields an item type has

  Returns the structure of a type of item, such as charts or datasets, so the assistant knows how to query it.

  Try: “What fields can I filter dashboards by?”

  Read · get_schema

• Lists background jobs

  Shows Superset's background tasks, used to follow long-running work. Added after Superset 6.1.0.

  Try: “Are any background jobs still running?”

  Read · list_tasks

• Checks on one background job

  Gets the status of a single background task. Added after Superset 6.1.0.

  Try: “Has task 18 finished?”

  Read · get_task_info

• Checks that the server is working

  A simple test that the MCP service is running.

  Try: “Is Superset healthy?”

  Read · health_check

• Writes a bug report about the connection

  Produces a bug report you can paste and send to whoever runs the server. Added after Superset 6.1.0.

  Try: “Write a bug report for the error you just got.”

  Read · generate_bug_report

• Finds the right Superset tool for a request

  In the default mode only a few tools are listed up front; the assistant uses this to search for the rest.

  Read · search_tools

• Runs a tool the assistant found by searching

  Runs a Superset tool that is not listed up front, after the assistant found it with the tool search.

  Write · call_tool

Watch out for

• No sign-in by default

  Every caller acts as the user set in MCP_DEV_USERNAME, often an admin. Keep the port on localhost or turn on token sign-in first. superset.apache.org

• It runs SQL on your databases

  DROP, TRUNCATE and ALTER are blocked, but other writes run if the database login allows them. Use a read-only database login or disable the SQL tool. github.com

• 6.1.0 cannot give each person their own login

  Maintainers say 6.1.0 cannot map tokens to users, so everyone shares one account. Per-user permissions need a newer build. github.com

• A broken custom sign-in can leave it open

  On 6.1.0, if a custom MCP_AUTH_FACTORY fails, the server starts with no sign-in. Check the logs after setup; newer builds refuse to start. github.com

• Newer builds can delete and change access

  Builds after 6.1.0 add tools that delete charts, dashboards and datasets and change dashboard owners and roles. Deleted items can be restored from trash. github.com

• Roles and audit log apply

  Each call checks the user's Superset roles and row-level security, and is recorded in Settings, Action Log. superset.apache.org

Security advisories

In their words