A side-by-side look at the MCP Snowflake Server and Pg Readonly MCP MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose MCP Snowflake Server for databases work as a local process; choose Pg Readonly MCP for databases as a local process. You can also run both side by side in one mcpServers block.
SNOWFLAKE_USER, SNOWFLAKE_ACCOUNT, SNOWFLAKE_ROLE, SNOWFLAKE_DATABASE, SNOWFLAKE_SCHEMA, SNOWFLAKE_WAREHOUSE, SNOWFLAKE_PASSWORD, SNOWFLAKE_PRIVATE_KEY_PATH.read_query, query, SELECT.PG_READONLY_MCP_DSN.Rows where the two servers differ are marked.
| Spec | P Pg Readonly MCP | |
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 55/100 · Good | 41/100 · Fair |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Local subprocess (stdio) |
| Auth | other | other |
| Pricing | BYOK (pay the provider) | Free |
| Required env vars | SNOWFLAKE_USERSNOWFLAKE_ACCOUNTSNOWFLAKE_ROLESNOWFLAKE_DATABASESNOWFLAKE_SCHEMASNOWFLAKE_WAREHOUSESNOWFLAKE_PASSWORDSNOWFLAKE_PRIVATE_KEY_PATH | PG_READONLY_MCP_DSN |
| Verified owner | Community listing | Community listing |
| GitHub stars | 184 | 0 |
| Directory activity | 2 views 0 installs 0 upvotes | 0 views 0 installs 0 upvotes |
| Tools | 15 | Not listed |
| Full listing | View MCP Snowflake Server | View Pg Readonly MCP |
read_queryquerySELECTwrite_querycreate_tablelist_databaseslist_schemasdatabaselist_tablesschemadescribe_tabletable_nameNo 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": {
"isaacwasserman-mcp-snowflake-server": {
"command": "uvx",
"args": [
"--python=3.12",
"mcp_snowflake_server"
],
"env": {
"SNOWFLAKE_USER": "YOUR_SNOWFLAKE_USER_HERE",
"SNOWFLAKE_ACCOUNT": "YOUR_SNOWFLAKE_ACCOUNT_HERE",
"SNOWFLAKE_ROLE": "YOUR_SNOWFLAKE_ROLE_HERE",
"SNOWFLAKE_DATABASE": "YOUR_SNOWFLAKE_DATABASE_HERE",
"SNOWFLAKE_SCHEMA": "YOUR_SNOWFLAKE_SCHEMA_HERE",
"SNOWFLAKE_WAREHOUSE": "YOUR_SNOWFLAKE_WAREHOUSE_HERE",
"SNOWFLAKE_PASSWORD": "YOUR_SNOWFLAKE_PASSWORD_HERE",
"SNOWFLAKE_PRIVATE_KEY_PATH": "YOUR_SNOWFLAKE_PRIVATE_KEY_PATH_HERE"
}
}
}
}
{
"mcpServers": {
"pg-readonly-mcp": {
"command": "uvx",
"args": [
"pg-readonly-mcp"
],
"env": {
"PG_READONLY_MCP_DSN": "YOUR_PG_READONLY_MCP_DSN_HERE"
}
}
}
}