agentskillexchange Expose Postgres safely to agents with pREST MCP
Run pREST in front of existing Postgres databases to provide instant REST APIs and a read-only MCP endpoint with auth, ACL, custom SQL routes, and multi-database support.
Prerequisites
pRESTd; PostgreSQL 9.5+; database connection configuration; optional Docker, Homebrew, or Go install path; MCP-capable AI client
Installation
Use the upstream install or setup path that matches your environment:
- make test-unit
- make test-integration-postgres
- make test-integration-timescaledb
- docker compose -f integration/postgres/docker-compose.yml up -d --wait \
Requirements and caveats from upstream:
- | Get pREST (Docker, Homebrew, Go) | Get pREST |
- Run integration suites inside Docker (no local Postgres required):
- Or with Docker Compose:
Basic usage or getting-started notes:
http
GET /{database}/{schema}/{table}
See Configuring pREST for auth, ACL, custom queries, and MCP.
Source: https://github.com/prest/prest
Extracted from upstream docs: https://raw.githubusercontent.com/prest/prest/HEAD/README.md