See Oracle-Compatible EPAS Schemas as an Interactive Diagram

EDB Postgres Advanced Server is PostgreSQL built out for the enterprise, with an Oracle compatibility layer on top. DbSchema connects through the standard PostgreSQL driver and diagrams EPAS schemas — packages, synonyms, and Oracle-compatible objects included.

Reuse the PostgreSQL JDBC driver your team already trusts
Put schemas full of packages and synonyms on a readable diagram
Run PL/pgSQL and Oracle-flavored SQL — CONNECT BY, ROWNUM — side by side
Hold development, test, and production to the same reviewed schema

available for

ISO-27001 certified

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

Free Download

DbSchema diagramming an EDB Postgres Advanced Server schema

Trusted by teams at

Half the Team Thinks in Oracle,
Half Thinks in Postgres

Teams usually arrive at EPAS mid-journey from Oracle. The schema mixes VARCHAR2 with native Postgres types, packages sit beside PL/pgSQL functions, and DBAs from both worlds have to reason about the same objects with different instincts.

A shared diagram settles the vocabulary problem: everyone sees the same tables, packages, and synonyms, whatever dialect they think in.

Model, Edit & Align
EPAS Across Environments

Design-side tooling for the database carrying your most regulated workloads.

Reverse engineer EPAS schemas with Oracle-compatible objects

Packages and Synonyms, on the Map

Reverse-engineer EPAS schemas into diagrams that keep Oracle-compatible objects visible — a data model both your Postgres and Oracle people can read.

Write PL/pgSQL and Oracle-compatible SQL against EPAS

Two Dialects, One Editor

Test PL/pgSQL and Oracle-compatible statements — hierarchical CONNECT BY queries, ROWNUM pagination, package calls — with completion for tables, views, and functions.

Compare EPAS schemas across development, test, and production

Environments That Stop Drifting

Diff the model against each EPAS instance, review the differences, and apply a migration script you have read — the audit trail writes itself.

Documentation for the Auditors
Access for Nobody Extra

Regulated industries run on EPAS — and on evidence. Export the schema as interactive HTML5 documentation with searchable diagrams and column comments, and compliance reviewers browse the data model without an account on any database server.

Open the Documentation Tool

HTML5 documentation of an EPAS schema generated by DbSchema

EPAS Connection Facts

EPAS speaks the PostgreSQL protocol, so the standard driver (org.postgresql.Driver) that ships with DbSchema is all you need. The default listener port is 5444 — unlike community PostgreSQL's 5432 — giving a URL such as jdbc:postgresql://localhost:5444/mydb. For TDE-enabled clusters, append ?ssl=true so the connection uses SSL; for HA deployments, point DbSchema at the EDB Failover Manager virtual IP or a PgBouncer pool that handles failover transparently. See the EnterpriseDB JDBC driver page for setup.