DBeaver - Universal SQL Manager and SQL Client

•    Java

---

DBeaver is a multi-platform database tool for developers, SQL programmers, database administrators and analysts. It supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc. Its feature include metadata editor, SQL editor, rich data editor, ERD, data export/import/migration, SQL execution plans, etc.

database-tool database-management database-administration sql-client

falcon - Free, open-source SQL client for Windows and Mac 🦅

•    Javascript

---

Falcon is a free, open-source SQL editor with inline data visualization. It currently supports connecting to RedShift, MySQL, PostgreSQL, IBM DB2, Impala, MS SQL, Oracle, SQLite and more (for connecting to Oracle, please, see here the instructions to install the required free Oracle Instant Client). Visit plot.ly to learn more or visit the Plotly forum.

electron visualization plotly sql mysql-client postgresql falcon redshift postgres elasticsearch drill s3 persistent connector

Mongify - Data translator system for moving your SQL data to MongoDB

•    Ruby

---

Mongify allows you to map your data from a sql database and into a mongodb document database. It supports MySQL, PostgreSQL, SQLite, Oracle, SQLServer, and DB2.

mysql-to-mongodb database-import database-tools

OmniDB - Web tool for database management

•    Python

---

OmniDB is a browser-based tool that simplifies database management focusing on interactivity, designed to be powerful and lightweight. It supports Tree view showing database structure, Powerful table creation, Syntax highlighting for SQL, SQL code completion for table columns and subquery, Graphs displaying complete ER diagram, Visualization of explain plan and lot more.

database-management dbms database-tools database-admin db-admin

Oracle, ODBC, DB2-CLI Template Library

•    C++

---

Oracle, ODBC, DB2-CLI Template Library (OTL). Provides C++ stream like interface to relational databases (SQL), like Oracle, MS SQL Server, DB2, MySQL, PostgreSQL, Interbase, etc. Multi-database, multi-platform, portable, high performance.

linq2db - Linq to database provider.

•    CSharp

---

LINQ to DB is the fastest LINQ database access library offering a simple, light, fast, and type-safe layer between your POCO objects and your database.Architecturally it is one step above micro-ORMs like Dapper, Massive, or PetaPoco, in that you work with LINQ expressions, not with magic strings, while maintaining a thin abstraction layer between your code and the database. Your queries are checked by the C# compiler and allow for easy refactoring.

database orm sql access db2 firebird informix mysql oracle postgresql sap-hana sqlce sqlite mssql mariadb c-sharp

System Architect

•    C++

---

Cross-platform System Architecting tool; ERD (logical/physical), SQL editor, and UML. MySQL, PostgreSQL, DB2, Firebird, MS SQL, Interbase, Oracle, Sybase, etc. Linux, XP, OSX, Solaris, etc. Developed with Qt, ODBC.

usql - universal command-line interface for SQL databases

•    Go

---

usql is a universal command-line interface for PostgreSQL, MySQL, Oracle, SQLite3, Microsoft SQL Server, and other databases.The below is a demonstration using usql with xo's booktest simple test database, showcasing the release version v0.5.0. In the demonstration, usql connects to a PostgreSQL database, executes some queries, with variable interpolation, connects to a SQLite3 database file, and does some more queries, before then connecting to a Microsoft SQL database and ending the session.

sql postgresql mysql sqlite3 command-line microsoft-sql-server oracle-database cli

SchemaSpy - Graphical Database Schema Metadata Browser

•    Java

---

SchemaSpy analyzes database metadata to reverse engineer dynamic Entity Relationship (ER) diagrams. It works with just about any JDBC-compliant database (Oracle/MySQL/DB2/SQL Server/PostgreSQL/Sybase/etc) and can identify Ruby on Rails relationships.

documentation sql-documentation

Job Scheduler

•    Java

---

The Job Scheduler is used for automation - for example, process automation using the free database systems MySQL, PostgreSQL or Firebird or using SQL Server, Oracle or DB2. You can use the Job Scheduler to launch executable files and shell scripts and to run database procedures automatically. Jobs are configurable as Web Services providing interoperability with enterprise applications.

scheduler job-scheduler web-interface webservice

falcon-sql-client - Free, open-source SQL client for Windows and Mac 🦅

•    Javascript

