superset-mcp

Get list of all charts in Superset with optional filtering, sorting, and pagination. Uses Rison or JSON query parameters for filtering, sorting, pagination and for selecting specific columns and metadata.

Create a new chart in Superset. IMPORTANT: You must first call `get_chart_params` with your desired viz_type to get the correct parameter structure before using this tool. Without the proper parameter structure, chart creation will fail.

Get complete chart information including metadata, configuration, and relationships. This provides comprehensive details about a chart including its visualization parameters, datasource info, ownership, dashboards, tags, and more.

Update chart properties including metadata, datasource, and visualization settings. This tool replaces the old update_chart_params with a unified interface that accepts object format params and can modify any chart property. IMPORTANT: When updating visualization parameters, first call `get_chart_pa…

Get current data filters applied to a chart. This extracts filters from the chart's query context or form data. Use this tool to see what filters are currently applied before modifying them.

Set data filters for a chart. This permanently updates the chart's query context with the specified filters. Filters are applied at the data level, affecting what data is retrieved from the datasource.

Retrieves a list of all datasets in Superset. Supports powerful filtering, sorting, and pagination. You can specify which columns to return, making it efficient for fetching just the needed information.

Fetches detailed information for a single dataset by its ID. For virtual datasets, this tool returns the raw SQL query.

Creates a new dataset in Superset. You can create a physical dataset by linking to a table in a database, or a virtual dataset by providing a custom SQL query. For a physical dataset, provide `database_id` and `table_name`. For a virtual dataset, provide `database_id`, a `table_name` (as an alias), …

Updates an existing dataset's properties. You can change its name, description, or underlying SQL query. This is also the tool to adjust settings like cache timeout. Note: To add, remove, or update individual columns in a virtual dataset's SQL, prefer using the more specific tools: `add_dataset_colu…

Deletes a dataset from Superset. This is a permanent operation and cannot be undone. Be cautious, as deleting a dataset will also break any charts and dashboards that depend on it.

Refreshes a dataset's schema by syncing it with the latest information from the source database table. This is useful when the underlying table structure has changed (e.g., columns were added or removed) to ensure Superset has the most up-to-date column information.

Performs a simple text find-and-replace on a virtual dataset's SQL query. This is a powerful but direct tool; be sure to provide the exact text to find and its replacement to maintain valid SQL.

Get all metrics for a specified dataset

Create one or more new metrics for a dataset

Update one or more metrics in a dataset

Delete one or more metrics from a dataset

Get column information of a dataset, useful for referencing available fields when creating metrics

Create one or more new calculated columns for a dataset

Update one or more existing calculated columns in a dataset

Delete one or more calculated columns from a dataset

Get all databases configured in Superset

Execute SQL query using /api/v1/sqllab/execute/ endpoint

Get paginated list of all dashboards with optional filtering, sorting, and pagination. Uses Rison or JSON query parameters for filtering, sorting, pagination and for selecting specific columns and metadata.

Get the complete query context for a specific chart in a dashboard, including the chart's dataset ID, used metrics with their SQL expressions, calculated columns, and all applied dashboard filters. This tool provides comprehensive information about the chart's data sources and query structure.

Get all charts in a specific dashboard with their basic information including chart IDs, names, visualization types, and dataset information.

Get the dashboard's filter configuration including native filters, global filters, and their scope settings.

Get dashboard details and embedded configuration in a single response.

Update dashboard properties and/or embedded configuration in a single request. Provide at least one of dashboard or embedded_config.

Add an existing chart to a dashboard and place it in the layout (position_json).

Remove a chart from a dashboard and clean up its layout nodes.