Design and Manage Pervasive PSQL Databases with DbSchema

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.

DbSchema Database Designer

Download DbSchema See Pervasive PSQL Features Download Pervasive PSQL JDBC Driver

What happens after you download?

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

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

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. DbSchema connects via JDBC, renders the SQL schema visually, and helps development teams understand the structure of long-running PSQL applications.

Download DbSchema Free See Pervasive PSQL Features

Connect to Pervasive PSQL and Load the Schema

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.

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

Generate Schema Documentation

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

Connecting DbSchema to Pervasive PSQL

The JDBC URL format is jdbc:pervasive://host:1583/dbname, where 1583 is the default PSQL server port. Download the Pervasive JDBC driver from the Actian developer portal and register the JAR in DbSchema's driver manager. The driver supports both local connections to a PSQL workgroup engine and remote connections to a PSQL server engine. On Windows, PSQL also supports an ODBC connection, but the JDBC driver provides direct access without requiring an ODBC data source name to be configured on the client machine.

Why DbSchema for Pervasive 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.