DbSchema: Hive Admin GUI Tool & Database Designer

  • DbSchema is a Hive diagram-oriented database designer with integrated tools for query and data. DbSchema is build for large diagrams and schemes. No Hive database experience required - the tool is visual.
  • DbSchema is managing its own internal copy of the schema, distinct from the database. This makes possible to design a schema and deploy it on multiple databases, generate migration scripts or share the design project file in a team.
  • Hive connectivity is described on JDBC driver page.

DbSchema Database Tool

Best Hive Diagrams

Hive Diagram Designer DbSchema has the market best Hive interactive diagrams. The designer can display diagrams with more then 1000+ tables.

  • The layouts (diagrams) will can be saved to project file and reopen next time you access the application
  • HTML5 documentation with interactive vector image can be exported. Sample here.
  • Foreign keys can be drawn using different notations, with lines pointing to tables or to columns.
Read more »

Relational Data Browse

Hive Data Explorer Relational Data Browse is a visual data explorer from multiple tables at a time. The explorer is using the foreign keys between tables to cascade from table to table and simultaneous explore data. If your project is missing foreign keys you can create virtual foreign keys in the layout.

Using Relational Data Browse you can also edit the database data or insert new records.

The editor will be saved to project file and reopen next time as it is. In this way you can build different perspectives over the data and reuse them whenever you need.

Read more »

Deploy Schema on Multiple Databases

Convert Schema to Hive DbSchema manages its own image of the schema and saves it to XML project file. This makes possible to design schema in a team and deploy it on multiple databases.

New projects can be started by reverse engineer schema from the database or design offline. In both cases an internal schema, distinct from the database, will be created.

To refresh the internal schema from the database you have to press 'Refresh schema from database' from the menu. At this step you can decide which changes to take over in the internal project or push in the database. The project file can be shared in a team using versioning systems ( GIT, SVN, etc.).

Read more »

Hive Visual Query Builder, Query Editor and Random Data Generator

Hive visual query builder and query editor

  • Visually create SQL queries using the query builder. Multiple JOIN clauses can be used, including LEFT OUTER JOIN, EXISTS, etc. or group by clauses. The joins are using the foreign keys or virtual foreign keys.
  • The Query editor with text-autocompletion, script execution and graphical explain plan.
  • Random data generator using reverse regular expressions and predefined patterns.

Read more »

Database Forms and Reports | Database Manager

Hive Forms and Reports DbSchema Hive forms and reports can be used to build applications or reports and run them as JavaFx or Web applications. Based on the forms designer we started building Hive applications for space, permission and activity management.

Read more »

Start using DbSchema right now !

DbSchema can be evaluated 15 days for free.

DbSchema can run on all operating systems: Windows, Linux, MAC.

DbSchema Database Tool
Video Presentation