Schema Forge · Database

From the Excel model to SQL scripts, without redoing it by hand.

You define how your database should end up in a spreadsheet. Schema Forge compares it with your project’s scripts, detects the differences per table and generates the scripts to reach the target model.

See how it works
  • Target model in Excel
  • Per-table gap analysis
  • Generated SQL scripts
  • ZIP download and history
The problem

Bringing the database to the new model is manual and error-prone.

Schema Forge automates the comparison and the writing of the scripts, and shows you what is missing in each table so you can review with judgment.

01

Model and reality out of sync

The model defined by the business does not match what is in the project’s scripts.

02

Differences hard to see

Comparing table by table by hand takes days and things get missed.

03

Scripts written one by one

Every column or table change is written and tested separately.

See it in action

Schema Forge end to end

A spreadsheet with the target model, the comparison with the project and the generated SQL scripts.

How it works

From a spreadsheet to ready scripts

  1. 1

    You define the model

    Each sheet in your Excel is a table and highlighted cells mark the target columns.

  2. 2

    You pick your project

    Schema Forge reads the SQL scripts your project already has, and can optionally use Explorer’s context.

  3. 3

    The AI compares and generates

    It analyzes the differences per table and generates the new scripts to reach the model.

  4. 4

    You review and download

    See the result, check the generation history and download everything in a ZIP.

Capabilities

Built to evolve databases

Model in Excel

Define the target model in a spreadsheet the business understands.

Per-table analysis

Differences between what exists and what should exist, table by table.

New SQL scripts

Generates the scripts to bring your project to the target model.

Generation history

Review, compare and delete previous generations of each project.

ZIP download

Take all the scripts of a generation in a single file.

With your project’s context

It can rely on Explorer’s criteria and on the entities detected in the code.

Use cases

When to use it

Align the schema

Bring the project’s scripts to the model the business defined.

Prepare the destination

Generate the schema for the new database while you migrate the application.

See what is missing

Detect pending tables and columns before writing code.

Gap analysis and scripts generated by Schema Forge
Integrations

Works with your files

Excel (.xlsx)Scripts SQLZIP
Security & governance

Database changes under control

Review before applying

Scripts are generated for you to review; you decide when to run them.

Traceable history

Every generation is recorded per project.

Your data in your environment

The platform can run in your infrastructure.

FAQ

Frequently asked questions

What format does the Excel model have?
Each sheet represents a table and highlighted cells indicate the columns of the target model.
Does it run the scripts on my database?
No. It generates the scripts and the analysis for you to review and apply.
Can I see earlier generations?
Yes, each project keeps its history and you can download any generation as a ZIP.

You may also like

Revitalize

Incremental migration of legacy systems to modern architectures, no “big bang”.

Explorer

Full analysis of your code: acceptance criteria, architecture, diagrams and AI chat.

Code Inspector

The real graph of classes, functions and routes in your code, extracted with a true parser.
Accepting new diagnostic requests

Bring your database to the new model

Bring an Excel model and a project’s scripts: we will show you the differences and the generated scripts.

ISO 27001 certified
SOC Type II
On-premise deployable
NDA before we start