Connect Metabase to Your AI Agent

Give AI a saved question ID to run and explain the result columns and rows.

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: Read Metabase question [ID], run it, and summarize the result columns and rows. State any row limit and do not extrapolate beyond the data provided.

Start Working with Metabase

Install OOMOL

Set up oo CLI and the oo Skill in your agent.
Install OOMOL →
Connect Metabase

Connect a Metabase API key and public HTTPS instance URL.
Connect Metabase →
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

Codex Claude Code Cursor Hermes

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

Metabase Tools

The connection combines REST content lookup with native MCP query and content operations. Native MCP features must be enabled and available on your instance.

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

Which saved questions can I run?

Native MCP can run accessible questions that do not require parameters or input template tags.

Are query results unlimited?

No. Native MCP query results use pages of 200 rows within a 2,000-row total budget. Keep the limit visible in summaries.

How do I check native tool availability?

Discover the instance’s MCP tools. Discovery shows current tools and their inputs; unknown tools are not automatically executable.