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

Fully Managed MySQL, PostgreSQL, and SQL Server

Automatic backups, patching, replication, and failover. Focus on your app, not your database.

Cloud SQL handles your database ops end to end, so you can focus on your app.

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 anyone who works with data, from solo developers and startups to professional teams managing complex environments, including developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It offers a graphical interface...

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
FastQueryBuilder

FastQueryBuilder is an easy to use visual SQL query builder. It works with local and client-server databases. Let's your customers create DB queries without SQL! FastQueryBuilder enables you to work with local and client-server databases by means of the BDE. It also allows you to work with...

See Software