PostGraphile logo

PostGraphile

Instant GraphQL API for your PostgreSQL database; use standalone or as a Node.js middleware; MIT-licensed OSS
77
182
+ 1
43

What is PostGraphile?

Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database
PostGraphile is a tool in the Query Languages category of a tech stack.
PostGraphile is an open source tool with 10.9K GitHub stars and 506 GitHub forks. Here’s a link to PostGraphile's open source repository on GitHub

Who uses PostGraphile?

Companies
17 companies reportedly use PostGraphile in their tech stacks, including Fielda, Booking, and HearMe.

Developers
59 developers on StackShare have stated that they use PostGraphile.

PostGraphile Integrations

Node.js, PostgreSQL, GraphQL, ExpressJS, and Apollo are some of the popular tools that integrate with PostGraphile. Here's a list of all 11 tools that integrate with PostGraphile.
Pros of PostGraphile
10
Postgres based authentication
6
Great developer support
5
Database first with no braking changes
5
Lightning fast
4
Simple to set up and scale
4
Bye bye Resolvers
2
Instant production ready GraphQL
2
Back to database first
2
Easy setup of relationships and permissions
2
9 Automatically generates your GraphQL schema
1
Works with new and existing databases

PostGraphile's Features

  • instant GraphQL schema via reflection over PostgreSQL database API
  • compiles complex GraphQL queries into very few SQL statements resulting in high performance
  • built entirely from plugins - heavily customisable
  • support for PostgreSQL RBAC and RLS
  • watch mode (monitors for database schema changes) for great DX
  • standalone server, express middleware, or GraphQL schema
  • integration with Express auth via pgSettings (e.g. Passport.js, optional)
  • JWT auth (optional)
  • very strong support for PostgreSQL functions
  • simple to set up and scale

PostGraphile Alternatives & Comparisons

What are some alternatives to PostGraphile?
Prisma
Prisma is an open-source database toolkit. It replaces traditional ORMs and makes database access easy with an auto-generated query builder for TypeScript & Node.js.
Hasura
An open source GraphQL engine that deploys instant, realtime GraphQL APIs on any Postgres database.
GraphQL
GraphQL is a data query language and runtime designed and used at Facebook to request and deliver data to mobile and web apps since 2012.
PostgreSQL
PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
TypeORM
It supports both Active Record and Data Mapper patterns, unlike all other JavaScript ORMs currently in existence, which means you can write high quality, loosely coupled, scalable, maintainable applications the most productive way.
See all alternatives

PostGraphile's Followers
182 developers follow PostGraphile to keep up with related blogs and decisions.