Skip to main content
Glama

superset-mcp

Servidor MCP (Model Context Protocol) para Apache Superset. Proporciona a los asistentes de IA acceso completo a tu instancia de Superset: paneles, gráficos, conjuntos de datos, bases de datos y ejecución de SQL.

Requisitos previos

  • uv — Gestor de paquetes de Python

  • Acceso a una instancia de Apache Superset en ejecución

Related MCP server: Zaturn

Configuración (toma ~1 minuto)

1. Clonar el repositorio

git clone <repo-url>
cd superset-mcp

2. Configurar las credenciales

cp .env.example .env

Edita .env:

SUPERSET_URL=http://your-superset-host:8088
SUPERSET_USERNAME=your-username
SUPERSET_PASSWORD=your-password

3. Probar que funciona

uv run superset-mcp

Deberías ver que el servidor MCP se inicia sin errores. Presiona Ctrl+C para detenerlo.


Conectar a tu cliente de IA

Reemplaza /ABSOLUTE/PATH/TO/superset-mcp con la ruta real donde clonaste el repositorio.

Claude Code

Añade a ~/.claude/settings.json (o al archivo .claude/settings.json a nivel de proyecto):

{
  "mcpServers": {
    "superset": {
      "command": "uv",
      "args": ["--directory", "/ABSOLUTE/PATH/TO/superset-mcp", "run", "superset-mcp"],
      "env": {
        "SUPERSET_URL": "http://your-superset-host:8088",
        "SUPERSET_USERNAME": "your-username",
        "SUPERSET_PASSWORD": "your-password"
      }
    }
  }
}

O ejecuta en la terminal:

claude mcp add superset -- uv --directory /ABSOLUTE/PATH/TO/superset-mcp run superset-mcp

Claude Desktop

Añade a ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) o %APPDATA%\Claude\claude_desktop_config.json (Windows):

{
  "mcpServers": {
    "superset": {
      "command": "uv",
      "args": ["--directory", "/ABSOLUTE/PATH/TO/superset-mcp", "run", "superset-mcp"],
      "env": {
        "SUPERSET_URL": "http://your-superset-host:8088",
        "SUPERSET_USERNAME": "your-username",
        "SUPERSET_PASSWORD": "your-password"
      }
    }
  }
}

Cursor

Añade a .cursor/mcp.json en tu proyecto o a ~/.cursor/mcp.json de forma global:

{
  "mcpServers": {
    "superset": {
      "command": "uv",
      "args": ["--directory", "/ABSOLUTE/PATH/TO/superset-mcp", "run", "superset-mcp"],
      "env": {
        "SUPERSET_URL": "http://your-superset-host:8088",
        "SUPERSET_USERNAME": "your-username",
        "SUPERSET_PASSWORD": "your-password"
      }
    }
  }
}

Herramientas disponibles

Paneles (Dashboards)

Herramienta

Descripción

list_dashboards

Listar todos los paneles (con búsqueda opcional)

get_dashboard

Obtener un panel por ID o slug

get_dashboard_charts

Obtener todos los gráficos de un panel

get_dashboard_datasets

Obtener todos los conjuntos de datos usados por un panel

create_dashboard

Crear un nuevo panel

update_dashboard

Actualizar título, diseño, metadatos

publish_dashboard

Publicar un panel en borrador

copy_dashboard

Duplicar un panel

delete_dashboard

Eliminar un panel

Gráficos (Charts)

Herramienta

Descripción

list_charts

Listar todos los gráficos (con búsqueda opcional)

get_chart

Obtener un gráfico por ID o UUID

get_chart_data

Obtener los datos más recientes de un gráfico

create_chart

Crear un nuevo gráfico

update_chart

Actualizar propiedades del gráfico

delete_chart

Eliminar un gráfico

Conjuntos de datos (Datasets)

Herramienta

Descripción

list_datasets

Listar todos los conjuntos de datos

get_dataset

Obtener un conjunto de datos por ID o UUID

create_dataset

Crear a partir de una tabla o consulta SQL

get_or_create_dataset

Obtener uno existente o crear uno nuevo

refresh_dataset

Sincronizar columnas desde la tabla de origen

update_dataset

Actualizar propiedades del conjunto de datos

get_dataset_related_objects

Ver qué gráficos/paneles lo utilizan

delete_dataset

Eliminar un conjunto de datos

Bases de datos (Databases)

Herramienta

Descripción

list_databases

Listar todas las conexiones a bases de datos

get_database

Obtener una conexión a base de datos por ID

list_schemas

Listar esquemas en una base de datos

list_tables

Listar tablas en un esquema

get_table_metadata

Obtener información de columnas de una tabla

get_select_star

Obtener una plantilla SELECT * para una tabla

SQL

Herramienta

Descripción

execute_sql

Ejecutar una consulta SQL y obtener resultados

format_sql

Formatear una consulta SQL

estimate_query_cost

Estimar el costo de la consulta (si es compatible)

list_saved_queries

Listar consultas SQL guardadas

save_query

Guardar una consulta SQL


Ejemplos de prompts

Una vez conectado a tu asistente de IA:

  • "List all published dashboards"

  • "Create a new dashboard called 'Sales Overview'"

  • "Show me all charts in dashboard 11"

  • "Run a SQL query on database 2: SELECT count() FROM orders"*

  • "What datasets are used by the 'Revenue' dashboard?"

  • "Create a bar chart using dataset 5 showing sales by region"

Available Tools

34 tools
copy_dashboardC

Create a copy of a dashboard.

Inputs: id_or_slug (required). Returns: object

create_chartC

Create a new chart.

