mgramin/awesome-db-tools

Data

QuickTable - Empowers everyone to access, clean, analyze, transform, and model data with no code.

Schema

Changes

Skeemastars1k - Declarative pure-SQL schema management system for MySQL and MariaDB, with support for sharding and external online schema change tools.

Schema

Design

WWW SQL Designerstars2.6k - Online SQL diagramming tool.

SQL

Parsers

SQLGlotstars345 - Pure Python SQL parser, transpiler, and builder.

Data

Catalog

Amundsenstars3.3k - Metadata driven application for improving the productivity of data analysts, data scientists and engineers when interacting with data.

DataHubstars5.5k - The Metadata Platform for the Modern Data Stack.

Marquezstars1.1k - Collect, aggregate, and visualize a data ecosystem's metadata.

Schema

Changes

pg-oscstars246 - Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL.

SQL

Parsers

libpg_querystars678 - C library for accessing the PostgreSQL parser outside of the server environment.

Monitoring/Statistics/Perfomance

PostgreSQL Metricsstars561 - Service to extract and provide metrics on your PostgreSQL database.

postgres-checkup - New-generation diagnostics tool that allows users to do a deep analysis of the health of Postgres databases.

pgMonitorstars330 - All-in-one tool to easily create an environment to visualize the health and performance of your PostgreSQL cluster.

Schema

Design

Database Designstars160 - Useful tips for designing robust database schema.

SQL

Plan

pev2stars1.5k - A VueJS component to show a graphical vizualization of a PostgreSQL execution plan.

pg_flamestars1.5k - A flamegraph generator for Postgres EXPLAIN ANALYZE output.

SQL

Über SQL

osquerystars18.9k - SQL powered operating system instrumentation, monitoring, and analytics.

Monitoring/Statistics/Perfomance

Promscalestars1.1k - The open-source observability backend for metrics and traces powered by SQL.

pgbadgerstars22 - A fast PostgreSQL Log Analyzer.

Data

Generators

Fakerstars6.1k - Generate massive amounts of fake data in the browser and Node.js.

Beneratorstars63 - Generate, obfuscate (anonymize / pseudonymize) and migrate data for development, testing and training purposes.

dbForge Data Generator for MySQL - Powerful GUI tool for creating massive volumes of realistic test data.

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

dbForge Data Generator for SQL Server - Powerful GUI tool for a fast generation of meaningful test data for databases.

Noisiastars670 - Harmful workload generator for PostgreSQL.

SB Data Generator - Simple and powerful tool to generate and populate selected tables or entire databases with realistic test data for your applications. Generate test data for: Oracle, MS SQL Server, MySQL, PostgreSQL, Firebird, SQLite, Azure SQL Database, Amazon Redshift and Amazon RDS.

HA/Failover/Sharding

pgslicestars795 - Postgres partitioning as easy as pie.

Schema

Changes

Atlasstars1.6k - Inspect and Apply changes to your database schema.

Reshapestars1.3k - An easy-to-use, zero-downtime schema migration tool for Postgres.

sqldefstars1.2k - Idempotent schema management for MySQL, PostgreSQL, and more.

Schema

Documentations

dbdocs - Create web-based database documentation using DSL code.

DBMLstars1.4k - Database Markup Language, designed to define and document database structures.

SchemaCrawlerstars1.2k - A free database schema discovery and comprehension tool.

Schema Spystars2.2k - Generating your database to HTML documentation, including Entity Relationship diagrams.

tblsstars1.4k - CI-Friendly tool for document a database, written in Go.

Schema

Design

DBDiagram - A free, simple tool to draw ER diagrams by just writing code.

ERBuilder Data Modeler - Easy-to-use database modeling software for high-quality data models. It's a complete data modeling solution for data modelers and data architects.

Navicat Data Modeler - A powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models.

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

pgmodelerstars2.4k - Data modeling tool designed for PostgreSQL.

Testing

SQLancerstars938 - Automatically test DBMS in order to find logic bugs in their implementation.

Schema

Diagrams

