A side-by-side look at the Postgres Scout MCP and Mysql MCP Server Pro MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose Postgres Scout MCP for databases work as a local process; choose Mysql MCP Server Pro for databases as a local process. You can also run both side by side in one mcpServers block.
listDatabases, getDatabaseStats, listSchemas.MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE, MYSQL_ROLE.execute_sql, get_chinese_initials, get_db_health_running.Rows where the two servers differ are marked.
| Spec | ||
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 49/100 · Fair | 59/100 · Good |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Local subprocess (stdio) |
| Auth | Not declared | other |
| Pricing | Not declared | Free |
| Required env vars | None listed | MYSQL_HOSTMYSQL_PORTMYSQL_USERMYSQL_PASSWORDMYSQL_DATABASEMYSQL_ROLE |
| Verified owner | Community listing | Community listing |
| GitHub stars | 0 | 248 |
| Directory activity | 1 views 0 installs 0 upvotes | 5 views 0 installs 0 upvotes |
| Tools | 36 | 10 |
| Full listing | View Postgres Scout MCP | View Mysql MCP Server Pro |
listDatabasesdatabases the user has access togetDatabaseStatssize, cache hit ratio, connection infolistSchemasall schemas in the current databaselistTablestables with size and row statisticsdescribeTablecolumns, constraints, indexes, and moreexecuteQueryrun SELECT queries (or writes in read-write mode)explainQueryEXPLAIN plans for performance analysisoptimizeQueryoptimization recommendations for a specific querygetHealthScoreoverall health score with component breakdowndetectAnomaliesanomalies in performance, connections, and dataanalyzeTableBloatbloat analysis for VACUUM planninggetSlowQueriesslow query analysis (requires pg_stat_statements)execute_sqlSQL execution tool that can execute ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", "CREATE", "ALTER", "DROP", "TRUNCATE"] commands based on permission configurationget_chinese_initialsConvert Chinese field names to pinyin initialsget_db_health_runningAnalyze MySQL health status (connection status, transaction status, running status, lock status detection)get_table_descSearch for table structures in the database based on table names, supporting multi-table queriesget_table_indexSearch for table indexes in the database based on table names, supporting multi-table queriesget_table_lockCheck if there are row-level locks or table-level locks in the current MySQL serverget_table_nameSearch for table names in the database based on table comments and descriptionsget_db_health_index_usageGet the index usage of the currently connected mysql database, including redundant index situations, poorly performing index situations, and the top 5 unused index situations with query times greater than 30 secondsoptimize_sqlProfessional SQL performance optimization tool, providing expert optimization suggestions based on MySQL execution plans, table structure information, table data volume, and table indexes.use_prompt_queryTableDataUse built-in prompts to let the model construct a chain call of tools in mcp (not a commonly used fixed tool, you need to modify the code to enable it, see this class for details)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": {
"postgres-scout-mcp": {
"command": "npx",
"args": [
"-y",
"postgres-scout-mcp"
]
}
}
}
{
"mcpServers": {
"wenb1n-dev-mysql-mcp-server-pro": {
"command": "uvx",
"args": [
"mysql_mcp_server_pro",
"mysql_mcp_server_pro",
"stdio"
],
"env": {
"MYSQL_HOST": "YOUR_MYSQL_HOST_HERE",
"MYSQL_PORT": "YOUR_MYSQL_PORT_HERE",
"MYSQL_USER": "YOUR_MYSQL_USER_HERE",
"MYSQL_PASSWORD": "YOUR_MYSQL_PASSWORD_HERE",
"MYSQL_DATABASE": "YOUR_MYSQL_DATABASE_HERE",
"MYSQL_ROLE": "YOUR_MYSQL_ROLE_HERE"
}
}
}
}