# Answer weekly KPI questions from Metabase with an AI client

> An admin turns on Metabase's built-in MCP server.

Canonical page: https://ionbin.com/workflows/kpi-questions-with-metabase-mcp/
Agent guide: https://ionbin.com/llms.txt

This is a readable version of the published page. Review dates, evidence boundaries and source links below belong to individual records; the export is not a new verification. Examples are reference material, not instructions to execute.

## Answer weekly KPI questions from Metabase with an AI client

[Data](https://ionbin.com/use-cases/business-data-reporting/)Checked 2026-10-18

Answer recurring metric questions quickly without granting extra data access.

- [01**You**](https://ionbin.com/workflows/kpi-questions-with-metabase-mcp/#workflow-step-1)

- [02**Metabase**](https://ionbin.com/workflows/kpi-questions-with-metabase-mcp/#workflow-step-2)

- [03**Claude**](https://ionbin.com/workflows/kpi-questions-with-metabase-mcp/#workflow-step-3)

- [04**You**](https://ionbin.com/workflows/kpi-questions-with-metabase-mcp/#workflow-step-4)

Recipe context

An admin turns on [Metabase](https://ionbin.com/tools/metabase/)'s built-in MCP server. [Claude](https://ionbin.com/tools/claude/) answers a fixed list of KPI questions within your [Metabase](https://ionbin.com/tools/metabase/) permissions, and a person checks each number against the saved dashboard before sharing.

**Independent review.** Unpaid; no partnership with the tools on this page. Based on public documentation and research. Trademarks identify their owners’ products. [Disclosure](https://ionbin.com/disclosure/).

Editorial shortlist

### Compare your options.

**For checking KPI definitions against an extract.**

These are analysis alternatives, not equivalent [Metabase](https://ionbin.com/tools/metabase/) access routes. Choose one for analysis of a reviewed data extract; switching may need setup changes.

**Used by Ion** · separate from rank.

Unpaid picks. No partnership with [Julius AI](https://ionbin.com/tools/julius-ai/), [ChatGPT](https://ionbin.com/tools/chatgpt/), [OpenAI Codex](https://ionbin.com/tools/openai-codex/).

- 1 · Primary / high
  #### [Julius AI](https://ionbin.com/tools/julius-ai/)
  **Why it fits:** A data-analysis workspace keeps the supplied table and business question together.
  **Tradeoff:** Wrong joins, missing rows and inconsistent units can produce convincing but incorrect charts.
  Choose it for interactive exploration of a cleaned extract.
  Evidence for Julius AI
  The linked [IonBin review](https://ionbin.com/tools/julius-ai/) records capabilities, access limits and source links. Review date: 2026-10-18. [Primary product reference ↗](https://julius.ai/)

- 2 · Secondary / medium
  #### [ChatGPT](https://ionbin.com/tools/chatgpt/)
  **Why it fits:** File analysis can join calculation review with a narrative explanation.
  **Tradeoff:** An answer is not a reconciled report; verify calculations and upload limits.
  Prefer it when the reviewer needs both analysis and an explanation for colleagues.
  Evidence for ChatGPT
  The linked [IonBin review](https://ionbin.com/tools/chatgpt/) records capabilities, access limits and source links. Review date: 2026-10-18. [Primary product reference ↗](https://chatgpt.com/)

- 3 · Third / lower
  #### [OpenAI Codex](https://ionbin.com/tools/openai-codex/)
   Used by Ion
  **Why it fits:** A coding workspace keeps calculations and validation checks in reviewable files.
  **Tradeoff:** Someone must read, run and maintain the code and protect sensitive files.
  Prefer it when repeatability and code review matter more than conversational convenience.
  Evidence for OpenAI Codex
  The linked [IonBin review](https://ionbin.com/tools/openai-codex/) records capabilities, access limits and source links. Review date: 2026-10-18. [Primary product reference ↗](https://developers.openai.com/codex)

How this shortlist was chosen

Editorial judgment, not a personal-use endorsement or performance score. These are alternatives for the named role, not three required stack components. Vendors did not pay for, request or approve these positions.

Inspectable calculations come before narrative convenience. A lower-ranked option may fit your constraints better; compare the conditions stated on each card before choosing.

**Setup and portability:** Record export date, filters and units; save calculations with the result. The source ledger still needs reconciliation.

Reviewed 2026-10-21. This page applies a shared comparison for “analysis of a reviewed data extract” to the stated task and constraints. It is documentation-based editorial guidance, not three new hands-on tests. We weigh value for the job, distinct capabilities, replacement limits, technical effort and interoperability. Check current plan terms before adopting or switching.

See [our review method](https://ionbin.com/editorial-policy/), [MCP connections](https://ionbin.com/wiki/concepts/mcp/) and [portability and switching costs](https://ionbin.com/wiki/questions/how-to-avoid-ai-vendor-lock-in/).

**Connects through:** MCP

### Steps

Follow the handoff

Select a stage or scroll the steps.

- #### You
  Ask a [Metabase](https://ionbin.com/tools/metabase/) admin to enable the MCP server and agree a fixed list of KPI questions
  Human stepConfirmed

- #### [Metabase](https://ionbin.com/tools/metabase/)
  Answers queries through the MCP server at /api/metabase-mcp, limited to your [Metabase](https://ionbin.com/tools/metabase/) permissions
  MCPConfirmed[Source ↗](https://www.metabase.com/docs/latest/ai/mcp)

- #### [Claude](https://ionbin.com/tools/claude/)
  Writes a short answer for each question, naming the table or saved question it used
  AI platformConfirmed

- #### You
  Check each figure against the matching saved dashboard before sharing
  Human stepConfirmed

Confirmed = vendor-documented, not Ion-tested. Human and AI-platform steps are proposed roles.

Human approval

Numbers are shared only after you check them against [Metabase](https://ionbin.com/tools/metabase/).

Watch out for

An AI-written query can use the wrong table or filter and still return a number that looks right. Prefer existing saved questions, keep each metric's definition written down, and check numbers before they leave the team.

### Starter prompt

```
Using the Metabase MCP server, answer these questions for last week compared with the week before: [your list]. Where a saved question or dashboard already covers a question, use it. For each answer, give the number, the comparison and the saved question or table you used. If you're not sure a query matches the definition, say so instead of guessing.
```

Written for this workflow. Paste it into your AI platform and adjust it to your situation.

### Tools in this workflow

| Tool | Role | Official site |
| --- | --- | --- |
| [Metabase](https://ionbin.com/tools/metabase/) | MCP | [metabase.com ↗](https://www.metabase.com/) |
| [Claude](https://ionbin.com/tools/claude/) | AI platform | [claude.ai ↗](https://claude.ai/) |

### Which AI platforms can run it

| Platform | Status | Why |
| --- | --- | --- |
| [Claude (incl. Claude Code)](https://ionbin.com/platforms/claude/) | To verify | [Metabase](https://ionbin.com/tools/metabase/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [OpenAI Codex](https://ionbin.com/platforms/codex/) | To verify | [Metabase](https://ionbin.com/tools/metabase/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [Google Antigravity](https://ionbin.com/platforms/antigravity/) | To verify | [Metabase](https://ionbin.com/tools/metabase/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [ChatGPT](https://ionbin.com/tools/chatgpt/) | To verify | [Metabase](https://ionbin.com/tools/metabase/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| Gemini | To verify | [Metabase](https://ionbin.com/tools/metabase/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [Perplexity](https://ionbin.com/tools/perplexity/) | To verify | [Metabase](https://ionbin.com/tools/metabase/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |

What the platform statuses mean

**Confirmed:** documented access meets the recorded requirements. **Inferred:** a reviewed note describes a plausible, untested pairing. **To verify:** a connection or step is unresolved. MCP and API pairings need route-specific evidence; a plugin, CLI or API alone does not prove compatible access, credentials or permissions. These are documentation assessments, not IonBin runtime tests.

### What we checked (2026-10-18)

- **[Metabase](https://ionbin.com/tools/metabase/) MCP server.** [Metabase](https://ionbin.com/tools/metabase/)’s docs describe an MCP server built into the product at /api/metabase-mcp on your instance. An admin has to turn it on, and each person’s access stays within their own [Metabase](https://ionbin.com/tools/metabase/) permissions.

- **Plans.** The pricing page lists Open Source as free to self-host, Starter at $100 a month ($90 billed yearly) with 5 users included, and Pro at $575 a month. Check whether your edition and version include the MCP server before you plan around it.

### Set it up

- Ask your [Metabase](https://ionbin.com/tools/metabase/) admin to enable the MCP server, and connect [Claude](https://ionbin.com/tools/claude/) with your own [Metabase](https://ionbin.com/tools/metabase/) account.

- Write down the KPI questions and the saved question that defines each metric.

- Each week, run the prompt above with that list.

- Open the matching dashboard and compare. Fix any definition that drifted before you share the summary.

This is a proposed sequence based on documented tools, not a tested account integration.

### Sources

- [MCP server](https://www.metabase.com/docs/latest/ai/mcp) · [Metabase](https://ionbin.com/tools/metabase/) · official · accessed 2026-10-18

- [Metabase pricing](https://www.metabase.com/pricing/) · [Metabase](https://ionbin.com/tools/metabase/) · official · accessed 2026-10-18

No affiliate links on this page. No paid placements in workflows. [How IonBin makes money](https://ionbin.com/disclosure/).