Inputs: slice_name (required), viz_type (required), datasource_id (required), datasource_type, +3 more. Returns: object

create_dashboardC

Create a new dashboard.

Inputs: title (required), slug, published, json_metadata, +1 more. Returns: object

create_datasetB

Create a dataset from a table or SQL query.

Inputs: database_id (required), table_name (required), schema, sql, +1 more. Returns: object

delete_chartC

Delete a chart by ID.

Inputs: pk (required). Returns: object

delete_dashboardC

Delete a dashboard by ID.

Inputs: pk (required). Returns: object

delete_datasetB

Delete a dataset by ID.

Inputs: pk (required). Returns: object

estimate_query_costC

Estimate the cost of running a SQL query (supported databases only).

Inputs: database_id (required), sql (required), schema. Returns: object

execute_sqlB

Execute a SQL query and return results.

Inputs: database_id (required), sql (required), schema, limit. Returns: object

format_sqlB

Format/pretty-print a SQL query.

Inputs: sql (required). Returns: object

get_chartC

Get a chart by ID or UUID.

Inputs: id_or_uuid (required). Returns: object

get_chart_dataC

Fetch the latest data for a chart.

Inputs: pk (required). Returns: object

get_dashboardB

Get a single dashboard by ID or slug.

Inputs: id_or_slug (required). Returns: object

get_dashboard_chartsB

Get all charts in a dashboard.

Inputs: id_or_slug (required). Returns: object

get_dashboard_datasetsB

Get all datasets used by a dashboard.

Inputs: id_or_slug (required). Returns: object

get_databaseB

Get a database connection by ID.

Inputs: pk (required). Returns: object

get_datasetB

Get a dataset by ID or UUID.

Inputs: id_or_uuid (required). Returns: object

get_or_create_datasetB

Get an existing dataset or create it if it doesn't exist.

Inputs: database_id (required), table_name (required), schema. Returns: object

get_select_starC

Get a SELECT * query for a table (with schema).

Inputs: database_id (required), table_name (required), schema. Returns: object

get_table_metadataC

Get column metadata for a table.

Inputs: database_id (required), table_name (required), schema. Returns: object

list_chartsC

List charts. Optionally filter by name.

Inputs: page, page_size, search. Returns: object

list_dashboardsB

List dashboards. Optionally filter by title with search.

Inputs: page, page_size, search. Returns: object

list_databasesB

List all database connections configured in Superset.

Inputs: page, page_size. Returns: object

list_datasetsC

List datasets (virtual or physical tables).

Inputs: page, page_size, search. Returns: object

list_saved_queriesB

List saved SQL queries.

Inputs: page, page_size. Returns: object

list_schemasB

List all schemas in a database.

Inputs: database_id (required). Returns: object

list_tablesB

List tables in a database schema.

Inputs: database_id (required), schema. Returns: object

publish_dashboardC

Set a dashboard as published.

Inputs: pk (required). Returns: object

refresh_datasetC

Refresh the dataset's columns and metrics from the source.

Inputs: pk (required). Returns: object

save_queryC

Save a SQL query.

Inputs: label (required), sql (required), database_id (required), schema, +1 more. Returns: object

update_chartC

Update a chart's properties.

Inputs: pk (required), slice_name, description, viz_type, +2 more. Returns: object

update_dashboardC

Update an existing dashboard.

Inputs: pk (required), title, published, json_metadata, +1 more. Returns: object

update_datasetC

Update a dataset's properties.

Inputs: pk (required), table_name, description, sql, +3 more. Returns: object

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3.2/5.0

    Scored across 34 tools

    Disambiguation5/5

    Every tool has a clearly distinct purpose targeting specific resources (charts, dashboards, datasets, databases, queries) and actions (create, get, list, update, delete, execute, format, etc.), with no apparent overlap or ambiguity. For example, get_chart, get_chart_data, and list_charts serve different functions without confusion.

    Naming Consistency5/5

    Tool names follow a highly consistent verb_noun pattern throughout, such as create_chart, delete_dashboard, list_datasets, and update_dataset, with no deviations in style or convention. This predictability makes the tool set easy to navigate and understand.

    Tool Count3/5

    With 34 tools, the count is borderline high for typical MCP server scopes, which often range from 3-15 tools. While it covers a comprehensive Superset domain, it may feel heavy and potentially overwhelming for agents, though not extreme like 50+ tools.

    Completeness5/5

    The tool surface provides complete CRUD/lifecycle coverage for charts, dashboards, datasets, and queries, along with execution, formatting, and metadata operations. There are no obvious gaps; agents can perform all core workflows from creation to deletion and analysis without dead ends.

    Maintenance

    ActivityInactive
    ResponsivenessOutdated data

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      B
      quality
      D
      maintenance
      MCP server enabling AI agents to programmatically connect to and control Apache Superset instances, allowing users to manage dashboards, charts, databases, datasets, and run SQL queries through natural language interactions.
      60
      195
      MIT
    • A
      license
      A
      quality
      D
      maintenance
      An open-source MCP server that connects to various data sources (SQL databases, CSV, Parquet files), allowing AI models to execute SQL queries and generate data visualizations for analytics and business intelligence.
      12
      76
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      An MCP server for Apache Superset that enables AI models to manage dashboards, create charts with auto-detection, and execute SQL queries programmatically. It utilizes stateless HTTP transport to ensure compatibility with integration tools like Open WebUI.
      MIT
    • A
      license
      A
      quality
      D
      maintenance
      An MCP server that enables AI assistants to query databases, execute SQL, and manage Metabase resources like dashboards, cards, and collections through natural language.
      22
      MIT