A side-by-side look at the AdoMcp and MCP Server Mysql MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose AdoMcp for databases work over a hosted endpoint; choose MCP Server Mysql for databases as a local process. You can also run both side by side in one mcpServers block.
ADOMCP_MODE, ADOMCP_URLS, ADOMCP_ALLOWANYSQL, ADOMCP_DATABASES.list_connections, add_connection, remove_connection.MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB.Rows where the two servers differ are marked.
| Spec | ||
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 52/100 · Good | 52/100 · Good |
| Install command | Confirmed | Confirmed |
| Transport | Remote HTTP/SSE | Local subprocess (stdio) |
| Auth | Not declared | other |
| Pricing | Not declared | Free |
| Required env vars | ADOMCP_MODEADOMCP_URLSADOMCP_ALLOWANYSQLADOMCP_DATABASES | MYSQL_HOSTMYSQL_PORTMYSQL_USERMYSQL_PASSMYSQL_DB |
| Verified owner | Community listing | Community listing |
| GitHub stars | 4 | 2,153 |
| Directory activity | 1 views 0 installs 0 upvotes | 3 views 0 installs 0 upvotes |
| Tools | 8 | Not listed |
| Full listing | View AdoMcp | View MCP Server Mysql |
list_connectionsList configured database connectionsadd_connectionAdd (or replace) a database connection at runtimeremove_connectionRemove a dynamically-added connectionlist_objectsList database objects (table/view/procedure/function/trigger/sequence/synonym, etc.)get_table_schemaGet table schema details (columns/types/nullability/PK/default/comments)get_table_indexesGet table indexesquery_sqlExecute read-only SQL and return CSVexecute_sqlExecute write SQL (requires `--allow-any-sql`)No tool names declared yet. Check the project README from the listing page.
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": {
"adomcp": {
"url": "http://localhost:5100/mcp"
}
}
}
{
"mcpServers": {
"benborla29-mcp-server-mysql": {
"command": "npx",
"args": [
"-y",
"@benborla29/mcp-server-mysql"
],
"env": {
"MYSQL_HOST": "YOUR_MYSQL_HOST_HERE",
"MYSQL_PORT": "YOUR_MYSQL_PORT_HERE",
"MYSQL_USER": "YOUR_MYSQL_USER_HERE",
"MYSQL_PASS": "YOUR_MYSQL_PASS_HERE",
"MYSQL_DB": "YOUR_MYSQL_DB_HERE"
}
}
}
}