Preparing for system design interviews?  Try bugzed.com →

pg-to-ts

JSON →
library 4.2.0 ·javascript
verified Jun 5, 2026

Generate TypeScript interfaces and constants from a Postgres database schema by querying pg_catalog. Version 4.2.0 requires TypeScript >=4.1. A fork of schemats that drops MySQL support in favor of deeper Postgres integration, supports table/column comments as JSDoc, custom JSON types via `--jsonTypesFile`, date-as-string mode, and schema name prefixing. Ships with a CLI tool and outputs both select and input interfaces plus runtime table constants.

total hits 6
actors 2 distinct systems
last hit 16d ago AhrefsBot
GPTBot
3
Humans
2

top countries 🇺🇸 United States · 🇸🇬 Singapore · 🇨🇦 Canada