Divide complex schemas into separate layouts (groups of tables) for a better representation of the database. Use the layouts to browse and edit the schema visually, without having to write any SQL queries.
- Edit Tables in Diagram
Double-click any table directly in diagram to edit.
- Visual Create Foreign Keys
Create new foreign keys by drag&drop of one table column
- Design Schema Offline
Design schema offline and create it later in database
- Joined Foreign Key Lines
Draw foreign key line from table to table or from column to column mode.
- Foreign Key Notation
Use different foreign key notation: Idefix, Barker, etc.
- Colors and Comments
Use for each table a different color, place comment callouts.
Relational Data Browse
Use this simple tool to view data from multiple tables simultaneously, based on foreign keys. There is no limit to how many tables can be opened at once.
- Cascade Into Multiple Tables
View data from multiple tables simultaneously based on normal or foreign key relationships.
- Edit Records with One Click
Double click any cell to edit
- Pick Up Where You Left Off
Your data browse editor will be saved in the project file so you can access it next time you start DbSchema.
- Make Your Browsing More Relevant
Apply filters and data sorting mechanisms to browse more efficiently
- Create Virtual Foreign Keys
If your schema is missing foreign keys, create virtual foreign keys. They also can be used in relational data browsing.
- View Images from Database
Easily access BLOB or CLOB files in DbSchema
Random Data Generator
Generate test data in your database using configurable, random and reverse regular expression patterns. A predefined repository of patterns will help you find the best data pattern for each column.
- Predefined Patterns
DbSchema offers a wide variety of predefined patterns.
- Auto-Fill Patterns
DbSchema analyzes the column name and anticipates the data type.
- Edit Table Patterns
Add a new pattern or edit existing ones.
- Access Pattern Repository
See and organize patterns from pattern repository.
Visual Query Builder
Build SQL Queries visually, without having to write any line of code. Add and edit tables with a simple click.
- Use Virtual Foreign Keys
Tables can be joined using normal or virtual foreign keys.
Can switch between LEFT, OUTER and EXITS joins
- Group ByConditions
Make use of COUNT(*), AVG(), SUM()
Set filters on columns
Connect to any Database & Reverse Engineer the Schema
Start a new project by reverse engineering the schema. Save the schema structure to the project file and you can reopen it without database connection.
- JDBC Drivers
Connect to any relational database using JDBC Drivers
- Add Your Database
If the database you’re working with is not on our drivers list, upload its JDBC Driver in DbSchema
- Edit Schema Offline
Open and edit your schema without being connected to the database
- SSH Connections
Work on your database through secured connections
DbSchema is using it’s own image of the schema saved to the project file. This enables you to open and modify the schema offline, then synchronize it when you connect to the database.
- Control Every Action
Choose what happens with each difference found in the schema.
- Convert Schemas
Easily convert your schema to a different database.
- Generate SQL Scripts
You can generate SQL Scripts for every database modification.
- Update Schema
Use DbSchema to update the database to the latest schema version.
Automate Your Tasks
DbSchema can read Groovy or Java Scripts enabling you to easily automate tasks:
- Automate schema deployment & migration
- Automate documentation export;
- Automate the reverse engineering of the schema and many more.
Forms & Reports
DbSchema integrates a very powerful and fully customizable Forms & Reports Engine that can be used for:
- Creating a multi-master detail report;
- Creating small applications or reports using Bootstrap responsive HTML templates. Alternatively they can run as JavaFx or PDF;
- Deploy applications as WAR Tomcat Apps.
DbSchema integrates multiple themes so you can personalize your interface.