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. 7, 2022, 11:06 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

Easily query, script, and visualize data from every database, file, and API.

441
11
1y 0d
n/a

Free universal database tool and SQL client

24.51K
2.31K
10m
Apache-2.0

State of the art MongoDB IDE

823
45
1y 59d
AGPL-3.0

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

2.8K
314
1y 37d
GPL-2.0

Collaborative in-browser database IDE for your team. Supports PostgreSQL & MongoDB.

384
11
10d
Apache-2.0

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

251
46
1y 6m
n/a

GUI

Database management in a single PHP file

4.94K
920
1y 49d
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.81K
785
6m
n/a

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

11.99K
689
16d
GPL-3.0

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

1.05K
50
1y 29d
MIT

Database explorer for Mac, Windows & Linux

182
3
7m
MIT

Database Subsetting and Relational Data Browsing Tool.

854
42
1y 36d
n/a

Suprematistic hackable GUI SQL-manager written in SQL itself

6
0
6m
MIT

GUI client for MySQL or MariaDB, including debugger

52
13
1y 46d
n/a

Web tool for database management

2.65K
372
1y 11m
MIT

Cross-platform client for PostgreSQL databases

7.2K
584
10m
MIT

A web interface for MySQL and MariaDB

5.84K
3.09K
10m
GPL-2.0

Native cross-platform MongoDB management tool

8.83K
743
10m
n/a

MySQL/MariaDB database management for macOS

5.14K
193
5d
n/a

MySQL/MariaDB database management for macOS

8.58K
842
2y 5m
n/a

A TUI for viewing and editing database files.

811
20
1y 39d
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
1y 36d
MIT

Database management for VSCode

853
182
1y 65d
MIT

Tabix.io UI

1.45K
194
1y 67d
n/a

TablePlus macOS issue tracker

2.51K
48
1y 80d
n/a

CLI

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

1.45K
243
1y 57d
MIT

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

1.72K
78
10m
BSD-3-Clause

Command-line admin tool for observing and troubleshooting Postgres.

1.33K
79
1y 42d
n/a

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

14
2
2y 9m
PostgreSQL

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

99
15
1y 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
1y 38d
BSD-2-Clause

Python CLI utility and library for manipulating SQLite databases

873
65
6m
Apache-2.0

Shell for issuing SQL to relational databases via JDBC

469
134
1y 37d
BSD-3-Clause

Universal command-line interface for SQL databases

6.82K
250
1y 42d
MIT

dbcli

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

176
27
11m
BSD-3-Clause

CLI for SQLite Databases with auto-completion and syntax highlighting

1.55K
56
10m
BSD-3-Clause

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

1.13K
144
1y 84d
BSD-3-Clause

A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

10.68K
641
32d
n/a

Postgres CLI with autocompletion and syntax highlighting

10.08K
455
10m
BSD-3-Clause

Vertica CLI with auto-completion and syntax highlighting

76
13
5y 9m
n/a

Changes

DB schema as code tool

32
11
1y 39d
GPL-3.0

A database toolkit

1.03K
26
10m
Apache-2.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
1y 36d
Apache-2.0

Flyway by Redgate โ€ข Database Migrations Made Easy.

6.2K
1.19K
1y 39d
n/a

GitHub's Online Schema Migrations for MySQL

9.4K
1.09K
1y 45d
MIT

Main Liquibase Source

2.83K
1.4K
1y 36d
Apache-2.0

Like diff but for PostgreSQL schemas

2.05K
86
1y 94d
Unlicense

Node.js database migration management for Postgresql

974
143
1y 39d
MIT

Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL

214
5
9m
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
1y 11m
Apache-2.0

Provides utilities for Postgres database schema versioning.

317
58
1y 37d
BSD-3-Clause

An easy-to-use, zero-downtime schema migration tool for Postgres

1.22K
21
9m
MIT

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

489
49
1y 37d
Apache-2.0

Declarative pure-SQL schema management for MySQL and MariaDB

