# Postgres MCP server

Agent View of the PolicyLayer registry record for Postgres: identity, probed posture, risk grade, and all 8 tools classified. HTML page: https://policylayer.com/tools/allensandiego-postgres-mcp-server

## Facts

- Server id: `@allensandiego/postgres-mcp-server`
- Install: `npx -y @allensandiego/postgres-mcp-server`
- Homepage: https://www.npmjs.com/package/@allensandiego/postgres-mcp-server
- Registry record: grade F, identity unverified
- Lifecycle: active
- Rate-limited: no
- Tools: 8 (6 with introspected schema)
- Tool categories present: Execute, Read, Write
- Context-window cost: 833 tokens per request — https://policylayer.com/token-cost/allensandiego-postgres-mcp-server
- Tags: allensandiego postgres mcp server, automation
- Record last modified: 2026-09-01T18:13:31.652Z

## Tools (8)

| Tool | Category | Risk | Record |
| --- | --- | --- | --- |
| `run_query` | Execute | High | https://policylayer.com/tools/allensandiego-postgres-mcp-server/run-query.md |
| `run_write_query` | Execute | High | https://policylayer.com/tools/allensandiego-postgres-mcp-server/run-write-query.md |
| `describe_table` | Read | Low | https://policylayer.com/tools/allensandiego-postgres-mcp-server/describe-table.md |
| `list_databases` | Read | Low | https://policylayer.com/tools/allensandiego-postgres-mcp-server/list-databases.md |
| `list_permissions` | Read | Low | https://policylayer.com/tools/allensandiego-postgres-mcp-server/list-permissions.md |
| `list_roles` | Read | Low | https://policylayer.com/tools/allensandiego-postgres-mcp-server/list-roles.md |
| `list_tables` | Read | Low | https://policylayer.com/tools/allensandiego-postgres-mcp-server/list-tables.md |
| `set_role` | Write | Medium | https://policylayer.com/tools/allensandiego-postgres-mcp-server/set-role.md |

## Tool descriptions

- `run_query` — Execute a read-only SELECT query and return structured rows (FR-003)
- `run_write_query` — Execute INSERT/UPDATE/DELETE/DDL statements when write mode is enabled (FR-006)
- `describe_table` — Detail the columns, types, and primary keys of a specific table (FR-002)
- `list_databases` — Discover databases visible/connectable to the connected user (FR-002a)
- `list_permissions` — Discover privileges granted to roles on schemas, tables, and columns (FR-002c)
- `list_roles` — Discover roles/users and their attributes and memberships (FR-002b)
- `list_tables` — Discover schemas and their tables/columns without writing a query (FR-002)
- `set_role` — Set active PostgreSQL role/user for the session (SET ROLE) or reset to default (RESET ROLE)

## Related servers

- UnClick (1662 tools) — https://policylayer.com/tools/io-github-malamutemayhem-unclick-mcp-server.md
- Delx Mcp A2a (1082 tools) — https://policylayer.com/tools/io-github-davidmosiah-delx-mcp-a2a.md
- Delx Protocol — Agent Recovery & Continuity (1076 tools) — https://policylayer.com/tools/io-github-davidmosiah-delx-protocol.md
- Nodebench (824 tools) — https://policylayer.com/tools/io-github-homenshum-nodebench.md
- MCP Framework Personal (811 tools) — https://policylayer.com/tools/inggerman-mcps.md
- Delx MCP Server (740 tools) — https://policylayer.com/tools/io-github-davidmosiah-delx-mcp-server.md
- Binance MCP Server (734 tools) — https://policylayer.com/tools/nirholas-binance-mcp.md
- Crawlora (728 tools) — https://policylayer.com/tools/crawlora-mcp.md

## For agents

This record is a snapshot. Live verdicts and the full registry:

- Check every server in your MCP config at once: `npx -y policylayer stack`
- Vet a server before you add it: install the mcp-precheck skill — `npx skills add https://policylayer.com` (skill text: https://policylayer.com/skill.md)
- Query the registry over MCP: endpoint `https://api.policylayer.com/mcp` — tools `check_mcp_server`, `check_mcp_stack`, `check_tool`, `search_registry`, `get_change_events`

---

Source: the PolicyLayer MCP registry — one continuously verified record per MCP server. Full record: https://policylayer.com/registry?q=allensandiego-postgres-mcp-server · API: https://policylayer.com/registry/api · Recommended policies for every tool: https://policylayer.com/policies/allensandiego-postgres-mcp-server