Open Source PL/SQL SQL Clients

DBeaver is a free, multi-platform database tool that supports any database having a JDBC driver. It is useful for developers, SQL programmers, database administrators and analysts. DBeaver comes with plenty of great features such as metadata and SQL editors, ERD, data export/import/migration and more. Plugins are available for certain databases, and there are also several database management utilities. DBeaver’s Enterprise Edition provides even more features and supports non-JDBC datasources.

TOra is a Toolkit for Oracle which aims to help the DBA or developer of database applications. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a full set of DBA tools. TOra also includes support for MySQL and Postgres.

Squawk is a static SQL linter for PostgreSQL designed to catch common mistakes and enforce query best practices. It analyzes raw SQL files and flags errors, anti-patterns, or style issues before queries are deployed. Squawk is ideal for teams that want to enforce SQL standards in CI pipelines.

pgManage is an open-source, cross-platform desktop GUI for managing PostgreSQL databases. It provides a tabbed interface for browsing schemas, writing queries, and managing server configurations. Designed for both developers and DBAs, pgManage aims to be a user-friendly yet powerful alternative to pgAdmin.

Just use the portable copy of the free sqlitebrowser program, available here : https://sqlitebrowser.org/dl/ to open and test the sample db, that I have given as a download here ( after extracting the zip file ) . Also, I have enclosed, the csv files, that I have used for importing and exporting, from the file menu of the program. Also, watch the video below, for a quick start. Tags: Learn SQL Quickly, Analyze Data Easily, SQL Guide, SQL Samples

DB Explorer is a powerful, cross-platform Java-based database query tool and explorer designed for developers, DBAs, and data analysts. It provides an intuitive GUI for connecting to multiple databases including PostgreSQL, MySQL, SQL Server, Oracle, SQLite and Dynamo DB along with support of connection any of database via Generic JDBC driver. Key features include real-time SQL execution with syntax highlighting, interactive schema browsing, result pagination with lazy loading, query export capabilities, and memory management controls including a garbage collection button. The application includes connection pooling, health monitoring, multiple themes, and keyboard shortcuts.

CrystalDB Tool is used by developers, DBAs and analyst for managing, administering and developing databases. The utility supports the two common database management system, namely MS SQL Server and Oracle. It provides an editor that offers code completion and syntax highlighting for standard SQL. It features a connection browser and a comprehensive set of database administration tools.

This project will add support for editing Oracle PL/SQL objects right inside the NetBeans IDE, including syntax highlighting, code folding and indentation. See Wiki for more information.

An open-source SQL editor write in Java.

temporal_tables is a PostgreSQL extension that adds temporal support to tables by automatically tracking row history. It enables versioned records, letting users query data as it existed at any point in time. This is ideal for audit logging, data versioning, and time-travel queries without needing manual triggers or archive tables.

PL/SQL Editor Plugin for Eclipse using file and database access for auto completion and many standard source editing capabilities of eclipse. Designed to support editing the Oracle based PL/SQL language. Written in java, supported on all platforms.