Get instant support on our discord server
How Hasura GraphQL engine works¶
Table of contents
Given a Postgres database, Hasura GraphQL engine can automatically generate a GraphQL schema and process GraphQL queries, subscriptions and mutations. Here’s what Hasura GraphQL engine does under the hood.
Schema generation¶
Hasura GraphQL engine automatically generates GraphQL schema components when you track a Postgres table/view in Hasura and create relationships between them.
Tables¶
When you track a Postgres table in Hasura GraphQL engine, it automatically generates the following for it:
- A GraphQL type definition for the table
- A Query field with
where,order_by,limitandoffsetarguments - A Subscription field with
where,order_by,limitandoffsetarguments - An Insert mutation field with
on_conflictargument that supports upsert and bulk inserts - An Update mutation field with
whereargument that supports bulk updates - A Delete mutation field with
whereargument that supports bulk deletes
Views¶
When you track a Postgres view in Hasura GraphQL engine, it automatically generates the following for it:
- A GraphQL type definition for the view
- A Query field with
where,order_by,limitandoffsetarguments - A Subscription field with
where,order_by,limitandoffsetarguments
Essentially Hasura GraphQL engine does the same thing it would do for a table, but without creating the insert, update and delete mutations.
Relationships¶
When you create a relationship between a table/view with another table/view in Hasura GraphQL engine, it does the following:
- Augments the type of the table/view by adding a reference to the nested type to allow fetching nested objects.
- Augments the
whereandorder_byclauses to allow filtering and sorting based on nested objects.
Resolvers¶
Hasura GraphQL engine does not have any resolvers. The Hasura GraphQL engine is actually a compiler that compiles your GraphQL query into an SQL query.
Hasura’s GraphQL syntax is also optimized to expose the power of the underlying SQL so that you can make powerful queries via GraphQL.
Metadata¶
All the information required for schema generation is stored by Hasura GraphQL engine as metadata in a specific Postgres schema in the database. See metadata schema for more details.
