Design and Manage InterBase Databases Visually with DbSchema

DbSchema lets you design, manage, and document InterBase 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 InterBase database, and deploy changes. DbSchema also includes a data editor, query builder, and HTML5 documentation - everything you need in one tool.

Download DbSchema Download InterBase JDBC Driver

Embarcadero InterBase is a compact relational database with on-disk encryption, change journaling, and a wire protocol shared with Firebird through their common lineage. It is widely used in Delphi and C++ Builder applications where the database ships embedded within the installed product. These application databases are typically maintained by developers rather than dedicated DBAs, with no tooling for schema visualization. DbSchema provides an ER diagram view of InterBase schemas, an SQL editor for querying data, and documentation generation for understanding legacy application databases.

Visualize InterBase Schemas and Relationships

InterBase databases in Delphi and C++ Builder applications often have table structures that evolved over many application release cycles with no formal ERD. DbSchema renders the current schema state — tables, columns, primary keys, foreign keys, and generator-backed identity columns — as a diagram that makes the underlying data model visible without reading raw DDL.

Query InterBase Data with the SQL Editor

InterBase supports stored procedures and triggers using a PSQL dialect closely related to Firebird's. DbSchema's SQL editor connects to InterBase and lets you run ad-hoc queries, test stored procedure calls, and inspect system table metadata — useful for reverse-engineering what a Delphi application actually does with its embedded database.

Document InterBase Schemas for Maintenance and Handover

Application databases bundled with Delphi or C++ Builder products rarely have up-to-date documentation. DbSchema generates HTML schema documentation directly from the InterBase system catalog, providing a shareable reference that development teams can use during feature additions, maintenance work, or application handover to a new team.

Connecting to InterBase

InterBase listens on port 3050 by default. The JDBC URL format is jdbc:interbase://host:3050//path/to/database.gdb — note the double slash before the absolute path to the database file. Download the InterBase JDBC driver (IBProvider or an InterBase-compatible driver build) from the Embarcadero developer portal and register it via DbSchema's driver manager. The database file extension is typically .gdb or .ib depending on the InterBase version used when the application was built.

Why Use DbSchema with InterBase

• Render InterBase schemas visually for Delphi and C++ Builder application databases
• Inspect stored procedures and triggers without reading raw PSQL source files
• Generate schema documentation for application handover and ongoing maintenance
• Run SQL queries and browse table data without installing a separate ISQL client
• Compare InterBase schemas across application versions to track schema evolution