User Experience on mobile might not be great yet, but I'm working on it.

Your first time on this page? Allow me to give some explanations.

Awesome Database Tools

Everything that makes working with databases easier

Here you can see meta information about this topic like the time we last updated this page, the original creator of the awesome list and a link to the original GitHub repository.

Last Update: Dec. 2, 2020, 9:04 a.m.

Thank you mgramin & contributors
View Topic on GitHub:
mgramin/awesome-db-tools

Search for resources by name or description.
Simply type in what you are looking for and the results will be filtered on the fly.

Further filter the resources on this page by type (repository/other resource), number of stars on GitHub and time of last commit in months.

IDE

Free universal database tool and SQL client

16.78K
1.51K
3d
Apache-2.0

State of the art MongoDB IDE

772
44
1y 6m
AGPL-3.0

A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL and SQLite, written in Delphi

2.26K
253
1d
GPL-2.0

TOra is an open source SQL IDE for Oracle, MySQL and PostgreSQL dbs

235
43
17d
n/a

Premier multi-purpose admin tool for database management, control and development.

Aqua Data Studio is productivity software for Database Developers, DBAs, and Analysts.

Multiple database management tool with support for 20+ databases.

Cross-Platform IDE for Databases & SQL by JetBrains.

Universal IDE for MySQL and MariaDB database development, management, and administration.

Powerful IDE for Oracle management, administration, and development.

GUI tool for managing and developing databases and objects.

Powerful integrated development environment for SQL Server development, management, administration, data analysis, and reporting.

Comprehensive GUI tool for Firebird and InterBase.

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.

A database development tool that allows you to simultaneously connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application.

Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments.

The most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

Long Term Support for pgAdmin3.

IDE that is specifically targeted at the development of stored program units for Oracle Databases.

Complete and powerful database management, admin and development tool for PostgreSQL.

Toad is the premier database solution for developers, admins and data analysts. Manage complex database changes with a single database management tool.

Simplified database development tool for MySQL and Postgres.

Cross-platform database administration tool (Free/Commercial)

GUI Managers/Clients

Database management in a single PHP file

4.46K
843
6m
n/a

A simple ClickHouse client.

182
17
1y 11m
MIT

Web tool for database management

2.26K
342
35d
MIT

Cross-platform client for PostgreSQL databases

6.68K
503
45d
MIT

A web interface for MySQL and MariaDB

5.22K
2.83K
1d
GPL-2.0

Native cross-platform MongoDB management tool

8.3K
708
40d
n/a

MySQL/MariaDB database management for macOS

8.11K
773
5m
n/a

Azure Data Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.

6.02K
599
1d
n/a

Web-based SQL editor run in your own private cloud. Supports MySQL, Postgres, SQL Server, Vertica, Crate, ClickHouse, Presto, SAP HANA, Cassandra, Snowflake, BigQuery, SQLite, and more with ODBC

3.47K
544
1d
MIT

Database management for VSCode

692
131
12d
MIT

Tabix.io UI

1.04K
139
1y 9m
n/a

TablePlus macOS issue tracker

2.17K
42
7m
n/a

Universal database tool for developers, DBAs and analysts.

Direct SQL access to all your data, no matter where it lives.

Web-based SQLite database admin tool written in PHP with support for SQLite3 and SQLite2.

PSequel provides a clean and simple interface for you to perform common PostgreSQL tasks quickly.

Modern, collaborative SQL editor for your team.

A Modern PostgreSQL Client for the Mac.

Graphical interface supports all SQLite features.

A simple, powerful Postgres manager for macOS.

Graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

The most complete and easy to use MySQL GUI.

PostgreSQL Web Administration GUI - use your PostgreSQL databases from anywhere, with rich, lightning-fast AJAX web interface.

CLI tools

%%sql magic for IPython, hopefully evolving into full SQL client

1.31K
224
6m
MIT

Interactive Redis: A Terminal Client for Redis with AutoCompletion and Syntax Highlighting.

