schemats

Schemats is a TypeScript code generator that creates type definitions from existing PostgreSQL schemas. It helps developers working with raw SQL or query builders to maintain strong typing and avoid runtime errors. By analyzing database schemas, Schemats bridges the gap between relational databases and TypeScript-based applications.

Features

Generates TypeScript interfaces from PostgreSQL schemas
Supports tables, views, enums, and composite types
CLI tool for quick integration into build pipelines
Ideal for raw SQL and lightweight query builder use cases
Keeps type definitions in sync with schema changes
Reduces boilerplate and runtime type mismatches

Project Samples

Project Activity

See All Activity >

License

MIT License

Follow schemats

schemats Web Site

Other Useful Business Software

MongoDB Atlas runs apps anywhere

Deploy in 115+ regions with the modern database for every enterprise.

MongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.

Start Free

Rate This Project

User Reviews

Be the first to post a review of schemats!

Additional Project Details

Operating Systems

Linux, Mac, Windows

Programming Language

TypeScript

Related Categories

TypeScript SQL Clients

Registered

2025-06-10

Similar Business Software

DbVisualizer

DbVisualizer is a universal database client for developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It provides a graphical interface for database development, SQL querying, data exploration, and database admin. The tool includes a powerful SQL editor...

See Software
KS DB Merge Tools

KS DB Merge Tools is an easy to use diff & merge tool for MySQL, MariaDB, Oracle Database, SQL Server, PostgreSQL, SQLite, MS Access and Cross-DBMS databases allowing to compare and sync both schema and data. Starting with a schema changes summary, results can be narrowed down to object lists of...

See Software
DbSchema

DbSchema is for visual designing the schema in a team, deploy and document the schema. Other integrated features like data explorer, visual query editor, data generator, etc., makes DbSchema an every-day tool for everybody who interacts with databases. DbSchema supports all relational and No-SQL...

See Software
Visual Expert

Visual Expert is a static code analyzer for Oracle PL/SQL, SQL Server T-SQL, and PowerBuilder. Identify code dependencies to modify your code without breaking your application. Scan your code to improve the security, performance, and quality. Perform Impact analysis to Identify breaking...

See Software
DBeaver Community

DBeaver Community is a free, open-source database management tool recommended for personal projects. Manage and explore SQL databases like MySQL, MariaDB, PostgreSQL, SQLite, Apache Family, and more. Connect to popular SQL databases (PostgreSQL, MySQL, SQL Server, Oracle, SQLite, etc.) SQL...

See Software
AIHelperBot

Simple, powerful, and affordable. Generate SQL queries without prior SQL knowledge using everyday language. Just sign in and write what you desire using everyday language and AI Bot will build the desired SQL query. No coding is required, no SQL knowledge is required. Start a free trial and see...

See Software