# 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.

- Skill: `agentskillexchange/expose-postgres-safely-to-agents-with-prest-mcp` (Agent Skill)
- Install (CLI): `npx skillmds@latest add agentskillexchange/expose-postgres-safely-to-agents-with-prest-mcp`
- Raw SKILL.md: https://api.skillmd.com/api/skills/agentskillexchange/expose-postgres-safely-to-agents-with-prest-mcp/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: agentskillexchange (https://skillmd.com/u/agentskillexchange)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/agentskillexchange/expose-postgres-safely-to-agents-with-prest-mcp

---


# 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](https://docs.prestd.com/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](https://docs.prestd.com/get-started/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

## Documentation

- https://docs.prestd.com/

## Source

- [Agent Skill Exchange](https://agentskillexchange.com/skills/expose-postgres-safely-to-agents-with-prest-mcp/)