SweetIQ/schemats

Health v2 · maintenance only

Adoption not part of the score

1061 stars · 102 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

Schemats is a CLI tool that automatically generates TypeScript interface definitions from Postgres or MySQL database schemas. It introspects tables and columns to produce statically typed interfaces for use in TypeScript projects.

Use cases

• generate typescript types from postgres schema
• create typescript interfaces from mysql database tables
• keep typescript types in sync with database schema
• statically type sql query results in typescript
• generate type definitions for all tables in a database schema
• avoid hand-writing typescript interfaces for database rows

When to choose

• you use Postgres or MySQL with TypeScript and want types derived directly from the live schema
• you want a simple CLI or config-file-driven code generation step in your build
• you prefer lightweight schema-to-interface generation over a full ORM

When to avoid

• you use a database other than Postgres or MySQL
• you want runtime query validation or a query builder, not just type definitions
• you need an actively developed tool with recent updates and broad database support

Facets

cli-tool · maturity maintenance

database type-system cli databases developer-tools web-development cli cross-platform typescript postgresql mysql sql-schema code-generation schema-reflection nodejs

Member repositories

For agents

markdown · JSON · MCP: product_card(name="SweetIQ/schemats")