FREE

SQOL - Universal SQL Console

Query Legacy & Modern Databases from Your Browser

Universal SQL console for DB2, Oracle, MySQL, PostgreSQL, and mainframe databases. Work with your data anywhere — from mainframes to the cloud — in one secure, zero-install tool. Run queries, explore schemas, migrate data, and generate APIs from your browser.

✓No license required

✓On-premise installation

Universal Database Console Features

Professional SQL tools for DB2, Oracle, MySQL, PostgreSQL, and mainframe databases

🔍

Schema Browser

Explore database schemas with intuitive navigation and search capabilities.

⚡

SQL Execution

Execute SQL queries with syntax highlighting and result visualization.

📋

Data Migration

Copy schema and data between legacy and modern database systems.

🛡️

Security & Access

Secure connections with role-based access control and audit logging.

Why Choose SQOL SQL Console?

🔗

Unified Database Access

Connect to DB2, Oracle, MySQL, PostgreSQL, mainframe, AS/400, and DB400 databases in a single SQL console interface.

🆓

No License Required

Free to use, whether you run it locally or in the cloud.

🚀

Runs Anywhere

Download the JAR or use the Docker image. No installation headaches.

🛡️

Secure by Default

Enterprise-grade security for peace of mind.

Prerequisites

Ensure you have the necessary requirements before getting started with SQOL

⚙️

Installation Options

Choose one of the following installation methods:

☕ Java Installation

Java 17 or higher, installed and configured as JAVA_HOME. Supported on any operating system (server or desktop) that runs Java 17.

🐳 Docker Installation

Docker installed and running.

🌐

Network & System Access

✓

License

A valid OpenLegacy Community application license (available under your user profile).

✓

TCP/IP Connectivity

Connectivity to your Mainframe or AS/400

✓

System Details

IP/hostname and port of your legacy system

✓

Database Access

User ID and password for your database of choice.

DB2-specific requirement: IBM DB2 license JAR must be available.

✓

Browser

Latest version of Chrome, Edge, Safari, or Firefox.

Connect to OpenLegacy Hub for More

🔗

Turn SQL Into APIs

Auto-generate REST endpoints from your SQL queries. Intelligent parameter mapping and built-in documentation.

🔄

Streamline Data Workflows

Visual ETL & CDC pipeline builder. Manage extract–transform–load and change-data-capture processes without writing code.