ERAlchemystars906 - Entity Relation Diagrams generation tool.

Schema

Samples

Oracle Database Sample Schemasstars503 - Oracle Database Sample Schemas.

Data

dbtstars4.9k - Transform your data by simply writing select statements, while dbt handles turning these statements into tables and views in a data warehouse.

Data

Replication

dtlestars463 - Distributed Data Transfer Service for MySQL.

Litestreamstars6.6k - Streaming replication for SQLite.

pgsyncstars2.3k - Sync Postgres data between databases.

pg_chameleonstars312 - MySQL to PostgreSQL replica system written in Python 3. The system use the library mysql-replication to pull the row images from MySQL which are stored into PostgreSQL as JSONB.

PGDeltaStreamstars227 - A Golang webserver to stream Postgres changes atleast-once over websockets, using Postgres logical decoding feature.

repmgrstars1.3k - The Most Popular Replication Manager for PostgreSQL.

SQL

Über SQL

Resmo - Audit and evaluate resources using SQL.

Steampipestars1.4k - Use SQL to instantly query your cloud services (AWS, Azure, GCP and more).

CloudQuerystars2.3k - Extracts, transforms, and loads your cloud assets into normalized PostgreSQL tables.

csvqstars1k - SQL-like query language for CSV.

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

OctoSQLstars3.1k - Query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

TextQLstars8.8k - Execute SQL against structured text like CSV or TSV.

trdsqlstars1.2k - CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN.

Application platforms

Budibasestars13.4k - Low-code platform for creating internal apps in minutes.

Saltcornstars783 - Open source no-code builder for web datatabase applications. Server and drag-and-drop UI builder, data stored in PostgreSQL or SQLite.

Cloning

clone_schemastars87 - Postgres clone schema utility without need of going outside of database.

Database Lab Engine - Instant thin cloning for Postgres to scale the development process.

Spawn - Cloud service for creating instant database copies for development and CI. No more local db installs, instant recovery to arbitrary save points, isolated copies for each feature branch or test. Instant provisioning regardless of database size.

Backup

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

API

Datasettestars6.1k - A tool for exploring and publishing data.

Papers

The "Database as Code" Manifestostars14 - Treat your database as Code.

Security

Inspektorstars211 - Access control layer for databases. Inspektor leverages open policy agent to make policy decisions.

SQL

Analyzers

TSQLLintstars150 - A tool for describing, identifying, and reporting the presence of anti-patterns in TSQL scripts.

SQLCheckstars2.1k - Automatically detects common SQL anti-patterns.

SQLFluffstars4.2k - Dialect-flexible and configurable SQL linter.

SQL

Formatters

Poor SQL - Instant free and open-source T-SQL formatting.

CodeBuffstars394 - Language-agnostic pretty-printing through machine learning.

pgFormatterstars1.3k - A PostgreSQL SQL syntax beautifier.

SQL Formatterstars1.1k - JavaScript library for pretty-printing SQL queries.

CLI

usqlstars7.2k - A universal command-line interface for PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, and many other databases including NoSQL and non-relational databases!

SQL

Extensions

PartiQL - SQL-compatible access to relational, semi-structured, and nested data.

SQL

Frameworks

Apache Calcite - Dynamic data management framework with advanced SQL features.

ZetaSQLstars1.8k - Analyzer Framework for SQL.

SQL

Parsers

General SQL Parser - Parsing, formatting, modification and analysis for SQL.

jOOQstars4.9k - Parses SQL, translates it to other dialects, and allows for expression tree transformations.

JSqlParserstars3.7k - Parses an SQL statement and translate it into a hierarchy of Java classes.

More SQL Parsing!stars121 - Parse SQL into JSON.

sqlparsestars2.9k - Non-validating SQL parser for Python.

IDE

Slashbasestars312 - The open-source collaborative IDE for your databases. Connect to your database, browse data, run a bunch of SQL commands or share SQL queries with your team, right from your browser.

Scripts

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

GUI

ocelotguistars52 - For MySQL, MariaDB, and Tarantool. Developed for Linux but can run on Windows.

