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. 4, 2021, 3:03 p.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

23.51K
2.22K
1d
Apache-2.0

State of the art MongoDB IDE

823
45
53d
AGPL-3.0

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

2.8K
314
31d
GPL-2.0

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

251
46
5m
n/a

GUI Managers/Clients

Database management in a single PHP file

4.94K
920
43d
n/a

Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.

7.9K
360
19d
MIT

Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application

1.05K
50
23d
MIT

A simple ClickHouse client.

233
23
53d
MIT

Database Subsetting and Relational Data Browsing Tool.

854
42
30d
n/a

Web tool for database management

2.65K
372
11m
MIT

Cross-platform client for PostgreSQL databases

7.1K
568
56d
MIT

A web interface for MySQL and MariaDB

5.71K
3.05K
12d
GPL-2.0

Native cross-platform MongoDB management tool

8.77K
735
26d
n/a

MySQL/MariaDB database management for macOS

8.54K
824
1y 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.55K
720
30d
n/a

A TUI for viewing and editing database files.

811
20
33d
MIT

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

4.05K
638
30d
MIT

Database management for VSCode

853
182
59d
MIT

Tabix.io UI

1.45K
194
61d
n/a

TablePlus macOS issue tracker

2.51K
48
74d
n/a

CLI tools

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

1.45K
243
51d
MIT

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

1.65K
73
12d
BSD-3-Clause

Command-line admin tool for observing and troubleshooting Postgres.

1.33K
79
36d
n/a

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

14
2
1y 9m
PostgreSQL

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

99
15
4m
BSD-3-Clause

Unix pager (with very rich functionality) designed for work with tables. Designed for PostgreSQL, but MySQL is supported too. Works well with pgcli too. Can be used as CSV or TSV viewer too. It supports searching, selecting rows, columns, or block and export selected area to clipboard.

1.73K
77
32d
BSD-2-Clause

Universal command-line interface for SQL databases

6.82K
250
36d
MIT

dbcli

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

168
26
4m
BSD-3-Clause

CLI for SQLite Databases with auto-completion and syntax highlighting

1.5K
52
84d
BSD-3-Clause

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

1.13K
144
78d
BSD-3-Clause

A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

10.03K
611
6m
n/a

Postgres CLI with autocompletion and syntax highlighting

9.95K
457
16d
BSD-3-Clause

Vertica CLI with auto-completion and syntax highlighting

76
13
4y 8m
n/a

DB-schema navigation and visualization

Entity Relation Diagrams generation tool

855
92
75d
Apache-2.0

Free database schema discovery and comprehension tool

1.12K
158
30d
n/a

SchemaSpy code home

1.97K
226
39d
LGPL-3.0

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

1.17K
79
43d
MIT

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.3K
339
30d
GPL-3.0

Migration tools

DB schema as code tool

32
11
33d
GPL-3.0

Web-based, zero-config, dependency-free database schema change and version control tool for teams. Public demo: https://demo.bytebase.com

1.41K
69
30d
Apache-2.0

Flyway by Redgate โ€ข Database Migrations Made Easy.

6.2K
1.19K
33d
n/a

GitHub's Online Schema Migrations for MySQL

9.4K
1.09K
39d
MIT

Main Liquibase Source

2.83K
1.4K
30d
Apache-2.0

Like diff but for PostgreSQL schemas

2.05K
86
88d
Unlicense

Node.js database migration management for Postgresql

974
143
33d
MIT

Issues for Prisma Migrate are now tracked at prisma/prisma. This repo was used to track issues for Prisma Migrate Experimental and is now deprecated.

774
28
11m
Apache-2.0

Provides utilities for Postgres database schema versioning.

317
58
31d
BSD-3-Clause

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

489
49
31d
Apache-2.0

Sensible database change management

2.25K
182
34d
MIT

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

199
34
6m
Apache-2.0

Code generation tools

Guesses table DDL based on data

230
26
52d
MIT

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

63
38
49d
n/a

Wrappers

DreamFactory API Management Platform

1.2K
272
52d
Apache-2.0

Work (secure) with your backend database within HTML

16
0
1y 12d
MIT

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

24.36K
2.08K
31d
n/a

SQL for JSON and CSV streams

50
0
3y 116d
MIT

PostgreSQL foreign data wrapper for MySQL

381
130
39d
n/a

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

16.85K
932
74d
Apache-2.0

REST API for any Postgres database

17.84K
823
31d
MIT

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

2.97K
216
11d
MIT

restSQL service and core framework

129
50
2y 10m
MIT

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

