# Metabase for AI agents. Managed auth, ready-made tools.

> Browse dashboards and questions, run saved and new queries, and save questions in Metabase on behalf of each of your users.

- Page: https://www.agent200.com/connectors/metabase/
- Category: Search and data
- Authentication: Managed OAuth
- Identifier in code: `metabase`
- Create an API key: https://agent200.com/platform/apikeys/
- Updated: 2026-11-18

## Instructions for AI agents

Connector: Metabase, through Agent200. In code: "metabase".
What it does: Browse dashboards and questions, run saved and new queries, and save questions in Metabase on behalf of each of your users.
Page: https://www.agent200.com/connectors/metabase/

1. Get an Agent200 API key. If the developer has none, send them to https://agent200.com/platform/apikeys/ and ask them to choose "Create an API key". Read the key from the AGENT200_API_KEY environment variable. Never ask for it in chat, and never write it into code, prompts or logs.
2. Sign-in is managed OAuth. Each end user approves access once, on Metabase's own page, through the authorization link Agent200 returns. Never ask a user for a Metabase password or token in chat.
3. Give every request a stable id for the end user. Agent200 uses only that user's own connection.
4. Read tools: metabase_list_dashboards, metabase_get_dashboard, metabase_list_questions, metabase_run_question, metabase_list_databases, metabase_run_query. Write tools: metabase_create_question. Name "metabase" in the tools of a request; the model decides which tool to call.
5. Stay within the project's settings. If a tool is turned off or a call is refused, tell the user. Do not work around it.
6. Before a write, confirm with the user, unless they asked for that exact change.
7. For setup with a specific framework, follow its guide:
   https://www.agent200.com/connectors/metabase/framework/claude/
   https://www.agent200.com/connectors/metabase/framework/chatgpt/
   https://www.agent200.com/connectors/metabase/framework/claude-code/
   https://www.agent200.com/connectors/metabase/framework/muse/
   https://www.agent200.com/connectors/metabase/framework/grok-bot/
   https://www.agent200.com/connectors/metabase/framework/openai-dots/
   https://www.agent200.com/connectors/metabase/framework/claude-duet/
   https://www.agent200.com/connectors/metabase/framework/hermes-agent/
   https://www.agent200.com/connectors/metabase/framework/openclaw/

The code on the connector page is a conceptual example of the SDK. SDK reference: https://docs.igpt.ai/

## About

With the Metabase connector, your agent works in each user's own Metabase. It can list dashboards and saved questions, run a question and get its results, query a connected database and save a new question, using only the tools your project allows.

Metabase is an open source business intelligence tool for dashboards and data questions.

## Metabase tools

- **List dashboards** (`metabase_list_dashboards`, read): List the dashboards the user can see.
- **Get a dashboard** (`metabase_get_dashboard`, read): Get a dashboard and the questions on it.
- **List questions** (`metabase_list_questions`, read): List saved questions.
- **Run a question** (`metabase_run_question`, read): Run a saved question and get its results.
- **List databases** (`metabase_list_databases`, read): List the databases connected to Metabase.
- **Run a query** (`metabase_run_query`, read): Run a query against a connected database and get the results.
- **Save a question** (`metabase_create_question`, write): Save a new question with its query.

## Limits you can set

**Turn single tools on or off.** Let the agent read dashboards and run questions, and switch off `metabase_create_question` so it can never save a question.

**Restrict what the agent reaches.** Choose the endpoints and scopes a project may use, for example saved questions but not new database queries. A call outside them is refused.

## Get started

### Step 1: Set up the SDK

Add the Agent200 SDK to the codebase you already have and authenticate with your API key. The key covers every connector enabled for the project.

File `agent.js`:

```js
// One Agent200 API key covers every connector enabled for the project.
const agent200 = new Agent200({
  apiKey: process.env.AGENT200_API_KEY,
});
```

(Conceptual example of the Agent200 SDK.)

### Step 2: Let your user connect Metabase

Each end user authorizes their own Metabase account once. Agent200 runs the OAuth flow, handles the callback, stores the tokens and refreshes them.

File `connect.js`:

