Icon
Join us for the fourth annual Hasura User Conference on June 20-22. Register now  >

Instant REST API for PostgreSQL

Hasura connects to PostgreSQL database and gives Instant REST APIs
Instant REST API for PostgreSQL

Powerful queries out-of-the-box

GET Data (Query)

GET Data (Query)

Query across tables & views with powerful filtering, pagination and pattern search.
Read More
POST Data (Query or Insert)

POST Data (Query or Insert)

Insert single or multiple objects. Make upsert operations on conflict to simplify app logic.
Read More
PUT Data (Update)

PUT Data (Update)

Update objects based on a condition. Update to Increment/multiply directly.
Read More
DELETE Data (Delete)

DELETE Data (Delete)

Delete one object or in bulk based on a condition.
Read More
Query
Remove old product tags & insert new tags
Query
Fetch first 5 brands with top 10 products for each

Trigger webhooks on database events

  • Hasura captures changes to PostgreSQL tables and triggers webhooks
  • Atomic capture, reliable delivery, horizontally scalable.

Add to an existing, live postgres database

Add Hasura to any existing postgres database as-is and expose select tables & views over REST.

We took Gitlab CE (a complex rails + postgres application), hosted it on DigitalOcean and added REST to it in just a few minutes. Check out the demo on the left!
HasuraView docs to connect an existing databaseBrowse
githublogoView on Github

Rails like Database migrations for PostgreSQL

  • Using Hasura Console in migration mode, the database migration files are automatically created.
  • up/down migrations for going back and forth and reverting changes.

Optimise PostgreSQL performance using explain

Hasura supports PostgreSQL read replicas that can be used automatically to load-balance your REST API queries.
Optimise PostgreSQL
Manage PostgreSQL

Manage PostgreSQL data with Hasura Console

  • Hasura comes with a Console admin UI that can be used to manage the database schema and adding/modifying records.
  • The UI can also be used with CLI to manage database migrations automatically.
Manage PostgreSQL

PostgreSQL flavors and extensions that work with Hasura

Hasura works natively with different PostgreSQL flavors and extensions
TimescaleDBTimescaleDB - Timeseries Database
YugabyteDBYugabyteDB - Distributed
Aurora PostgreSQLAurora PostgreSQL - Serverless
PostGISPostGIS - Geo PostgreSQL Extension

Join the community!

If you need any help with developing on Hasura, the 6000+ member strong Hasura Discord is here to help. Our community members include some very experienced engineers from some of the world’s most exciting companies, and many of them have been using Hasura in Production for a long time.
Hasura icon