mcp-metabase-server P
Provides comprehensive integration with Metabase analytics platform, enabling full CRUD operations on dashboards, questions/cards, collections, users, and databases. Supports advanced features like dashboard subscriptions, public sharing, data export, permission management, and system monitoring with 70+ tools covering all major Metabase functionality.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@mcp-metabase-server Plist dashboards from last quarter"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Metabase MCP Server
A Model Context Protocol (MCP) server for Metabase that gives AI assistants full access to your analytics platform — dashboards, cards, databases, tables, collections, and more.
Developed and maintained by EaseCloud — cloud-native, AI-driven, and data infrastructure solutions.
Quick Start
export METABASE_URL=https://your-metabase-instance.com
export METABASE_API_KEY=your_metabase_api_key
npx @easecloudio/mcp-metabase-serverRelated MCP server: Metabase MCP Server
96 Tools Available
Domain | Tools |
Dashboard Management | 27 |
Card / Question Management | 21 |
Database Management | 16 |
Table Management | 17 |
Collections, Users & Search | 13 |
Schema Cache (SQL→MBQL) | 2 |
Supported Metabase Versions
Metabase v0.46.x and above (recommended: v0.48.x or later)
Metabase Cloud (fully supported)
Self-hosted instances (Docker, JAR, or cloud deployments)
Installation
npx (Recommended)
npx @easecloudio/mcp-metabase-serverGlobal install
npm install -g @easecloudio/mcp-metabase-server
mcp-metabase-serverDocker
docker build -t mcp-metabase-server .
docker run -it --rm \
-e METABASE_URL=https://your-metabase-instance.com \
-e METABASE_API_KEY=your_metabase_api_key \
mcp-metabase-serverConfiguration
Authentication
API Key (preferred):
METABASE_URL=https://your-metabase-instance.com
METABASE_API_KEY=your_metabase_api_keyUsername / Password (fallback):
METABASE_URL=https://your-metabase-instance.com
METABASE_USERNAME=your_username
METABASE_PASSWORD=your_passwordCopy .env.example to .env and fill in your values.
Tool Filtering (TOOL_MODE)
Set TOOL_MODE to control which tools are exposed to the AI. Useful for limiting surface area or preventing accidental writes.
Mode | Description |
| Every available tool (default) |
| Core read + execute tools only |
| All non-destructive tools |
| All tools including create / update / delete |
TOOL_MODE=essential # smallest surface area
TOOL_MODE=read # read-only
TOOL_MODE=all # everything (default)Claude Desktop Integration
MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%/Claude/claude_desktop_config.json
Using npx:
{
"mcpServers": {
"metabase": {
"command": "npx",
"args": ["@easecloudio/mcp-metabase-server"],
"env": {
"METABASE_URL": "https://your-metabase-instance.com",
"METABASE_API_KEY": "your_metabase_api_key"
}
}
}
}With tool filtering:
{
"mcpServers": {
"metabase": {
"command": "npx",
"args": ["@easecloudio/mcp-metabase-server"],
"env": {
"METABASE_URL": "https://your-metabase-instance.com",
"METABASE_API_KEY": "your_metabase_api_key",
"TOOL_MODE": "essential"
}
}
}
}Using a local build:
{
"mcpServers": {
"metabase": {
"command": "node",
"args": ["/path/to/metabase-server/dist/index.js"],
"env": {
"METABASE_URL": "https://your-metabase-instance.com",
"METABASE_API_KEY": "your_metabase_api_key"
}
}
}
}Username / password fallback:
{
"mcpServers": {
"metabase": {
"command": "npx",
"args": ["@easecloudio/mcp-metabase-server"],
"env": {
"METABASE_URL": "https://your-metabase-instance.com",
"METABASE_USERNAME": "your_username",
"METABASE_PASSWORD": "your_password"
}
}
}
}Available Tools
Core CRUD
Tool | Description |
| List all dashboards |
| Get a specific dashboard by ID |
| Create a new dashboard |
| Update an existing dashboard |
| Delete / archive a dashboard |
| Duplicate a dashboard (shallow or deep copy) |
| Save a complete dashboard object with nested data |
| Move a dashboard into a specific collection |
| Search dashboards by name or description |
| Mark a dashboard as a favourite |
| Remove a dashboard from favourites |
Card Layout
Tool | Description |
| Get all cards in a dashboard |
| Add a card with positioning |
| Add a text or heading block to a dashboard |
| Remove a card |
| Update card position, size, and settings |
| Bulk-replace all cards on a dashboard |
| Update a specific dashcard's properties |
| Execute a specific dashcard and return results |
Public Sharing & Embedding
Tool | Description |
| Create a public sharing link |
| Remove the public link |
| List dashboards with public links |
| List dashboards enabled for embedding |
Revision, Audit & Discovery
Tool | Description |
| Get revision history (audit trail) |
| Revert to a previous revision |
| Get related content suggestions |
| Extract all card queries with resolved field IDs |
Core CRUD
Tool | Description |
| List all questions / cards |
| Get a card by ID (includes full SQL / MBQL query) |
| Create a new question |
| Update an existing question |
| Delete / archive a question |
| Duplicate a card |
| Move one or more cards to a different collection |
| Bulk-move cards from a source collection |
Execution & Export
Tool | Description |
| Run a card and return results |
| Run a card formatted as a pivot table |
| Export results as CSV or JSON |
Parameters
Tool | Description |
| Get available values for a card parameter |
| Search / filter parameter values |
| Get how parameter values are remapped for display |
Metadata & Discovery
Tool | Description |
| Get column types and display names |
| List dashboards containing this card |
| Get series data or related card suggestions |
Public Sharing & Embedding
Tool | Description |
| Create a public sharing link |
| Remove the public link |
| List cards with public links |
| List cards enabled for embedding |
Core CRUD
Tool | Description |
| List all database connections |
| Get a specific database by ID |
| Create a new database connection |
| Update a database connection's config or credentials |
| Permanently remove a database connection |
| Add the built-in H2 sample database with demo data |
Querying
Tool | Description |
| Execute a SQL query against a database |
Schema & Sync
Tool | Description |
| Get schema information |
| Get all tables in a database |
| Get full metadata including all tables and field IDs |
| List all schemas within a database |
| Trigger a schema metadata sync |
| Check sync status |
Diagnostics
Tool | Description |
| Check connection health |
| Validate connection settings before saving |
| Test an existing connection |
Metadata
Tool | Description |
| List tables (optionally filtered by database) |
| Get table metadata by ID |
| Get full query metadata including field IDs and types |
| Get foreign key relationships |
| Find related tables via FK relationships |
| Get a sample data preview from a table |
| Look up a field ID by table ID + column name (returns MBQL ref) |
Card Virtual Tables
Tool | Description |
| Get FK relationships for a card's virtual table |
| Get query metadata for a card's virtual table |
Management
Tool | Description |
| Update display name, description, or visibility |
| Bulk-update multiple tables with the same config |
| Change the display order of fields |
| Trigger a schema sync for a specific table |
| Rescan field values (updates filter dropdowns) |
| Discard cached field values |
CSV Upload (Metabase-managed tables)
Tool | Description |
| Append new rows from CSV content |
| Replace all table data with new CSV content |
Collections
Tool | Description |
| List all collections |
| Create a new collection |
| Get collection details |
| Update name, description, color, or parent |
| Delete a collection and its contents |
| List cards, dashboards, and sub-collections |
| Move a card or dashboard to a different collection |
Users
Tool | Description |
| List all users |
| Create a new user |
Permissions
Tool | Description |
| List all permission groups |
| Create a new permission group |
Search
Tool | Description |
| Search across all Metabase content |
These tools enable an AI to convert native SQL questions into interactive MBQL questions. Metabase has no REST API for this conversion — it requires field IDs, which these tools cache locally.
How it works:
get_card— extract the SQL anddatabase_idget_schema_cache— get tables + field IDs for MBQL references like["field", 42, null]AI translates SQL → MBQL using the cached field IDs
create_card— save the new interactive question
Cache is stored at ~/.easecloud/metabase-mcp/cache/{url-hash}/ with a 24-hour TTL and scoped per Metabase instance.
Tool | Description |
| Return cached schema (auto-fetches if missing or stale) |
| Force-refresh cache for one or all databases |
MCP Resources
Access Metabase entities directly via metabase:// URIs:
URI | Description |
| Dashboard details |
| Card / question details |
| Database information |
| Collection details |
| User information |
| Table metadata |
| Field information |
Development
npm install
npm run build # compile TypeScript → dist/
npm run watch # incremental rebuild
npm run dev # build + start
npm run inspector # launch MCP Inspector for debuggingDebugging
MCP servers communicate over stdio, which makes direct debugging awkward. Use the MCP Inspector:
npm run inspectorThe Inspector provides a browser UI for sending tool calls and inspecting responses.
About EaseCloud
EaseCloud is a cloud consulting and solutions company specializing in:
Cloud-native application development
AI & automation integrations
DevOps and infrastructure management
Data analytics and BI platform consulting
We built this project to contribute to the open-source MCP ecosystem while demonstrating our expertise in integration, automation, and cloud solutions.
If your team is adopting Metabase at scale or looking to integrate AI with your BI stack, get in touch — we provide consulting, customization, and managed support for enterprises.
📧 support@easecloud.io 🌐 easecloud.io
Bug Reports & Issues
Found a bug or have a feature request?
Please include:
Metabase version
MCP server version
Steps to reproduce
Expected vs actual behavior
Any error messages or logs
Contributing
Contributions are welcome. Visit the GitHub repository to submit issues or pull requests.
License
MIT — see LICENSE for details.
This server cannot be installed
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/easecloudio/mcp-metabase-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server