984
87
10m
Apache-2.0

Sensible database change management

2.25K
182
1y 40d
MIT

Idempotent schema management for MySQL, PostgreSQL, and more

1.15K
78
8m
n/a

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

226
38
10m
Apache-2.0

Code generation

Guesses table DDL based on data

230
26
1y 58d
MIT

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

63
38
1y 55d
n/a

Diagrams

An Entity Relationship diagram (ERD) visualization tool, with various filters and inputs to help understand your database schema

333
21
62d
MIT

Entity Relation Diagrams generation tool

855
92
1y 81d
Apache-2.0

Documentations

Database Markup Language (DBML), designed to define and document database structures

1.28K
102
8m
Apache-2.0

Free database schema discovery and comprehension tool

1.12K
158
1y 36d
n/a

SchemaSpy code home

1.97K
226
1y 45d
LGPL-3.0

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

1.17K
79
1y 49d
MIT

Design

Ideas on better database design

138
20
8m
n/a

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
1y 36d
GPL-3.0

WWW SQL Designer, your online SQL diagramming tool

2.55K
668
7m
BSD-3-Clause

Samples

Oracle Database Sample Schemas

444
382
1y 93d
MIT

API

An open source multi-tool for exploring and publishing data

5.55K
371
1y 39d
Apache-2.0

DreamFactory API Management Platform

1.2K
272
1y 58d
Apache-2.0

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

24.36K
2.08K
1y 37d
n/a

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

16.85K
932
1y 80d
Apache-2.0

Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database!

10.8K
505
1y 42d
MIT

REST API for any Postgres database

17.84K
823
1y 37d
MIT

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

3.1K
226
10m
MIT

A CRUD framework for full stack TypeScript

558
18
6m
MIT

restSQL service and core framework

129
50
3y 11m
MIT

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

90
28
1y 10m
MIT

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

1.78K
188
1y 11m
Apache-2.0

Application platforms

Quickly build any custom business software like admin panels, internal tools, dashboards and more with pre-built UI widgets that connect to any database, GraphQL or REST API, controlling everything with Javascript.

8.18K
805
1y 36d
Apache-2.0

Budibase is an open-source low-code platform for creating internal apps in minutes. Supports PostgreSQL, MySQL, MSSQL, MongoDB, Rest API, Docker, K8s ๐Ÿš€

11.86K
616
8m
n/a

The Open Source Firebase Alternative with GraphQL.

3.17K
174
5m
MIT

Free and open source no-code application builder

533
77
1y 38d
MIT

Extensible low-code framework for building business applications. Connect to databases, cloud storages, GraphQL, API endpoints, Airtable, etc and build apps using drag and drop application builder. Built using JavaScript/TypeScript. ๐Ÿš€

10.31K
827
6m
AGPL-3.0

Backup

Barman - Backup and Recovery Manager for PostgreSQL

1.19K
123
1y 36d
GPL-3.0

Reliable PostgreSQL Backup & Restore

933
122
1y 36d
MIT

Copy a Postgres database to a target Postgres server (pg_dump | pg_restore on steroids)

444
17
8m
n/a

Cloning

Postgres clone schema utility without need of going outside of database. Makes developers life easy by running single function to clone schema with all objects. It is very handy on Postgres RDS. Utility is sponsored by http://elephas.io/

75
22
8m
MIT

Monitoring/Statistics/Perfomance

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

100
53
1y 79d
GPL-3.0

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

75
34
4y 10m
MIT

PMM general repo

219
44
1y 36d
AGPL-3.0

pganalyze statistics collector for gathering PostgreSQL metrics and log data

213
31
1y 37d
n/a

pgbadger.github.io

21
4
4y 89d
n/a

A performance dashboard for Postgres

6.25K
374
10m
MIT

Collect and display information and stats from a running PostgreSQL server

699
40
1y 57d
Apache-2.0

PostgreSQL Monitoring, Metrics Collection and Alerting Resources from Crunchy Data

