Presentation of DbSchema workflow

DbSchema database tool

Are you looking for an intuitive database tool, for the complete database life cycle, from design, implementation, SQL and query editing, data browse until schema synchronization and deployment ?
Would you like to feel the schema, understand it per see ?
Master complicated queries without having to write SQL ?
Browse the data from multiple tables as you would browse the internet ?

DbSchema works with most of the databases: MySql, PostgreSql, SqlServer, Derby, Firebird, Oracle, Db2, Informix, HSql, Pointbase, Mimer, Pervasive, Sybase and others.

Key features

Interactive diagrams

Create multiple diagrams ( layouts ) to design and edit your schema. Is enough to move the mouse over a foreign key to see the corresponding columns, to double-click a table to edit it or drag a column over another to create a foreign key. Foreign keys can be drawn joined to tables or to columns, so you can see exactly which columns are joined. read more

Synchronize schema, edit schema online/offline

Working online the schema changes will be applied in DbSchema and in the database. Working offline the schema changes will be done only in DbSchema and saved in the project file. Later you can decide to synchronize the schema with the database and commit the schema changes or refresh changes from Db. You can convert your schema to a different database, upload it on database... read more

Relational data browse  Browse Database data using the mouse

An amazingly simple and efficient relational data explorer that offers simultaneous views of data from multiple tables and features numerous filters, data sorting mechanisms, and much more. read more

Sql editor

The Sql editor with syntax highlighting and code completion, makes your editing easier, productive and can even be fun. Supports execution of simple queries or large scripts, with output on screen or spool to file. read more

Visual Query Builder  Build queries using the mouse

Graphically compose complex queries with INNER, OUTER, EXISTS joins, filters and group by clauses. This in a visual way, using diagrams, for a better understanding of the relations between tables. read more

Interactive Web image documentation

DbSchema supports documentation from the ground up, allowing every table, column, index, etc. to have an associated comment or description. DbSchema can generate documentation in visual graphical format, compact ( XHTML / SVG ) for an easy deploy over web. You can view your schema remote, move the mouse over the tables and columns and read the comments. View sample here. read more

Save schema design as project file

The DbSchema project file will store the schema design and the layouts with the SQL and Data Browse editors. The project file can be opened from any other computer, even if you cannot connect to the database. read more

Team work

Due the ability to save DbSchema project to file you can share your work in a team, with no need of a physical database. The project file can be stored in a subversion repository and can be updated by each member of the team. read more

You have a great product! The Browse feature is terrific!

Brian Beitzel, College professor

Our company works for the national telephony company with extreme large databases. Using DbSchema we succeed to document and interact better with them. For all synchronization and migration issues we use your tool. We love them all, the layouts, browse and the sql. Nice work!

Santos Mariano, Database expert

"Using DbSchema we improved our database design. We managed to work in team on this task. The result was a two times faster database."

Darcu Macclain, System Architect

"Relational Data Browse is the most efficient way of viewing data. In the last time I spent significant less time typing queries, and I did my job much faster."

Stephan Collar, Developer