Connect Metabase to Your AI Agent

Get the important figures from a saved report without rebuilding the analysis.

28 tools API key

Try a Metabase Task

Copy a prompt into your agent with the oo Skill installed. Add your page links and source notes before running it.

oo Skill Metabase

Summarize a saved question’s data

Inspect a question and execute it to summarize actual result rows.

/oo Metabase: Run saved Metabase question [question]. Summarize [business question] and mention any limits on the results reviewed.

Start Working with Metabase

  1. Install OOMOL

    Set up oo CLI and the oo Skill in your agent.

    Install OOMOL →
  2. Connect Metabase

    Connect a Metabase API key and public HTTPS instance URL.

    Connect Metabase →
  3. Give Your Agent a Task

    Use /oo with the pages to read, the changes to make, and where to save the result.

    Connection Guide →

Choose Your Agent

  • A public HTTPS Metabase instance and API key.
  • Native MCP support for running questions or using MCP query features.

Metabase Tools

Use existing questions and dashboards to review business performance. Run a saved report and turn the returned figures into a summary your team can discuss.

Content lookup and saved questions

Find questions and dashboards, inspect their definitions, and run saved questions through native MCP.

28 tools

Get Current User

Get the Metabase user associated with the API key.

metabase.get_current_user

List Databases

List Metabase databases visible to the API key.

metabase.list_databases

Get Database

Retrieve one Metabase database by ID.

metabase.get_database

List Collections

List Metabase collections visible to the API key.

metabase.list_collections

Get Collection

Retrieve one Metabase collection by ID.

metabase.get_collection

List Cards

List Metabase cards, also known as questions.

metabase.list_cards

Get Card

Retrieve one Metabase card by ID.

metabase.get_card

List Dashboards

List Metabase dashboards visible to the API key.

metabase.list_dashboards

Get Dashboard

Retrieve one Metabase dashboard by ID.

metabase.get_dashboard

Search

Search Metabase content visible to the API key.

metabase.search

Search Content

Search native Metabase MCP content using keyword or semantic queries (not the REST search action). Requires native MCP on the instance.

metabase.search_content

Read Resource

Read up to five Metabase entity URIs. Preserves individual resource errors; list endpoints cap at 25 items.

metabase.read_resource

Construct Query

Construct portable MBQL 5 without executing it; returns a stored query handle.

metabase.construct_query

Construct Native Query

Construct SQL for saving as a question. This handle cannot be run by execute_query or query; use execute_sql to execute SQL.

metabase.construct_native_query

Query

Execute MBQL or fetch its next page. Native MCP returns pages of 200 rows within a 2,000-row total budget.

metabase.query

Execute Query

Execute constructed MBQL and return rows and columns. Native SQL handles are not supported.

metabase.execute_query

Execute Sql

Execute native SQL. Requires native-query permission and the instance's execute-SQL setting to be enabled.

metabase.execute_sql

Execute Question

Run a saved question. Parameterized questions and input template tags are not supported by native MCP.

metabase.execute_question

Create Question

Save a constructed MBQL or SQL query as a question.

metabase.create_question

Update Question

Patch a saved question, optionally replacing its query with a stored handle.

metabase.update_question

Create Metric

Save constructed MBQL as a metric: one aggregation and at most one date/datetime grouping.

metabase.create_metric

Update Metric

Patch a metric; replacement queries must still meet metric requirements.

metabase.update_metric

Create Dashboard

Create a dashboard with optional saved questions, automatically positioned.

metabase.create_dashboard

Update Dashboard

Patch a dashboard and apply ordered add/remove/move card mutations.

metabase.update_dashboard

Create Collection

Create a collection, optionally nested under a parent.

metabase.create_collection

List Mcp Tools

Discover native MCP tools and their upstream schemas. Unknown tools are discoverable, not automatically executable.

metabase.list_mcp_tools

List Mcp Resources

Discover native MCP resources. Only documentation resources can be read by this connector; Apps are not supported.

metabase.list_mcp_resources

Read Mcp Resource

Read native metabase://docs/ documentation, not entities or MCP Apps resources.

metabase.read_mcp_resource

Frequently Asked Questions

Can I run a report that asks for filter values?

The supported saved-question execution does not accept questions requiring parameters. Choose a report with its criteria already defined.

Will a summary include every row?

A query can return up to 2,000 rows through this connection. Larger datasets need a more focused saved question.

What must be enabled on my instance?

Metabase’s native MCP features must be available and enabled for these query operations.

Connect Metabase

About Metabase ↗