Open Source SQL Clients - Page 6

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.

athenaSQL is Athena SQL query builder, inspired by sparkSQL. It borrow some sparkSQL’s concept sparkSQL. It was initially designed to eliminate the need for hard-coding SQL queries as strings within Python scripts and as an alternative to any bespoke SQL query templating. However, it offers the flexibility to be used in various ways as needed.

Generic C++ SQL client wrapper over different SQL DB engines. Using a unified interface, it currently supports MySQL/MariaDB, ODBC, PostgreSQL and SQLite.

An easy to use sql client gui.

A small .NET application that allows you to connect to the Microsoft Access database files (*. mdb) and execute SQL-queries to them. More information in russian can be fount here - http://2lx.ru/2009/02/mdb-sql-client/

pgtyped brings type safety to SQL queries in TypeScript by parsing SQL files and generating typed query functions. It analyzes SQL against your PostgreSQL schema and outputs TypeScript code that ensures inputs and results are correctly typed. This allows teams to use raw SQL while retaining the safety and developer experience of TypeScript.

pg_probackup is an advanced backup and recovery tool for PostgreSQL developed by PostgresPro. It supports full, incremental, and differential backups with compression and encryption, and provides fine-grained control over backup and restore processes. It’s designed for enterprise-grade backup strategies in PostgreSQL environments.

Lightweight SQL querying tool written in Java. Connects to any JDBC compliant database and will run on any OS with a Java VM. Features: keyword highlighting, result formatting, statement history, multi-window, multiple database connects at one time.

repmgr is a management tool for PostgreSQL replication, providing monitoring, failover, and administrative capabilities for streaming replication setups. It simplifies the configuration of primary/standby clusters and automates failover processes for high availability. repmgr is widely used in production environments where database resilience and minimal downtime are critical.

Schemats is a TypeScript code generator that creates type definitions from existing PostgreSQL schemas. It helps developers working with raw SQL or query builders to maintain strong typing and avoid runtime errors. By analyzing database schemas, Schemats bridges the gap between relational databases and TypeScript-based applications.

SQL editor, execution of scripts, export results (.xls).

SQL editor console for MS-Access Database Requires MS .NET Framework 2.0

sqldef is a schema migration tool that automatically generates SQL migration statements by comparing database schemas. Instead of writing migrations manually, developers define the desired schema, and sqldef computes the difference. It's compatible with MySQL, PostgreSQL, SQLite, and others, making migrations safer and more maintainable.

SQLSmith is a fuzz testing tool for PostgreSQL that automatically generates random SQL queries to uncover bugs in the query planner and executor. It is widely used by PostgreSQL developers and database vendors to stress-test SQL features and engine behavior under edge-case conditions. SQLSmith helps improve database robustness by revealing unexpected failures.

sqsh2 is a database independent sql client for terminal environment of Unix/Linux (~isql) with 1) command history 2) command editing via vi 3) shell integration 4) multiple db connections. sqsh2 is inspired by sqsh (Thank you Scott).

DBGet is a light-weight database Schema Browser and SQL Editor for Sybase, Oracle, SQL Server & IBM DB2 databases.