Schema-driven Dynamic API

Qornix Schema Manager

Validate an XML schema, compare it with the current database, review the diff and SQL preview, then apply only a confirmed plan. For the first run, load the bundled demo schema: it creates categories, products, customers, and orders.

Read Schema Guide Open demo XML Open XSD

1. Current database schema

Export the actual database schema and show it in the UI. This does not overwrite the desired XML schema.

Load the current schema first, then you can save it as an XML file.

The database schema has not been loaded yet.

2. Desired XML schema

Paste XML manually, upload a file, or click Load demo schema. The demo schema is stored in schema/app.schema.xml and also served as /static/demo_schema.xml for the UI.

Validation results will appear here.

3. Diff

The diff has not been built yet.

4. Plan & risk

The plan has not been built yet.

Risk labels will appear here.

5. SQL preview

Build a plan to see the SQL preview.

6. Apply confirmed plan

I confirm destructive operations, if any
I confirm manual-review operations, if required
Dry-run only, do not change the database

By default, Apply performs a live apply. Enable dry-run only when you want to test the pipeline without changing the database. If the database is already partially populated, or if you loaded an older roundtrip XML from the example app, click Reset demo database and apply the bundled demo schema again.

Apply results will appear here.

7. Schema history

History has not been loaded yet.