PostGraphile
postgraphile.org
- Free plan
- Web
- API
- Self-hosted
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.
Plans
Every plan and pricePostGraphile V4 Core
PostGraphile Pro License Only
Production Sponsor
Private Advisor Tier
Free plan
Getting started
- Open the PostGraphile homepage
- Install or run the provided npx pgl command
- Supply a PostgreSQL connection string
- Deploy the service in your self-hosted environment
- 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.