← Back to Apache Superset

Install Apache Superset

Pick your client, copy the command, done.

database
1

Add it to Claude Code

claude mcp add -e "SUPERSET_URL=${SUPERSET_URL}" -e "SUPERSET_USERNAME=${SUPERSET_USERNAME}" -e "SUPERSET_PASSWORD=${SUPERSET_PASSWORD}" mcp-superset -- uvx mcp-superset
Required:SUPERSET_URLSUPERSET_USERNAMESUPERSET_PASSWORD

Environment Variables

Set these before running Apache Superset.

VariableDescriptionRequired
SUPERSET_URLThe base URL of your Apache Superset instanceYes
SUPERSET_USERNAMEUsername for authenticationYes
SUPERSET_PASSWORDPassword for authenticationYes

Available Tools (5)

Once configured, Apache Superset gives your AI agent access to:

dashboard_crudPerform create, read, update, and delete operations on Superset dashboards.
dashboard_idpayload
chart_crudManage Superset charts including creation, retrieval, and updates.
chart_idpayload
sql_lab_queryExecute queries in SQL Lab, format SQL, and export results.
database_idsqlschema
security_managementManage users, roles, groups, and Row Level Security (RLS) policies.
user_idrole_idpolicy_id
permissions_auditPerform a comprehensive audit of user permissions and access matrices.
user_id

Try It Out

After setup, try these prompts with your AI agent:

→List all dashboards currently available in my Superset instance.
→Create a new chart based on the 'sales_data' dataset showing total revenue by month.
→Run a SQL query to check the top 10 customers from the 'orders' table in SQL Lab.
→Audit the permissions for the user 'jdoe' and identify any excessive access rights.
→Grant the 'Marketing' role access to the 'Q3 Performance' dashboard.
Prerequisites & system requirements
  • An MCP-compatible client (Claude Code, Cursor, Windsurf, Claude Desktop, or Codex)
  • Python 3.8+ with pip installed
  • SUPERSET_URL — The base URL of your Apache Superset instance
  • SUPERSET_USERNAME — Username for authentication
  • SUPERSET_PASSWORD — Password for authentication
Alternative installation methods

pip

pip install mcp-superset

Keep this setup from going cold

Save the docs, env vars, and workflow around Apache Superset in Conare so Claude Code, Codex, and Cursor remember it next time.

Remember this setup
← Apache Superset overview Browse database servers →