Open Source SQL Clients - Page 5

SQL-Kitten is a generic sql client written in Java that can be used to connect to any jdbc compliant database. Some features are: Run SQL queries, Search within resultsets, Easy insert/update/delete, insert/update CLOB and BLOB datatype

SQLAdHoc - the better SQL-Editor

It allows you to connect with Management System Relational Databases such as Oracle, MySql, PostgreSQL .. It allows you to create database tables .. and manipulate data (read, create, update, delete) already stored in the tables. It shows the time excusion of the applications, to execute SEVERAL queries at once ....

SQLMinus - "sqlplus minus the pain". This SQL Client (Java) is very configurable, completes table and column names upon tabbing. Completes other words and abbrevs (vi-style). Powerful auto-linking across tables. Powerful auto-joining across tables.

This program connects to a users MSSQL Database, and searches it entirely for a search string. When finished, the results are populated in the log as preformatted queries that can be copy/pasted into SSMS for additional analysis.

sqler is a lightweight API gateway that automatically exposes your SQL database as a RESTful API. It allows developers to run parameterized SQL queries safely over HTTP, turning databases into microservices without writing backend code. sqler is great for prototyping, dashboards, and internal tools with quick database integration.

DB Copy Plugin is a plugin for the SQuirreL SQL Client (1.2beta6 and 2.0 RC1+) that allows copying database objects (schema def and data) from one session window to another. The sessions can be disparate database vendors (Oracle -> MySQL, for instance).

Built for power and simplicity, Saltwater SQL Client allows the experienced Oracle Guru to perform magic, yet is simple enough for a novice to use. Features: PL/SQL, CLOB tools, import/export, table edit, data dictionary, multiple connections/queries

SQL editor for Oracle, MS-SQL, CA-Ingres, InterBase, Access, MySQL, PostgreSQL, etc. Table structures, indexes, exec. plans! Syntax highlight. CTRL+Space: commands and tables. Creates SELECT, INSERT, UPDATE, and DELETE. In english, french or portuguese.

Simple java based command line SQL editor. Will connect to any database that you can provide a JDBC Type 4 driver for (in the form of a jar).

Relational Algebra is a very important formal language associated with relational databases. This is why most of the universities have Relational Algebra as an integral part of their database management courses. But unfortunately, most of the traditional relational DBMS software tools support Structured Query Language (SQL) only. For a student it is very difficult to know whether a relational algebra query written on paper is correct or not. Also as an instructor it is difficult to evaluate an innovative relational query because same result can be gained by different ways. Springbok is a free (non-commercial) educational tool to execute/validate relational algebra queries. Students, Instructors or any other interested parties can verify a relational algebra query by executing it through the Springbok.

Sqimplex is a visual SQL client made for simple manipulation with SQL data for Oracle database platform (maybe later even other ones). Sqimplex is created in Delphi and runs on Windows Vista or later.

Sqled is a simple sql editor to write and execute sql and ddl commands, and shows query results in a grid table view. It helps user with sintax highliting and table list selection.

SqlKata is a powerful and elegant SQL query builder for .NET that provides a fluent, expressive syntax to construct complex SQL queries programmatically. It supports multiple database engines and can compile queries to raw SQL with parameters, making it easy to integrate with Dapper or ADO.NET. SqlKata emphasizes flexibility and readability, enabling developers to write maintainable and reusable query logic.

This plugin is to allow a developer to introspect a BLOB column via the Squirrel SQL client. The initial focus will be on viewing Java objects but this will be expanded as time goes on.

Supavisor is a high-performance Postgres connection pooler designed for multi-tenant environments, built in Rust by the Supabase team. It acts as a gateway that routes and manages database connections for each tenant, supporting row-level isolation and optimized connection sharing. Supavisor is ideal for SaaS platforms needing efficient, scalable multi-tenancy over PostgreSQL.

A low weight replacement for TOAD. Java based app had tabbed UI to support multiple connections.

The interface supports drag and drop HTML components, javascript and scriptlet events, and generate a very fast code, with no additional softwares layers or libraries. You can put your libraries, like jQuery. The generated code works with all browsers. You can create and debug Applets or Java Swing applications easily with the Visual Editor of the tool. Build C++ applications.

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.

Vela is a Open Source SQL and PL/SQL client software for Oracle database with a graphical user interface developed using Java Swing. It is a Front-End tool for a Oracle developer. It supports most of the common developer tasks.

ViennaSQL is a GUI SQL client written in 100% Java. ViennaSQL can communicate with any database that has a JDBC driver. It should run anywhere Java runs.

Feature rich web based SQL Server Explorer and Management Tool. Dynamic forms, DDL/Data script generator and Structure and data comparision tool. Tabbed AJAX/Atlas driven smart web based SQL Editor.

Web SQL Client is a light-weight HTTP server allowing an end-user to access JDBC data sources via generated data entry screens. It has purposely been designed to be used with standard web browsers wireless tablet PCs and is highly configurable. WebSQLClient is capable of connecting to any JDBC datasource. Its main purpose is to provide rapid data model driven development. The WebSQLClient data entry forms are generated by querying the database system table information, but can alternatively be configured manually. WebSQLClient comprises a database agnostic data load utility (SQLLoader), a data unload tool (SQLExport) and SQL scripting capabilities. The application is a combination of a Java based multi-threaded webserver and HTML and Java Script. The major technology used comprises : Java, jQuery, jQuery UI, jqGrid, XML, JSON, Ajax and JDBC. WSQLC’s main components are the WSQLC server and dynamically created HTML pages. 27-May-2012 : Release 1.0 code and manual available

with_advisory_lock is a Ruby gem that provides a simple and thread-safe way to use PostgreSQL advisory locks within Ruby applications. It allows developers to wrap critical code sections with database-level locks to prevent race conditions across concurrent processes or threads. It’s especially useful in distributed systems, background job processing, or scheduled tasks where application-level mutexes aren't sufficient.

AnySQL is a SQL client designed for developers. It has all the required features a developer might need. It's developed with the new ExtJS 5 framework, it's simple to develop and simple to use. It aims to support as many db drivers as possible. For now, the aim is to implement drivers for MySQL, SQLServer and Oracle. You can install it as web app and run it on your server throw the browser or you can get the desktop version and install it as a standalone application.