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
8m
Apache-2.0

State of the art MongoDB IDE

786
46
2y 5m
AGPL-3.0

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

2.38K
273
8m
GPL-2.0

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

242
43
10m
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
8m
n/a

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

5.08K
219
8m
MIT

A simple ClickHouse client.

196
18
2y 9m
MIT

Database Subsetting and Relational Data Browsing Tool.

810
42
54d
n/a

Web tool for database management

2.36K
345
10m
MIT

Cross-platform client for PostgreSQL databases

6.77K
522
10m
MIT

A web interface for MySQL and MariaDB

5.34K
2.9K
8m
GPL-2.0

Native cross-platform MongoDB management tool

8.44K
711
9m
n/a

MySQL/MariaDB database management for macOS

8.24K
782
1y 117d
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
8m
n/a

A TUI for viewing and editing database files.

627
11
47d
MIT

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
8m
MIT

Database management for VSCode

732
143
11m
MIT

Tabix.io UI

1.12K
147
2y 7m
n/a

TablePlus macOS issue tracker

2.27K
42
1y 5m
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 5m
MIT

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

1.38K
51
9m
n/a

Command-line admin tool for observing and troubleshooting Postgres.

1.11K
66
8m
n/a

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

9
1
1y 8m
PostgreSQL

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

90
15
1y 19d
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
8m
BSD-2-Clause

Universal command-line interface for SQL databases

6.1K
214
8m
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
11m
BSD-3-Clause

CLI for SQLite Databases with auto-completion and syntax highlighting

1.32K
40
9m
BSD-3-Clause

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

1.04K
124
8m
BSD-3-Clause

A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

9.41K
574
8m
n/a

Postgres CLI with autocompletion and syntax highlighting

9.4K
432
8m
BSD-3-Clause

Vertica CLI with auto-completion and syntax highlighting

74
13
4y 8m
n/a

DB-schema navigation and visualization

Entity Relation Diagrams generation tool

758
74
3y 4m
Apache-2.0

Free database schema discovery and comprehension tool

1.01K
142
8m
n/a

SchemaSpy code home

1.65K
193
1y 25d
LGPL-3.0

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

908
56
8m
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
10m
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
8m
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.05K
47
52d
Apache-2.0

Flyway by Redgate โ€ข Database Migrations Made Easy.

5.71K
1.13K
8m
n/a

GitHub's Online Schema Migrations for MySQL

8.57K
912
8m
MIT

Main Liquibase Source

2.46K
1.31K
8m
Apache-2.0

Like diff but for PostgreSQL schemas

1.93K
73
8m
Unlicense

Node.js database migration management for Postgresql

828
128
8m
MIT

Declarative data modeling & database migrations

750
28
1y 96d
Apache-2.0

Provides utilities for Postgres database schema versioning.

297
52
1y 32d
BSD-3-Clause

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

243
22
8m
Apache-2.0

Sensible database change management

2.15K
173
9m
MIT

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

149
21
8m
Apache-2.0

Code generation tools

Guesses table DDL based on data

214
25
1y 4m
MIT

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

61
34
2y 11m
n/a

Wrappers

DreamFactory API Management Platform

1.14K
264
8m
Apache-2.0

Work (secure) with your backend database within HTML

7
0
1y 9d
MIT

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

20.27K
1.8K
8m
n/a

SQL for JSON and CSV streams

49
0
3y 78d
MIT

PostgreSQL foreign data wrapper for MySQL

354
122
8m
n/a

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

16.87K
946
9m
Apache-2.0

REST API for any Postgres database

16.57K
764
8m
MIT

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

2.57K
172
8m
MIT

restSQL service and core framework

123
48
3y 10d
MIT

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

83
25
9m
MIT

Free and open source no-code application builder

281
37
4m
MIT

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

1.65K
179
10m
Apache-2.0

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

49
3
1y 8m
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
8m
MIT

