How do I install the metabase mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `METABASE_URL`, `METABASE_API_KEY`, `ANTHROPIC_API_KEY`, `OPENAI_API_KEY` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Metabase MCP Server

MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL

Local serverstdio

What is the Metabase MCP Server?

MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL

What the server does

That's it! Your AI assistant now has full Metabase superpowers. 🦸

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
db_list	List all databases
db_schemas	Get schemas in a database
db_tables	Get tables with fields
sql_execute	Execute SQL queries
db_table_create	Create tables (AI-prefixed)
db_view_create	Create views
db_matview_create	Create materialized views
db_index_create	Create indexes
db_vacuum_analyze	VACUUM and ANALYZE
db_query_explain	EXPLAIN query plans
db_table_stats	Table statistics
db_index_usage	Index usage analysis
db_schema_explore	Fast schema exploration

How to install the Metabase MCP Server

claude mcp add metabase-ai-assistant --env METABASE_URL=your-value --env METABASE_API_KEY=your-value --env ANTHROPIC_API_KEY=your-value --env OPENAI_API_KEY=your-value -- npx -y metabase-ai-assistant

Configuration

Variable	Description	Required
METABASE_URL	Endpoint or connection string the server talks to.	Yes
METABASE_API_KEY	Credential the server authenticates with.	Yes
ANTHROPIC_API_KEY	Credential the server authenticates with.	Yes
OPENAI_API_KEY	Credential the server authenticates with.	Yes

Example prompts to try

“Use Metabase to Feature.”
“Use Metabase to db list.”
“Use Metabase to db schemas.”

Frequently asked questions

MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.