276
55
1y 36d
n/a

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

97
13
1y 44d
n/a

PostgreSQL metrics monitor/dashboard

1.1K
188
1y 42d
BSD-3-Clause

Tool that extracts and provides metrics on your PostgreSQL database

544
40
1y 5m
Apache-2.0

The open-source observability backend for metrics and traces powered by SQL ๐Ÿš€

963
106
8m
Apache-2.0

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

10.74K
4.56K
1y 36d
MIT

Prometheus

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

115
11
1y 86d
BSD-3-Clause

A PostgreSQL metric exporter for Prometheus

1.51K
505
1y 57d
Apache-2.0

postgres exporter for prometheus

102
31
6m
Apache-2.0

Zabbix

161
25
1y 37d
BSD-3-Clause

This is the Zabbix monitoring template for PostgreSQL Database.

162
84
1y 40d
Apache-2.0

Python script to monitor Oracle Databases

96
80
4y 55d
n/a

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

73
49
2y 7m
MIT

Testing

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

201
87
1y 39d
GPL-2.0

Regression Testing your SQL queries

212
10
1y 11m
n/a

Detecting Logic Bugs in DBMS

907
133
8m
MIT

HA/Failover/Sharding

Distributed PostgreSQL as an extension

5.44K
417
1y 36d
AGPL-3.0

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

4.35K
548
1y 37d
MIT

A High Scalability Solution for MySQL Clustering and High Availability

276
118
1y 37d
n/a

PostgreSQL cloud native High Availability and more.

3.43K
380
1y 63d
Apache-2.0

Postgres extension and service for automated failover and high-availability

664
74
1y 36d
n/a

PostgreSQL replication monitoring and failover daemon

136
14
1y 79d
Apache-2.0

Postgres partitioning as easy as pie

759
46
1y 71d
MIT

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

294
47
1y 84d
n/a

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

409
112
1y 38d
MIT

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

12.8K
1.63K
1y 36d
Apache-2.0

Kubernetes

Postgres operator creates and manages PostgreSQL clusters running in Kubernetes

2.11K
541
1y 36d
MIT

Highly available elephant herd: HA PostgreSQL cluster using Docker

894
212
1y 37d
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
1y 49d
GPL-3.0

PostgreSQL configuration wizard

952
91
1y 115d
BSD-3-Clause

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

2.19K
147
1y 10m
GPL-3.0

DevOps

Reporting

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

1.84K
316
1y 4m
MIT

Distributions

DBdeployer is a tool that deploys MySQL database servers easily.

530
97
1y 40d
Apache-2.0

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

1.7K
647
1y 37d
MIT

The easiest way to get started with PostgreSQL on the Mac

6.21K
352
10m
n/a

PostgreSQL Management Appliance

154
19
1y 88d
GPL-3.0

Pigsty - Battery-Included Open-Source Distribution for PostgreSQL

525
99
6m
Apache-2.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.

935
101
10m
Apache-2.0

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

909
43
1y 39d
MIT

Open Policy for your Data layer ๐Ÿ‘ฎ

24
0
9m
Apache-2.0

Analyzers

Automatically identify anti-patterns in SQL queries

2.04K
93
2y 8m
Apache-2.0

A SQL linter and auto-formatter for Humans

3.1K
230
11m
MIT

SQL Lineage Analysis Tool powered by Python

416
78
65d
MIT

Configurable linting for TSQL

141
57
1y 50d
MIT

Extensions

Frameworks

ZetaSQL - Analyzer Framework for SQL

1.67K
144
11m
Apache-2.0

Formatters

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

382
68
2y 4m
BSD-2-Clause

A PostgreSQL SQL syntax beautifier that can work as a console program or as a CGI. On-line demo site at http://sqlformat.darold.net/

1.21K
83
11m
PostgreSQL

A whitespace formatter for different query languages

1.02K
259
11m
MIT

Parsers

