Your model becomes
a database. Automatically.
SolidX reads your visual model definitions and generates the complete database schema — tables, columns, data types, foreign keys, indexes — with zero manual SQL.
Define it visually.
SolidX writes the schema.
Every model you create in the SolidX App Builder — every field, every relationship, every constraint — is stored as structured metadata. The schema engine continuously reads this metadata and translates it into precise database tables.
- ✓Creates database tables and columns that exactly match your visual model definitions
- ✓Data types are mapped precisely — Short Text → VARCHAR, Integer → BIGINT, Date → DATE
- ✓Constraints are enforced at the DB level — Required → NOT NULL, Unique → UNIQUE INDEX
- ✓Relational fields automatically create foreign key constraints between tables
- ✓Changes to models are immediately reflected — add a field, the column appears
| SolidX Type | → | SQL Type | Constraints |
|---|---|---|---|
| Integer | → | BIGINT | PK auto-increment if ID |
| Short Text | → | VARCHAR(1000) | NOT NULL if Required |
| Long Text | → | TEXT | UNIQUE if flagged |
| Date | → | DATE | NOT NULL if Required |
| DateTime | → | TIMESTAMPTZ | DEFAULT NOW() if sys |
| Boolean | → | BOOLEAN | DEFAULT false/true |
| Relational | → | BIGINT + FK | REFERENCES target(id) |
| Rich Text | → | LONGTEXT | HTML content stored |
Fast in dev.
Safe in production.
SolidX handles the two phases of schema management differently. During development, schema changes sync in real time. In production, all changes go through explicit migration scripts.
- ✓Development — TypeORM automatically aligns the DB schema to your entity definitions on every save.
- ✓Production — schema updates require explicit SQL migrations. Full control, full auditability.
- ✓SolidX generates migration scripts from model diffs
Enterprise-grade ORM.
Zero configuration.
SolidX uses TypeORM — one of the most battle-tested ORM tools — to manage all schema operations without needing to configure it directly.
SolidX converts each visual model definition into a TypeORM Entity class with all column decorators automatically.
@DeleteDateColumn()
export class StudentMaster {
@PrimaryGeneratedColumn()
id: number;
@Column({unique: true)
admissionNo: string;
}
SolidX applies a consistent naming strategy — JavaScript conventions are automatically converted to database-standard naming.
StudentMaster → student_master
admissionNo → admission_no
// Relations → FK columns
@ManyToOne ClassSection
→ class_section_id BIGINT
One-to-Many, Many-to-One, Many-to-Many — TypeORM handles the foreign key columns, junction tables automatically.
@OneToMany(() => FeeRecord)
feeRecords: FeeRecord[];
// M:N → Auto junction table
@ManyToMany(() => Tag)
tags: Tag[];
Every entity generated by SolidX automatically receives the four system-managed fields with auto-lifecycle hooks.
@PrimaryGeneratedColumn()
id: number;
@CreateDateColumn()
createdAt: Date;
@DeleteDateColumn()
deletedAt: Date | null;
Consistent naming across every layer
SolidX enforces a single, predictable naming convention end-to-end — from the display name you enter in the UI, to the exact database column name.
From model definition to live database table
The schema generation pipeline runs automatically behind the scenes every time you make changes to your models.
Define or update a model visually
Add a new Model in the App Builder, define its fields, set relationships, and configure settings. SolidX stores your definitions as structured metadata.
Metadata is parsed by the schema engine
On save, the SolidX schema engine reads the updated metadata and identifies what changed — new fields, modified constraints, new relationships.
TypeORM entities are generated
The engine generates TypeORM Entity classes with all the correct column decorators, type mappings, relationship definitions, and custom naming strategy applied.
Schema is applied to the database
In development, TypeORM syncs the schema immediately. In production, SolidX generates a migration script for you to review and apply.
Your models build
your database for you.
Define your data visually. SolidX handles the tables, columns, types, constraints, and migrations.
npx @solidxai/solidctl@latest create-app