Hana MCP Server vs Metabase AI Assistant
A side-by-side look at the Hana MCP Server and Metabase AI Assistant MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose Hana MCP Server for databases work as a local process; choose Metabase AI Assistant for databases as a local process. You can also run both side by side in one mcpServers block.
Which MCP server should you choose?
Choose Hana MCP Server when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- Its auth model fits you: other.
- You have the keys it needs:
HANA_HOST, HANA_PORT, HANA_USER, HANA_PASSWORD, HANA_SCHEMA. - You want tools like
hana_show_config, hana_test_connection, hana_list_schemas.
Choose Metabase AI Assistant when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- You have the keys it needs:
METABASE_URL, METABASE_API_KEY. - You want tools like
db_list, db_test_speed, db_schemas.
Feature & specification comparison
Rows where the two servers differ are marked.
| Spec | ||
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 69/100 · Great | 63/100 · Good |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Local subprocess (stdio) |
| Auth | other | Not declared |
| Pricing | Free | Not declared |
| Required env vars | HANA_HOSTHANA_PORTHANA_USERHANA_PASSWORDHANA_SCHEMA | METABASE_URLMETABASE_API_KEY |
| Verified owner | Community listing | Community listing |
| GitHub stars | 72 | 49 |
| Directory activity | 4 views 0 installs 0 upvotes | 2 views 0 installs 0 upvotes |
| Tools | 34 | 134 |
| Full listing | View Hana MCP Server | View Metabase AI Assistant |
Tools & capabilities
Hana MCP Server tools 34
hana_show_configShow the HANA database configurationhana_test_connectionTest connection to HANA databasehana_list_schemasList schemas in the HANA database with optional prefix filter and pagination (HANA_LIST_DEFAULT_LIMIT / offset).hana_show_env_varsShow all HANA-related environment variables (for debugging)hana_list_tablesList tables in a schema with optional name prefix and pagination (HANA_LIST_DEFAULT_LIMIT / offset).hana_describe_tableDescribe the structure of a specific tablehana_explain_tableReturn column metadata merged with optional business semantics from HANA_SEMANTICS_PATH or HANA_SEMANTICS_URL (JSON keys: SCHEMA.TABLE or DB.SCHEMA.TABLE when catalog_database is set). Optional catalog_database reads SYS.* from another MDC database (e.g. HSP).hana_list_indexesList all indexes for a specific tablehana_describe_indexDescribe the structure of a specific indexhana_execute_queryExecute SQL against HANA. When HANA_QUERY_LIMITS_ENABLED=true, SELECT/WITH queries are wrapped with LIMIT/OFFSET (HANA_MAX_RESULT_ROWS) and row/column/cell caps apply; results are returned as-is otherwise. INSERT/UPDATE/DELETE are blocked by default; set HANA_ALLOW_INSERT, HANA_ALLOW_UPDATE, HANA_ALLOW_DELETE=true individually to permit each. Use limit, offset, maxRows, includeTotal as needed. If truncated, snapshotId may be returned for hana_query_next_page.hana_query_next_pageFetch the next page of a truncated SELECT using snapshotId from a previous hana_execute_query result (same SQL and parameters; TTL HANA_QUERY_SNAPSHOT_TTL_MS).hana_list_constraintsList primary key, unique, check, and foreign key constraints for a table (SYS.CONSTRAINTS + SYS.REFERENTIAL_CONSTRAINTS).- +22 more on the listing page
Metabase AI Assistant tools 134
db_listGet list of all databases in Metabase instance with IDs and connection typesdb_test_speedCheck database response time and performance - run this before heavy operations to determine optimal timeout settingsdb_schemasGet all schema names in specified database - useful for data exploration and finding business data locationsdb_tablesGet comprehensive table list across all schemas with field counts - provides overview of data structuredb_table_profileGet comprehensive table profile: row count, column types, distinct values, sample data. Auto-detects dimension/reference tables (dim_, ref_, lookup_ prefix). Ideal for understanding lookup tables before writing queries.sql_executeRun SQL queries against database - supports SELECT, DDL with security controls, returns formatted results. For long-running queries (>60s), use sql_submit instead.sql_submitSubmit a long-running SQL query asynchronously. Returns immediately with job_id. Use sql_status to check progress. Ideal for queries that may take minutes.sql_statusCheck status of an async query submitted via sql_submit. Returns results when complete.sql_cancelCancel a running async query. Also attempts to cancel on database server.mb_question_createCreate new question/chartmb_questionsBrowse saved questions and charts in Metabase - filter by collection to find specific reportsmb_dashboard_createCreate a new dashboard in Metabase with layout options- +122 more on the listing page
Ready-to-paste client configs
Paste either block (or both) into your client config, e.g. claude_desktop_config.json or ~/.cursor/mcp.json. We only show a config when the install command is confirmed.
Hana MCP Server
{
"mcpServers": {
"hana-mcp-server": {
"command": "npx",
"args": [
"-y",
"hana-mcp-ui"
],
"env": {
"HANA_HOST": "YOUR_HANA_HOST_HERE",
"HANA_PORT": "YOUR_HANA_PORT_HERE",
"HANA_USER": "YOUR_HANA_USER_HERE",
"HANA_PASSWORD": "YOUR_HANA_PASSWORD_HERE",
"HANA_SCHEMA": "YOUR_HANA_SCHEMA_HERE"
}
}
}
}
Metabase AI Assistant
{
"mcpServers": {
"metabase-ai-assistant": {
"command": "npx",
"args": [
"-y",
"metabase-ai-assistant"
],
"env": {
"METABASE_URL": "YOUR_METABASE_URL_HERE",
"METABASE_API_KEY": "YOUR_METABASE_API_KEY_HERE"
}
}
}
}
Frequently asked questions
Hana MCP Server is categorized under Databases and uses a local stdio subprocess. Metabase AI Assistant belongs to Databases and uses a local stdio subprocess. Pick Hana MCP Server for databases work and Metabase AI Assistant for databases.
Copy the mcpServers block from the config section on this page into your client's config (for example claude_desktop_config.json or ~/.cursor/mcp.json), then fully restart the client.
Hana MCP Server is listed as free. Auth: other. Metabase AI Assistant has no declared pricing — check the project's own site. If a server needs environment variables such as API keys, define them under the env key in your client's MCP config.
Yes. MCP clients support multiple servers: add hana-mcp-server and metabase-ai-assistant as separate keys in the same mcpServers object, and your assistant will call tools from either one.
On AllMCPs, Hana MCP Server has a quality signal of 69/100 (Great) with 4 views, 0 installs and 72 GitHub stars. Metabase AI Assistant has 63/100 (Good) with 2 views, 0 installs and 49 GitHub stars.