Gathering detailed insights and metrics for @subql/x-graphile-build-pg
Gathering detailed insights and metrics for @subql/x-graphile-build-pg
Monorepo home of graphile-build, graphile-build-pg, graphile-utils, postgraphile-core and graphql-parse-resolve-info. Build a high-performance easily-extensible GraphQL schema by combining plugins!
Installations
npm install @subql/x-graphile-build-pgDeveloper Guide
BETA
Typescript
Yes
Module System
CommonJS
Min. Node Version
>=8.6
Node Version
14.18.1
NPM Version
6.14.15
Releases
Unable to fetch releases
Languages
4
JavaScript
TypeScript
PLpgSQL
Shell
JavaScript (75.9%)
TypeScript (17.58%)
PLpgSQL (5.61%)
Shell (0.92%)
Developer
Download Statistics
Total Downloads
0
Last Day
0
Last Week
0
Last Month
0
Last Year
0
GitHub Statistics
762 Stars
1,110 Commits
130 Forks
10 Watchers
21 Branches
62 Contributors
Updated on Jul 11, 2025
Maintainers
2
Package Meta Information
Latest Version
4.13.0-0.2.5
Package Id
@subql/x-graphile-build-pg@4.13.0-0.2.5
Unpacked Size
1.74 MB
Size
406.17 kB
File Count
159
NPM Version
6.14.15
Node Version
14.18.1
Published on
Jul 03, 2023
Total Downloads
Cumulative downloads
Total Downloads
NaN
Last Day
0%
NaN
Compared to previous day
Last Week
0%
NaN
Compared to previous week
Last Month
0%
NaN
Compared to previous month
Last Year
0%
NaN
Compared to previous year
Weekly Downloads
Monthly Downloads
Yearly Downloads
Peer Dependencies
1
Dev Dependencies
5
graphile-build-pg
graphile-build-pg is a collection of Graphile Engine plugins that allow you
to extend your GraphQL schema with high-performance types and fields based on
resources found in your PostgreSQL database schema.
Crowd-funded open-source software
To help us develop this software sustainably under the MIT license, we ask all individuals and businesses that use it to help support its ongoing maintenance and development via sponsorship.
Click here to find out more about sponsors and sponsorship.
And please give some love to our featured sponsors 🤩:
 Surge * |  Netflix * |  The Guild * |  Qwick * |
 Chad Furman * |  Dovetail * |  Enzuzo * |  Stellate * |
