Design and Manage Ingres Databases Visually with DbSchema

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

DbSchema Database Designer

Download DbSchema Download Ingres JDBC Driver

Exploring Legacy Ingres Schemas with a Modern Visual Tool

Ingres is one of the foundational relational database systems in computing history, and its architectural concepts influenced many modern databases including PostgreSQL. Despite its age, Ingres (now developed by Actian as part of the OpenIngres lineage) remains in production in government, financial, and industrial environments. DbSchema provides a modern visual interface for Ingres schema structures, making it practical to explore and document legacy database systems that often lack contemporary tooling.

ER Diagrams for Ingres Database Schemas

DbSchema connects to Ingres via JDBC and reads table definitions, column metadata, and constraint information from the system catalogs. The resulting ER diagram gives your team a clear picture of the database structure — particularly valuable when onboarding developers to an inherited Ingres system with little existing documentation.

Creating an ER diagram for an Ingres database schema in DbSchema

SQL Client for Ingres and OpenIngres

The DbSchema SQL editor supports Ingres SQL syntax, allowing you to run queries and inspect data directly from the application. This is especially useful for teams working with Ingres where terminal-based tools like isql are often the only available alternative to writing queries blind.

Running Ingres SQL queries in DbSchema's SQL editor

Schema Documentation for Legacy Ingres Systems

Documentation for legacy Ingres databases is often sparse or outdated. DbSchema generates current, accurate HTML documentation directly from the live schema, capturing table structures, column definitions, and relationships — providing a reliable reference for maintenance teams or migration planning projects.

Auto-generated Ingres schema documentation in DbSchema

Connecting DbSchema to Ingres

Ingres listens on port 21064 by default. The JDBC URL format is: jdbc:ingres://host:21064/dbname. The JDBC driver class is com.ingres.jdbc.IngresDriver. Download the Ingres JDBC driver from the Actian Corporation download page and add the JAR via DbSchema's driver manager under Connections > Manage Drivers. Ensure the Ingres network server (ingstart with networking enabled) is running and that the database name matches the installed Ingres instance name exactly.

Why DbSchema for Ingres

  • Explore and document legacy Ingres schemas with a modern graphical interface
  • Generate up-to-date schema documentation for maintenance and migration projects
  • Run Ingres SQL queries from a desktop client without relying on terminal tools
  • Identify undocumented relationships and constraints in inherited Ingres systems
  • Export schema diagrams for team knowledge transfer when working with legacy systems