Metabase MCP connector

Metabase is an open-source business intelligence platform for querying databases, visualizing data, and managing analytics workflows. The Metabase MCP connector allows AI agents to create and manage questions, execute queries against connected databases, and retrieve results for analysis. It also supports managing metrics, organizing dashboards, and configuring alerts to monitor data changes.

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:

• Query databases and retrieve business metrics without writing SQL code
• Build interactive dashboards to monitor key performance indicators in real time
• Create saved questions to standardize reporting across your organization
• Set up alerts that notify your team when metrics cross critical thresholds
• Define custom metrics to track business outcomes specific to your company
• Connect multiple data sources and unify reporting across systems
• Automate data exploration workflows to answer business questions faster

Example prompts

Use the following example prompts to invoke Metabase MCP connector tools from your AI assistant or Boomi Connect workflow:

• Create a new Metabase question to find all customers who made purchases last quarter.
• Show me the total revenue by product category from our Metabase dashboard.
• Set up an alert in Metabase to notify me when daily sales drop below $10,000.
• List all the saved questions in Metabase and tell me which ones are used most often.
• Create a metric in Metabase to track our customer churn rate automatically.
• Connect our data warehouse to Metabase so we can query it directly.
• Update the sales dashboard in Metabase to include last month's forecast data.
• Delete the old inventory report from Metabase and create a new one with current data.
• Run a query in Metabase to compare this month's performance against last year.
• Show me all active alerts in Metabase that monitor our critical business metrics.

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	Retrieves a list of all saved questions in the Metabase instance.
createQuestion	Creates a new question to query and analyze data.
getQuestion	Retrieves details and configuration for a specific question.
updateQuestion	Modifies the settings or query of an existing question.
deleteQuestion	Removes a question from the Metabase instance.
executeQuestion	Runs a question's query and returns the result data.
getAllMetrics	Retrieves a list of all defined metrics in the instance.
createMetric	Creates a new metric for consistent data measurement.
getMetric	Retrieves details and definition for a specific metric.
updateMetric	Modifies the settings or formula of an existing metric.
deleteMetric	Removes a metric from the Metabase instance.
getAllDatabases	Retrieves a list of all connected databases.
createDatabase	Establishes a new connection to a database source.
getDatabase	Retrieves configuration details for a specific database.
updateDatabase	Modifies the settings of an existing database connection.
deleteDatabase	Removes a database connection from the instance.
getAllAlerts	Retrieves a list of all configured alerts.
createAlert	Creates a new alert to notify on specific data conditions.
getAlert	Retrieves details and settings for a specific alert.
updateAlert	Modifies the conditions or settings of an existing alert.
deleteAlert	Removes an alert from the Metabase instance.