A side-by-side look at the Database MCP and SmartDB MCP MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose Database MCP for databases work as a local process; choose SmartDB MCP for databases as a local process. You can also run both side by side in one mcpServers block.
conn_create, conn_list, conn_get.DATABASE_CONFIG_FILE, CLIENT_ID, CLIENT_SECRET, ACCESS_TOKEN_EXPIRE_MINUTES, REFRESH_TOKEN_EXPIRE_DAYS, TOKEN_SECRET_KEY, OAUTH_USER_NAME, OAUTH_USER_PASSWORD.execute_sql, get_db_health, get_table_desc.Rows where the two servers differ are marked.
| Spec | ||
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 60/100 · Good | 57/100 · Good |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Local subprocess (stdio) |
| Auth | Not declared | OAuth 2.0 |
| Pricing | Not declared | Free |
| Required env vars | None listed | DATABASE_CONFIG_FILECLIENT_IDCLIENT_SECRETACCESS_TOKEN_EXPIRE_MINUTESREFRESH_TOKEN_EXPIRE_DAYSTOKEN_SECRET_KEYOAUTH_USER_NAMEOAUTH_USER_PASSWORD |
| Verified owner | Community listing | Community listing |
| GitHub stars | 2 | 77 |
| Directory activity | 1 views 0 installs 0 upvotes | 3 views 0 installs 0 upvotes |
| Tools | 34 | 8 |
| Full listing | View Database MCP | View SmartDB MCP |
conn_createCrea una nueva conexion a base de datos (PostgreSQL, MySQL o SQLite). SIEMPRE pregunta al usuario a que grupo pertenece.conn_listLista todas las conexiones disponibles e indica cual esta activa.conn_getObtiene los detalles de una conexion. El password se muestra enmascarado.conn_setActualiza un campo de una conexion existente.conn_switchCambia la conexion activa (de sesion). Para cambiar el default permanente usa conn_set_default.conn_renameRenombra una conexion existente.conn_deleteElimina una conexion. IMPORTANTE: pide confirmacion al usuario antes de llamar esta tool con confirm=true.conn_duplicateDuplica una conexion existente con un nuevo nombre.conn_testPrueba la conexion a una base de datos. Ejecuta SELECT 1 y mide la latencia.conn_project_listLista todos los proyectos con conexiones especificas asignadas.conn_project_clearElimina la asociacion de conexion especifica de un proyecto.conn_exportExporta conexiones a JSON. Por defecto enmascara passwords — usa include_secrets=true para incluirlos.execute_sqlSQL execution tool that can execute ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", "CREATE", "ALTER", "DROP", "TRUNCATE"] commands based on permission configurationget_db_healthAnalyzes database health status (connection status, transaction status, running status, lock detection) and outputs professional diagnostic reports and solutionsget_table_descSearches for table structures in the database based on table names, supports multi-table queriesget_table_indexSearches for table indexes in the database based on table names, supports multi-table queriesget_table_nameDatabase table name query tool. Used to query all table names in the database or search for corresponding table names based on Chinese table names or table descriptionsget_db_versionDatabase version query toolsql_creatorSQL query generation tool that generates corresponding SQL query statements based on different database typessql_optimizeA professional SQL performance optimization tool that provides expert optimization suggestions based on execution plans, table structure information, table data volume, and table indexes.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.
{
"mcpServers": {
"database-mcp": {
"command": "npx",
"args": [
"-y",
"@cocaxcode/database-mcp@latest"
]
}
}
}
{
"mcpServers": {
"wenb1n-dev-smartdb-mcp": {
"command": "uvx",
"args": [
"SmartDB-MCP"
],
"env": {
"DATABASE_CONFIG_FILE": "YOUR_DATABASE_CONFIG_FILE_HERE",
"CLIENT_ID": "YOUR_CLIENT_ID_HERE",
"CLIENT_SECRET": "YOUR_CLIENT_SECRET_HERE",
"ACCESS_TOKEN_EXPIRE_MINUTES": "YOUR_ACCESS_TOKEN_EXPIRE_MINUTES_HERE",
"REFRESH_TOKEN_EXPIRE_DAYS": "YOUR_REFRESH_TOKEN_EXPIRE_DAYS_HERE",
"TOKEN_SECRET_KEY": "YOUR_TOKEN_SECRET_KEY_HERE",
"OAUTH_USER_NAME": "YOUR_OAUTH_USER_NAME_HERE",
"OAUTH_USER_PASSWORD": "YOUR_OAUTH_USER_PASSWORD_HERE"
}
}
}
}