Instant Realtime GraphQL API for PostgreSQL

Hasura connects to Postgres database and gives Instant Realtime GraphQL APIs
Instant Realtime GraphQL API for PostgreSQL

Powerful queries out-of-the-box



Query across tables & views with powerful filtering, pagination and pattern search.
Insert Mutations

Insert Mutations

Insert single or multiple objects. Make upsert operations on conflict to simplify app logic.
Update Mutations

Update Mutations

Update objects based on a condition. Update to Increment/multiply directly.
Delete Mutations

Delete Mutations

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

Realtime with subscriptions & live-queries

Convert any GraphQL query to a live query by using subscriptions.
1) Setup a GraphQL subscription
2) As Postgres data changes...
Orders (postgres table)
3) The UI is updated
Order XX-57 (mobile/web UI)

Trigger webhooks on database events

  • Hasura captures changes to Postgres 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 GraphQL.

We took Gitlab CE (a complex rails + postgres application), hosted it on DigitalOcean and added GraphQL to it in just a few minutes. Check out the demo on the left!

Rails like Database migrations for Postgres

  • 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 Postgres performance using explain

Hasura supports Postgres read replicas that can be used automatically to load-balance your GraphQL queries.
Optimise Postgres
Manage Postgres

Manage Postgres 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 Postgres

Postgres flavors and extensions that work with Hasura

Hasura works natively with different Postgres flavors and extensions

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

Frequently Asked Questions

What versions of Postgres does Hasura support?
v9.5 and above
Can I use multiple Postgres databases with the same Hasura instance?
Yes we can