A Desktop SQL Client for Apache Drill Storage Plugins

DbSchema gives Apache Drill teams a design-first workflow: import the existing schema as an interactive ER diagram, refine it visually, and ship every change as a reviewed SQL script.

Built for visual modeling, schema documentation, and deployment, with an offline model you can keep in Git, team collaboration, and documentation that developers, analysts, and stakeholders can navigate in minutes.

Download DbSchema See Apache Drill Features Download Apache Drill JDBC Driver · All drivers

Exploring Heterogeneous Data Sources with Apache Drill and DbSchema

Apache Drill provides schema-free SQL over a wide range of data sources — Hadoop HDFS, HBase, Amazon S3, MongoDB, and local file systems — without requiring pre-defined schema definitions. This flexibility makes Drill powerful for ad-hoc analytics, but also makes it challenging to maintain a clear picture of what data is available and how sources relate to each other. DbSchema connects via the Drill JDBC driver, discovers available storage plugins and their schemas, and provides a SQL client for running Drill queries across your data infrastructure.

Download DbSchema Free See Apache Drill Features

Visual Query Builder for Drill Data Sources

DbSchema's query builder helps you construct queries against Apache Drill tables and file-based sources using a graphical interface, reducing the need to write raw Drill SQL for every exploratory query. This is practical for data engineers who are familiar with Drill's storage plugin model but prefer a visual tool for initial data exploration.

Interactive Data Explorer for Drill Results

DbSchema's data explorer lets you browse result sets from Drill queries interactively, paginate through data, and apply filters without modifying the underlying query. This is useful for data engineers exploring file-based or HBase data sources through Drill without writing complex filter predicates by hand.

SQL Editor for Drill Queries Across Multiple Sources

The DbSchema SQL editor connects directly to Apache Drill and supports Drill's SQL dialect, including cross-source joins, file system queries, and Drill-specific functions. Write and run queries against HDFS files, HBase tables, and MongoDB collections from a single desktop interface without managing separate client tools for each source.

From Download to Drill ER Diagram

1. Install DbSchema on your machine — no account is needed for the download.
2. Download the Drill JDBC driver from the Apache Drill download page and register it under Connections > Manage Drivers.
3. Create a connection using a direct Drillbit URL, jdbc:drill:drillbit=host:31010, where 31010 is Drill's default JDBC port.
4. If Drill is deployed on YARN with ZooKeeper coordination instead, point the connection at the ensemble with jdbc:drill:zk=host:2181/drill/cluster.
5. Connect — DbSchema lists the available storage plugins and their schemas for querying and diagramming.

Highlights of Using DbSchema with Apache Drill

• Discover and browse available Drill storage plugins and their schema objects visually
• Run Drill SQL queries across HDFS, HBase, S3, and MongoDB from a desktop client
• Explore query results interactively with filtering and pagination
• Document the Drill data model for analytics and data engineering teams
• Use the query builder to construct Drill queries without writing raw SQL

Working across HDFS, HBase, and S3 through Drill and want one picture of it all? Download DbSchema for free and browse every storage plugin's schema from a single desktop client.

Related databases

Teams working with Apache Drill often use these engines too. Explore dedicated guides and JDBC setup for each.

• Apache Druid
• Apache Ignite
• Apache Pinot
• Apache Solr
• Dremio
• HBase

Browse all 100+ supported databases