Backup

BaRManstars1.3k - Backup and Recovery Manager for PostgreSQL.

pgbackreststars1.2k - Reliable PostgreSQL Backup & Restore.

CLI

SQLLinestars508 - Command-line shell for issuing SQL to relational databases via JDBC.

SQL

Language Server Protocol

SQLLanguageServerstars315 - SQL Language Server.

sqlsstars544 - SQL Language Server written in Go.

IDE

DataStationstars1.6k - Easily query, script, and visualize data from every database, file, and API.

GUI

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

GUI

MissionKontrol - Modern drag & drop admin panel/client with full user permissions for non-technical users.

sqlite-tuistars1.1k - A TUI for viewing sqlite databases, written in Go.

Reporting

Chartbrew - Create live dashboards, charts, and client reports from multiple databases and services.

Schema

Changes

Bytebasestars2.9k - Web-based, zero-config, dependency-free database schema change and version control tool for teams.

GUI

Jailerstars1.3k - Database Subsetting and Relational Data Browsing Tool/Client.

GUI

Beekeeper Studiostars9.8k - Open Source SQL Editor and Database Manager with a privacy commitment in their mission statement.

Monitoring/Statistics/Perfomance

Prometheus

pgSCVstars129 - Metrics exporter for PostgreSQL and Postgres-related services.

postgres_exporterstars1.7k - Prometheus exporter for PostgreSQL server metrics.

Security

Databunker - Special GDPR compliant secure vault for customer records built on top of regular DB.

Schema

Changes

Prisma Migratestars773 - Declarative database schema migration tool that uses a declarative data modeling syntax to describe your database schema.

Schema

Changes

yuniqlstars293 - Yet another schema versioning and migration tool just made with native .NET Core 3.0+ and hopefully better.

Distributions

dbatoolsstars1.8k - PowerShell module that you may think of like a command-line SQL Server Management Studio.

GUI

SQLToolsstars926 - Database management for VSCode.

CLI

iredisstars1.8k - A Cli for Redis with AutoCompletion and Syntax Highlighting.

IDE

Toad Edge - Simplified database development tool for MySQL and Postgres.

PL/SQL Developer - IDE that is specifically targeted at the development of stored program units for Oracle Databases.

GUI

SQLite Expert - Graphical interface supports all SQLite features.

API

sandman2 - Automatically generate a RESTful API service for your legacy database.

Configuration Tuning

MySQLTuner-perlstars7.5k - Script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability.

postgresqltuner.plstars2.3k - Simple script to analyse your PostgreSQL database configuration, and give tuning advice.

Schema

Changes

Sqitchstars2.4k - Sensible database-native change management for framework-free development and dependable deployment.

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

Security

Acrastars976 - 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.

Distributions

DBdeployerstars580 - Tool that deploys MySQL database servers easily.

Postgres.appstars6.3k - Full-featured PostgreSQL installation packaged as a standard Mac app.

BigSQL - A developer-friendly distribution of Postgres.

Elephant Shedstars167 - Web-based PostgreSQL management front-end that bundles several utilities and applications for use with PostgreSQL.

Monitoring/Statistics/Perfomance

mssql-monitoringstars78 - Monitor your SQL Server on Linux performance using collectd, InfluxDB and Grafana.

ASH Viewerstars113 - Provides a graphical view of active session history data within the Oracle and PostgreSQL DB.

HA/Failover/Sharding

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

Testing

RegreSQLstars231 - Regression Testing your SQL queries.

Scripts

Postgres cheat sheet - Useful SQL-scripts and commands by <timescale.com>.

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

Configuration Tuning

PGConfigurator - Free online tool to generate an optimized postgresql.conf.

Schema

Code generation

scheme2ddlstars72 - Command line util for export Oracle schema to set of ddl init scripts with ability to filter undesirable information, separate DDL in different files, pretty format output.

API

restSQLstars131 - SQL generator with Java and HTTP APIs, uses a simple RESTful HTTP API with XML or JSON serialization.