jOOQ is the best way to write SQL in Java

4.72K
1.05K
11m
n/a

JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern

3.44K
1.06K
11m
n/a

C library for accessing the PostgreSQL parser outside of the server environment

644
104
8m
BSD-3-Clause

Let's make a SQL parser so we can provide a familiar interface to non-sql datastores!

76
18
11m
MPL-2.0

A non-validating SQL parser module for Python

2.72K
549
1y 91d
BSD-3-Clause

Python SQL Parser and Transpiler

329
36
7m
MIT

รœber SQL

The open-source cloud asset inventory powered by SQL.

2.19K
159
8m
MPL-2.0

SQL-like query language for csv

981
42
8m
n/a

Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.

1.75K
68
8m
n/a

OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

2.91K
143
8m
MPL-2.0

SQL powered operating system instrumentation, monitoring, and analytics.

18.79K
2.29K
8m
n/a

Use SQL to instantly query your cloud services (AWS, Azure, GCP and more). Open source CLI. No DB required.

1.21K
60
8m
AGPL-3.0

Execute SQL against structured text like CSV or TSV

8.9K
308
1y 5m
MIT

CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN. Can output to various formats.

741
43
9m
MIT

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)

4.33K
1.39K
1y 36d
Apache-2.0

Language Server Protocol

SQL Language Server

268
21
11m
MIT

SQL language server written in Go.

444
22
11m
MIT

Learning

Welcome to my GitHub repository. I hope you enjoy solving these puzzles as much as I have enjoyed creating them.

63
19
4m
n/a

Inspired by @veltman's command-line mystery, use SQL to research clues and find out whodunit!

1.12K
128
5m
MIT

Plan

Postgres Explain Visualizer 2

1.43K
64
8m
PostgreSQL

A flamegraph generator for Postgres EXPLAIN ANALYZE output.

1.43K
26
2y 11m
Apache-2.0

Scripts

T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs.

55
21
10m
MIT

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

966
168
1y 78d
n/a

Queries to mesure statistical bloat in indexes and tables for PostgreSQL

313
69
1y 4m
BSD-2-Clause

Useful PostgreSQL utilities

578
116
1y 53d
n/a

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

576
69
1y 40d
BSD-3-Clause

Tanel Poder's Troubleshooting & Performance Tools for Oracle Databases

470
224
1y 84d
n/a

Data

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.

4.45K
833
8m
Apache-2.0

Catalog

Amundsen is a metadata driven application for improving the productivity of data analysts, data scientists and engineers when interacting with data.

3.18K
791
8m
Apache-2.0

The Metadata Platform for the Modern Data Stack

5.26K
1.4K
8m
Apache-2.0

Collect, aggregate, and visualize a data ecosystem's metadata

1.01K
164
8m
Apache-2.0

Generators

Benerator is a leading software solution to generate, obfuscate, pseudonymize and migrate data for development, testing, and training purposes.

60
10
8m
n/a

Generate massive amounts of fake data in the browser and node.js

4.88K
423
8m
n/a

Harmful workload generator for PostgreSQL

666
13
1y 84d
BSD-3-Clause

Replication

Distributed Data Transfer Service for MySQL

393
99
1y 36d
MPL-2.0

Streaming replication for SQLite.

4.4K
91
9m
Apache-2.0

Sync data from one Postgres database to another

2.1K
119
1y 79d
MIT

MySQL to PostgreSQL replica system

295
63
1y 12m
BSD-2-Clause

Streaming Postgres logical replication changes atleast-once over websockets

215
15
4y 6m
Apache-2.0

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

1.26K
222
1y 42d
n/a

Compare

Efficiently diff rows across two different databases.

725
17
5m
MIT

Papers

The "Database as Code" Manifesto

11
0
9m
CC0-1.0

Machine Learning

In-Database Machine Learning

5.57K
619
10m
GPL-3.0

Brings SQL and AI together.

4.52K
671
7m
Apache-2.0