1.28K
47
7d
n/a

Command-line admin tool for observing and troubleshooting Postgres.

1.02K
60
32d
n/a

WARNING: Personal fork. pg_activity repository is now hosted here https://github.com/dalibo/pg_activity

6
1
10m
PostgreSQL

Mirror of https://gitlab.com/pg_top/pg_top

88
15
55d
BSD-3-Clause

Unix pager designed for work with tables. Designed for PostgreSQL, but MySQL is supported too. Now it can be used as CSV or TSV viewer. Works well with pgcli too.

1.38K
60
4d
BSD-2-Clause

Universal command-line interface for SQL databases

6.04K
205
7d
n/a

Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database.

dbcli

AthenaCLI is a CLI tool for AWS Athena service that can do auto-completion and syntax highlighting.

140
20
19d
BSD-3-Clause

CLI for SQLite Databases with auto-completion and syntax highlighting

1.25K
40
45d
BSD-3-Clause

A command-line client for SQL Server with auto-completion and syntax highlighting

1.01K
119
85d
BSD-3-Clause

A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

9.2K
566
37d
n/a

Postgres CLI with autocompletion and syntax highlighting

9.13K
415
49d
BSD-3-Clause

Vertica CLI with auto-completion and syntax highlighting

74
13
3y 9m
n/a

DB-schema navigation and visualization

Entity Relation Diagrams generation tool

730
72
2y 5m
Apache-2.0

Free database schema discovery and comprehension tool

979
136
1d
n/a

SchemaSpy code home

1.52K
182
61d
LGPL-3.0

tbls is a CI-Friendly tool for document a database, written in Go.

781
45
6d
MIT

Quick and simple tool for help you draw your database relationship diagrams and flow quickly using simple DSL language.

Modelers

pgModeler - PostgreSQL Database Modeler - is an open source data modeling tool designed for PostgreSQL. No more DDL commands written by hand let pgModeler do the job for you! This software reunites the concepts of entity-relationship diagrams and the features that PostgreSQL implements as extensions of SQL standards. Support this project by donate on project's official web site link:

2.13K
316
58d
GPL-3.0

Powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. ![App Store][app-store Icon]

Oracle SQL Developer Data Modeler is a free graphical tool that enhances productivity and simplifies data modeling tasks.

Migration tools

DB schema as code tool

27
10
11d
GPL-3.0

Flyway by Redgate โ€ข Database Migrations Made Easy.

5.52K
1.11K
1d
n/a

GitHub's Online Schema Migrations for MySQL

8.34K
866
40d
MIT

Main Liquibase Source

2.35K
1.29K
14d
Apache-2.0

Like diff but for PostgreSQL schemas

1.87K
68
19d
Unlicense

Node.js database migration management for Postgresql

806
122
2d
MIT

Declarative data modeling & database migrations

750
28
4m
Apache-2.0

Provides utilities for Postgres database schema versioning.

288
52
68d
BSD-3-Clause

A Kubernetes operator for declarative database schema management (gitops for database schemas)

192
20
7d
Apache-2.0

Sensible database change management

2.08K
173
52d
MIT

Free and open source schema versioning and database migration made natively with .NET Core.

102
14
32d
Apache-2.0

Code generation tools

Guesses table DDL based on data

209
24
6m
MIT

Command line util for export oracle schema to set of ddl scripts

58
33
2y 29d
n/a

Wrappers

DreamFactory API Management Platform

1.13K
264
64d
Apache-2.0

Work (secure) with your backend database within HTML

7
0
45d
MIT

Blazing fast, instant realtime GraphQL APIs on Postgres with fine grained access control, also trigger webhooks on database events.

19.52K
1.72K
7d
n/a

SQL for JSON and CSV streams

45
0
2y 114d
MIT

PostgreSQL foreign data wrapper for MySQL

345
120
42d
n/a

๐Ÿ’พ Database Tools incl. ORM, Migrations and Admin UI (Postgres, MySQL & MongoDB)

