A side-by-side look at the Pg Readonly MCP and Read Only Local Mysql MCP Server MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose Pg Readonly MCP for databases work as a local process; choose Read Only Local Mysql MCP Server for databases as a local process. You can also run both side by side in one mcpServers block.
PG_READONLY_MCP_DSN.DB_HOST, DB_PORT, DB_DATABASE, DB_USERNAME, DB_PASSWORD, DB_ALLOWED_HOSTS.connect, disconnect, query.Rows where the two servers differ are marked.
| Spec | P Pg Readonly MCP | |
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 41/100 · Fair | 57/100 · Good |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Local subprocess (stdio) |
| Auth | other | Not declared |
| Pricing | Free | Not declared |
| Required env vars | PG_READONLY_MCP_DSN | DB_HOSTDB_PORTDB_DATABASEDB_USERNAMEDB_PASSWORDDB_ALLOWED_HOSTS |
| Verified owner | Community listing | Community listing |
| GitHub stars | 0 | 7 |
| Directory activity | 0 views 0 installs 0 upvotes | 1 views 0 installs 0 upvotes |
| Tools | Not listed | 3 |
| Full listing | View Pg Readonly MCP | View Read Only Local Mysql MCP Server |
No tool names declared yet. Check the project README from the listing page.
connectConnect to a MySQL database using a connection string. The connection will be used for subsequent queries until changed.disconnectDisconnect from the current runtime database and revert to the default environment-configured connectionqueryRun a read-only SQL query against the currently connected databasePaste 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": {
"pg-readonly-mcp": {
"command": "uvx",
"args": [
"pg-readonly-mcp"
],
"env": {
"PG_READONLY_MCP_DSN": "YOUR_PG_READONLY_MCP_DSN_HERE"
}
}
}
}
{
"mcpServers": {
"read-only-local-mysql-mcp-server": {
"command": "npx",
"args": [
"-y",
"@hovecapital/read-only-mysql-mcp-server@latest"
],
"env": {
"DB_HOST": "YOUR_DB_HOST_HERE",
"DB_PORT": "YOUR_DB_PORT_HERE",
"DB_DATABASE": "YOUR_DB_DATABASE_HERE",
"DB_USERNAME": "YOUR_DB_USERNAME_HERE",
"DB_PASSWORD": "YOUR_DB_PASSWORD_HERE",
"DB_ALLOWED_HOSTS": "YOUR_DB_ALLOWED_HOSTS_HERE"
}
}
}
}