postgres-schema-builder

A TypeScript library for building PostgreSQL schemas and writing typesafe queries. Version 1.3.0, last updated in 2020 (no recent releases). It uses a declarative schema definition with TableSchema, automatic TypeScript type inference from column types, and a Table API for CRUD operations. Key differentiator: strong TypeScript type safety for schema and queries, including compile-time checks for nullable columns and foreign keys. Not actively maintained; no query builder for joins or aggregations. Alternative: kysely or drizzle-orm.