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.

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.

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.

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.

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.

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.

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.