# PostgREST

Standalone web server that serves a RESTful API directly from a PostgreSQL database schema.


Source: https://findsoftware.frbit.cloud/postgrest/
Last reviewed: 2026-11-03
Listed since: 2026-11-03

## Record

### Links

- home: https://docs.postgrest.org/
- repository: https://github.com/PostgREST/postgrest
- docs: https://docs.postgrest.org/
- forum: https://github.com/PostgREST/postgrest/discussions

### Identity

- status: active
- maintainer: The PostgREST contributors
- maintainerType: community
- parent: unknown
- firstRelease: 2014
- hqCountry: unknown

### Kind

- category: backend
- hosting: binary
- language: haskell
- runtime: binary
- runtimeMin: unknown
- basedOn: unknown

### Content

- contentStore: unknown
- databases: postgres
- adminUi: unknown
- headlessApi: rest
- templating: unknown
- i18n: unknown

### Rendering and deploy

- runsAs: always-on
- renderingModes: unknown
- installMethod: binary-download

### License

- licenseModel: open-source
- license: MIT

### Releases

- currentMajor: 16
- latestReleaseDate: 2026-10-20

### Adoption

- githubStargazers: 27739
- packagistDownloads: not applicable
- npmWeeklyDownloads: not applicable
- contributors: 228
- pluginCount: unknown
- packagistMonthlyDownloads: unknown
- ecosystemsMonthlyDownloads: unknown
- httpArchiveSites: unknown
- wordpressActiveInstalls: unknown
- dependentRepos: unknown
- dependentPackages: unknown

### Sources

- urls: https://docs.postgrest.org/ (read 2026-11-03)
- urls: https://docs.postgrest.org/ (read 2026-11-03)
- urls: https://github.com/PostgREST/postgrest (read 2026-11-03)
- category: https://docs.postgrest.org/ (read 2026-11-03)
- maintainer: https://github.com/PostgREST/postgrest/blob/main/LICENSE (read 2026-11-03)
- maintainerType: https://github.com/PostgREST/postgrest/blob/main/LICENSE (read 2026-11-03)
- firstRelease: https://github.com/PostgREST/postgrest (read 2026-11-03)
- language: https://github.com/PostgREST/postgrest (read 2026-11-03)
- runtime: https://docs.postgrest.org/en/stable/explanations/install.html (read 2026-11-03)
- license: https://github.com/PostgREST/postgrest (read 2026-11-03)
- currentMajor: https://github.com/PostgREST/postgrest/releases (read 2026-11-03)
- latestReleaseDate: https://github.com/PostgREST/postgrest/releases (read 2026-11-03)
- installMethod: https://docs.postgrest.org/en/stable/explanations/install.html (read 2026-11-03)
- installMethod: https://docs.postgrest.org/en/stable/explanations/install.html (read 2026-11-03)
- installMethod: https://docs.postgrest.org/en/stable/explanations/install.html (read 2026-11-03)
- installMethod: https://docs.postgrest.org/en/stable/explanations/install.html (read 2026-11-03)
- installMethod: https://docs.postgrest.org/en/stable/explanations/install.html (read 2026-11-03)
- installMethod: https://docs.postgrest.org/en/stable/explanations/install.html (read 2026-11-03)
- installMethod: https://docs.postgrest.org/en/stable/explanations/install.html (read 2026-11-03)
- installMethod: https://docs.postgrest.org/en/stable/explanations/install.html (read 2026-11-03)
- runsAs: https://docs.postgrest.org/en/stable/integrations/systemd.html (read 2026-11-03)
- databases: https://docs.postgrest.org/ (read 2026-11-03)
- headlessApi: https://docs.postgrest.org/ (read 2026-11-03)
- githubStargazers: https://github.com/PostgREST/postgrest (read 2026-11-03)
- contributors: https://github.com/PostgREST/postgrest (read 2026-11-03)

## Notes

PostgREST is a standalone web server that serves a RESTful API directly from a PostgreSQL database, so the endpoints and their permissions follow the database schema and its roles. It is written in Haskell and ships as a compiled binary, as a Docker image and through several operating system package managers. A configuration file names the database connection, and the project's [systemd guide](https://docs.postgrest.org/en/stable/integrations/systemd.html) runs it as a daemon. Requests authenticate with JSON Web Tokens, and the anonymous, authenticator and user roles in the database decide what each request may do. The external-auth guide names Auth0 as a service that can issue those tokens.

## Worth knowing

The API takes its shape from the schema, so a change to a table, view or permission changes what clients can call. The install guide lists the PostgreSQL versions it supports.

---

Data licensed CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Attributes are recorded, never scored; absent means unknown.
Credit, in full: FindSoftware, CC BY 4.0