pREST (prest/prest) provides instant REST and MCP APIs on top of Postgres databases, with multi-database support, auth, ACL, and custom SQL routes. It is written in Go, MIT licensed, and active as of 2026-07-28.
Collecting history — the radar snapshots this repo daily. The trend line appears after 3 days of data (2 so far).
What it is
pRESTd delivers REST and Model Context Protocol (MCP) APIs on top of PostgreSQL databases, enabling CRUD operations, custom SQL routes, authentication, ACL, and a read-only MCP endpoint without writing backend code. It supports existing or new Postgres databases and offers multi-database capabilities.
How it works
The project exposes REST endpoints by querying a Postgres instance. Users configure authentication, ACLs, and custom queries via configuration. It also provides MCP over HTTP. The repository indicates support for multiple databases and integration with various environments (Docker, Homebrew, Go).
Getting started
Install and run options are documented in the docs site. Typical usage involves pointing pREST at a Postgres URL via PREST_PG_URL / DATABASE_URL and issuing HTTP GET requests like:
GET /{database}/{schema}/{table}
For configuration details, see the documentation at the linked pages in the README:
- Get pREST
- Configuring pREST
- MCP over HTTP
Recent releases
Latest releases (latest 5):
- v2.4.0 (2026-07-27) with fix: six SQL-injection-adjacent security gaps found via advisory review (#1014)
- v2.3.0 (2026-07-22) with fix unauthenticated SQL injection in
_select, migrate JWKS to jwx v3, add integration-log tooling (#1002) - v2.2.0 (2026-07-18) update Dockerfile and GoReleaser configuration (#998); upgrade Postgres v
- v2.1.0 (2026-07-09) feat: Native MCP support over HTTP (#977)
- v2.0.0 (2026-07-08) feat: add support for multiple DBs (#973); feat: configuration resilience and error handling
Traction
Stars: 4602 (as of last update). Forks: 310. Open issues: 145.
Behind the repo
Not applicable in this entry (no linked startup/company in the provided data).
Caveats
License: MIT. Created 2016-11-22. Last push: 2026-07-28. Languages: Go. Open issues: 145.