Postgraphile
Automatically generates a secure, extensible GraphQL API from your PostgreSQL schema in seconds, eliminating the need for custom backend development.
Postgraphile is an open-source alternative to:
PostGraphile
PostGraphile is a lightning-fast tool that instantly generates a powerful, extensible GraphQL API directly from your PostgreSQL database schema. By leveraging PostgreSQL's built-in features like role-based access control and row-level security, it provides a secure and performant data layer for your applications without the overhead of writing custom backend code.
Key Features
- Instant API Generation: Automatically creates a GraphQL API from your PostgreSQL schema in seconds
- Security Integration: Uses PostgreSQL's native role-based access control and row-level security policies
- Extensible Architecture: Supports plugins and smart tags for customizing the generated API
- Real-time Capabilities: Enables real-time updates through PostgreSQL's native features
- Performance Optimized: Built with Graphile Engine's advanced GraphQL look-ahead and plugin expansion technologies
- Flexible Deployment: Can be run as a standalone server, library, or deployed on platforms like Heroku, AWS Lambda, and Docker
- JWT Authentication: Supports JSON Web Token authentication out of the box
- Schema Customization: Allows fine-tuning of the GraphQL schema through smart tags and plugins
Tech / Self-Hosting
PostGraphile is a self-hosted solution that requires a PostgreSQL database. It can be deployed on any platform that supports Node.js applications, including:
- Standalone server
- Docker containers
- Cloud platforms (Heroku, AWS Lambda, GCP)
- As a library within your existing application
The tool is open source (MIT licensed) and actively maintained by the Graphile team. For production use, consider the PostGraphile Pro version which offers additional features and support.