Finally, a Schema Diagram for Your Pervasive PSQL App

Build a clearer workflow for Pervasive PSQL: 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.

Download DbSchema See Pervasive PSQL Features Download Pervasive PSQL JDBC Driver · All drivers

What happens after you download?

Get to your first Pervasive PSQL schema diagram in minutes. No account, no credit card.

Install in minutes

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

Connect to Pervasive PSQL or open a sample

Reverse engineer an existing Pervasive PSQL database or open a sample model to explore tables, relationships, and indexes.

Design, document, and deploy

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

Get Started Free

Schema Visualization for Point-of-Sale and Manufacturing Databases

Pervasive PSQL — now marketed as Actian PSQL — is a transactional database engine used widely in point-of-sale, retail management, and manufacturing software. Its Btrieve-derived storage engine operates as a local workgroup store or as a client-server installation accessible over the network. Many vertical-market applications have run on PSQL for decades with minimal schema documentation, so the person maintaining the application today is often not the person who originally designed its tables. DbSchema connects via JDBC, renders the SQL schema visually, and helps development teams understand the structure of long-running PSQL applications without digging through the original source code first.

Download DbSchema Free See Pervasive PSQL Features

Load a Pervasive PSQL Schema onto the Diagram Canvas

DbSchema connects to a Pervasive PSQL server using the PSQL JDBC driver and reads the database catalog. Tables, columns, data types, and indexes are displayed in the diagram canvas, providing a visual map of a database that often has no existing schema diagram. Relationships inferred from foreign keys are drawn automatically, giving a starting layout you can then rearrange to match how the application actually groups its data.

Connecting to a Pervasive PSQL server and loading the schema in DbSchema

Write and Run SQL Queries

DbSchema's SQL editor supports the PSQL SQL dialect — including its handling of Btrieve- originated column types and its transaction model. Run queries to validate data, audit records, or investigate application behavior without requiring access to the PSQL Control Center or the host application itself.

SQL editor running a query against a Pervasive PSQL database in DbSchema

HTML Schema Reports for PSQL Migration Planning

DbSchema's documentation generator exports the Pervasive PSQL schema as a navigable HTML report with table listings, column definitions, and relationship diagrams — a practical starting point for migration planning or compliance documentation in industries with long PSQL application lifecycles.

HTML documentation generated from a Pervasive PSQL schema in DbSchema

How to Connect DbSchema to Pervasive PSQL

A short driver setup is the only prerequisite before you can browse a Pervasive PSQL database visually.

Download the Pervasive JDBC driver from the Actian developer portal.
Register the JAR in DbSchema's driver manager.
Start a new connection with host and port 1583 (the default PSQL server port), giving the URL jdbc:pervasive://host:1583/dbname.
Connect — this works for both a local PSQL workgroup engine and a remote PSQL server engine.

On Windows, PSQL also supports an ODBC connection, but the JDBC driver gives DbSchema direct access without requiring an ODBC data source name to be configured on the client machine.

Why Long-Running Apps Rely on DbSchema for PSQL

Visualize PSQL schemas for applications with no prior ER diagram documentation.
Run SQL queries against PSQL databases without the PSQL Control Center utility.
Export schema documentation for legacy system audits and compliance reviews.
Plan migration from PSQL to a modern database by comparing source and target schemas.
Inspect Btrieve-originated column types and constraints in a structured visual editor.

Inherited a Pervasive PSQL application with no schema diagram in sight? Download DbSchema and reverse-engineer its Btrieve-based tables into a documented ER diagram.

Teams working with Pervasive PSQL often use these engines too. Explore dedicated guides and JDBC setup for each.