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

ServiceStack.OrmLite - Fast, Simple, Typed ORM for .NET

•    CSharp

---

Follow @ServiceStack or join the Google+ Community for updates, or StackOverflow or the Customer Forums for support.OrmLite's goal is to provide a convenient, DRY, config-free, RDBMS-agnostic typed wrapper that retains a high affinity with SQL, exposing intuitive APIs that generate predictable SQL and maps cleanly to (DTO-friendly) disconnected POCO's. This approach makes easier to reason-about your data access making it obvious what SQL is getting executed at what time, whilst mitigating unexpected behavior, implicit N+1 queries and leaky data access prevalent in Heavy ORMs.

orm poco c-sharp net-framework net-core sqlserver sqlite postgresql mysql oracle firebird high-performance

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

db - Productive data access layer for Go.

•    Go

---

The upper.io/db.v3 package for Go is a productive data access layer for Go that provides a common interface to work with different data sources such as PostgreSQL, MySQL, SQLite, MSSQL, QL and MongoDB.Take the tour to see real live examples in your browser.

orm database sql upper db postgresql mysql nosql sqlite mongodb dal database-library go-orm

phpMyFAQ - phpMyFAQ - Open Source FAQ system for PHP and MySQL, PostgreSQL and other databases

•    PHP

---

phpMyFAQ is a multilingual, completely database-driven FAQ-system. It supports various databases to store all data, PHP 5.6+ is needed in order to access this data. phpMyFAQ also offers a multi-language Content Management System with a WYSIWYG editor and an Image Manager, real time search support with Elasticsearch, flexible multi-user support with user and group based permissions on categories and records, a wiki-like revision feature, a news system, user-tracking, 40+ supported languages, enhanced automatic content negotiation, HTML5/CSS3 based responsive templates, PDF-support, a backup-system, a dynamic sitemap, related FAQs, tagging, RSS feeds, built-in spam protection systems, OpenLDAP and Microsoft Active Directory support, and an easy to use installation script. phpMyFAQ is only supported on PHP 5.6.0 and up, you need a database as well. Supported databases are MySQL, Percona Server, PostgreSQL, Microsoft SQL Server, SQLite3 and MariaDB. If you want to use Elasticsearch as main search engine, you need Elasticsearch 2.x as well. Check our detailed requirements on phpmyfaq.de for more information.

faq phpmyfaq mysql database postgresql sqlite mssql elasticsearch docker docker-compose

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

Propel - smart easy object persistance in PHP

•    PHP

---

Propel is an open-source Object-Relational Mapping (ORM) for PHP5. It allows you to access your database using a set of objects, providing a simple API for storing and retrieving data. Propel uses PDO as an abstraction layer, and code generation to remove the burden of runtime introspection. Therefore Propel is fast.

orm persistence database-development orm-php

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

querybuilder - SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql and Firebird

•    CSharp

---

SqlKata Query Builder is a powerful Sql Query Builder written in C#. It's secure and framework agnostic. Inspired by the top Query Builders available, like Laravel Query Builder, and Knex.

sql-query-builder sql-server postgresql mysql c-sharp database query-builder sql-query sql activerecord data-access-layer

FluentData -Micro ORM with a fluent API that makes it simple to query a database

•    

---

A simple to use Micro ORM with a great fluent API that makes it simple to select, insert, update and delete data in a database. Supported databases: Microsoft SQL Server, MS SQL Server Compact, MS SQL Azure, Oracle and MySQL.

orm data-access data-access-layer fluent-interface ibm-db2 micro-orm

XORM - eXtra ORM for Go

•    Go

---

Xorm is a simple and powerful ORM for Go.

orm mysql sqlite mssql postgres postgresql tidb database-library go-orm

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

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.

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

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.

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

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

HeidiSQL - A lightweight client for managing MySQL, MSSQL and PostgreSQL, written in Delphi

•    Pascal

---

HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases, PostgreSQL and MariaDB. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data, either to SQL file, clipboard or to other servers. Read about features or see some screenshots. Look at the online help page for learning how to use HeidiSQL.

mysql delphi mssql postgresql sql mariadb

dbeaver - Free universal database tool and SQL client

•    Java

---

Free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports any database which has JDBC driver (which basically means - ANY database). EE version also supports non-JDBC datasources (WMI, MongoDB, Cassandra, Redis). You can download prebuilt binaries from official web site or directly from GitHub releases.

sql database dbeaver gui mysql postgresql oracle db2 sqlite erd