90
28
10m
MIT

Free and open source no-code application builder

533
77
32d
MIT

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

1.76K
190
11m
Apache-2.0

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

53
4
1y 9m
BSD-3-Clause

Backup tools

Reliable PostgreSQL Backup & Restore

933
122
30d
MIT

Barman - Backup and Recovery Manager for PostgreSQL

1.19K
123
30d
GPL-3.0

Replication/Data operation

An open source multi-tool for exploring and publishing data

5.55K
371
33d
Apache-2.0

Distributed Data Transfer Service for MySQL

393
99
30d
MPL-2.0

Sync data from one Postgres database to another

2.1K
119
73d
MIT

MySQL to PostgreSQL replica system

295
63
11m
BSD-2-Clause

Streaming Postgres logical replication changes atleast-once over websockets

215
15
3y 5m
Apache-2.0

A lightweight replication manager for PostgreSQL (Postgres) - latest version 5.3.0 (2021-10-12)

1.26K
222
36d
n/a

Scripts

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

966
168
72d
n/a

Queries to mesure statistical bloat in indexes and tables for PostgreSQL

313
69
4m
BSD-2-Clause

Useful PostgreSQL utilities

578
116
47d
n/a

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

576
69
34d
BSD-3-Clause

Tanel Poder's Troubleshooting & Performance Tools for Oracle Databases

470
224
78d
n/a

Monitoring/Statistics/Perfomance

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

100
53
73d
GPL-3.0

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

75
34
3y 10m
MIT

PMM general repo

219
44
30d
AGPL-3.0

pganalyze statistics collector for gathering PostgreSQL metrics and log data

213
31
31d
n/a

A performance dashboard for Postgres

6.14K
366
18d
MIT

Collect and display information and stats from a running PostgreSQL server

699
40
51d
Apache-2.0

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

97
13
38d
n/a

PostgreSQL metrics monitor/dashboard

1.1K
188
36d
BSD-3-Clause

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

10.74K
4.56K
30d
MIT

Prometheus

pgSCV is a multi-purpose monitoring agent and metrics exporter for Weaponry.IO

115
11
80d
BSD-3-Clause

A PostgreSQL metric exporter for Prometheus

1.51K
505
51d
Apache-2.0

Zabbix

161
25
31d
BSD-3-Clause

This is the Zabbix monitoring template for PostgreSQL Database.

162
84
34d
Apache-2.0

Python script to monitor Oracle Databases

96
80
3y 49d
n/a

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

73
49
1y 7m
MIT

Testing

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

201
87
33d
GPL-2.0

Regression Testing your SQL queries

212
10
11m
n/a

Data generator

Administration

pgbadger.github.io

21
4
3y 83d
n/a

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

277
28
8m
n/a

Postgres partitioning as easy as pie

759
46
65d
MIT

HA/Failover/Sharding

Distributed PostgreSQL as an extension

5.44K
417
30d
AGPL-3.0

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

4.35K
548
31d
MIT

A High Scalability Solution for MySQL Clustering and High Availability

276
118
31d
n/a

PostgreSQL cloud native High Availability and more.

3.43K
380
57d
Apache-2.0

Postgres extension and service for automated failover and high-availability

664
74
30d
n/a

PostgreSQL replication monitoring and failover daemon

136
14
73d
Apache-2.0

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

294
47
78d
n/a

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

409
112
32d
MIT

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

12.8K
1.63K
30d
Apache-2.0

Kubernetes

Postgres operator creates and manages PostgreSQL clusters running in Kubernetes

2.11K
541
30d
MIT

Highly available elephant herd: HA PostgreSQL cluster using Docker

894
212
31d
Apache-2.0

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.

7.19K
1.12K
43d
GPL-3.0

PostgreSQL configuration wizard

952
91
109d
BSD-3-Clause

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

2.19K
147
9m
GPL-3.0

DevOps

Schema samples

Oracle Database Sample Schemas

444
382
87d
MIT

Reporting

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

1.84K
316
4m
MIT

Distributions

DBdeployer is a tool that deploys MySQL database servers easily.

530
97
34d
Apache-2.0

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

1.7K
647
31d
MIT

The easiest way to get started with PostgreSQL on the Mac

6.1K
349
9d
n/a

PostgreSQL Management Appliance

154
19
82d
GPL-3.0

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.

830
94
10d
Apache-2.0

Secure SDK/vault for personal records/PII built to comply with GDPR

909
43
33d
MIT

Code formatters

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

382
68
1y 4m
BSD-2-Clause