Collaborative data science and analytics platform.
## Mode MCP Server: Collaborative Analytics The **Mode MCP Server** connects Mode's collaborative analytics platform to Google Antigravity, enabling developers to create SQL-based analyses, build interactive dashboards, and share insights through AI-assisted workflows. ### Why Mode MCP? - **SQL-First Analytics**: Write and execute SQL against connected data sources with AI assistance - **Python/R Notebooks**: Extend analysis with Python or R notebooks for advanced analytics - **Interactive Dashboards**: Build dynamic dashboards from SQL results with drag-and-drop builders - **Collaboration Features**: Share analyses, add comments, and collaborate with team members - **Scheduled Reports**: Automate report generation and distribution on custom schedules ### Key Features #### 1. SQL Analysis and Visualization ```sql -- Create analysis via MCP -- Mode automatically suggests optimizations SELECT DATE_TRUNC('week', order_date) as week, product_category, SUM(revenue) as total_revenue, COUNT(DISTINCT customer_id) as unique_customers, SUM(revenue) / COUNT(DISTINCT customer_id) as revenue_per_customer FROM orders WHERE order_date >= CURRENT_DATE - INTERVAL '90 days' GROUP BY 1, 2 ORDER BY 1 DESC, 3 DESC; ``` #### 2. Report Management ```python # Create and schedule reports report = await mode.createReport({ "name": "Weekly Sales Performance", "queries": [revenue_query, customer_query, product_query], "charts": [ {"type": "line", "query_index": 0, "x": "week", "y": "total_revenue"}, {"type": "bar", "query_index": 1, "x": "segment", "y": "customers"} ], "schedule": { "frequency": "weekly", "day": "monday", "time": "09:00", "recipients": ["team@company.com"] } }) ``` ### Configuration ```json { "mcpServers": { "mode": { "command": "npx", "args": ["-y", "@anthropic/mcp-mode"], "env": { "MODE_API_TOKEN": "your-api-token", "MODE_API_SECRET": "your-api-secret", "MODE_WORKSPACE": "your-workspace" } } } } ``` ### Use Cases **Business Intelligence**: Create self-service analytics for business teams with SQL-powered dashboards. **Data Exploration**: Rapidly explore and analyze datasets with AI-suggested queries and visualizations. **Stakeholder Reporting**: Build and automate recurring reports for executives and stakeholders. The Mode MCP Server combines SQL analytics with collaborative features for team-wide data insights.
{
"mcpServers": {
"mode": {}
}
}