Monitoring/Statistics/Perfomance

Percona Monitoring and Managementstars245 - Open source platform for managing and monitoring MySQL and MongoDB performance.

HA/Failover/Sharding

Citusstars6.2k - Postgres extension that distributes your data and your queries across multiple nodes.

patronistars4.7k - A template for PostgreSQL High Availability with ZooKeeper, etcd, or Consul.

Percona XtraDB Clusterstars293 - A High Scalability Solution for MySQL Clustering and High Availability.

stolonstars3.7k - Cloud native PostgreSQL manager for PostgreSQL high availability.

pg_auto_failoverstars764 - Postgres extension and service for automated failover and high-availability.

pglookoutstars147 - PostgreSQL replication monitoring and failover daemon.

PostgreSQL Automatic Failoverstars300 - High-Availibility for Postgres, based on industry references Pacemaker and Corosync.

Kubernetes

KubeDB - Making running production-grade databases easy on Kubernetes.

Postgres operatorstars2.5k - The Postgres Operator enables highly-available PostgreSQL clusters on Kubernetes (K8s) powered by Patroni.

Spilostars973 - HA PostgreSQL Clusters with Docker.

StackGres - Enterprise-grade, Full Stack PostgreSQL on Kubernetes.

Configuration Tuning

pgtunestars976 - PostgreSQL configuration wizard.

Monitoring/Statistics/Perfomance

Zabbix

pg_monzstars160 - This is the Zabbix monitoring template for PostgreSQL Database.

Mamonsustars167 - Monitoring agent for PostgreSQL.

ZabbixDBAstars77 - ZabbixDBA is fast, flexible, and continuously developing plugin to monitor your RDBMS.

IDE

IBExpert - Comprehensive GUI tool for Firebird and InterBase.

pgAdmin3 - Long Term Support for pgAdmin3.

dbKodastars853 - Modern (JavaScript/Electron framework), open source IDE for MongoDB. It has features to support development, administration and performance tuning on MongoDB databases.

Scripts

TPTstars506 - These sqlplus scripts are for Oracle Database performance optimization & troubleshooting.

postgres_queries_and_commands.sql - Useful PostgreSQL Queries and Commands.

Monitoring/Statistics/Perfomance

Telegraf PostgreSQL plugin - Provides metrics for your postgres database.

HA/Failover/Sharding

Vitessstars14.1k - Database clustering system for horizontal scaling of MySQL through generalized sharding.

GUI

PopSQL - Modern, collaborative SQL editor for your team.

Reporting

Polistars1.9k - An easy-to-use SQL reporting application built for SQL lovers.

Schema

Changes

migrastars2.5k - Like diff but for PostgreSQL schemas.

CLI

dbcli

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

liteclistars1.6k - CLI for SQLite Databases with auto-completion and syntax highlighting.

mssql-clistars1.2k - A command-line client for SQL Server with auto-completion and syntax highlighting.

myclistars10.4k - A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

pgclistars10.4k - Postgres CLI with autocompletion and syntax highlighting.

vclistars76 - Vertica CLI with auto-completion and syntax highlighting.

GUI

sqlpadstars4.4k - Web-based SQL editor run in your own private cloud.

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

DbVisualizer - Universal database tool for developers, DBAs and analysts.

SQLyog - The most complete and easy to use MySQL GUI.

SQuirreL - 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.

Sequel Prostars8.7k - Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL & MariaDB databases.

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

SQLPro - A simple, powerful Postgres manager for macOS.

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

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

Monitoring/Statistics/Perfomance

Monyog - Agentless & Cost-effective MySQL Monitoring Tool.

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

IDE

Valentina Studio - Create, administer, query and explore Valentina DB, MySQL, MariaDB, PostgreSQL and SQLite databases for FREE.

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

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

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

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

API

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

CLI

pg_topstars101 - 'top' for PostgreSQL.

Schema

Changes

gh-oststars10k - Online schema migration for MySQL.

GUI

Pgwebstars7.3k - Web-based database browser for PostgreSQL, written in Go and works on macOS, Linux and Windows machines.

