graphile-build-pg

import { makeSchema } from 'postgraphile'; import { defaultPreset } from 'postgraphile'; import { makePgSources } from '@dataplan/pg'; import { printSchema } from 'graphql'; // Ensure you have a PostgreSQL database running and DATABASE_URL set. // Example: export DATABASE_URL="postgres://user:password@localhost:5432/mydb" const DATABASE_URL = process.env.DATABASE_URL ?? 'postgres://postgres:password@localhost:5432/postgres'; async function buildPostgresSchema() { if (!DATABASE_URL) { throw new Error('DATABASE_URL environment variable is not set.'); } // makePgSources defines how to connect to your PostgreSQL database // and what schemas to introspect. const pgSources = [await makePgSources({ connection: DATABASE_URL, schemas: ['public'], })]; // The `defaultPreset` from `postgraphile` already includes the // `graphile-build-pg` plugins. We add our database sources to it. const preset = { ...defaultPreset, extends: [ ...(defaultPreset.extends || []), { // Add the PostgreSQL sources to the preset plugins: [], // No extra plugins from this block needed schema: { pgSources, }, }, ], }; // Build the GraphQL schema using the configured preset. const { schema } = await makeSchema(preset); console.log('Successfully built GraphQL schema from PostgreSQL database:\n'); console.log(printSchema(schema)); } buildPostgresSchema().catch(console.error);