Metabase MCP server

Connect Metabase to Claude, ChatGPT, Cursor, Claude Code, Codex, Gemini, GitHub Copilot and any other MCP client, for your whole team. Metorial adds security, governance, and tracing, and gives everyone one Magic MCP URL to connect.

What you can do with the Metabase MCP server

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Use the execute query tool in Metabase
  • Use the manage dashboard cards tool in Metabase
  • Use the manage dashboard tool in Metabase
  • Use the list dashboards tool in Metabase
  • Use the manage question alert tool in Metabase
  • Use the manage permissions tool in Metabase

Supported Tools

execute_query

Execute Query

Execute an ad-hoc query or run a saved question's query against a connected database. Supports native SQL queries and Metabase's structured query language (MBQL). Returns query results including column metadata and row data.

manage_dashboard_cards

Manage Dashboard Cards

Add or remove question cards from a dashboard. When adding a card, you can specify its position and size on the dashboard grid. Parameter mappings allow you to connect dashboard filters to the card's parameters.

manage_dashboard

Manage Dashboard

Create, update, retrieve, copy, or archive a dashboard in Metabase. Dashboards organize questions (cards) into a visual layout. Use this to manage dashboard properties like name, description, collection, and parameters. Set **archived** to true to move a dashboard to the trash.

list_dashboards

List Dashboards

List dashboards in Metabase with optional filtering. Returns all dashboards, dashboards you created, or archived dashboards.

manage_alert

Manage Question Alert

Create, update, retrieve, list, or archive scheduled alerts for saved questions. Alerts use Metabase notification handlers for email, Slack, or HTTP delivery and Quartz cron schedules.

manage_permissions

Manage Permissions

Manage permission groups and group memberships in Metabase. Create or delete permission groups, add or remove users from groups, and retrieve or replace the versioned data permissions graph. Permission groups control access to databases, tables, and collections.

manage_database

Manage Database

List connected databases, retrieve database details and metadata, or trigger a sync/rescan. Use the **metadata** action to list tables, then get_table_metadata to inspect one table's fields. Use **sync** to trigger a manual schema metadata sync, or **rescan** to trigger a field value scan.

manage_user

Manage User

Create, update, retrieve, deactivate, or reactivate a user in Metabase. Supports setting the user's name, email, group memberships, and superuser status. Use **deactivate** to disable a user account or **reactivate** to restore it.

list_questions

List Questions

List saved questions (cards) in Metabase with optional filtering. Returns all questions, your questions, bookmarked or archived questions, or questions filtered by a related object.

manage_question

Manage Question

Create, update, retrieve, or archive a saved question (card) in Metabase. Questions can be built using native SQL or Metabase's structured query language (MBQL). Use this to manage saved questions including changing their name, description, display type, collection, or query definition. Set **archived** to true to move a question to the trash.

manage_collection

Manage Collection

Create, update, retrieve, list, or archive collections in Metabase. Collections organize questions, dashboards, and other content. Use "root" for top-level content and "trash" for archived content.

get_current_user

Get Current User

Return the Metabase user represented by the current connection.

export_question_results

Export Question Results

Run a saved question and return its complete CSV, JSON, or XLSX result as a downloadable file.

get_table_metadata

Get Table Metadata

Inspect a table and its fields before building an MBQL query or understanding available data.

Connect Metabase to your AI client

Every client uses the same Magic MCP URL, and so does any other MCP client. Add it once and sign in with SSO.

  1. Enable Metabase in Metorial. In your Metorial portal, enable the Metabase MCP server and sign in with the account that owns the data. Access stays governed by your team policies.
  2. Add a custom connector. Open Customize, then Connectors. Select Add, then Custom, then Web.
  3. Paste your Metorial MCP URL. Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>) and continue.
  4. Sign in. Select Add and sign in to load Metabase tools.

Run Metabase through the Metorial gateway

One governed layer for every app your agents reach, not a separate connector per tool.

  • Give Metabase and every other app to your whole team through one MCP gateway, behind your SSO.
  • Scope which teams and agents can use Metabase tools with role-based access control, and trace every call.
  • Prefer to run it yourself? Metorial is open source and self-hostable.

More integrations teams use with Metabase

Google Sheets

Create, read, and update spreadsheets and their cell data. Read and write values to individual cells, ranges, or multiple ranges using A1 notation or named ranges. Apply cell formatting including text styles, backgrounds, borders, number formats, and conditional formatting. Manage sheets (tabs) within a spreadsheet—add, delete, copy, rename, and reorder them. Create and manage embedded charts, pivot tables, filter views, data validation rules, protected ranges, named ranges, and merged cells. Perform batch operations to apply multiple updates atomically.

GitHub

Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.

Salesforce

Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Resolve site users to numeric Person/Group LookupId values. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Retrieve site properties and search for sites across Microsoft 365.

Airtable

Create, read, update, and delete records in Airtable bases and tables. Manage base schemas including creating tables and fields. Filter records using formulas, sort by fields, and scope queries to specific views. Upsert records to find, create, or update in a single call. Upload attachments to records, read and write record comments, list accessible bases, and receive real-time base change events through webhooks.

Google Drive

Upload, download, create, copy, move, rename, trash, and permanently delete files and folders in Google Drive. Search for files using complex queries filtering by name, MIME type, owner, modification date, labels, and other metadata. Share files and folders with specific users, groups, or domains with role-based permissions (owner, writer, commenter, reader). Manage shared drives and their members. Export Google Workspace files (Docs, Sheets, Slides) to standard formats like PDF, DOCX, and XLSX. Track file revision history and restore earlier versions. Create, read, update, and delete threaded comments and replies on files. Read label definitions and search files by label. Browse the Drive apps installed for your account. Store app-specific data in a hidden per-user folder.

Technical notes for Metabase

Run and export saved questions, execute SQL or MBQL queries, inspect database and table metadata, and manage questions, dashboards, collections, users, groups, permissions, public links, and scheduled question alerts.

Frequently asked questions

Common questions about connecting Metabase to AI agents with Metorial.

  1. How many tools does the Metabase MCP server have?
    The Metabase MCP server exposes 16 tools, including Execute Query, Manage Dashboard Cards, Manage Dashboard. Each one is governed and traced through Metorial.
  2. Metabase exposes tools your agents call on demand; it does not publish event triggers yet. Everything still runs through one governed MCP URL.
  3. Any MCP client, including VS Code, Windsurf, Zed, OpenCode and Grok. Each one reaches the Metabase MCP server through the same Metorial URL.
  4. Use role-based access control to decide which teams, users, and agents can use Metabase and which of its tools they can call.
  5. Yes. Metorial is open source, so you can run the Metabase MCP server yourself or use the hosted gateway.

Connect Metabase to production AI agents

See how Metorial gives your team governed access to Metabase, with tracing and security controls built in.