adelsz/pgtyped

Health v2 · maintenance only

Adoption not part of the score

3276 stars · 116 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

PgTyped is a TypeScript library that generates static types for raw SQL queries against a running PostgreSQL database. It parses queries from SQL or TS files and produces typed query functions without requiring schema definitions or acting as an ORM.

Use cases

• generate TypeScript types for raw SQL queries
• use raw SQL with type safety in a Node.js app
• avoid writing an ORM schema mapping for Postgres
• prevent SQL injection when writing parameterized queries
• auto-generate query result and parameter interfaces from a live Postgres database
• write SQL in .sql files and get typed query functions

When to choose

• you prefer writing raw SQL over query builders or ORMs
• you want compile-time type checking of query parameters and results
• your team uses PostgreSQL with TypeScript and wants minimal runtime overhead
• you want the live database schema to be the source of truth for types

When to avoid

• you need an ORM with relations, migrations, and schema management
• you use a database other than PostgreSQL
• you don't want a running database connection during development for type generation
• you need runtime query building or dynamic SQL composition

Facets

library · maturity active

database database-driver type-system developer-tools databases developer-tools web-development backend cross-platform sql postgres type-safety query-generator code-generation raw-sql esm nodejs typescript

Member repositories

For agents

markdown · JSON · MCP: product_card(name="adelsz/pgtyped")