Working with Daffodil DB in DbSchema

DbSchema reaches Daffodil DB in embedded or network server mode, reverse engineers tables and views into ER diagrams, and adds SQL editing and HTML documentation for this pure-Java relational store.

Connect in either deployment mode through one driver
Reverse engineer tables and views onto a diagram canvas
Iterate on SQL in an interactive desktop editor
Produce HTML reports for audits and team handovers

available for

ISO-27001 certified

Free Community Edition No signup required 15-day Architect trial included

Free Download

DbSchema rendering a Daffodil DB schema as an ER diagram

Trusted by teams at

A Database Inside Your JVM
Shouldn't Stay Invisible

An embedded Daffodil DB ships inside the application, and its structure ships inside the source code. Auditors, new hires, and integration partners see nothing until someone reads the code out loud.

DbSchema connects in embedded or network mode and gives the database what it never had: a diagram, a query workbench, and documentation anyone can open.

Connect, Query & Review
Daffodil DB in Either Mode

The same desktop workflow whether the database is a server or a file.

Reverse engineer a Daffodil DB schema in DbSchema

One Connection, Either Mode

Point DbSchema at the network server or the embedded database and get tables, views, and column definitions on a diagram canvas.

Execute SQL against Daffodil DB in the DbSchema editor

A Real SQL Workbench

Run statements against the connected instance, validate query logic, and investigate data anomalies without a separate CLI.

Review generated Daffodil DB DDL in DbSchema

Changes Reviewed as Scripts

Design schema edits on the model and inspect the generated DDL before anything reaches a production Daffodil DB instance.

Schema History That Lives
Beside Your Java Code

Commit the Daffodil DB model into the same repository as the application that embeds it. Reviewers see structural changes as ordinary diffs, and DbSchema turns the merged result into DDL for the database.

Daffodil DB schema synchronization between the Git-tracked model and the database

Read Git Workflow Docs

Two Ways to Reach Daffodil DB

Network server mode uses jdbc:daffodilDB_net://host:3456/dbname, with 3456 as the default port; embedded mode uses jdbc:daffodilDB_embedded:dbname. The driver comes from the Daffodil Software website and registers in DbSchema's driver manager — see the Daffodil DB JDBC driver page. In embedded mode a single JVM holds an exclusive lock on the database, so stop the host application before DbSchema connects.