Modern data exploration and visualization platform.
## Superset MCP Server: Data Visualization Platform The **Superset MCP Server** integrates Apache Superset into Google Antigravity, enabling developers to create interactive dashboards and explore data through AI-assisted visualization and SQL analysis workflows. ### Why Superset MCP? - **Open Source**: Free, enterprise-ready BI platform with active community - **Rich Visualizations**: 40+ visualization types from simple charts to geospatial maps - **SQL Lab**: Powerful SQL IDE with autocomplete and query history - **Semantic Layer**: Define metrics and dimensions once, reuse everywhere - **Access Control**: Fine-grained security for dashboards and data sources ### Key Features #### 1. Chart and Dashboard Creation ```python # Create chart via MCP chart = await superset.createChart({ "name": "Monthly Revenue Trend", "datasource": "orders_dataset", "viz_type": "line", "query": { "metrics": ["sum__revenue"], "groupby": ["month"], "time_range": "Last year", "order_desc": True } }) # Add chart to dashboard await superset.addChartToDashboard({ "dashboard_id": "sales_overview", "chart_id": chart.id, "position": {"row": 0, "col": 0, "width": 6, "height": 4} }) ``` #### 2. SQL Lab Queries ```python # Execute SQL query results = await superset.executeSql({ "database_id": 1, "sql": """ SELECT product_category, SUM(revenue) as total FROM orders WHERE order_date >= CURRENT_DATE - INTERVAL 30 DAY GROUP BY product_category ORDER BY total DESC """, "limit": 100 }) # Save query as dataset dataset = await superset.createDataset({ "name": "top_categories_30d", "sql": saved_query, "database_id": 1 }) ``` ### Configuration ```json { "mcpServers": { "superset": { "command": "npx", "args": ["-y", "@anthropic/mcp-superset"], "env": { "SUPERSET_URL": "https://your-superset-instance.com", "SUPERSET_USERNAME": "your-username", "SUPERSET_PASSWORD": "your-password" } } } } ``` ### Use Cases **Business Intelligence**: Build self-service BI dashboards for business teams with consistent metrics. **Data Exploration**: Explore new datasets with SQL Lab and quickly create visualizations from results. **Embedded Analytics**: Embed Superset charts and dashboards in your applications. The Superset MCP Server brings open-source BI capabilities to your AI-assisted development workflow.
{
"mcpServers": {
"superset": {}
}
}