For a better representation of the database, you can divide complex schemas into separate layouts (groups of tables). Use the layouts to visually browse & edit the schema without having to write SQL Queries.
Generate test data in your database with Data Generator. Use configurable, random, or reverse regular expression patterns.
Build small applications or create multiple master-detail sections using DbSchema powerful form engine. Model the report engine using internal Java or Groovy scripts.
Browse & edit data from multiple tables based on foreign keys. There is no limit on how many tables you can browse simultaneously.
Use the DbSchema SQL editor to write your SQL queries.
Use DbSchema to build SQL Queries visually, without having to write any line of code.
Open & modify the schema offline, then synchronize it to the database. DbSchema enables you to synchronize schemas between different databases as well.
Use DbSchema to connect to any Relational or NoSql Database. If your database is not on our driver list, upload its JDBC Driver in DbSchema.
Use DbSchema to export an interactive HTML5 Documentation.
Choose whether you want to see each column data type or not.
In DbSchema, Foreign Keys are represented visually in the layouts. If your database lacks foreign keys, you can create Virtual Foreign Keys. They will be stored only in DbSchema and won't affect the database in any way.
Personalize your experience in DbSchema with Customizable Themes.