Instant Realtime GraphQL for PostgreSQL

Hasura connects to Postgres database and gives Instant Realtime GraphQL APIs
hasura-postgres-img

Powerful queries out-of-the-box

Queries

Queries

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.
Query
Remove old product tags & insert new tags
Query
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
Subscription
2) As Postgres data changes...
Orders (postgres table)
order_idpaymentdispatched
XX-57trueNULL
3) The UI is updated
Order XX-57 (mobile/web UI)
Payment
Delivery...

Trigger webhooks on database events

  • ExpandHasura captures changes to Postgres tables and triggers webhooks
  • ExpandAtomic 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

  • ExpandUsing Hasura Console in migration mode, the database migration files are automatically created.
  • Expandup/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 data with Hasura Console

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

Postgres flavors and extensions that work with Hasura

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

FAQ

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