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

Beekeeper Studio - Open Source SQL Editor and Database Manager

•    Javascript

---

The smoothest, best looking, and easiest to use SQL client for MySQL, Postgres, SQLite, SQL Server, Red shift, MariaDB, CockroachDB and more.

database-manager sql-editor database-tools electron mysql sql sql-server database sqlite postgresql database-management

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

Coolstorage - ORM library for .NET

•    CSharp

---

The main strength of Vici CoolStorage is the ease of use. Most ORM tools still require a lot of unneeded code to accomplish basic data persistence tasks, but Vici CoolStorage is designed to relieve the programmer from these tedious and error-prone tasks, making it very intuitive to use.

orm persistence database-development datamapper ormdotnet

SQL Operations Studio - Data management tool that enables working with SQL Server, Azure SQL DB and SQL DW

•    TypeScript

---

SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. Its feature include SQL Server Connection Management with Connection Dialog, Server Groups, Azure Integration and Registered Servers, T-SQL Query Editor with advanced coding features such as autosuggestions, error diagnostics, tooltips, formatting and peek definition, Management Dashboard supporting customizable widgets with drill-through actionable insights and lot more.

database-management dbms database-tools

PostGIS - Spatial and Geographic objects for PostgreSQL

•    C

---

PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL. PostGIS adds extra types (geometry, geography, raster and others) to the PostgreSQL database. It also adds functions, operators, and index enhancements that apply to these spatial types.

database geospatial-database spatial-database geospatial geospatial-analytics postgresql-extension

php-crud-api - Single file PHP script that adds a REST API to a SQL database

•    PHP

---

Single file PHP 7 script that adds a REST API to a MySQL 5.6 InnoDB database. PostgreSQL 9.1 and MS SQL Server 2012 are fully supported. NB: This is the TreeQL reference implementation in PHP.

api-server restful mysql geospatial postgresql php-api postgis crud rest-api openapi swagger automatic-api database multi-database sql-database ubuntu-linux geojson sqlserver

Command-Line Database Builder

•    

---

A command-line tool for interacting with a DBMS command-line interface (e.g., sqlcmd.exe) to execute a sequential list of SQL scripts against the DBMS. Tool allows for expression replacement in the SQL scripts during execution.

build build-tools command-line database-build-tools database-tools sql-server

JavaScript SQL (JSSQL)

•    Javascript

---

A database engine entirely in JavaScript (AJAX)

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

pgAdmin - Administration and development platform for PostgreSQL

•    C

---

pgAdmin is the most popular and feature rich administration and development platform for PostgreSQL. It is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more.

postgresql-admin database-admin database-tools postgresql-tools postgresql-management postgresql-gui database-management

Prisma - Next-generation ORM for Node.js and TypeScript

•    Typescript

---

Prisma helps app developers build faster and make fewer errors with an open source ORM for PostgreSQL, MySQL and SQLite. It makes database access easy with an auto-generated and type-safe query builder that's tailored to your database schema. It provides an alternative to traditional ORMs and SQL query builders.

mysql postgres mongo sql-server orm database mongodb sqlite postgresql mariadb mssql sqlserver mongodb-orm prisma-client nodejs-orm rest-api database-migration

ByteBase - Web-based, zero-config, dependency-free database schema change and version control tool for teams

•    Go

---

Bytebase is a web-based, zero-config, dependency-free database schema change and version control management tool for developers and DBAs. It is for developers to collaborate on database schemas changes. It helps to construct a single pipeline to propagate the schema change across multiple environments. It can also store the schemas in VCS and trigger a new pipeline upon commit push.

mysql devops gitlab schema sql frontend clickhouse dml postgresql snowflake ddl dba tidb database-as-code sqlreview schema-changes gitops schema-migration database-migration

PHPMyAdmin

•    PHP

---

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

database-front-end adminstration tool mysql-admin mysql-management mysql-tool

Chinook Database

•    

---

Chinook is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script. Chinook database is an alternative to the Northwind database, being ideal for demos and testing ORM tools targeting single and multiple database servers.

database sql-server database-tools effiproz mysql oracle sample-databases

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

PolarDB - Share-nothing, Distributed database based on PostgreSQL

•    C

---

PolarDB for PostgreSQL (PolarDB for short) is an open-source database system based on PostgreSQL. It extends PostgreSQL to become a share-nothing distributed database, which supports global data consistency and ACID across database nodes, distributed SQL processing, and data redundancy and high availability through Paxos based replication.

database distributed-database rdbms postgresql

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

SQLx - The Rust SQL Toolkit

•    Rust

---

SQLx is an async, pure Rust SQL crate featuring compile-time checked queries without a DSL. It is truly Asynchronous. Built from the ground-up using async/await for maximum concurrency. It has support for PostgreSQL, MySQL, SQLite, and MSSQL.

mysql postgres sql async sqlite postgresql mariadb mssql await orm sql-builder connection-pool

VisualDB (Database Management using Visual WebGui)

•    CSharp

---

VisualDB is a Database Management created using Visual WebGui and actually support SQL Server 2000-2005 and MySQL 5.

sql-server ajax database database-tools mysql sql-server-2005