postgrest

PostgREST is a server application that offers RESTful API directly from any existing PostgreSQL database. Developed with Haskell, JSON delivers a standard-compliant architecture by handing over operations such as serialization and authorization to the database. It performs the authentication process through JSON Web Tokens (JWT) and generates documents using the OpenAPI standard.

PO

PostgREST · Databases & Vector Infrastructure

STARS27.7K
FORKS1.2K
COMMITS6.1K
CONTRIBUTORS228
VERSIONv16.3
UPDATEDtoday
HaskellPostgreSQLREST APIOpenAPIMIT

Common commercial products in this category: Oracle Database, Microsoft SQL Server, Amazon Aurora

What can it do?
  • From any PostgreSQL database, you offer a RESTful API entirely.
  • You manage authentication using JSON Web Tokens.
  • You make API version through database schemas.
User reviews
  • • NeutralHacker News

    PostgREST

    “> > And if you treat the database as the source of truth for managing data, then the idea of making it an application engine would be anathema. > Why? Could you elaborate more on that? Sure. Your previous declaration of: > We argue that all "business logic" is in fact "data…”

  • ↑ PositiveHacker News

    PostgREST

    “I see what you mean. This is the view that considers that the database should only be a Persistence Layer and not a Processing Engine. There is a great talk[1] that @felixyz shared regarding the shortcomings of the Persistence Layer approach and the advantages of Processing…”

Verified against README · Oct 26, 2026 · source

My note

Alternative pages

More in: Databases & Vector Infrastructure