PostgreSQL DDL
CREATE TABLE, composite keys, inline/table foreign keys, defaults and nullability.
Limits: REFERENCES requires explicit target columns. No migrations, views, triggers, policies or index modeling. Unsupported statements warn; unsupported syntax fails.
MySQL DDL
CREATE TABLE, backticks, AUTO_INCREMENT, composite keys and foreign keys.
Limits: No ALTER migrations, engine semantics, generated expressions or index modeling.
SQLite DDL
CREATE TABLE, inline/table references and composite keys.
Limits: No migration evaluation, virtual tables or SQLite affinity/rowid validation.
Drizzle TypeScript
Static pgTable/mysqlTable/sqliteTable with imported column builders, keys and inline references.
Limits: No execution, dynamic helpers, extra table config/compound keys, custom types or cross-file resolution. Combine related declarations in one input.
Prisma schema
Relational models, scalar/list fields, enums, explicit relations and compound keys.
Limits: Implicit relations, mapping/native-type semantics and indexes warn. MongoDB/composite types are rejected.
TypeORM EntitySchema JSON
JSON EntitySchema options (object or array): columns, primary/unique keys and explicit join columns.
Limits: No decorators, executable JS/TS, inferred join columns, inheritance or automatic junction tables.
Document JSON Schema
Object properties, nested objects, arrays, required fields, types and descriptions.
Limits: Structural document view, not an ERD or full validator. References, composition and validation keywords warn.