16.88K
957
111d
Apache-2.0

REST API for any Postgres database

16.11K
750
1d
MIT

pREST (PostgreSQL REST), simplify and accelerate development, โšก instant, realtime, high-performance on any Postgres application, existing or new

2.48K
153
2d
MIT

restSQL service and core framework

122
48
2y 46d
MIT

Easily convert your SQL database into a REST API using Express.js

83
25
1y 7m
MIT

Automatically generate a RESTful API service for your legacy database. No code required!

1.6K
179
52d
Apache-2.0

Advanced REST-wrapper for your SQL-queries (actually not only SQL)

49
3
9m
BSD-3-Clause

A mid-tier Java application, ORDS maps HTTP(S) verbs (GET, POST, PUT, DELETE, etc.) to database transactions and returns any results formatted using JSON.

Backup tools

Reliable PostgreSQL Backup & Restore

706
99
2d
MIT

BaRMan - Backup and Recovery Manager for PostgreSQL

989
101
29d
GPL-3.0

Replication/Data operation

An open source multi-tool for exploring and publishing data

4.14K
234
1d
Apache-2.0

Distributed Data Transfer Service for MySQL

314
83
1d
MPL-2.0

Sync data from one Postgres database to another

1.83K
99
13d
MIT

MySQL to PostgreSQL replica system

267
55
70d
BSD-2-Clause

Streaming Postgres logical replication changes atleast-once over websockets

190
13
2y 5m
Apache-2.0

The Most Popular Replication Manager for PostgreSQL (Postgres) - latest version 5.2.0 (2020-10-22)

1.17K
213
1d
n/a

Scripts

A collection of useful little scripts for database analysis and administration, created by our team at PostgreSQL Experts.

850
142
7m
n/a

Queries to mesure statistical bloat in indexes and tables for PostgreSQL

247
58
107d
BSD-2-Clause

Useful PostgreSQL utilities

503
97
78d
n/a

The missing set of useful tools for Postgres DBAs and all engineers

520
57
6m
BSD-3-Clause

Tanel Poder's Troubleshooting & Performance Tools for Oracle Databases

414
190
7d
n/a

SQL test that checks if your database follows rules from https://wiki.postgresql.org/wiki/Don't_Do_This.

Useful SQL-scripts and commands by .

Monitoring/Statistics/Perfomance

ASH Viewer provides a graphical view of active session history data within the Oracle and PostgreSQL DB

83
47
23d
GPL-3.0

Monitor your SQL Server on Linux performance using collectd, InfluxDB and Grafana

68
29
2y 10m
MIT

PMM general repo

181
36
6d
AGPL-3.0

pganalyze statistics collector for gathering PostgreSQL metrics and log data

170
29
6d
n/a

A PostgresSQL metric exporter for Prometheus

1.13K
392
96d
n/a

A performance dashboard for Postgres

5.62K
318
8d
MIT

Collect and display information and stats from a running PostgreSQL server

584
34
6d
Apache-2.0

Collects PostgreSQL statistics, and either saves them in CSV files or print them on the stdout

92
12
40d
n/a

PostgreSQL metrics monitor/dashboard

892
156
5d
BSD-3-Clause

The plugin-driven server agent for collecting & reporting metrics.

9.45K
3.94K
2d
MIT

Agentless & Cost-effective MySQL Monitoring Tool.

A safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible.

a new-generation diagnostics tool that allows users to collect deep analysis of the health of a Postgres database.

Measure and track every aspect of your PostgreSQL databases.

A user interface for Postgres explain plans, plus tips to improve performance.

Zabbix

145
19
5m
BSD-3-Clause

This is the Zabbix monitoring template for PostgreSQL Database.

164
82
21d
Apache-2.0

Python script to monitor Oracle Databases

94
73
2y 47d
n/a

Zabbix Database Monitoring Service (Oracle, Pg, MySQL, MS SQL, DB2, etc.)

