Brenelz Web Solutions

Brenley Dueck


Hasura GraphQL FTW

July 08, 2020

Have you been wanting to dive into GraphQL but haven't found the right tool?

I think I would use Hasura for rapid GraphQL development.

Hasura basically sits on top of a relational database (Postgres) which is a big plus. I tend to favour relational databases over nosql ones. I also hear MySQL support is coming soon.

So we've just talked about a database whats the the big deal anyways. Well Hasura gives you an automatic GraphQL server to query your database. Some benefits of this are easy queries for related tables, and the ability to only choose the columns you absolutely need.

Also all the resources I looked at for GraphQL required you to kind of write your own resolvers which just seemed like too big of a hassle.

An example query would be something like:

query {
  user {
    bookings {

Get Started

The first step is to get a Postgres database and the hasura/graphql-engine setup. The easiest way to do this is on Heroku by hitting the Deploy to Heroku button.

I've basically just toyed around with it. I'm not totally sure how things would scale on Heroku for a large app but I guess thats a problem to solve at a later time.

Env Variables

I wish there was some clearer docs about what to all setup when you start, but you will want to add the following variables to Heroku.


It took me awhile to figure out how to have an unauthorized role which is something you definitely will want before you start querying your admin. At first I was just using the admin secret but that is not secure. You will want to lock things down.

Hasura Console

Once you have this setup on heroku you will see a dashboard something like this:

Hasura Console

From here you can click on "Data" and start creating your tables. It is pretty great interface as I picked it up fairly easily. One thing to remember is to setup your foreign keys, and also setup the associated relationships for your tables.

Once the above is done you can use the GraphiQL interface to play around and query your data.

Pain Points

My biggest pain point in actually putting a Hasura instance into action is authorization. Having user specific permissions is easy to define on a per table basis, but to set it up in your app is clunky.

I know authorization is not an easy thing, so makes sense its tricky to setup. It seems like the current approach is to use something like Auth0 and hook it into Hasura.


Hasura seems super cool, and it allowed me to get up and running productive quickly. No backend api to worry about as I could just start coding the frontend in React and have Hasura be the backend.

I'm sure this breaks down when you start doing more complicated things but worth tinkering around with.


Hasura Quickstart
Hasura Basics
Hasura - Authentication using JWT
Scott Tries Hasura - A Realtime GraphQL API Builder
User auth and roles with Hasura

Thoughts? Hit me up on twitter @brenelz