PostGraphile

PostGraphile builds a GraphQL API directly from a PostgreSQL database. It reads the schema and generates the API, which you can then customise with plugins.

PostGraphile connects to a Postgres database and creates GraphQL types, queries and mutations that match your tables. You can run it with a single npx command to try it quickly, then move to a full project as the API takes shape. The engine, called Grafast, plans database queries efficiently to reduce load. An eject option lets you move the generated code into your own project later. Plugins can extend the schema, and the version 5 configuration system makes it easier to shape the API for your needs. A starter project is also available for full-stack applications.

• Generate a GraphQL API from a PostgreSQL schema
• Extend the schema with custom plugins
• Run with npx for a quick start
• Use the Grafast engine to reduce database load
• Start from Graphile Starter for a full-stack app

Backend developers and full-stack teams that already store their data in PostgreSQL will find it a fast way to get an API. SaaS teams that want a GraphQL layer with custom business logic can also build on it.

The project is open source under the MIT license and is free to use. Paid Pro and support options are available for teams that want more help. Generated APIs expose your database structure, so plan permissions and security rules before you connect it to real data.