66
45
7m
MIT

Orabbix is a plugin designed to work with Zabbix Enterprise Monitor to provide multi-tiered monitoring, performance and availability reporting and measurement for Oracle Databases, along with server performance metrics.

Testing

DbFit is a database testing framework that supports easy test-driven development of your database code.

191
83
88d
GPL-2.0

Regression Testing your SQL queries

168
6
1y 52d
n/a

Data generator

It is a framework for generating realistic and valid high-volume test data for your system under test (avoiding the Datalite anti-pattern).

Powerful GUI tool for creating massive volumes of realistic test data.

Small but mighty GUI tool for populating Oracle schemas with tons of realistic test data.

Powerful GUI tool for a fast generation of meaningful test data for databases.

Administration

pgbadger.github.io

16
3
2y 81d
n/a

Manage a Postgres cluster's roles, role memberships, schema ownership, and privileges

258
24
11m
n/a

Postgres partitioning as easy as pie

699
42
13d
MIT

HA/Failover/Sharding

Distributed PostgreSQL as an extension - for multi-tenant and real-time analytics workloads

4.43K
347
1d
AGPL-3.0

A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes

3.64K
433
5d
MIT

A High Scalability Solution for MySQL Clustering and High Availability

244
106
9d
n/a

PostgreSQL cloud native High Availability and more.

3.04K
346
5m
Apache-2.0

Postgres extension and service for automated failover and high-availability

484
58
1d
n/a

PostgreSQL replication monitoring and failover daemon

121
12
30d
Apache-2.0

PostgreSQL Automatic Failover: High-Availibility for Postgres, based on Pacemaker and Corosync.

282
40
5d
n/a

PostgreSQL High-Availability Cluster (based on "Patroni" and "DCS(etcd)"). Automating deployment with Ansible.

251
58
16d
MIT

Vitess is a database clustering system for horizontal scaling of MySQL.

10.97K
1.41K
1d
Apache-2.0

Kubernetes

Postgres operator creates and manages PostgreSQL clusters running in Kubernetes

1.44K
333
5d
MIT

Highly available elephant herd: HA PostgreSQL cluster using Docker

733
148
6d
Apache-2.0

Making running production-grade databases easy on Kubernetes.

Enterprise-grade, Full Stack PostgreSQL on Kubernetes.

Configuration Tuning

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.

6.45K
1.02K
16d
GPL-3.0

PostgreSQL configuration wizard

922
90
5m
BSD-3-Clause

Simple script to analyse your PostgreSQL database configuration, and give tuning advice

2.02K
123
68d
GPL-3.0

Free online tool to generate an optimized postgresql.conf.

DevOps

DBmaestro accelerates release cycles & supports agility across the entire IT ecosystem.

Toad DevOps Toolkit executes key database development functions within your DevOps workflow โ€”without compromising quality, performance or reliability.

Schema samples

Oracle Database Sample Schemas

361
318
19d
MIT

Reporting

An easy-to-use BI server built for SQL lovers. Power data analysis in SQL and gain faster business insights.

1.73K
276
6m
MIT

Distributions

DBdeployer is a tool that deploys MySQL database servers easily.

440
77
2d
Apache-2.0

๐Ÿš€ SQL Server automation and instance migrations have never been safer, faster or freer

1.4K
583
1d
MIT

The easiest way to get started with PostgreSQL on the Mac

5.54K
318
6d
n/a

PostgreSQL Management Appliance

136
16
61d
GPL-3.0

A developer-friendly distribution of Postgres.

Security

Database security suite. Database proxy with field-level encryption, search through encrypted data, SQL injections prevention, intrusion detection, honeypots. Supports client-side and proxy-side ("transparent") encryption. SQL, NoSQL.

658
77
29d
Apache-2.0

Code formatters

Language-agnostic pretty-printing through machine learning (uh, like, is this possible? YES, apparently).

350
46
118d
BSD-2-Clause