PostGraphile Alternatives for Self-Hosted

Hasura is a software development tool that lets you build real-time GraphQL APIs for a PostgreSQL database. The software is free and open source, while enterprise features are provided at a cost. Hasura is perfect for building GraphQL powered microservices and 3factor applications.

Prisma is a free and open source modern database access layer for TypeScript and Node.js. The software aims to make database access easier with an auto-generated and type-safe query builder that's tailored to your database schema. Prisma is a new take on the traditional ORMs and SQL query builders found in many frameworks and development solutions today. By providing a single access layer that works across databases and technologies Prisma creates what they believe to be the feature of database access and management. Prisma ships with the Prisma Client, a tool that makes it easy to reason about your database queries, so that you can focus on your data and application rather than complex SQL queries or ORM models. With Prisma you can create your own GraphQL or REST API that can access different types of databases including PostgreSQL, MongoDB and MySQL.

Strapi is a free and open source headless CMS developed with JavaScript for Node.js. The software makes it really simple to generate REST and GraphQL APIs. Simply create your database schema and relationships in the Strapi admin panel UI, and Strapi will auto-generate API endpoints to represent the data structures provided. Strapi comes packed with features you come to expect from normal CMS's such as authentication, authorization, content management and a media library. The software can be used for free and can be self-hosted on any server and platform. Extra enterpise functionallity is currently being developed, and will be sold at cost.

PostgREST is a standalone web server and development tool that automatically turns your PostgreSQL database into a RESTful API.

Squidex is 100% open source headless CMS, built by passionated developers. With Squidex both individuals and organizations can handle content for the new web with ease. Squidex modular platform allows users to create content APIs that can be consumed by any frontend framework or technology in a matter of minutes. The framework itself can also be extended and tweaked to suite individual use-cases. Squidex is provided as a fully open source software released and free of charge, for the self-hosted community edition. For organizations that want to get up and running fast, commercially hosted solutions are provided.

Supabase is a free and open-source self-hosted and SaaS provided alternative to Firebase. With Supabase you can add a realtime REST API to a PostgreSQL without writing a single line of code.