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.

SQLTools is a light weight and robust frontend for Oracle database development. This program is not so comprehensive as Tora or TOAD but it is ideal when you need basic data querying capabilities and objects browsing. It also supports a basic subset of SQL*Plus commands (connect/disconnect, bind and define variables). The program is developed and tested on Windows 10, and is fully compatible with Windows 7 and Windows 11. It is distributed in two versions: a 32-bit build and a 64-bit build. A properly installed Oracle Client is required. The required client architecture (32-bit or 64-bit) must match the program version being used. Supported Oracle Client versions include 12c and 19c. The program may also work with 11g and 21c, although these versions are not tested. https://www.oracle.com/database/technologies/instant-client/downloads.html Check http://www.sqltools.net for more information, https://sqltools.net/smf20/index.php?topic=866.0 for development progress and n

DB Explorer is a free, cross-platform database query tool and schema explorer built for developers, DBAs, and data analysts. It provides a clean graphical interface for connecting to multiple database systems, writing and executing SQL, exploring schemas, monitoring database health, and generating SQL queries using AI — all from a single application. Supported Databases: PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite, Amazon DynamoDB, and any JDBC-compatible database.

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

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.

An open-source SQL editor write in Java.

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.

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.

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.