Design and Manage Ingres Databases with DbSchema

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

DbSchema is built for visual modeling, schema documentation, and deployment. 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 Ingres Features Download Ingres JDBC Driver

What happens after you download?

Get to your first Ingres 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 Ingres or open a sample

Reverse engineer an existing Ingres 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

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.

Download DbSchema Free See Ingres Features

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