Design and Manage Apache HBase Databases Visually with DbSchema

DbSchema lets you design, manage, and document Apache HBase databases. Create ER diagrams, define tables and columns, and generate SQL scripts - with or without a live database connection.

Use Git to share the design, compare it with the Apache HBase database, and deploy changes. DbSchema also includes a data editor, query builder, and HTML5 documentation - everything you need in one tool.

DbSchema Database Designer

Download DbSchema Download Apache HBase JDBC Driver

Apache HBase is a wide-column, NoSQL data store built on top of HDFS that provides random, real-time read and write access to large datasets. Its schema model organizes data into tables with column families — groups of columns stored together on disk — and rows identified by row keys. Apache Phoenix layers a SQL interface on top of HBase, enabling standard SQL DDL and DML operations while translating queries into native HBase scans. DbSchema connects through the Phoenix JDBC driver, reads the Phoenix-managed schema, and exposes HBase table structures for visual exploration and data browsing.

Browsing HBase Column Family and Data Type Structures

Phoenix exposes HBase column families and their column definitions as a typed SQL schema. DbSchema reads this schema and displays the full data type catalog for each column — including Phoenix-specific types like UNSIGNED_INT, ARRAY, and VARBINARY — giving engineers visibility into the physical column family structure without using the HBase shell.

Browsing Apache HBase column family data types via Phoenix in DbSchema

Phoenix SQL Query Builder for HBase Tables

DbSchema's query builder constructs Phoenix SQL SELECT statements visually, handling the row key prefix conditions that Phoenix uses to translate SQL predicates into efficient HBase row key scans. This allows engineers to build performant queries against HBase without deep knowledge of the underlying scan mechanics.

Building Phoenix SQL queries against Apache HBase tables in DbSchema

Data Explorer for Wide-Column HBase Tables

The DbSchema data explorer fetches rows from Phoenix-managed HBase tables and renders them in a paginated tabular view. You can apply column filters and inspect individual cell values across wide tables with many column families, without constructing HBase scan operations manually.

Exploring HBase table data via Apache Phoenix in DbSchema's data explorer

Connecting DbSchema to Apache HBase

DbSchema connects to HBase via the Apache Phoenix JDBC driver. For the thin client, the JDBC URL format is jdbc:phoenix:zookeeper_host:2181:/hbase. Download the Phoenix thin client JDBC driver from the Phoenix release page and register it in DbSchema's driver manager via Settings > Drivers. Alternatively, use the Phoenix thick driver by specifying the full ZooKeeper quorum address directly. For HBase running on Amazon EMR, obtain the ZooKeeper address from the EMR cluster summary page and ensure the security group allows inbound traffic on port 2181. The Phoenix query server must be running for the thin client to connect.

Why Teams Use DbSchema with Apache HBase

  • Column family visualization — see which columns belong to which column families in a structured schema view.
  • Phoenix SQL access — build and execute Phoenix SQL queries visually without writing HBase scan operations.
  • Row data inspection — browse wide-column table contents row by row from the data explorer with filter support.
  • Schema documentation — document the Phoenix-managed HBase schema for teams that lack direct cluster access.
  • EMR integration — connect to HBase on Amazon EMR using the cluster ZooKeeper endpoint and Phoenix thin client.