Postgres & Compatible Databases
Hasura enables connecting to a Postgres and Postgres compatible databases to automatically build an rich GraphQL API based on the schema.
Hasura GraphQL Engine supports all supported versions of Postgres per the public documentation.
Hasura supports most databases with full Postgres compatibility such as:
AWS RDS Aurora Postgres
AWS RDS Postgres
Digital Ocean Postgres
Google Cloud SQL Postgres
Curious about any other Postgres flavors? Any other questions? Ask us on GitHub discussions
Managing data with the Hasura Console
The Hasura Console is a web UI that allows you to manage your data and metadata. It is available at
http://localhost:8080/console when you run Hasura locally, or from your project's Console endpoint when you use
The data-management features (such as creating tables) are available in the
Data tab. You can access your GraphQL API
API tab and interact with it using the GraphiQL interface.
You can use these tools to manage your PostgreSQL database, but we recommend using your preferred PostgreSQL client instead. The Hasura Console is designed to be a tool for managing your GraphQL API, and not a full-fledged database management tool.
Required user role permissions
Below are the role permissions required for Hasura to perform all its functionality. Note that, with the exception of
GRANT USAGE, the other features are opt-in, and not enabling them will simply mean that only the
corresponding Hasura features will not work.
CONNECTis required in order for Hasura to connect to your Postgres data source.
- You must
GRANT USAGEto the Hasura user role for any schema you want to access via Hasura.
- To allow queries and subscriptions via the GraphQL API,
SELECTpermissions are required.
DELETEpermissions are required for mutations.
- The Hasura Console requires permissions such as
CREATEto make changes to your schema.
TRIGGERis required to use Event Triggers
- If you want to use computed fields or user-defined Postgres functions, the
EXECUTEpermission is required.
If you're interested in learning more about PostgreSQL, check out this tutorial from our Learn site.