---

Falcon in a free, open-source SQL editor with inline data visualization. It currently supports connecting to RedShift, MySQL, PostgreSQL, IBM DB2, Impala, MS SQL, and SQLite. Visit plot.ly to learn more or visit the Plotly forum.

electron visualization plotly sql mysql-client postgresql falcon redshift postgres elasticsearch drill s3 persistent connector

Eclipse SQL Explorer [RCP/Plugin]

•    Java

---

Eclipse SQL Client for database querying/browsing any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2, MySQL, PostgreSQL, Sybase, Informix) and can be extended.

DbNetData

•    CSharp

---

A collection of cross vendor database interface classes for .NET written in C# providing a consistent and simplified way of accessing SQL Server, SQL Server CE,Oracle,Access,Access 2007,MySql,DB2,Visual FoxPro,dBASE,Paradox,Pervasive,Firebird,VistaDB and Postgresql databases.

database access access-2007 data-access data-access-layer

sqitch - Sane database change management

•    Perl

---

Sqitch is a database change management application. It currently supports PostgreSQL 8.4+, SQLite 3.7.11+, MySQL 5.0+, Oracle 10g+, Firebird 2.0+, Vertica 6.0+, Exasol 6.0+ and Snowflake. Sqitch is not integrated with any framework, ORM, or platform. Rather, it is a standalone change management system with no opinions about your database engine, application framework, or your development environment.

sqitch postgresql mysql sqlite exasol vertica firebird oracle snowflake

DBShield - Database firewall written in Go

•    Go

---

Protects your data by inspecting incoming queries from your application server and rejecting abnormal ones. By adding DBShield in front of database server we can protect it against abnormal queries. To detect abnormal queries we first run DBShield in learning mode. Learning mode lets any query pass but it records information about it (pattern, username, time and source) into the internal database.

sql-injection database mysql db2 postgresql mariadb oracle

fatfree - A powerful yet easy-to-use PHP micro-framework designed to help you build dynamic and robust Web applications - fast!

•    PHP

---

Condensed in a single ~65KB file, F3 (as we fondly call it) gives you solid foundation, a mature code base, and a no-nonsense approach to writing Web applications. Under the hood is an easy-to-use Web development tool kit, a high-performance URL routing and cache engine, built-in code highlighting, and support for multilingual applications. It's lightweight, easy-to-use, and fast. Most of all, it doesn't get in your way. F3 supports both SQL and NoSQL databases off-the-shelf: MySQL, SQLite, MSSQL/Sybase, PostgreSQL, DB2, and MongoDB. It also comes with powerful object-relational mappers for data abstraction and modeling that are just as lightweight as the framework. No configuration needed.

datamapper cache-engine route-handler template-engine html-template sql-engine sql-mapper database-engine php-template

Aura.SqlQuery - Independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.

•    PHP

---

Provides query builders for MySQL, Postgres, SQLite, and Microsoft SQL Server. These builders are independent of any particular database connection library, although PDO in general is recommended. This package is installable and PSR-4 autoloadable via Composer as aura/sqlquery.

query-builder mysql postgresql microsoft-sql-server sqlite

Hibernate - Relational Persistence for Java

•    Java

---

Hibernate facilitated the storage and retrieval of domain objects via Object/Relational Mapping. Today, Hibernate is a collection of related projects enabling developers to utilize POJO-style domain models in their applications in ways extending well beyond Object/Relational Mapping.

orm persistence database-development orm-java

soci - SOCI - The C++ Database Access Library. This is official repository the SOCI project.

•    C++

---

Originally, SOCI was developed by Maciej Sobczak at CERN as abstraction layer for Oracle, a Simple Oracle Call Interface. Later, several database backends have been developed for SOCI, thus the long name has lost its practicality. Currently, if you like, SOCI may stand for Simple Open (Database) Call Interface or something similar. SOCI library is distributed under the terms of the Boost Software License.

cplusplus database-library oracle postgresql mysql odbc db2 firebird sqlite3 boost

JavaDB

•    Java

---

Java DB is Sun's supported distribution of the open source Apache Derby 100% Java technology database. It is fully transactional, secure, easy-to-use, standards-based — SQL, JDBC API, and Java EE — yet small, only 2.5 MB.

database relational transactional