```js
// Each end user authorizes their own Metabase account, once.
const connection = await agent200
  .user("user_123")
  .connect("metabase");

if (connection.authorizationUrl) {
  // Show this link to your user; Agent200 handles the rest.
  console.log(connection.authorizationUrl);
}
```

(Conceptual example of the Agent200 SDK.)

### Step 3: Run with the Metabase tools

Name the user, the model and the tools. The model decides which Metabase tools to call, and Agent200 executes them with that user's connection.

File `run.js`:

```js
const result = await agent200
  .user("user_123")
  .run({
    model: "openai/gpt-5.6-sol",
    input: "What does the weekly revenue dashboard show",
    tools: ["metabase"],
  });

console.log(result.output);
```

(Conceptual example of the Agent200 SDK.)

## Sign-in and permissions

**Who signs in.** Each of your users, once, by connecting their own Metabase account. Each connection is their own.

**What access is requested.** The connection acts with that user's access in Metabase, such as reading dashboards and running questions. Users can revoke it later from their Metabase account settings.

## Example requests

- "What does the weekly revenue dashboard show"
- "Run the active users question for last month"
- "How many orders came from Germany this quarter"
- "Save this query as a question called churn by plan"

## Guides: Metabase with your AI framework

- [Metabase + Claude](https://www.agent200.com/connectors/metabase/framework/claude.md): Set up Metabase for Claude with Agent200, then check which tools are available to your agent.
- [Metabase + ChatGPT](https://www.agent200.com/connectors/metabase/framework/chatgpt.md): Set up Metabase for ChatGPT with Agent200, then check which tools are available to your agent.
- [Metabase + Claude Code](https://www.agent200.com/connectors/metabase/framework/claude-code.md): Set up Metabase for Claude Code with Agent200, then check which tools are available to your agent.
- [Metabase + Muse](https://www.agent200.com/connectors/metabase/framework/muse.md): Set up Metabase for Muse with Agent200, then check which tools are available to your agent.
- [Metabase + Grok Bot](https://www.agent200.com/connectors/metabase/framework/grok-bot.md): Set up Metabase for Grok Bot with Agent200, then check which tools are available to your agent.
- [Metabase + OpenAI Dots](https://www.agent200.com/connectors/metabase/framework/openai-dots.md): Set up Metabase for OpenAI Dots with Agent200, then check which tools are available to your agent.
- [Metabase + Claude Duet](https://www.agent200.com/connectors/metabase/framework/claude-duet.md): Set up Metabase for Claude Duet with Agent200, then check which tools are available to your agent.
- [Metabase + Hermes Agent](https://www.agent200.com/connectors/metabase/framework/hermes-agent.md): Set up Metabase for Hermes Agent with Agent200, then check which tools are available to your agent.
- [Metabase + OpenClaw](https://www.agent200.com/connectors/metabase/framework/openclaw.md): Set up Metabase for OpenClaw with Agent200, then check which tools are available to your agent.

## FAQ

### Who handles the Metabase OAuth flow and the tokens?

Agent200. It runs the authorization, handles the callback on its own domain, stores the tokens and refreshes them. You do not build or maintain an OAuth integration for Metabase.

### Does my agent act as the end user?

Within what that user authorized, yes. Every request names an end user, and Agent200 uses only that user's Metabase connection, never another user's. It cannot reach anything the user or Metabase has not authorized.

### Can I limit what my agent can do in Metabase?

Yes. You choose which services, endpoints and authorization scopes are allowed in your Agent200 configuration, and the agent works only within them.

## Related connectors

- [Tavily](https://www.agent200.com/connectors/tavily.md): Web search built for agents, reached with your Agent200 API key.
- [Exa](https://www.agent200.com/connectors/exa.md): Search the web by meaning, read page contents and find similar pages, reached with your Agent200 API key.
- [Firecrawl](https://www.agent200.com/connectors/firecrawl.md): Scrape pages into Markdown, crawl and map sites, and extract structured data, reached with your Agent200 API key.
- [Brave Search](https://www.agent200.com/connectors/brave-search.md): Search the web, news, images and videos from Brave's independent index, reached with your Agent200 API key.

---

Agent200: https://www.agent200.com/ · API keys: https://agent200.com/platform/apikeys/ · Docs: https://docs.igpt.ai/