* Sponsors the entire Graphile suite
About
Thanks to Graphile Engine's advanced query
look-ahead features,
the plugins in this package do not exhibit the N+1 query problem common in
many database-based GraphQL APIs. For all but the flattest GraphQL queries
these plugins typically outperform DataLoader-based solutions.
An example of an application built on graphile-build-pg is
PostGraphile which with one
command connects to your PostgreSQL database and provides a full highly
performant standards-compliant GraphQL API.
It is recommended that you use PostGraphile directly unless you really want to get low level access to this library.
If you prefer to use the plugins yourself it's advised that you use the
defaultPlugins export from graphile-build-pg and then create a new array
based on that into which you may insert or remove specific plugins. This is
because it is ordered in a way to ensure the plugins work correctly (and we
may still split up or restructure the plugins).
Export: defaultPlugins
An array of graphql-build plugins in the correct order to generate a
well-thought-out GraphQL object tree based on your PostgreSQL schema. This is
the array that postgraphile-core uses.
Manual usage
1import { defaultPlugins, getBuilder } from "graphile-build";
2import { defaultPlugins as pgDefaultPlugins } from "graphile-build-pg";
3
4async function getSchema(
5 pgConfig = process.env.DATABASE_URL,
6 pgSchemas = ["public"],
7 additionalPlugins = []
8) {
9 return getBuilder(
10 [...defaultPlugins, ...pgDefaultPlugins, ...additionalPlugins],
11 {
12 pgConfig,
13 pgSchemas,
14 pgExtendedTypes: true,
15 }
16 );
17}
No vulnerabilities found.
Reason
no dangerous workflow patterns detected
Reason
no binaries found in the repo
Reason
9 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 7
Reason
Found 11/25 approved changesets -- score normalized to 4
Reason
security policy file detected
Details
- Info: security policy file detected: github.com/graphile/.github/SECURITY.md:1
- Warn: no linked content found
- Info: Found disclosure, vulnerability, and/or timelines in security policy: github.com/graphile/.github/SECURITY.md:1
- Info: Found text in security policy: github.com/graphile/.github/SECURITY.md:1
Reason
no effort to earn an OpenSSF best practices badge detected
Reason
detected GitHub workflow tokens with excessive permissions
Details
- Warn: no topLevel permission defined: .github/workflows/ci.yml:1
- Info: no jobLevel write permissions found
Reason
dependency not pinned by hash detected -- score normalized to 0
Details
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:20: update your workflow using https://app.stepsecurity.io/secureworkflow/graphile/graphile-engine/ci.yml/v4?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:22: update your workflow using https://app.stepsecurity.io/secureworkflow/graphile/graphile-engine/ci.yml/v4?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:74: update your workflow using https://app.stepsecurity.io/secureworkflow/graphile/graphile-engine/ci.yml/v4?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:76: update your workflow using https://app.stepsecurity.io/secureworkflow/graphile/graphile-engine/ci.yml/v4?enable=pin
- Info: 0 out of 4 GitHub-owned GitHubAction dependencies pinned
Reason
license file not detected
Details
- Warn: project does not have a license file
Reason
project is not fuzzed
Details
- Warn: no fuzzer integrations found
Reason
SAST tool is not run on all commits -- score normalized to 0
Details
- Warn: 0 commits out of 25 are checked with a SAST tool
Reason
32 existing vulnerabilities detected
Details
- Warn: Project is vulnerable to: GHSA-968p-4wvh-cqc8
- Warn: Project is vulnerable to: GHSA-h5c3-5r3r-rr8q
- Warn: Project is vulnerable to: GHSA-rmvr-2pp2-xj38
- Warn: Project is vulnerable to: GHSA-xx4v-prfh-6cgc
- Warn: Project is vulnerable to: GHSA-93q8-gq69-wqmw
- Warn: Project is vulnerable to: GHSA-v6h2-p8h4-qcjw
- Warn: Project is vulnerable to: GHSA-grv7-fg5c-xmjg
- Warn: Project is vulnerable to: GHSA-7gc6-qh9x-w6h8
- Warn: Project is vulnerable to: GHSA-3xgq-45jj-v275
- Warn: Project is vulnerable to: GHSA-rc47-6667-2j5j
- Warn: Project is vulnerable to: GHSA-78xj-cgh5-2h22
- Warn: Project is vulnerable to: GHSA-2p57-rm9w-gvfp
- Warn: Project is vulnerable to: GHSA-896r-f27r-55mw
- Warn: Project is vulnerable to: GHSA-8cf7-32gw-wr33
- Warn: Project is vulnerable to: GHSA-hjrf-2m68-5959
- Warn: Project is vulnerable to: GHSA-qwph-4952-7xr6
- Warn: Project is vulnerable to: GHSA-p6mc-m468-83gw
- Warn: Project is vulnerable to: GHSA-35jh-r3h4-6jhm
- Warn: Project is vulnerable to: GHSA-952p-6rrq-rcjv
- Warn: Project is vulnerable to: GHSA-f8q6-p94x-37v3
- Warn: Project is vulnerable to: GHSA-r683-j2x4-v87g
- Warn: Project is vulnerable to: GHSA-5fw9-fq32-wv5p
- Warn: Project is vulnerable to: GHSA-3j8f-xvm3-ffx4
- Warn: Project is vulnerable to: GHSA-j9fq-vwqv-2fm2
- Warn: Project is vulnerable to: GHSA-pqw5-jmp5-px4v
- Warn: Project is vulnerable to: GHSA-p8p7-x288-28g6
- Warn: Project is vulnerable to: GHSA-c2qf-rxjj-qqgw
- Warn: Project is vulnerable to: GHSA-f5x3-32g6-xq36
- Warn: Project is vulnerable to: GHSA-72xf-g2v4-qvf3
- Warn: Project is vulnerable to: GHSA-7p7h-4mm5-852v
- Warn: Project is vulnerable to: GHSA-6fc8-4gx4-v693
- Warn: Project is vulnerable to: GHSA-3h5v-q93c-6h6q
Score
3.8
/10
Last Scanned on 2025-07-07
The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software (OSS). The Scorecard provides security health metrics for open source projects.
Learn More