Metabase MCP Server

Retrieve all items (cards, dashboards) within a Metabase collection - use this to explore collection contents, organize analytical assets, or understand content structure

Move a Metabase card or dashboard to a different collection - use this to reorganize content, implement governance policies, or clean up analytical assets

Search across all Metabase content including cards, dashboards, collections, and models - use this to find specific content, discover assets, or explore analytical resources

Retrieve all Metabase collections for organizing analytical content - use this to understand content structure, find collections, or explore organizational hierarchy

Create a new Metabase collection for organizing analytical content - use this to establish organizational containers for cards, dashboards, and reports

Update collection properties including name, description, and organization - use this to maintain metadata, reorganize hierarchies, or update structure

Permanently delete a Metabase collection - use with caution as this affects contained content and cannot be undone

Retrieve all Metabase users with their roles and permissions - use this to understand user access, manage permissions, or audit accounts

Generate a Metabase playground link for interactive query exploration - allows users to see results and experiment with data in a user-friendly interface

Retrieve all Metabase cards with optional filtering by source type (e.g., 'models') or model relationships - use this to discover available cards, find specific cards by type, or get an overview of all analytical content

Get complete metadata and configuration for a specific Metabase card including query definition, visualization settings, collection location, and permissions - use this when you need to examine or understand how a particular card is built

Create a new Metabase card with custom query, visualization type, and settings - use this to programmatically build new analytical cards, dashboards charts, or data exploration queries

Modify an existing Metabase card's name, description, query definition, visualization type, or settings - use this to fix broken cards, change chart types, update queries, or move cards between collections

Remove a Metabase card either by archiving (soft delete, preserves history) or permanent deletion - use this to clean up unused cards, remove broken cards, or organize analytical content

Run a Metabase card query and return the actual data results - use this to get current data from existing cards, refresh analytical insights, or programmatically access query results for further processing

Execute a Metabase card and export the results in a specific format (CSV, Excel, JSON, etc.) - use this to download data for external analysis, create reports for stakeholders, or integrate query results with other systems

Create a duplicate copy of an existing Metabase card with identical query and settings - use this to create variations of existing cards, build templates for similar analyses, or backup important queries before modifications

Find all dashboards that include a specific Metabase card - use this to understand where a card is being used, track dependencies before making changes, or find related analytical content

Retrieve all Metabase cards configured for embedding in external applications (requires admin privileges) - use this to audit embedded content, manage external integrations, or review public-facing analytics

Generate a publicly accessible URL for a Metabase card that can be viewed without authentication (requires admin privileges) - use this to share analytical insights with external stakeholders, create public reports, or embed charts in websites

Remove public access to a Metabase card by deleting its public URL (requires admin privileges) - use this to revoke external access to sensitive data, clean up unused public links, or update security permissions

Retrieve all Metabase cards that have public URLs enabled (requires admin privileges) - use this to audit publicly accessible content, review security settings, or manage external data sharing

Relocate multiple Metabase cards to a different collection or dashboard for better organization - use this to reorganize analytical content, group related cards, or clean up workspace structure

Bulk transfer multiple Metabase cards to a specific collection for organizational purposes - use this to categorize cards by team, project, or topic, or to implement content governance policies

Run a Metabase card with pivot table formatting to cross-tabulate data with rows and columns - use this to create summary tables, analyze data relationships, or generate matrix-style reports from existing cards

Retrieve all available values for a specific parameter in a Metabase card - use this to populate dropdown filters, validate parameter inputs, or understand what data options are available for interactive cards

Search and filter available parameter values for a Metabase card using a text query - use this to find specific parameter options in large datasets, help users locate filter values, or implement autocomplete functionality

Retrieve how parameter values are remapped or transformed for display in a Metabase card - use this to understand data transformations, debug parameter issues, or see how raw values are presented to users

Retrieve structural metadata about a Metabase card's underlying query including column types, field information, and data schema - use this to understand card structure, validate data types, or build dynamic interfaces

Retrieve time series data or related card suggestions for a Metabase card - use this to get chronological data trends, find similar cards, or discover related analytical content for dashboard building

Retrieve all Metabase dashboards - use this to discover available dashboards, get an overview of analytical content, or find specific dashboards

Retrieve detailed information about a specific Metabase dashboard including cards, layout, and settings - use this to examine dashboard structure or get configuration details

Retrieve all cards within a specific Metabase dashboard - use this to analyze dashboard content, understand data sources, or examine card configurations

Retrieve entities related to a Metabase dashboard - use this to discover related content, find similar analytical views, or understand dashboard relationships

Retrieve revision history for a Metabase dashboard - use this to track dashboard evolution, review past changes, or restore previous versions

Retrieve all Metabase dashboards configured for embedding (requires superuser) - use this to audit embedded content or manage external integrations

Retrieve all Metabase dashboards with public URLs enabled (requires superuser) - use this to audit publicly accessible content or review security settings

Create a new Metabase dashboard - use this to build new analytical views, organize related cards, or establish monitoring interfaces

