Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

PostGraphile

postgraphile.org

  • Free plan
  • Web
  • API
  • Self-hosted
7.4 Club score Visit postgraphile.org

What PostGraphile is

PostGraphile creates extensible GraphQL APIs backed primarily by PostgreSQL, for SaaS backends and internal business tools. It can be self-hosted, and its homepage gives an `npx pgl` command for starting it with a PostgreSQL connection string. Core capabilities include GraphQL queries and mutations, automatic CRUD mutations, filtering, ordering and plugins. Authentication can use JWT or custom pgSettings, with row-level security and role-based access control. V4 Core and Version 5 are open source under the MIT license. Version 5 uses Grafast, a planning and execution engine intended to improve performance and maintainability. PostGraphile Pro adds query-cost, pagination and query-depth limits, along with a facility for scaling through database read replicas. The Pro plugin is for V4 Core; V5 remains open source and under development. Pro License Only costs $25 a month and covers up to four production instances and 100 development instances; larger clusters require custom licensing. The maker says license keys are static and the software does not phone home.

Who it suits

PostGraphile may suit developers building PostgreSQL-backed SaaS APIs or internal business tools. Teams considering Pro should note that its plugin is for V4 Core, not Version 5.

Good to know, and what to watch

  • V4 Core and V5 use the MIT license.
  • Supports row-level security and role-based access control.
  • Pro adds query-cost and depth limits.
  • Pro supports scaling through read replicas.
  • Pro plugin is for V4 Core only.
  • Larger clusters require custom licensing.
  • Automated Pro keys expire after one year.
  • Pro license limits production and development instances.

PostGraphile V4 Core

Free

PostGraphile Pro License Only

$25/mo

Production Sponsor

$100/mo

Private Advisor Tier

$899/mo

Free plan

Getting started

  1. Open the PostGraphile homepage
  2. Install or run the provided npx pgl command
  3. Supply a PostgreSQL connection string
  4. Deploy the service in your self-hosted environment
  5. Select the free V4 Core plan or a paid Pro, sponsor, advisor, or support plan

Limits to check

The free V4 Core plan is free under the MIT license. The Pro License Only plan permits up to four production instances and 100 development instances; larger clusters require custom licensing, and automated keys expire after one year.

The verdict

PostGraphile combines API generation with database-backed access controls and a self-hosted deployment model. Check the V4/V5 distinction and instance limits before selecting the Pro license.

Questions people ask

Is PostGraphile open source?

PostGraphile V4 Core and Version 5 are open source under the MIT license.

How much does PostGraphile cost?

There is a free V4 Core plan. Paid plans start at $25 a month for the Pro License Only plan.

Where can PostGraphile run?

PostGraphile is listed for API, web, and self-hosted use, with JavaScript and TypeScript server languages.

What support is available?

Community support is available through Discord. Sponsors receive maintainer priority there, and Private Advisor sponsors can receive support through company Slack or GitHub organization.

What the maker publishes

Compatibility limit
The Pro plugin is for PostGraphile V4 Core; the page says V5 is open source and continues to be developed. source
Core API features
The pricing comparison lists GraphQL queries and mutations, automatic CRUD mutations, JWT or custom pgSettings authentication, row-level security and role-based access control, filtering, ordering, and plugins. source
Getting started
The homepage gives an `npx pgl` command to start PostGraphile with a PostgreSQL connection string. source
License behavior
The maker says Pro license keys are static and the software does not phone home; automated keys expire after one year. source
License limit
The Pro license permits up to four production instances and 100 development instances; larger clusters require custom licensing. source
Maker
The homepage identifies Graphile Ltd. as the copyright holder. source
Open source
PostGraphile V4 Core and PostGraphile V5 are open source under the MIT license. source
Pro protections
PostGraphile Pro lists integrated query-cost, pagination, and query-depth limits, designed to protect APIs from expensive queries. source
Purpose
PostGraphile creates extensible, high-performance GraphQL APIs backed primarily by PostgreSQL. source
Scaling
PostGraphile Pro includes a facility to scale through database read replicas. source
Support
Community support is available through Discord, sponsors receive maintainer priority support there, and Private Advisor sponsors can receive support through their company Slack or GitHub organization. source
Use cases
The maker describes PostGraphile as suitable for SaaS backend APIs and internal business tools. source
Version 5 engine
PostGraphile Version 5 is built on Grafast, a planning and execution engine intended to improve performance and maintainability. source

Checked against the maker's pages on 7 Oct 2026.