EN 日本語中文

db_schema_analyze

MCP tool from Metabase Ai Assistant by enessari

Deep schema analysis

How to use it

db_schema_analyze is exposed by the Metabase Ai Assistant MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the db_schema_analyze tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install Metabase Ai Assistant

$npx metabase-ai-assistant

FULL METABASE AI ASSISTANT LISTING

Other tools in Metabase Ai Assistant (39)

ai_relationships_suggest

Suggest table relationships

Explain SQL in plain English

ai_sql_generate

Natural language → SQL

ai_sql_optimize

Query optimization suggestions

db_index_create

Create indexes

Index usage analysis

List all databases

db_matview_create

Create materialized views

db_query_explain

EXPLAIN query plans

db_relationships_detect

Detect foreign keys

db_schema_explore

Fast schema exploration

Get schemas in a database

db_table_create

Create tables (AI-prefixed)

Table statistics

Get tables with fields

db_vacuum_analyze

VACUUM and ANALYZE

Create views

mb_auto_describe

Auto-generate descriptions

mb_card_archive

Archive cards

Clone cards

Copy cards

Get card data as JSON

Delete cards

Get card details

Update cards

mb_dashboard_add_card

Add cards to dashboard

mb_dashboard_add_filter

Add filters

mb_dashboard_create

Create dashboards

mb_dashboard_delete

Delete dashboards

mb_dashboard_get

Get dashboard details

mb_dashboard_layout_optimize

Optimize layout

mb_dashboard_template_executive

Executive templates

mb_dashboard_update

Update dashboards

List all dashboards

mb_question_create

Create new questions

mb_question_create_parametric

Parametric questions

List all questions

List users

Execute SQL queries