Generate publicly accessible URL for a dashboard (requires superuser) - use this for external reporting, client dashboards, or public data sharing

Create a copy of an existing dashboard with all cards and layout - use this to create templates, backups, or variations of analytical views

Add an existing card to a dashboard with optional parameter mappings - use this to build comprehensive dashboards by combining multiple visualizations

Add a text block or heading to a dashboard - use this for explanatory text, titles, or instructions

Mark a dashboard as favorite for quick access - use this to bookmark frequently accessed analytical views

Restore a dashboard to a specific previous revision - use this to undo changes, restore deleted content, or return to known good configuration

Save a complete dashboard object with nested data - use this for bulk operations or complex dashboard structures

Save a dashboard object directly into a specific collection - use this for organized dashboard creation or bulk imports

Update dashboard properties including name, description, parameters, and settings - use this to maintain metadata, reorganize content, or configure sharing

⚠️ DANGER: REPLACES ALL dashboard cards - any cards not in the array will be DELETED. To update a single card, first get_dashboard to fetch ALL cards, then include ALL of them with your modifications. This affects ALL tabs.

Delete or archive a dashboard (soft or hard delete) - use with caution as permanent deletion cannot be undone

Remove public URL access for a dashboard (requires superuser) - use this to revoke external access for security or privacy reasons

Remove specific dashcards from a dashboard by their dashcard IDs (not card_id) - use this to clean up dashboards or reorganize content

Remove a dashboard from the user's favorites list - use this to clean up bookmarked dashboards

Execute a specific card from a dashboard and retrieve fresh data - use this to get current results from dashboard components or test card functionality

Search dashboards by name or description text - use this to find specific dashboards or discover related analytical content

Update a specific dashcard's properties without affecting other cards - use for parameter_mappings, visualization_settings, position, or size changes. Much safer than update_dashboard_cards.

Extract all queries from a dashboard with IDs resolved to actual table/column names - use this to understand dashboard data sources, audit queries, or plan migrations

Analyze dashboard filter connections to find unconnected or misconfigured cards - use this to diagnose filter issues and ensure all cards are properly connected

Retrieve all database connections in Metabase - use this to discover available data sources, check connection status, or get an overview of connected databases

Retrieve detailed information about a specific Metabase database including connection details and schema - use this to examine database properties or troubleshoot connections

Add a new database connection to Metabase - use this to connect new data sources, establish analytical pipelines, or expand data access

Update database configuration including name, connection details, and sync settings - use this to maintain connections, update credentials, or modify sync behavior

Permanently remove a database from Metabase - use with caution as this will break dependent content and cannot be undone

Test database connection parameters before creating - use this to verify credentials, connectivity, and accessibility

Add the built-in Metabase sample database with demo data - use this for testing, learning, or exploring Metabase features

Perform health check on database connection - use this to diagnose issues, monitor status, or troubleshoot sync problems

Retrieve comprehensive database metadata including tables, fields, and relationships - use this to understand structure or build dynamic queries

Retrieve all schema names in a database - use this to explore database organization or navigate multi-schema databases

Retrieve detailed information about a specific schema including tables and objects - use this to explore schema contents or understand organization

Execute a native SQL query against a Metabase database - use this for custom data analysis, complex queries, or extracting specific data not available through existing cards

Initiate schema sync to update Metabase metadata cache - use this after database changes to recognize new tables, columns, or relationships

Retrieve all Metabase tables with optional ID filtering - use this to discover available tables, explore database schema, or get metadata about specific tables

Bulk update multiple Metabase tables with same configuration - use this to apply consistent settings, update metadata, or modify table properties efficiently

Retrieve comprehensive table information including schema, fields, and metadata - use this to understand structure, explore fields, or get configuration details

Update table configuration including display name, description, and field settings - use this to customize presentation, update metadata, or configure data model

Retrieve foreign key relationships for a table - use this to understand data connections, build joins, or explore table dependencies

Retrieve query-optimized table metadata for building dynamic queries - use this when constructing queries or building query interfaces

Find tables and entities related through relationships or schemas - use this to discover connected data, find related content, or understand context

Retrieve foreign keys for a card's virtual table - use this to understand relationships in card-based queries or saved question tables

Retrieve query metadata for a card's virtual table - use this to build queries on top of saved questions or treat cards as queryable tables

Add new rows from CSV content to existing table - use this for incremental data loading, updates, or importing additional records

Clear cached field values to force fresh data loading - use this when table data has changed or cached values are stale

Change display order of table fields for better organization - use this to arrange fields logically, group columns, or improve presentation

Completely replace table data with new CSV content - use this for full data refreshes, model updates, or complete table replacements

Trigger rescan to refresh field values cache with current data - use this to update dropdown options, statistics, or filter values

Initiate schema sync for specific table to update metadata - use this when table structure has changed and needs recognition

Retrieve sample data from table for preview and analysis - use this to examine content, verify quality, or understand data patterns

Look up a field's ID and metadata by table and column name - essential for building parameter mappings. Returns field_id, base_type, and other metadata needed for filter connections.