Metabase MCP connector
Updated
Metabase is an open-source business intelligence platform for querying databases and building dashboards to visualize data. The Metabase MCP connector allows AI agents to create, retrieve, update, and delete questions and
Authentication type
- API Key - Requires a static API key to be configured before the agent can connect to the service.
Uses
Use the Metabase MCP connector to perform the following actions:
- Automate creation and management of business questions across Metabase
- Track key performance metrics without writing manual database queries
- Trigger alerts automatically when critical metrics cross defined thresholds
- Connect and manage multiple database sources from a single workflow
- Retrieve query results instantly for downstream reporting and dashboards
- Standardize metric definitions across teams for consistent business reporting
- Monitor sales, revenue, or operations data through automated alerts
- Streamline database connection setup and maintenance for analytics teams
Example prompts
Use the following example prompts to invoke Metabase MCP connector tools from your AI assistant or Boomi Connect workflow:
Show me all the questions saved in Metabase.Create a new question in Metabase to track weekly sales.Run the customer churn query in Metabase and show me the results.Set up an alert in Metabase for when revenue drops below target.List all databases connected to our Metabase instance.Create a metric in Metabase to track monthly active users.Update the sales dashboard question in Metabase with the new filter.Delete the outdated inventory alert in Metabase.Connect our new PostgreSQL database to Metabase.Get the details of our top revenue metric in Metabase.
Metabase MCP connector tools
The Metabase MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.
| Tool | Description |
|---|---|
| getAllQuestions | Get all questions |
| createQuestion | Create a question |
| getQuestion | Get a question |
| updateQuestion | Update a question |
| deleteQuestion | Delete a question |
| executeQuestion | Execute a question query |
| getAllMetrics | Get all metrics |
| createMetric | Create a metric |
| getMetric | Get a metric |
| updateMetric | Update a metric |
| deleteMetric | Delete a metric |
| getAllDatabases | Get all databases |
| createDatabase | Create a database connection |
| getDatabase | Get a database |
| updateDatabase | Update a database |
| deleteDatabase | Delete a database |
| getAllAlerts | Get all alerts |
| createAlert | Create an alert |
| getAlert | Get an alert |
| updateAlert | Update an alert |
| deleteAlert | Delete an alert |
