An instant REST API over a relational database, generated from the schema itself with no application code to write.
This product is available in the build below. Open it for the operating system, cloud and version detail, or read its deployment guide.
| Product | Cloud | Operating system | Version | |
|---|---|---|---|---|
| PostgREST Instant REST API with PostgreSQL 17 on Ubuntu 24.04 LTS | Azure | Ubuntu 24.04 | 17 | View · Guide |
PostgREST turns a PostgreSQL database directly into a RESTful API. It reads the database schema and serves every table, view and function as a JSON endpoint, so filtering, ordering, pagination and writes all come for free. Authorisation is the database's own role and grant system rather than a separate application layer, and access is carried in signed JSON Web Tokens.
cloudimg ships PostgREST and PostgreSQL together on one hardened, fully patched appliance, wired up and serving a worked example schema the moment it boots. The API is deny by default: unauthenticated callers can reach only a health endpoint, and everything else requires a token signed with a secret unique to that instance. The database superuser password, the API connection password and the token signing secret are all generated on first boot with no default login, every connection is encrypted with a per instance TLS certificate, and 24/7 support is included.