Barman - Backup and Recovery Manager for PostgreSQL

1.03K
104
11m
GPL-3.0

Replication/Data operation

An open source multi-tool for exploring and publishing data

4.7K
267
8m
Apache-2.0

Distributed Data Transfer Service for MySQL

336
87
8m
MPL-2.0

Sync data from one Postgres database to another

1.91K
102
10m
MIT

MySQL to PostgreSQL replica system

271
57
1y 34d
BSD-2-Clause

Streaming Postgres logical replication changes atleast-once over websockets

194
13
3y 4m
Apache-2.0

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

1.21K
218
8m
n/a

Scripts

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

874
146
1y 6m
n/a

Queries to mesure statistical bloat in indexes and tables for PostgreSQL

275
61
1y 71d
BSD-2-Clause

Useful PostgreSQL utilities

522
100
8m
n/a

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

530
58
1y 5m
BSD-3-Clause

Tanel Poder's Troubleshooting & Performance Tools for Oracle Databases

423
200
9m
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
8m
GPL-3.0

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

67
30
3y 9m
MIT

PMM general repo

195
39
9m
AGPL-3.0

pganalyze statistics collector for gathering PostgreSQL metrics and log data

178
29
8m
n/a

A performance dashboard for Postgres

5.77K
330
8m
MIT

Collect and display information and stats from a running PostgreSQL server

608
33
8m
Apache-2.0

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

93
12
8m
n/a

PostgreSQL metrics monitor/dashboard

942
163
8m
BSD-3-Clause

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

9.78K
4.11K
8m
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.

Prometheus

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

48
3
4m
BSD-3-Clause

A PostgresSQL metric exporter for Prometheus

1.23K
418
8m
n/a

Zabbix

145
19
1y 4m
BSD-3-Clause

This is the Zabbix monitoring template for PostgreSQL Database.

164
82
11m
Apache-2.0

Python script to monitor Oracle Databases

95
75
3y 11d
n/a

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

68
46
1y 6m
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
1y 52d
GPL-2.0

Regression Testing your SQL queries

186
8
10m
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
3y 45d
n/a

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

260
24
1y 10m
n/a

Postgres partitioning as easy as pie

717
44
10m
MIT

HA/Failover/Sharding

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

4.56K
361
8m
AGPL-3.0

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

3.82K
459
8m
MIT

A High Scalability Solution for MySQL Clustering and High Availability

259
110
8m
n/a

PostgreSQL cloud native High Availability and more.

3.13K
356
8m
Apache-2.0

Postgres extension and service for automated failover and high-availability

538
61
8m
n/a

PostgreSQL replication monitoring and failover daemon

129
13
8m
Apache-2.0

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

288
44
11m
n/a

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

285
69
8m
MIT

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

11.41K
1.46K
8m
Apache-2.0

Kubernetes

Postgres operator creates and manages PostgreSQL clusters running in Kubernetes

1.57K
386
8m
MIT

Highly available elephant herd: HA PostgreSQL cluster using Docker

771
165
8m
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
8m
GPL-3.0

PostgreSQL configuration wizard

932
93
1y 4m
BSD-3-Clause

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

2.04K
127
8m
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
9m
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
1y 4m
MIT

Open platform with which you can visualise your product's data. It connects to your DBs (MySQL, PostgreSQL, MongoDB) and APIs directly and you can get the data using the built-in query builders. (Demo, Source Code) MIT NodeJS

Distributions

DBdeployer is a tool that deploys MySQL database servers easily.

466
85
8m
Apache-2.0

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

1.46K
592
8m
MIT

The easiest way to get started with PostgreSQL on the Mac

5.67K
325
8m
n/a

PostgreSQL Management Appliance

145
17
10m
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
8m
Apache-2.0

Secure vault for customer records built to comply with GDPR

771
30
4m
MIT

Code formatters

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

363
54
1y 82d
BSD-2-Clause