Schema Package Overview

@graphql-suite/schema takes a Drizzle PgDatabase instance and produces a complete GraphQL schema at runtime. There is no code generation step — your Drizzle table definitions are the single source of truth.

Inspired by drizzle-graphql, this package is a purpose-built replacement focused on PostgreSQL with deeper relation support, configurable hooks, permission layers, and row-level security.

What gets generated

Queries are created for every included table:

• List query — returns an array of rows with filtering, ordering, pagination, and offset support
• Single query — returns one row by primary key or unique filter
• Count query — returns the number of matching rows

Mutations (when enabled) are created for every table that has mutations allowed:

• Insert — insert one or many rows, with returning clause
• Insert single — insert exactly one row
• Update — update rows matching a filter
• Delete — delete rows matching a filter

Relations are resolved automatically based on your Drizzle relations() definitions. Nested selections traverse one-to-one and one-to-many relationships with configurable depth limits.

Additional capabilities

• Filters — auto-generated filter input types with operators like eq, ne, gt, lt, gte, lte, like, ilike, in, notIn, isNull, plus AND/OR combinators
• Ordering — order by any column, ascending or descending
• Pagination — limit and offset arguments on list queries
• JSONB fields — exposed as the GraphQLJSON scalar type
• Configurable naming — control query/mutation suffixes to get natural names like users/user instead of user/userSingle
• Table exclusion — remove auth or internal tables from the public schema
• Read-only tables — generate queries but no mutations for specific tables
• Relation pruning — omit, flatten, or restrict specific relation paths
• Hooks — attach before/after/resolve lifecycle hooks to any operation
• Permissions — apply per-table access rules at the schema level
• Debug logging — inspect schema size and relation expansion tree

Key exports

Export	Description
buildSchema	Main function. Takes a Drizzle db and returns a GraphQLSchema plus entities.
buildSchemaFromDrizzle	Schema-only variant that needs no database connection. Creates stub resolvers. Useful for introspection, codegen, and testing.
buildEntities	Returns the GeneratedEntities object (queries, mutations, inputs, types) without building a full schema. Useful for composing into an existing GraphQL schema.
SchemaBuilder	The underlying class, exposed for advanced use cases.
GraphQLJSON	Custom scalar for JSONB columns.
parseResolveInfo	Selection tree for the field being resolved. Useful in custom resolvers.
generateSDL	Generate SDL string from a Drizzle schema (codegen utility).
generateTypes	Generate TypeScript type definitions from a Drizzle schema (codegen utility).
generateEntityDefs	Generate entity definition types for the client package.
permissive, readOnly, restricted	Permission preset helpers.
mergeHooks, withRowSecurity	Hook composition utilities.