Open-source business intelligence and analytics.
## Metabase MCP Server: Business Intelligence The **Metabase MCP Server** integrates Metabase's open-source BI platform into Google Antigravity. This enables creating dashboards, running queries, and sharing insights without SQL knowledge. ### Why Metabase MCP? Metabase democratizes data: - **No SQL Required**: Visual query builder - **Beautiful Dashboards**: Easy visualization - **Open Source**: Self-host for free - **Embedding**: Embed in your apps - **Multi-Database**: Connect to any database ### Key Features #### 1. Execute Queries ```python import requests headers = {"X-Metabase-Session": session_token} response = requests.post( "https://metabase.example.com/api/dataset", headers=headers, json={ "database": 1, "type": "native", "native": { "query": "SELECT COUNT(*) FROM orders WHERE created_at > current_date - 7" } } ) print(response.json()["data"]["rows"]) ``` #### 2. Manage Dashboards ```python # Create dashboard dashboard = requests.post( "https://metabase.example.com/api/dashboard", headers=headers, json={"name": "Weekly Metrics", "collection_id": 1} ) # Add card to dashboard requests.post( f"https://metabase.example.com/api/dashboard/{dashboard_id}/cards", headers=headers, json={"cardId": card_id, "row": 0, "col": 0, "size_x": 6, "size_y": 4} ) ``` #### 3. Embed Analytics ```python import jwt # Generate signed embed URL payload = { "resource": {"dashboard": 123}, "params": {"customer_id": 456}, "exp": time.time() + 600 } token = jwt.encode(payload, metabase_secret_key) embed_url = f"https://metabase.example.com/embed/dashboard/{token}" ``` ### Configuration ```json { "mcpServers": { "metabase": { "command": "npx", "args": ["-y", "@anthropic/mcp-metabase"], "env": { "METABASE_URL": "https://metabase.example.com", "METABASE_USERNAME": "admin@example.com", "METABASE_PASSWORD": "password" } } } } ``` ### Use Cases **Business Analytics**: Self-serve data exploration. **Embedded Analytics**: Add dashboards to your product. **Reporting**: Automated scheduled reports. The Metabase MCP Server brings open-source BI to Antigravity.
{
"mcpServers": {
"metabase": {}
}
}