Schema

Code generation

ddl-generatorstars242 - Infers SQL DDL (Data Definition Language) from table data.

CLI

ipython-sqlstars1.5k - Connect to a database for issue SQL commands within IPython or IPython Notebook.

pg_activitystars16 - Top like application for PostgreSQL server activity monitoring.

IDE

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

dbForge Studio for Oracle - Powerful IDE for Oracle management, administration, and development.

dbForge Studio for PostgreSQL - GUI tool for managing and developing databases and objects.

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

GUI

OmniDBstars2.8k - Web tool for database management.

SQL Operations Studiostars6.8k - A data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.

API

DreamFactory - A open source REST API backend for mobile, web, and IoT applications.

Monitoring/Statistics/Perfomance

pgDash - Measure and track every aspect of your PostgreSQL databases.

Monitoring/Statistics/Perfomance

pgwatch2stars1.3k - Flexible self-contained PostgreSQL metrics monitoring/dashboarding solution.

Schema

Changes

node-pg-migratestars1k - Node.js database migration management built exclusively for postgres. (But can also be used for other DBs conforming to SQL standard - e.g. CockroachDB.)

GUI

Robo 3Tstars8.9k - Robo 3T (formerly Robomongo) is a shell-centric cross-platform MongoDB management tool.

Tabixstars1.6k - SQL Editor & Open source simple business intelligence for Clickhouse.

Monitoring/Statistics/Perfomance

PgHerostars6.4k - A performance dashboard for Postgres - health checks, suggested indexes, and more.

pganalyze collectorstars223 - Pganalyze statistics collector for gathering PostgreSQL metrics and log data.

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

IDE

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

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

DevOps

Toad DevOps Toolkit - Toad DevOps Toolkit executes key database development functions within your DevOps workflow —without compromising quality, performance or reliability.

CLI

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

Testing

DbFitstars210 - A database testing framework that supports easy test-driven development of your database code.

IDE

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

HeidiSQLstars3.2k - A lightweight client for managing MySQL, MSSQL and PostgreSQL, written in Delphi.

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

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

GUI

Adminerstars5.2k - Database management in a single PHP file.

phpMyAdminstars6k - A web interface for MySQL and MariaDB.

Postico - A Modern PostgreSQL Client for the Mac.

Scripts

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

pgsql-bloat-estimationstars348 - Queries to mesure statistical bloat in indexes and tables for PostgreSQL.

pg-utilsstars615 - Useful PostgreSQL utilities.

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

Monitoring/Statistics/Perfomance

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

DevOps

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

API

preststars3.2k - Is a way to serve a RESTful API from any databases written in Go.

resquelstars97 - Easily convert your SQL database into a REST API.

Oracle REST Data Services - 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.

IDE

DataGrip - Cross-Platform IDE for Databases & SQL by JetBrains.

DBeaverstars26.6k - Free universal database manager and SQL client.

CLI

pspgstars1.8k - Postgres Pager.

Monitoring/Statistics/Perfomance

pgmetricsstars759 - Collect and display information and stats from a running PostgreSQL server.

Monitoring/Statistics/Perfomance

Zabbix

Orabbix - 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.

Pyorastars99 - Python script to monitor Oracle Databases.

CLI

pgcenterstars1.4k - Top-like admin tool for PostgreSQL.

IDE

Database .net - Multiple database management tool with support for 20+ databases.

GUI

TablePlusstars2.7k - Modern, native, and friendly GUI tool for relational databases: MySQL, PostgreSQL, SQLite & more.

Schema

Changes

2bassstars34 - Database configuration-as-code tool that utilizes concept of idempotent DDL scripts.

flywaystars6.6k - Database migration tool.

liquibasestars3.2k - Database-independent library for tracking, managing and applying database schema changes.

Pyrseasstars328 - Provides utilities to describe a PostgreSQL database schema as YAML.

API

Prismastars16.8k - Prisma turns your database into a realtime GraphQL API.

PostgRESTstars18.7k - REST API for any Postgres database.