awesome-repositories.com
Blog
MCP
awesome-repositories.com

Discover the best open-source repositories with AI-powered search.

ExploreCurated searchesOpen-source alternativesSelf-hosted softwareBlogSitemap
ProjectMCP serverAboutHow we rankPress
LegalPrivacyTerms
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com
graphile avatar

graphile/postgraphile

0
View on GitHub↗
graphile.org↗

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.

AI search

Explore more awesome repositories

Describe what you need in plain English — the AI ranks thousands of curated open-source projects by relevance.

Start searching with AI

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.
12,929 stars·621 forks·TypeScript·MIT·33 views

Star history

Star history chart for graphile/postgraphileStar history chart for graphile/postgraphile

How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.

Frequently asked questions

What does graphile/postgraphile do?

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.

What are the main features of graphile/postgraphile?

The main features of graphile/postgraphile are: GraphQL API Generators, PostgreSQL Integrations, Database Schema Introspection Tools, Schema Introspection, Query Planning, Schema Introspection Tools, Query Execution Engines, GraphQL Schema Management.

Which projects share features with graphile/postgraphile?

Projects with overlapping indexed features include: hasura/graphql-engine — graphql-engine is an automated GraphQL API engine that transforms database tables and relationships into a queryable… graphql-go/graphql — This project is a GraphQL implementation for Go, providing a complete suite for building GraphQL servers. It includes… seaql/sea-orm — Sea-ORM is an asynchronous SQL object-relational mapper and database toolkit for mapping relational tables to strongly… prest/prest — PostgREST is a tool that automatically transforms a PostgreSQL database schema into a production-ready RESTful API. It… postgrest/postgrest — PostgREST is a standalone server process that automatically transforms a relational database schema into a fully… graph-gophers/graphql-go — graphql-go is a schema-first GraphQL library and server implementation for Go. It provides a query execution engine…

Projects sharing features with Postgraphile

These projects share indexed features with Postgraphile. Shared tags can include platform or build tooling; verify the primary use case before treating a result as a replacement.
  • hasura/graphql-enginehasura avatar

    hasura/graphql-engine

    32,064View on GitHub↗

    graphql-engine is an automated GraphQL API engine that transforms database tables and relationships into a queryable GraphQL schema. It functions as a federation gateway and mapper, instantly generating APIs with built-in filtering, pagination, and mutations from existing databases and remote schemas. The project distinguishes itself through a fine-grained access control layer that enforces row-level and field-level permissions. It further provides a real-time data subscription server that converts standard queries into live streams and a system for triggering event-driven webhooks and notifi

    TypeScriptaccess-controlapiautomatic-api
    View on GitHub↗32,064
  • graphql-go/graphqlgraphql-go avatar

    graphql-go/graphql

    10,155View on GitHub↗

    This project is a GraphQL implementation for Go, providing a complete suite for building GraphQL servers. It includes a schema engine for defining types, a query parser to convert strings into abstract syntax trees, and an execution engine that resolves fields against a defined schema to return structured data. The library distinguishes itself through reflection-based type mapping, allowing object definitions and arguments to be derived directly from native Go structs. It also supports the execution of real-time data streaming via GraphQL subscriptions and provides an extensible execution pip

    Gographqlgraphql-gosubscriptions
    View on GitHub↗10,155
  • seaql/sea-ormSeaQL avatar

    SeaQL/sea-orm

    9,410View on GitHub↗

    Sea-ORM is an asynchronous SQL object-relational mapper and database toolkit for mapping relational tables to strongly typed objects. It provides a relational database mapper for performing CRUD operations across MySQL, PostgreSQL, and SQLite, and includes a programmatic dynamic query builder for constructing complex SQL statements. The project distinguishes itself by providing a GraphQL schema generator that transforms database entities into typed schemas with built-in pagination and filters. It also features a dedicated database migration tool for defining and applying versioned schema chan

    Rustdatabasehacktoberfestloco
    View on GitHub↗9,410
  • prest/prestprest avatar

    prest/prest

    4,551View on GitHub↗

    PostgREST is a tool that automatically transforms a PostgreSQL database schema into a production-ready RESTful API. It serves as a database access layer and query engine that maps HTTP requests directly to SQL queries, providing a low-code interface for executing create, read, update, and delete operations without requiring manual boilerplate code. The project distinguishes itself by using schema-driven API generation and metadata-based discovery to expose database tables as navigable resources. It extends standard CRUD capabilities through the execution of custom and templated SQL, a plugin-

    Goautomatic-apidatabasedatabases
    View on GitHub↗4,551
Compare all 30 related projects→