A GraphQL interface for PostgreSQL that automatically generates SQL queries from GraphQL syntax using table introspection.
GraphpostgresQL is a PostgreSQL extension that allows developers to query relational databases using GraphQL syntax. It automatically generates SQL queries by introspecting table structures, foreign keys, and complex data types like JSON and HStore, eliminating the need for a separate GraphQL server layer.
PostgreSQL developers and database administrators who want to expose GraphQL APIs directly from their database without implementing additional middleware or ORM layers.
It provides a native, lightweight way to integrate GraphQL with PostgreSQL, reducing complexity and overhead by leveraging the database's own introspection capabilities and avoiding external dependencies.
GraphQL for Postgres
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Translates GraphQL queries into optimized PostgreSQL SQL, as demonstrated in the README where graphql.to_sql produces complex SQL with lateral joins for foreign key traversal.
Automatically follows foreign key relationships between tables, enabling seamless relational data querying without manual JOIN specifications.
Indexes directly into JSON, JSONB, and HStore columns, allowing GraphQL queries to access nested data without additional processing layers.
Installed via a single SQL schema file without external dependencies or search path alterations, making setup quick and database-integrated.
The README explicitly warns it's 'alpha quality' with no extensive optimization or testing, making it unreliable for production workloads.
Only supports GraphQL queries; mutations, subscriptions, and advanced GraphQL capabilities are not implemented or mentioned in the current version.
Roadmap features like expanded selectors and PL/V8 implementation are planned but not yet available, indicating incomplete development and potential breaking changes.