graphile/postgraphile
Postgraphile
PostGraphile is an automated tool that converts a PostgreSQL database schema into a fully functional GraphQL API. It serves as a GraphQL execution engine and schema orchestrator, utilizing database schema introspection to retrieve strongly typed metadata directly from PostgreSQL.
The project features a modular system for composing and standardizing GraphQL schemas through plugins, which manage naming conventions and connections. It includes a PostgreSQL query builder that constructs dynamic, SQL-injection-proof queries using tagged template literals.
The system employs a declarative query planning engine to optimize request processing and reduce server load. Additionally, it provides a mechanism to export dynamically generated in-memory schemas into standalone JavaScript source code.
Features
- GraphQL API Generators - Automatically derives full GraphQL schemas and resolvers directly from existing PostgreSQL database structures.
- PostgreSQL Integrations - Provides a standardized and type-safe query interface for connecting applications to PostgreSQL databases.
- Database Schema Introspection Tools - Analyzes PostgreSQL database structures to automatically derive the API layer and strongly typed metadata.
- Schema Introspection - Retrieves strongly typed details of database fields by introspecting the PostgreSQL schema.
- Query Planning - Implements a declarative planning engine that optimizes database access by constructing abstract execution plans for GraphQL requests.
- Schema Introspection Tools - Analyzes PostgreSQL database structures to automatically generate the API layer and queryable GraphQL schema.
- Query Execution Engines - Implements a declarative query execution engine that optimizes business logic and reduces server load.
- GraphQL Schema Management - Provides a modular system for merging and maintaining GraphQL schema definitions through a plugin architecture.
- Catalog Introspection - Retrieves strongly typed database field details by querying official PostgreSQL system catalogs.
- Dynamic SQL Generators - Builds dynamic, SQL-injection-proof database queries using tagged template literals to handle complex data requirements.
- Logical Plan Lowering - Optimizes GraphQL request processing through a declarative planning engine to reduce server load.
- SQL Injection Prevention Tools - Produces SQL-injection-proof queries by parsing tagged template literals into structured objects at runtime.
- SQL Query Builders - Constructs dynamic and SQL-injection-proof database queries using tagged template literals.
- API Generation - Generates GraphQL APIs directly from existing PostgreSQL databases.
- Data Utilities - Instant GraphQL API generator.
- Database GraphQL Tools - High-performance GraphQL API layer for PostgreSQL.
