Preparing for system design interviews?  Try bugzed.com →

Schemats: TypeScript Interface Generator

JSON →
library 3.0.3 ·javascript
verified Jun 17, 2026

Schemats is a command-line interface (CLI) tool designed to automatically generate TypeScript interface definitions directly from existing SQL database schemas, specifically supporting PostgreSQL and MySQL. The current stable version is 3.0.3. While it doesn't adhere to a strict release cadence, updates are made to enhance compatibility and features. Its primary differentiator lies in enabling strong static typing for database queries by bridging the gap between relational databases and TypeScript applications. Users can generate type definitions for entire schemas or specific tables, either through command-line arguments or a `schemats.json` configuration file, which then allows for type-safe database interactions and enhanced developer experience with autocompletion and static checks in their application code.

total hits 16
actors 4 distinct systems
last hit 16d ago AhrefsBot
GPTBot
4
Amazonbot
3
Script
1
Humans
4

top countries 🇺🇸 United States · VN · 🇨🇦 Canada · 🇬🇧 United Kingdom · 🇩🇪 Germany