You should check out PostgREST, a tool to expose Postres tables through a JSON APIs: https://github.com/begriffs/postgrest