Metabase BI Tool Toolset for AI Agents - n8n Workflow

• AI Developers building LLM-powered data analytics agents.


• DevOps or BI teams needing programmatic access to Metabase functionality.


• n8n users looking to implement sophisticated AI tool orchestration using the n8n trigger architecture.


• Anyone seeking robust n8n templates for integrating BI platforms into automation flows.

This specialized n8n workflow serves as an 'AI tool definition set,' making complex Metabase Business Intelligence operations readily available to an external AI agent or Language Model. Unlike a linear n8n workflow, this setup utilizes the Master Control Program (MCP) mechanism. The primary value is enabling an LLM to dynamically select and execute specific Metabase tasks—such as fetching alerts, managing databases, or running questions—without needing manual intervention. This n8n node configuration accelerates the creation of smart, data-aware agents, offering a reusable set of Metabase functions wrapped efficiently within n8n.

This automation operates as a dedicated service waiting for AI requests. The central element is the Metabase Tool MCP Server n8n trigger node. When an AI agent (like an LLM deployed via Langchain or similar frameworks) detects a need for a Metabase operation—for example, 'Get the results from a question'—it calls this n8n trigger, supplying the necessary parameters.

1. AI Request: An external AI Agent determines which Metabase operation is required based on the user's prompt.


2. Tool Selection (n8n trigger): The request is routed to the Metabase Tool MCP Server n8n trigger node, which acts as the entry point for all tool calls.


3. Execution: Based on the tool name supplied by the AI, the relevant Metabase Tool n8n node (e.g., 'Add a databases' or 'Get many alerts') executes the desired action against the configured Metabase instance.


4. Result Return: The output (e.g., database details, alert status, or query results) is returned from the executing n8n node back through the n8n trigger to the originating AI Agent for synthesis and response generation. This approach defines a highly flexible and powerful n8n workflow template for BI automation.

To utilize this sophisticated n8n workflow template, follow these steps:

1. Import: Copy the provided JSON and import it into your n8n instance via the 'Workflows' > 'New' > 'Import from JSON' option.


2. Credentials: All Metabase Tool n8n node actions require configuration with valid Metabase credentials (API Key or Username/Password setup).


3. Metabase Connection: Ensure that the Metabase tool credential is set up correctly and connected to your target Metabase instance.


4. Activate: Save and activate the n8n workflow. Since it uses an MCP n8n trigger, it will be immediately available for calling by configured AI agents, defining a powerful set of tools usable within your wider n8n architecture.

This n8n workflow leverages the following key components:

Metabase Tool MCP Server (n8n trigger): This specialized n8n trigger node is the entry point for AI agents. It listens for requests specifying which Metabase function (tool) to execute. It defines the contract for how an AI interacts with this entire n8n workflow.

Metabase Tool (10 separate n8n node instances): Each instance represents a callable function for the AI agent:
Alerts: Get an alert, Get many alerts.
Databases: Add a databases, Get many databases, Get Fields a databases.
Metrics: Get a metric, Get many metrics.
Questions/Reports: Get a questions, Get many questions, Get the results from a question.

Each n8n node is configured as an 'AI Tool' connected directly back to the MCP n8n trigger, allowing the AI to dynamically invoke any of these 10 distinct Metabase operations.