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: None

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

18.99K
1.75K
79d
Apache-2.0

State of the art MongoDB IDE

786
46
1y 12m
AGPL-3.0

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

2.38K
273
93d
GPL-2.0

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

242
43
4m
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.62K
865
87d
n/a

A simple ClickHouse client.

196
18
2y 4m
MIT

Web tool for database management

2.36K
345
4m
MIT

Cross-platform client for PostgreSQL databases

6.77K
522
5m
MIT

A web interface for MySQL and MariaDB

5.34K
2.9K
80d
GPL-2.0

Native cross-platform MongoDB management tool

8.44K
711
4m
n/a

MySQL/MariaDB database management for macOS

8.24K
782
10m
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.13K
629
85d
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.61K
561
85d
MIT

Database management for VSCode

732
143
5m
MIT

Tabix.io UI

1.12K
147
2y 74d
n/a

TablePlus macOS issue tracker

2.27K
42
1y 11d
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.34K
231
1y 5d
MIT

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

1.38K
51
4m
n/a

Command-line admin tool for observing and troubleshooting Postgres.

1.11K
66
91d
n/a

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

9
1
1y 101d
PostgreSQL

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

90
15
7m
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.48K
69
88d
BSD-2-Clause

Universal command-line interface for SQL databases

6.1K
214
104d
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.

146
20
6m
BSD-3-Clause

CLI for SQLite Databases with auto-completion and syntax highlighting

1.32K
40
113d
BSD-3-Clause

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

1.04K
124
92d
BSD-3-Clause

A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

9.41K
574
80d
n/a

Postgres CLI with autocompletion and syntax highlighting

9.4K
432
82d
BSD-3-Clause

Vertica CLI with auto-completion and syntax highlighting

74
13
4y 75d
n/a

DB-schema navigation and visualization

Entity Relation Diagrams generation tool

758
74
2y 10m
Apache-2.0

Free database schema discovery and comprehension tool

1.01K
142
85d
n/a

SchemaSpy code home

1.65K
193
7m
LGPL-3.0

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

908
56
87d
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.19K
323
4m
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
11
86d
GPL-3.0

Flyway by Redgate โ€ข Database Migrations Made Easy.

5.71K
1.13K
85d
n/a

GitHub's Online Schema Migrations for MySQL

8.57K
912
96d
MIT

Main Liquibase Source

2.46K
1.31K
89d
Apache-2.0

Like diff but for PostgreSQL schemas

1.93K
73
104d
Unlicense

Node.js database migration management for Postgresql

828
128
89d
MIT

Declarative data modeling & database migrations

750
28
9m
Apache-2.0

Provides utilities for Postgres database schema versioning.

297
52
7m
BSD-3-Clause

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

243
22
92d
Apache-2.0

Sensible database change management

2.15K
173
112d
MIT

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

149
21
91d
Apache-2.0

Code generation tools

Guesses table DDL based on data

214
25
11m
MIT

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

61
34
2y 6m
n/a

Wrappers

DreamFactory API Management Platform

1.14K
264
85d
Apache-2.0

Work (secure) with your backend database within HTML

7
0
6m
MIT

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

20.27K
1.8K
85d
n/a

SQL for JSON and CSV streams

49
0
2y 9m
MIT

PostgreSQL foreign data wrapper for MySQL

354
122
93d
n/a

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

16.87K
946
117d
Apache-2.0

REST API for any Postgres database

16.57K
764
97d
MIT

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

2.57K
172
92d
MIT

restSQL service and core framework

123
48
2y 7m
MIT

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

83
25
105d
MIT

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

1.65K
179
4m
Apache-2.0

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

49
3
1y 91d
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

745
104
86d
MIT

Barman - Backup and Recovery Manager for PostgreSQL

1.03K
104
6m
GPL-3.0

Replication/Data operation

An open source multi-tool for exploring and publishing data

4.7K
267
85d
Apache-2.0

Distributed Data Transfer Service for MySQL

336
87
97d
MPL-2.0

Sync data from one Postgres database to another

1.91K
102
4m
MIT

MySQL to PostgreSQL replica system

271
57
7m
BSD-2-Clause

Streaming Postgres logical replication changes atleast-once over websockets

194
13
2y 11m
Apache-2.0

The Most Popular Replication Manager for PostgreSQL (Postgres) - latest version 5.2.1 (2020-12-07)

1.21K
218
85d
n/a

Scripts

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

874
146
1y 36d
n/a

Queries to mesure statistical bloat in indexes and tables for PostgreSQL

275
61
9m
BSD-2-Clause

Useful PostgreSQL utilities

522
100
94d
n/a

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

530
58
11m
BSD-3-Clause

Tanel Poder's Troubleshooting & Performance Tools for Oracle Databases

423
200
110d
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

88
50
97d
GPL-3.0

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

67
30
3y 107d
MIT

PMM general repo

195
39
4m
AGPL-3.0

pganalyze statistics collector for gathering PostgreSQL metrics and log data

178
29
85d
n/a

A PostgresSQL metric exporter for Prometheus

1.23K
418
87d
n/a

A performance dashboard for Postgres

5.77K
330
101d
MIT

Collect and display information and stats from a running PostgreSQL server

608
33
96d
Apache-2.0

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

93
12
87d
n/a

PostgreSQL metrics monitor/dashboard

942
163
86d
BSD-3-Clause

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

9.78K
4.11K
86d
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
11m
BSD-3-Clause

This is the Zabbix monitoring template for PostgreSQL Database.

164
82
6m
Apache-2.0

Python script to monitor Oracle Databases

95
75
2y 7m
n/a

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

68
46
1y 18d
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.

193
85
8m
GPL-2.0

Regression Testing your SQL queries

186
8
5m
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

15
3
2y 8m
n/a

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

260
24
1y 5m
n/a

Postgres partitioning as easy as pie

717
44
4m
MIT

HA/Failover/Sharding

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

4.56K
361
85d
AGPL-3.0

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

3.82K
459
85d
MIT

A High Scalability Solution for MySQL Clustering and High Availability

259
110
94d
n/a

PostgreSQL cloud native High Availability and more.

3.13K
356
86d
Apache-2.0

Postgres extension and service for automated failover and high-availability

538
61
86d
n/a

PostgreSQL replication monitoring and failover daemon

129
13
89d
Apache-2.0

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

288
44
5m
n/a

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

285
69
101d
MIT

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

11.41K
1.46K
86d
Apache-2.0

Kubernetes

Postgres operator creates and manages PostgreSQL clusters running in Kubernetes

1.57K
386
85d
MIT

Highly available elephant herd: HA PostgreSQL cluster using Docker

771
165
87d
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.64K
1.05K
99d
GPL-3.0

PostgreSQL configuration wizard

932
93
10m
BSD-3-Clause

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

2.04K
127
98d
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

386
326
4m
MIT

Reporting

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

1.76K
290
11m
MIT

Distributions

DBdeployer is a tool that deploys MySQL database servers easily.

466
85
98d
Apache-2.0

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

1.46K
592
86d
MIT

The easiest way to get started with PostgreSQL on the Mac

5.67K
325
81d
n/a

PostgreSQL Management Appliance

145
17
5m
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.

719
82
93d
Apache-2.0

Code formatters

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

363
54
9m
BSD-2-Clause