A visual schema designer for business applications.
Define your entities, columns, foreign keys, and indices in a visual editor. Hit apply, the migration runs against PostgreSQL, and your CRUD endpoints, grids, and detail forms appear automatically. The schema is the source of truth; the rest is generated.
Design the data model where it makes sense.
For a new business entity, the fast path is the visual designer. Add a table, drop in the columns, pick types, mark which ones are required, draw the foreign keys to related entities. The schema editor reads like an ERD because that is what it is.
What the designer produces is a JSON document version-controlled in your codebase. The same document a developer would have written by hand, just with a UI on top. No proprietary binary format, no opaque blob.
Safety on apply.
Changing a schema is the operation with the most downside in any business system. The designer treats it that way. Before applying, the engine computes what the change actually does:
- Pure additions (new tables, new nullable columns, new indices) apply silently.
- Type changes and column drops require an explicit "allow data loss" confirmation, with the affected row count surfaced.
- Foreign-key changes are checked against existing rows before the constraint applies. Broken references fail loud, not silently.
- The whole apply runs inside a PostgreSQL transaction. If any step fails, the database rolls back to the previous state.
Code-first when you'd rather.
The schema files are plain JSON checked into the codebase. A developer can author them in their text editor, review them in a pull request, and apply them through the same engine the visual designer uses. The designer is a helpful UI on top of a file format, not the only way in.
When a schema doesn't fit either, drop into psql and run raw SQL. Archestack picks the resulting state up on next sync. The escape hatch is always open.
Design your first entity.
Free 7-day trial. Open the schema designer, sketch a real entity, apply it, see the generated UI.