Graphql postgres debugging

To easily test queries with GraphQL against PostgreSQL DB schema you can utilize package called postgraphile, which is also installed to admin side as an express middleware (this can be extended to application side later, but testing it on admin for now)

To globally install dependency run: npm i -g postgraphile

To connect your local postgres server run:

postgraphile -c postgres://postgres:postgres@localhost:5432/database --enhance-graphiql

Now you should be able to connect into address http://localhost:5000/graphiql which is a great tool for debugging