Design and Manage EnterpriseDB (EDB) Databases with DbSchema

Build a clearer workflow for EnterpriseDB (EDB): reverse engineer existing schemas into interactive ER diagrams, model changes visually, and generate reviewed SQL scripts before deployment.

DbSchema is built for relational modeling, migration planning, and SQL-first collaboration. Keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.

DbSchema Database Designer

Download DbSchema See EnterpriseDB (EDB) Features Download EnterpriseDB (EDB) JDBC Driver

What happens after you download?

Get to your first EnterpriseDB (EDB) schema diagram in minutes. No account, no credit card.

1
Install in minutes

Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.

2
Connect to EnterpriseDB (EDB) or open a sample

Reverse engineer an existing EnterpriseDB (EDB) database or open a sample model to explore tables, relationships, and indexes.

3
Design, document, and deploy

Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.

Get Started Free

PostgreSQL-Compatible Architecture with Oracle Extensions

EDB Postgres Advanced Server (EPAS) is an enterprise-grade PostgreSQL-compatible database developed by EnterpriseDB, designed to ease migrations from Oracle while providing the reliability and ecosystem of PostgreSQL. Beyond standard PostgreSQL features, EPAS adds an Oracle compatibility layer that includes Oracle-style packages, procedures with OUT parameters, autonomous transactions, triggers with Oracle syntax, and a subset of Oracle built-in functions. Security enhancements such as Transparent Data Encryption (TDE), the edb_audit extension for compliance logging, and the EDB Failover Manager (EFM) for automatic HA round out the enterprise feature set. DbSchema connects using the standard PostgreSQL JDBC driver and renders EPAS schemas — including schemas that contain packages, synonyms, and Oracle-compatible objects — as visual diagrams.

Download DbSchema Free See EnterpriseDB (EDB) Features

Querying with Oracle-Compatible Syntax and PL/pgSQL

EPAS supports both standard PL/pgSQL and Oracle's PL/SQL dialect for stored procedures and functions, and both are accessible through the PostgreSQL JDBC driver. DbSchema's SQL editor connects over the standard PostgreSQL protocol on port 5444 (EPAS's default) and provides auto-completion for tables, views, functions, and packages. You can write and execute Oracle-compatible CONNECT BY hierarchical queries, use ROWNUM pagination, and call EPAS packages directly from SQL statements. The editor displays results in a paginated grid and supports multi-statement execution, making it practical to test stored procedure calls alongside their dependent queries.

DbSchema SQL editor writing Oracle-compatible SQL and PL/pgSQL against EnterpriseDB EPAS

Exploring EDB Tables, Packages, and Procedures

The DbSchema data explorer lets you browse EDB table contents interactively, with filter and sort controls that work across all EPAS data types including Oracle-compatible VARCHAR2, NUMBER, and DATE type aliases. From the schema diagram you can navigate directly to any table's data, or drill into package definitions to review procedure signatures and default values. This is particularly valuable during Oracle-to-EPAS migrations: you can validate that migrated table rows match the expected format and that package procedures compile and execute correctly in the EPAS environment.

Exploring EnterpriseDB EPAS tables and migrated Oracle data with DbSchema data explorer

Connection Setup and JDBC URL

DbSchema connects to EnterpriseDB Postgres Advanced Server using the standard PostgreSQL JDBC driver (org.postgresql.Driver). The JDBC URL format is jdbc:postgresql://localhost:5444/mydb, where port 5444 is EPAS's default listener port (distinguishing it from community PostgreSQL's default 5432). Supply an EDB username and password with the required schema privileges in the connection dialog. For TDE-enabled clusters, ensure the JDBC connection uses SSL by appending ?ssl=true to the URL. The EDB Failover Manager operates independently of the JDBC connection; for HA deployments, point DbSchema at the EFM virtual IP or a PgBouncer connection pool that handles failover transparently.

EnterpriseDB EDB schema documentation with Oracle-compatible objects generated by DbSchema

Why Teams Use DbSchema with EnterpriseDB

  • Visualize EPAS schemas including Oracle-compatible packages, synonyms, and type definitions in a schema diagram that communicates the full data model to both PostgreSQL and Oracle-experienced developers.
  • Write and test Oracle-compatible SQL and PL/pgSQL stored procedures in DbSchema's SQL editor during Oracle-to-EPAS migration projects.
  • Explore migrated data in the EDB data explorer to validate row counts, data types, and column values after schema migration scripts have run.
  • Generate schema documentation for EPAS databases to support compliance audits and architecture reviews in regulated industries.
  • Connect to EPAS using the same PostgreSQL JDBC driver already configured for community PostgreSQL, minimizing driver management overhead.
  • Use DbSchema's diff feature to compare source Oracle schemas with target EPAS schemas and identify objects that still require migration.