list_dashboardsLABSCO SUMMARY
From a question to a saved dashboard in one pass.
Reading Metabase is the easy half. This also writes — create a card from SQL, place it on a dashboard, set the visualization — which is what turns an exploratory query into something a team looks at every morning.
What it is
An MCP server over the Metabase API that reads dashboards, cards and databases, runs queries, and creates new dashboards and cards.
What you get
- Dashboards, saved questions, collections and connected databases all listed
- Tables and their fields listed for any connected database
- Saved questions executed with optional parameters, results returned
- Custom SQL executed against any connected database
- Dashboards created, updated and deleted, and cards positioned on them with optional tab assignment
- New cards created from SQL, and their visualization settings updated
- Collections created, so what you build has somewhere to live
- Resources addressed through metabase:// URIs
Requirements
A Metabase URL plus either an API key or the email and password of a Metabase account. The project recommends the API key for production.
Setup effort
Build from source — git clone https://github.com/CPR43/metabase-mcp.git
USE CASES
01
Answering a question no saved card covers
Write the SQL and run it against the connected database directly.
02
Re-running a report someone else built
Find the saved question and execute it with the parameters you need.
03
Finding out what columns a table really has
Read the fields before writing the query, rather than after the error.
04
Turning a good query into a dashboard tile
Save it as a card and place it on a dashboard where people will see it.
05
Tidying a dashboard that has drifted
Read what is on it, rename or re-describe it, and fix the charts that are showing the wrong shape.
06
Giving new work a home
Create a collection so the next twenty cards do not land in the root.
16 tools
Listed in project docs. Your client may show a different list.
list_cardslist_databaseslist_collectionslist_tablesget_table_fieldsexecute_cardexecute_queryget_dashboard_cardscreate_dashboardupdate_dashboarddelete_dashboardadd_card_to_dashboardcreate_cardupdate_card_visualizationcreate_collectionBEFORE YOU INSTALL
What to know first
Tools you get
16 tools named in the project's documentation.
Requires
- Node.js 18 or later
- A Metabase instance and its URL
- A Metabase API key, or the email and password of a Metabase account
- METABASE_URL in your environment
Where it runs
The documented client runs the server on your machine.
INSTALLATION
Connect your client
You clone this one yourself.
Server setup
TERMINAL
git clone https://github.com/CPR43/metabase-mcp.git
cd metabase-mcp
npm installMCP Clients
Claude Desktop
CLAUDE DESKTOP · JSON
{
"mcpServers": {
"metabase-mcp": {
"command": "node",
"args": [
"<YOUR_PATH_TO_METABASE_MCP>/build/index.js"
],
"env": {
"METABASE_URL": "<YOUR_METABASE_URL>",
"METABASE_API_KEY": "<YOUR_METABASE_API_KEY>"
}
}
}
}npm install also builds the server (the prepare script runs npm run build). <YOUR_PATH_TO_METABASE_MCP> is the full path of your clone. To sign in with an account, set METABASE_USER_EMAIL and METABASE_PASSWORD instead of METABASE_API_KEY.
