Secure Schema MCP vs Pgmcp
A side-by-side look at the Secure Schema MCP and Pgmcp MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose Secure Schema MCP for databases work as a local process; choose Pgmcp for databases over a hosted endpoint. You can also run both side by side in one mcpServers block.
Which MCP server should you choose?
Choose Secure Schema MCP when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- You have the keys it needs:
DATABASE_URL. - You want tools like
schema_overview, list_tables, inspect_table.
Choose Pgmcp when
- You need dedicated capabilities in the Databases domain.
- You prefer a remote HTTP/SSE transport.
- Its auth model fits you: API key required.
- You have the keys it needs:
DATABASE_URL.
Feature & specification comparison
Rows where the two servers differ are marked.
| Spec | ||
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 47/100 · Fair | 45/100 · Fair |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Remote HTTP/SSE |
| Auth | Not declared | API key required |
| Pricing | Not declared | Free |
| Required env vars | DATABASE_URL |
Tools & capabilities
Secure Schema MCP tools 3
schema_overviewcompact map of permitted tables, views, primary keys, and foreign-key relationshipslist_tablespermitted table and view inventoryinspect_tablecolumns, SQL types, nullability, primary keys, unique constraints, and foreign keys for one entity
Pgmcp tools
No tool names declared yet. Check the project README from the listing page.
Ready-to-paste client configs
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.
Secure Schema MCP
{
"mcpServers": {
"secure-schema-mcp": {
"command": "uvx",
"args": [
"mcp-secure-schema"
],
"env": {
"DATABASE_URL": "YOUR_DATABASE_URL_HERE"
}
}
}
}
Pgmcp
{
"mcpServers": {
"subnetmarco-pgmcp": {
"url": "http://localhost:8080/mcp"
}
}
}
Frequently asked questions
Secure Schema MCP is categorized under Databases and uses a local stdio subprocess. Pgmcp belongs to Databases and uses a remote HTTP/SSE transport. Pick Secure Schema MCP for databases work and Pgmcp for databases.
Copy the mcpServers block from the config section on this page into your client's config (for example claude_desktop_config.json or ~/.cursor/mcp.json), then fully restart the client.
Secure Schema MCP has no declared pricing — check the project's own site. Pgmcp is listed as free. Auth: api key required. If a server needs environment variables such as API keys, define them under the env key in your client's MCP config.
Yes. MCP clients support multiple servers: add secure-schema-mcp and subnetmarco-pgmcp as separate keys in the same mcpServers object, and your assistant will call tools from either one.
On AllMCPs, Secure Schema MCP has a quality signal of 47/100 (Fair) with 1 views, 0 installs and 0 GitHub stars. Pgmcp has 45/100 (Fair) with 3 views, 0 installs and 541 GitHub stars.
