# pg\_graphql: A GraphQL extension for PostgreSQL

DevFeed: [pg\_graphql: A GraphQL extension for PostgreSQL](<https://devfeed.tech/articles/pg-graphql-a-graphql-extension-for-postgresql-480.md>)

Original publisher: [Read original article](<https://supabase.com/blog/pg-graphql>)

Author: Oliver Rice

Published: 2021-12-03T07:00:00Z

Content type: article

Language: en

Sources: [Supabase Blog](<https://devfeed.tech/sources/supabase-blog.md>)

Topics: [GraphQL](<https://devfeed.tech/topics/graphql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Extension](<https://devfeed.tech/topics/extension.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Parsing](<https://devfeed.tech/topics/parsing.md>), [Supabase](<https://devfeed.tech/topics/supabase.md>), [JSON](<https://devfeed.tech/topics/json.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [C](<https://devfeed.tech/topics/c.md>), [Remote Procedure Call (RPC)](<https://devfeed.tech/topics/rpc.md>), [Security](<https://devfeed.tech/topics/security.md>)

Tags: [c](<https://devfeed.tech/tags/c.md>), [development](<https://devfeed.tech/tags/development.md>), [extension](<https://devfeed.tech/tags/extension.md>), [graphql](<https://devfeed.tech/tags/graphql.md>), [json](<https://devfeed.tech/tags/json.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [parsing](<https://devfeed.tech/tags/parsing.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [rpc](<https://devfeed.tech/tags/rpc.md>), [security](<https://devfeed.tech/tags/security.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This article introduces pg_graphql, an open-source native PostgreSQL extension that adds GraphQL support directly to the database. It generates and reflects a GraphQL schema from an existing PostgreSQL schema, parses and resolves GraphQL queries as SQL, and returns requested data as JSON while avoiding external services and the N+1 query problem.

## Source excerpt

GraphQL support is in development for PostgreSQL + Supabase.