Data & Analytics · Metabase + Claude
Metabase MCP with Claude: Ask Your Data Questions in Plain Language
The short answer
Claude works with Metabase through the Model Context Protocol (MCP), an open standard that acts as a secure adapter. Once connected, Claude can read existing dashboards and questions, run analytics queries, create visualisations and manage saved questions, all from natural language requests. The organisation controls which data and actions Claude can use.
What is Metabase?
Metabase is an open-source business intelligence tool that turns raw data into dashboards, charts and reports. Teams use it to see sales, operations, finance and product figures without writing complex code. Analysts, managers and operations staff all use it to explore data and share insights across the business. Its flexibility makes it popular with organisations of many sizes that want clear, fast reporting.
How Claude connects to Metabase through MCP
The Model Context Protocol (MCP) is an open standard that lets Claude securely use other software. Think of it as a universal adapter between Claude and a tool like Metabase. Through it, Claude can reach the information it needs without copying data into a separate system.
Once connected, Claude can typically read dashboards and saved questions, run queries against connected data sources, and help create new visualisations. A manager might simply ask for last quarter's regional revenue, and Claude returns the answer with a chart, drawn from Metabase.
Permissions and approvals keep people in charge. Access is set using a Metabase API key, scoped to the minimum rights each workflow needs. Consequential actions, such as saving or changing shared dashboards, can require human approval before they take effect, and every action is logged.
What you can automate
Plain-language sales reporting
A sales director asks, in ordinary English, for pipeline value by region for the current month. Claude runs the relevant Metabase query and returns a summary with a chart. This removes the wait for a analyst to build the same view by hand, and helps leaders act on figures the same day.
Weekly operations dashboard digest
Each Monday, Claude reviews key operations dashboards in Metabase, such as order fulfilment times and stock levels. It produces a short written summary highlighting changes against the previous week. Operations managers receive a clear briefing without opening several dashboards.
Finance month-end checks
A finance team uses Claude to run standard reconciliation queries in Metabase at month end. Claude flags unusual movements for review and prepares draft charts for the close pack. Accountants stay responsible for sign-off, while the routine checking takes less time.
Customer support trend analysis
A support lead asks which product issues rose most in the last thirty days. Claude queries ticket-related data in Metabase and groups the results by category. The team can then prioritise fixes and staffing using evidence rather than instinct.
Product usage insights for teams
Product managers ask Claude how feature adoption differs between new and long-standing users. Claude runs the analysis in Metabase and creates a visualisation to share in planning meetings. Teams make decisions faster, and the underlying questions remain saved for later reference.
An end-to-end workflow: Monthly regional performance pack
TriggerThe first working day of each month, a scheduled request is raised by the commercial operations lead.
Claude pulls the previous month's sales and margin questions from Metabase.
Claude compares results against targets held in the company's Microsoft 365 spreadsheet.
Claude checks open deals in the CRM to flag regions with weak pipeline coverage.
Claude drafts a written summary and charts for each region.
The commercial operations lead reviews the draft and approves it before distribution.
The approved pack is shared with regional heads through Microsoft 365.
OutcomeRegional leaders receive a consistent, reviewed performance pack on the first working day, instead of spending several hours assembling it. Typical results depend on data quality and how the workflow is designed.
How we set it up
Free automation audit
We review your current reporting, identify the Metabase dashboards and questions that matter, and pick the workflows worth automating first.
Secure connection
We connect Claude to Metabase using an API key, issued and scoped by your Metabase administrator to the least access each workflow needs.
Workflow design
We design the end-to-end process across Metabase and your other systems, such as Microsoft 365, CRM or ERP, with clear points where people approve actions.
Testing against real cases
We test the workflow using past reporting requests and real data, checking accuracy and refining prompts until results meet your standards.
Launch, monitoring and training
We launch with audit logs and monitoring in place, then train your team to use and oversee the workflow confidently.
Who benefits
- Chief operating officer
- Gets consistent operational reporting without waiting on manual report builds.
- Finance director
- Spends less time on routine checks and more time on analysis and decisions.
- Sales leader
- Asks pipeline and performance questions in plain English and receives answers the same day.
- Head of IT
- Keeps control of access through scoped API keys, approvals and audit logs.
Security and control
- Access uses a Metabase API key scoped to the minimum rights each workflow requires.
- Consequential actions, such as changing shared dashboards, can require human approval first.
- Every request and action is recorded in audit logs for review.
- Sensitive fields can be excluded from what Claude is permitted to read.
- Outputs are checked against known figures during testing before launch.
For teams in the US, UK, India and the Middle East
Organisations in the United States and the United Kingdom can host Claude in their chosen region to support their data protection obligations. In India, we design workflows to meet the Digital Personal Data Protection Act, 2023. For organisations in the UAE and Saudi Arabia, we take account of local data protection laws when selecting hosting and access controls. Hosting region is always chosen to match your specific legal and contractual requirements.
Learn more about Claude and MCP
Anthropic's AI model and assistant.
Secure links between Claude and business tools.
How engineers build and change software with Claude.
Hosted agents that run multi-step work.
The open standard Claude uses to connect to tools.
Frequently asked questions
What does the Metabase MCP server do?
The Metabase MCP server gives Claude a secure, standard way to reach Metabase. Through it, Claude can read dashboards and questions, run queries and help create visualisations. It acts as an adapter, so the connection uses defined permissions rather than direct, unrestricted access to your data.
Is connecting Metabase to Claude secure?
Security depends on how access is configured. We use a Metabase API key scoped to the minimum rights each workflow needs, add approval steps for consequential actions and keep audit logs. Your administrator stays in control of the key and can revoke it at any time.
What can Claude actually do with Metabase?
Typically, Claude can query dashboards and saved questions, run analytics on connected data, create charts and help manage questions, all from natural language. What it can do in your environment depends on the permissions you grant and the workflow we design together.
How long does setup take?
A simple connection and first workflow can often be set up in a few weeks, after a free automation audit. Larger, multi-system workflows take longer because they need more testing and training. We agree a realistic timeline once we understand your reporting needs.
What permissions or plan do I need?
You need a Metabase API key issued by an administrator, with access limited to the data and actions the workflow requires. The specific requirements depend on your Metabase setup, so we confirm these during the free audit rather than assume them.