Change your Database in a Click

With modelDBA, you can easily make the changes you need to the database directly using the user interface. modelDBA can handle all the changes you’d expect. Add, rename or drop tables. Add, alter or drop columns and constraints. You don’t need to worry about the SQL required, it’s all taken care of for. That time you would have spent looking up the correct SQL syntax (again) can be better spent elsewhere.

Make table changes easily using the table editor interface, shown in this modelDBA screenshot.
Change your tables directly with quick drop-downs, check-boxes and text fields. No SQL required.

It doesn’t matter if your change would have been a one-liner on the command line, or if it would have required ten SQL commands (ever tried to change the type of a primary key column referenced by five other tables? Not fun). modelDBA takes care of it all for you.

When you save changes, they’re stored locally in modelDBA at first. You’re able to review them directly in the live database diagram. When you’re happy with the changes, you can click apply to have them persisted to the database.

A change to a database has been saved, but not yet applied to the database in a screenshot from modelDBA.
Table changes are reflected in the database diagram and summarized in the changes panel. When you’re ready to persist the changes to the database, click ‘Apply’.

If at any time you decide not to implement a change you made, you can cancel it, and the database diagram will revert to the state it was in before you made the change. This allows you to play around with different table designs. You can try out and compare multiple different table structures and apply the one you like.

No more SQL scripts

You make the changes you need using the interface, modelDBA handles the rest. No copying and pasting a SQL script. And you definitely don’t need to “forward engineer” your database. You just need to click ‘Apply’ to have the changes updated in your database.

Try out the latest version of modelDBA for free here.

We'll send you updates on new functionality and tips on database management.