prest/prest

Docker: docker build -t prest/prest:latest . (or use released images)
Homebrew: brew install prestd
Go: go install / Go Reference at pkg.go.dev/github.com/prest/prest/v2
1-click Heroku deploy via prest-heroku template

Usage

• •Point pREST at Postgres via PREST_PG_URL (or pg.* / DATABASE_URL), then call GET /{database}/{schema}/{table}
• •PostgreSQL version 9.5 or higher required
• •Connect AI clients (Cursor, Claude, etc.) to the read-only MCP endpoint for MCP over HTTP
• •Configure auth, ACL, custom queries, and MCP via docs.prestd.com

Key features

• ✓Instant REST API (CRUD) over Postgres tables/views without writing backend code
• ✓Read-only MCP endpoint exposing the database to AI clients via MCP over HTTP
• ✓Custom SQL routes, auth, and ACL support
• ✓Multi-database support; TimescaleDB integration tests; Go-single-binary distribution
• ✓Production-ready with unit and integration test suites

Best for

Exposing a Postgres database to AI agents (read-only MCP) plus a full REST API, instantly, without a bespoke backend.

Caveats

• ⚠Requires PostgreSQL 9.5 or higher
• ⚠MCP endpoint is read-only
• ⚠Documentation lives at docs.prestd.com (not in the README)