prest/prest

Health v2 · maintenance only

Adoption not part of the score

4611 stars · 317 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

pRESTd is a production-ready Go service that exposes instant REST APIs (and a read-only MCP endpoint) on top of any existing or new PostgreSQL database, with CRUD, custom SQL routes, auth, and ACL without writing a backend. It is self-hosted, available via Docker, Homebrew, or Go, and works with Postgres 9.5+ including TimescaleDB.

Use cases

• expose a postgres database as a rest api
• generate crud endpoints for an existing postgres database
• build a backend without writing code
• add jwt auth and acl to database apis
• connect claude or cursor to a postgres database via mcp
• create custom sql query routes over http
• prototype a microservice backed by postgres

When to choose

• you have a Postgres database and need a REST API immediately without hand-writing a backend
• you want low-code CRUD plus custom SQL routes with built-in auth and ACL
• you want to expose your database to AI clients via a read-only MCP endpoint
• you need a self-hosted, high-performance API layer over Postgres or TimescaleDB

When to avoid

• you need complex business logic beyond SQL queries and ACL rules in the API layer
• your database is not PostgreSQL
• you need a fully custom backend with non-database integrations and workflows
• you require write access via MCP, since the MCP endpoint is read-only

Facets

service · maturity stable

api-framework http-server auth database mcp routing backend databases apis web-development self-hosted developer-tools windows self-hosted go cli postgresql rest-api crud instant-api baas low-code jwt openapi timescaledb mcp-server linux macos docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="prest/prest")