pg_graphql is a PostgreSQL extension that enables querying the database with GraphQL using a single a SQL function. The extension reflects a GraphQL schema from the existing SQL schema and exposes it through a SQL function, graphql. resolve(...). This enables any programming language that can connect to PostgreSQL to query the database via GraphQL with no additional servers, processes, or libraries. Each table receives an entry point in the top-level Query type that is a pageable collection with relationships defined by its foreign keys. Tables similarly receive entry points in the Mutation type that enable bulk operations for insert, update, and delete.

Features

  • Translates into a GraphQL schema
  • The SQL schema
  • pg_graphql reflects a GraphQL schema from the existing SQL schema
  • pg_graphql adds GraphQL support to your PostgreSQL database
  • The extension keeps schema translation and query resolution neatly contained on your database server
  • Each table receives an entrypoint in the top level Query type that is a pageable collection with relationships defined by its foreign keys

Project Samples

Project Activity

See All Activity >

License

Apache License V2.0

Follow pg_graphql

pg_graphql Web Site

Other Useful Business Software
Full-stack observability with actually useful AI | Grafana Cloud Icon
Full-stack observability with actually useful AI | Grafana Cloud

Our generous forever free tier includes the full platform, including the AI Assistant, for 3 users with 10k metrics, 50GB logs, and 50GB traces.

Built on open standards like Prometheus and OpenTelemetry, Grafana Cloud includes Kubernetes Monitoring, Application Observability, Incident Response, plus the AI-powered Grafana Assistant. Get started with our generous free tier today.
Create free account
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of pg_graphql!

Additional Project Details

Programming Language

Rust

Related Categories

Rust Software Development Software

Registered

2023-03-01