https://DevOpsCloud.io -- Cloud Monk Losang Jinpa, Ph.D., MCSE/MCT, GitOps DevOps Engineer

Return to Awesome Lists

See: GitHub Databases Topics

Community driven list of database tools

db-tools

Here we will collect information about awesome useful and awesome experimental tools that simplify working with databases for DBA, DevOps, Developers and mere mortals.

• [IDE](#ide)
• [GUI](#gui)
• [CLI](#cli)
• [Schema](#schema)

   - [Changes](#changes)
   - [Code generation](#code-generation)
   - [Diagrams](#diagrams)
   - [Documentations](#documentations)
   - [Design](#design)
   - [Samples](#samples)

• [API](#api)
• [Application platforms](#application-platforms)
• [Backup](#backup)
• [Cloning](#cloning)
• [Monitoring/Statistics/Perfomance](#monitoringstatisticsperfomance)

   - [Prometheus](#prometheus)
   - [Zabbix](#zabbix)

• [Testing](#testing)
• [HA/Failover/Sharding](#hafailoversharding)
• [Kubernetes](#kubernetes)
• [Configuration Tuning](#configuration-tuning)
• [DevOps](#devops)
• [Reporting](#reporting)
• [Distributions](#distributions)
• [Security](#security)
• [SQL](#sql)

   - [Analyzers](#analyzers)
   - [Extensions](#extensions)
   - [Frameworks](#frameworks)
   - [Formatters](#formatters)
   - [Games](#games)
   - [Parsers](#parsers)
   - [Über SQL](#über-sql)
   - [Language Server Protocol](#language-server-protocol)
   - [Learning](#learning)
   - [Plan](#plan)
   - [Scripts](#scripts)

• [Data](#data)

   - [Catalog](#catalog)
   - [Lineage](#lineage) 
   - [Generation/Masking/Subsetting](#generationmaskingsubsetting)
   - [Replication](#replication) 
   - [Compare](#compare) 

• [Papers](#papers)
• [Machine Learning](#machine-learning)

• https://www.sqlmaestro.com/products/anysql/maestro AnySQL Maestro – Premier multi-purpose admin tool for database management, control and development.

• https://www.aquafold.com/aquadatastudio Aqua Data Studio]] – Aqua Data Studio is productivity software for Database Developers, DBAs, and Analysts.

• https://www.coginiti.co/products/coginiti-pro Coginiti Pro – Modern IDE for analyst and analytics engineers with proweful script and grid functionality.

• http://fishcodelib.com/Database.htm Database dot NET – Multiple database management tool with support for 20+ databases.

• https://www.jetbrains.com/datagrip DataGrip – Cross-Platform IDE for Databases & SQL by JetBrains.

• https://github.com/multiprocessio/datastation DataStation – Easily query, script, and visualize data from every database, file, and API.

• https://github.com/dbeaver/dbeaver DBeaver – Free universal database manager and SQL client.

• https://www.devart.com/dbforge/mysql/studio dbForge Studio for MySQL – Universal IDE for MySQL and MariaDB database development, management, and administration.

• https://www.devart.com/dbforge/oracle/studio dbForge Studio for Oracle – Powerful IDE for Oracle management, administration, and development.

• https://www.devart.com/dbforge/postgresql/studio dbForge Studio for PostgreSQL – GUI tool for managing and developing databases and objects.

• https://www.devart.com/dbforge/sql/studio dbForge Studio for SQL Server – Powerful integrated development environment for SQL Server development, management, administration, data analysis, and reporting.

• https://www.datasparc.com/ DBHawk – Datasparc offers database security, database management, database governance and data analytics - all in one solution.

• https://github.com/SouthbankSoftware/dbkoda dbKoda – Modern (JavaScript/Electron framework), open source IDE for MongoDB. It has features to support development, administration and performance tuning on MongoDB databases.

• http://www.ibexpert.net/ibe IBExpert – Comprehensive GUI tool for Firebird and InterBase.

• https://github.com/HeidiSQL/HeidiSQL HeidiSQL – A lightweight client for managing MySQL, MSSQL and PostgreSQL, written in Delphi.

• https://keeptool.com KeepTool – A professional suite of tools for Oracle Database developers, administrators and advanced application users.

• https://www.mysql.com/products/workbench MySQL Workbench – MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.

• https://www.navicat.com/en/products#navicat 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.

• http://www.oracle.com/technetwork/developer-tools/sql-developer 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.

• https://www.pgadmin.org pgAdmin – The most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

• https://www.bigsql.org/pgadmin3 pgAdmin3 – Long Term Support for pgAdmin3.

• https://www.allroundautomations.com/products/pl-sql-developer PL/SQL Developer – IDE that is specifically targeted at the development of stored program units for Oracle Databases.

• https://www.sqlmaestro.com/products/postgresql/maestro PostgreSQL Maestro – Complete and powerful database management, admin and development tool for PostgreSQL.

• https://github.com/pinterest/querybook Querybook – Querybook is a Pinterest open-source Big Data Querying UI, combining collocated table metadata and a simple notebook IDE interface.

• https://github.com/slashbaseide/slashbase Slashbase – 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.

• https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-ssms Sql Server Management Studio]] – SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, for SQL Server and Azure SQL Databases.

• https://www.quest.com/toad/ Toad – Toad is the premier database solution for developers, admins and data analysts. Manage complex database changes with a single database management tool.

• https://www.toadworld.com/products/toad-edge Toad Edge – Simplified database development tool for MySQL and Postgres.

• https://github.com/tora-tool/tora TOra – TOra is an open source SQL IDE for Oracle, MySQL and PostgreSQL dbs.

• https://www.valentina-db.com/en/valentina-studio-overview Valentina Studio – Create, administer, query and explore Valentina DB, MySQL, MariaDB, PostgreSQL and SQLite databases for FREE.

• https://webdb.app WebDB – Free Efficient Database IDE. Featuring Server Discovery, ERD, Data Generator, AI, NoSQL Structure Manager, Database Versioning and many more.

• https://github.com/vrana/adminer Adminer – Database management in a single PHP file.
• https://github.com/qishibo/AnotherRedisDesktopManager Another Redis Desktop Manager – Free Open Source Redis Manager. Available on Mac, Linux, Windows, Homebrew, Snap, winget, and more.

• https://github.com/microsoft/azuredatastudio Azure Data Studio – A data management tool that enables working with SQL Server, PostgreSQL, Azure SQL DB and SQL DW from Windows, macOS and Linux.

• https://github.com/beekeeper-studio/beekeeper-studio Beekeeper Studio – Open Source SQL Editor and Database Manager with a privacy commitment in their mission statement.
• https://github.com/clidey/whodb Clidey WhoDB – A lightweight database explorer with next-gen UX for all SQL, NoSQL, Caches, and Queues.
• https://github.com/dbgate/dbgate DbGate – Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application.
• https://github.com/dblens/app DB Lens – Open Source Postgres GUI - Automatic ER diagrams, Internal DB Insights, Disk Utilisation, Performance Metrics, Index Usage, Sequential scan counts and more.
• https://www.dbvis.com DbVisualizer – Universal database tool for developers, DBAs and analysts.
• https://www.jackdb.com JackDB – Direct SQL access to all your data, no matter where it lives.
• https://github.com/Wisser/Jailer Jailer – Database Subsetting and Relational Data Browsing Tool/Client.
• https://github.com/mgramin/malewicz Malewicz – Yet Another WEB client for DB schema exploring and performance analysis, but originally created specifically for hacking and extending.
• https://www.missionkontrol.io MissionKontrol – Modern drag & drop admin panel/client with full user permissions for non-technical users.
• https://github.com/ocelot-inc/ocelotgui ocelotgui – For MySQL, MariaDB, and Tarantool. Developed for Linux but can run on Windows.
• https://github.com/OmniDB/OmniDB OmniDB – Web tool for database management.
• https://github.com/sosedoff/pgweb Pgweb – Web-based database browser for PostgreSQL, written in Go and works on macOS, Linux and Windows machines.
• https://www.phpliteadmin.org phpLiteAdmin – Web-based SQLite database admin tool written in PHP with support for SQLite3 and SQLite2.
• https://github.com/phpmyadmin/phpmyadmin phpMyAdmin – A web interface for MySQL and MariaDB.
• http://www.psequel.com psequel – PSequel provides a clean and simple interface for you to perform common PostgreSQL tasks quickly.
• https://popsql.com PopSQL – Modern, collaborative SQL editor for your team.
• https://eggerapps.at/postico Postico – A Modern PostgreSQL Client for the Mac.
• https://github.com/Studio3T/robomongo Robo 3T – Robo 3T (formerly Robomongo) is a shell-centric cross-platform MongoDB management tool.
• https://github.com/Sequel-Ace/Sequel-Ace Sequel Ace – MySQL/MariaDB database management for macOS.
• https://github.com/sequelpro/sequelpro Sequel Pro – Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL & MariaDB databases.
• http://www.sqliteexpert.com/index.html SQLite Expert – Graphical interface supports all SQLite features.
• https://github.com/mathaou/sqlite-tui sqlite-tui – A TUI for viewing sqlite databases, written in Go.
• https://github.com/rickbergfalk/sqlpad sqlpad – Web-based SQL editor run in your own private cloud.
• https://www.macpostgresclient.com SQLPro – A simple, powerful Postgres manager for macOS.
• https://sourceforge.net/projects/squirrel-sql 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.
• https://github.com/mtxr/vscode-sqltools SQLTools – Database management for VSCode.
• https://www.webyog.com/product/sqlyog SQLyog – The most complete and easy to use MySQL GUI.
• https://github.com/tabixio/tabix Tabix – SQL Editor & Open source simple business intelligence for Clickhouse.
• https://github.com/TablePlus/TablePlus TablePlus – Modern, native, and friendly GUI tool for relational databases: MySQL, PostgreSQL, SQLite & more.
• http://www.teampostgresql.com TeamPostgreSQL – PostgreSQL Web Administration GUI - use your PostgreSQL databases from anywhere, with rich, lightning-fast AJAX web interface.
• https://query.me Query.me – Collaborative SQL editor in Notebook format. Let's you reference query results using JINJA, visualize data, and schedule runs and exports.

• https://github.com/catherinedevlin/ipython-sql ipython-sql – Connect to a database for issue SQL commands within IPython or IPython Notebook.
• https://github.com/laixintao/iredis iredis – A Cli for Redis with AutoCompletion and Syntax Highlighting.
• https://github.com/lesovsky/pgcenter pgcenter – Top-like admin tool for PostgreSQL.
• https://github.com/julmon/pg_activity pg_activity – Top-like application for PostgreSQL server activity monitoring.
• https://github.com/markwkm/pg_top pg_top – Top for PostgreSQL.
• https://github.com/okbob/pspg pspg – Postgres Pager.
• http://www.oracle.com/technetwork/developer-tools/sqlcl/overview/index.html SQLcl – Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database.
• https://github.com/simonw/sqlite-utils sqlite-utils – CLI tools for manipulating SQLite database files - inserting data, running queries, creating indexes, configuring full-text search and more.
• https://github.com/julianhyde/sqlline SQLLine – Command-line shell for issuing SQL to relational databases via JDBC.
• https://github.com/xo/usql usql – A universal command-line interface for PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, and many other databases including NoSQL and non-relational databases

• https://github.com/dbcli/athenacli athenacli – AthenaCLI is a CLI tool for AWS Athena service that can do auto-completion and syntax highlighting.
• https://github.com/dbcli/litecli litecli – CLI for SQLite Databases with auto-completion and syntax highlighting.
• https://github.com/dbcli/mssql-cli mssql-cli – A command-line client for SQL Server with auto-completion and syntax highlighting.
• https://github.com/dbcli/mycli mycli – A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.
• https://github.com/dbcli/pgcli pgcli – Postgres CLI with autocompletion and syntax highlighting.
• https://github.com/dbcli/vcli vcli – Vertica CLI with auto-completion and syntax highlighting.

• https://github.com/CourseOrchestra/2bass 2bass – Database configuration-as-code tool that utilizes concept of idempotent DDL scripts.
• https://github.com/ariga/atlas Atlas – Inspect and Apply changes to your database schema.
• https://github.com/bytebase/bytebase Bytebase – Web-based, zero-config, dependency-free database schema change and version control tool for teams.
• https://github.com/flyway/flyway flyway – Database migration tool.
• https://github.com/github/gh-ost gh-ost – Online schema migration for MySQL.
• https://github.com/liquibase/liquibase liquibase – Database-independent library for tracking, managing and applying database schema changes.
• https://github.com/djrobstep/migra migra – Like diff but for PostgreSQL schemas.
• https://github.com/salsita/node-pg-migrate node-pg-migrate – Node.js database migration management built exclusively for postgres. (But can also be used for other DBs conforming to SQL standard - e.g. CockroachDB.)
• https://github.com/shayonj/pg-osc pg-osc – Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL.
• https://github.com/prisma/migrate Prisma Migrate – Declarative database schema migration tool that uses a declarative data modeling syntax to describe your database schema.
• https://github.com/perseas/Pyrseas Pyrseas – Provides utilities to describe a PostgreSQL database schema as YAML.
• https://github.com/fabianlindfors/reshape Reshape – An easy-to-use, zero-downtime schema migration tool for Postgres.
• https://github.com/schemahero/schemahero SchemaHero – A Kubernetes operator for declarative database schema management (gitops for database schemas).
• https://github.com/skeema/skeema Skeema – Declarative pure-SQL schema management system for MySQL and MariaDB, with support for sharding and external online schema change tools.
• https://github.com/sqitchers/sqitch Sqitch – Sensible database-native change management for framework-free development and dependable deployment.
• https://github.com/k0kubun/sqldef sqldef – Idempotent schema management for MySQL, PostgreSQL, and more.
• https://github.com/rdagumampan/yuniql yuniql – Yet another schema versioning and migration tool just made with native .NET Core 3.0+ and hopefully better.

• https://github.com/catherinedevlin/ddl-generator ddl-generator – Infers SQL DDL (Data Definition Language) from table data.
• https://github.com/qwazer/scheme2ddl scheme2ddl – 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.

• https://github.com/azimuttapp/azimutt Azimutt – An Entity Relationship diagram (ERD) visualization tool, with various filters and inputs to help understand your database schema.
• https://github.com/chartdb/chartdb ChartDB – Free and Open-source database diagrams editor, visualize and design your DB with a single query.
• https://github.com/drawdb-io/drawdb DrawDB – Free, simple, and intuitive online database design tool and SQL generator.
• https://github.com/Alexis-benoist/eralchemy ERAlchemy – Entity Relation Diagrams generation tool.
• https://www.erdlab.io/ ERD Lab – Free cloud based entity relationship diagram (ERD) tool made for developers.
• https://www.quickdatabasediagrams.com/ QuickDBD – Simple online tool to quickly draw database diagrams.

• https://dbdocs.io/ dbdocs – Create web-based database documentation using DSL code.
• https://github.com/holistics/dbml DBML – Database Markup Language, designed to define and document database structures.
• https://github.com/schemacrawler/SchemaCrawler SchemaCrawler – A free database schema discovery and comprehension tool.
• https://github.com/schemaspy/schemaspy Schema Spy – Generating your database to HTML documentation, including Entity Relationship diagrams.
• https://github.com/k1LoW/tbls tbls – CI-Friendly tool for document a database, written in Go.

• https://github.com/alextanhongpin/database-design Database Design – Useful tips for designing robust database schema.
• https://dbdiagram.io DBDiagram – A free, simple tool to draw ER diagrams by just writing code.
• https://dbschema.com/ DbSchema – Universal database designer for out-of-the-box schema management, schema documentation, design in a team, and deployment on multiple databases. DbSchema features tools for writing and executing queries, exploring the data, generating data, and building reports.
• https://soft-builder.com/erbuilder-data-modeler 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.
• https://www.datensen.com Moon Modeler – Data modeling tool for both noSQL and relational databases. Available for Windows, Linux and macOS.
• https://www.navicat.com/en/products/navicat-data-modeler Navicat Data Modeler – A powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models.

• http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html Oracle SQL Developer Data Modeler – Oracle SQL Developer Data Modeler is a free graphical tool that enhances productivity and simplifies data modeling tasks.

• https://github.com/pgmodeler/pgmodeler pgmodeler – Data modeling tool designed for PostgreSQL.
• https://github.com/ondras/wwwsqldesigner WWW SQL Designer – Online SQL diagramming tool.

• https://github.com/oracle/db-sample-schemas Oracle Database Sample Schemas – Oracle Database Sample Schemas.

Building API for your Data

• https://github.com/simonw/datasette Datasette – A tool for exploring and publishing data.
• https://github.com/dreamfactorysoftware/dreamfactory DreamFactory – A open source REST API backend for mobile, web, and IoT applications.
• https://github.com/exogee-technology/graphweaver Graphweaver – Turn multiple data sources into a single GraphQL API.
• https://github.com/hasura/graphql-engine Hasura GraphQL Engine – Blazing fast, instant realtime GraphQL APIs on Postgres with fine grained access control, also trigger webhooks on database events.
• http://www.oracle.com/technetwork/developer-tools/rest-data-services 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.
• https://github.com/prismagraphql/prisma Prisma – Prisma turns your database into a realtime GraphQL API.
• https://github.com/graphile/postgraphile PostGraphile – Instantly spin-up a GraphQL API server by pointing PostGraphile at your existing PostgreSQL database.
• https://github.com/PostgREST/postgrest PostgREST – REST API for any Postgres database.
• https://github.com/prest/prest prest – Is a way to serve a RESTful API from any databases written in Go.
• https://github.com/remult/remult Remult – End-to-end type-safe CRUD via REST API for your database, with fine-grained access control.
• https://github.com/restsql/restsql restSQL – SQL generator with Java and HTTP APIs, uses a simple RESTful HTTP API with XML or JSON serialization.
• https://github.com/formio/resquel resquel – Easily convert your SQL database into a REST API.
• https://github.com/jeffknupp/sandman2 sandman2 – Automatically generate a RESTful API service for your legacy database.
• https://github.com/thevahidal/soul soul – Automatic SQLite RESTful and realtime API server.
• https://github.com/Canner/vulcan-sql VulcanSQL – Write templated SQL to automatically exposing RESTful APIs from your database/data warehouse/data lake.

Low-code and no-code platforms for application building

• https://github.com/appsmithorg/appsmith Appsmith – Powerful open source low code framework to build internal applications really quickly.
• https://github.com/Budibase/budibase Budibase – Low-code platform for creating internal apps in minutes.
• https://github.com/illacloud/illa-builder ILLA Cloud – Low-code internal tool building platform.
• https://github.com/nhost/nhost Nhost – The Open Source Firebase Alternative with GraphQL.
• https://github.com/saltcorn/saltcorn Saltcorn – Open source no-code builder for web datatabase applications. Server and drag-and-drop UI builder, data stored in PostgreSQL or SQLite.
• https://github.com/ToolJet/ToolJet Tooljet – Open-source low-code platform to build internal tools.

• https://github.com/2ndquadrant-it/barman BaRMan – Backup and Recovery Manager for PostgreSQL.
• https://github.com/pgbackrest/pgbackrest pgbackrest – Reliable PostgreSQL Backup & Restore.
• https://github.com/dimitri/pgcopydb pgcopydb – Copy a Postgres database to a target Postgres server (pg_dump | pg_restore on steroids).

• https://gitlab.com/postgres-ai/database-lab Database Lab Engine – Instant thin cloning for Postgres to scale the development process.
• https://github.com/denishpatel/pg-clone-schema clone_schema – Postgres clone schema utility without need of going outside of database.
• https://spawn.cc/ 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.

• https://github.com/akardapolov/ASH-Viewer ASH Viewer – Provides a graphical view of active session history data within the Oracle and PostgreSQL DB.
• https://www.metisdata.io/product/troubleshooting Metis – Metis provides observability and performance tuning for SQL databases.
• https://www.webyog.com/product/monyog Monyog – Agentless & Cost-effective MySQL Monitoring Tool.
• https://github.com/microsoft/mssql-monitoring mssql-monitoring – Monitor your SQL Server on Linux performance using collectd, InfluxDB and Grafana.
• https://www.navicat.com/en/products/navicat-monitor Navicat Monitor – A safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible.
• https://github.com/percona/pmm Percona Monitoring and Management – Open source platform for managing and monitoring MySQL and MongoDB performance.
• https://github.com/pganalyze/collector pganalyze collector – Pganalyze statistics collector for gathering PostgreSQL metrics and log data.
• https://github.com/dalibo/pgbadger pgbadger – A fast PostgreSQL Log Analyzer.
• https://pgdash.io pgDash]] – Measure and track every aspect of your PostgreSQL databases.
• https://github.com/ankane/pghero PgHero – A performance dashboard for Postgres - health checks, suggested indexes, and more.
• https://github.com/rapidloop/pgmetrics pgmetrics – Collect and display information and stats from a running PostgreSQL server.
• https://github.com/CrunchyData/pgmonitor pgMonitor – All-in-one tool to easily create an environment to visualize the health and performance of your PostgreSQL cluster.
• https://www.pgmustard.com pgMustard – A user interface for Postgres explain plans, plus tips to improve performance.
• https://github.com/gleu/pgstats pgstats – Collects PostgreSQL statistics, and either saves them in CSV files or print them on the stdout.
• https://github.com/cybertec-postgresql/pgwatch2 pgwatch2 – Flexible self-contained PostgreSQL metrics monitoring/dashboarding solution.
• https://github.com/spotify/postgresql-metrics PostgreSQL Metrics – Service to extract and provide metrics on your PostgreSQL database.
• https://postgresmonitor.com Postgres Monitor – An easy-to-use monitoring service for PostgreSQL providing alerts, dashboards, query stats and dynamic recommendations.
• https://gitlab.com/postgres-ai/postgres-checkup postgres-checkup – New-generation diagnostics tool that allows users to do a deep analysis of the health of Postgres databases.
• https://github.com/timescale/promscale Promscale – The open-source observability backend for metrics and traces powered by SQL.
• https://github.com/influxdata/telegraf/tree/master/plugins/inputs/postgresql Telegraf PostgreSQL plugin – Provides metrics for your postgres database.

• https://github.com/weaponry/pgscv pgSCV – Metrics exporter for PostgreSQL and Postgres-related services.
• https://github.com/wrouesnel/postgres_exporter postgres_exporter – Prometheus exporter for PostgreSQL server metrics.
• https://github.com/Vonng/pg_exporter pg_exporter – Fully customizable Prometheus exporter for PostgreSQL & Pgbouncer with fine-grained execution control.

• https://github.com/postgrespro/mamonsu Mamonsu – Monitoring agent for PostgreSQL.
• http://www.smartmarmot.com/wiki/index.php?title=Orabbix 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.
• https://github.com/pg-monz/pg_monz pg_monz – This is the Zabbix monitoring template for PostgreSQL Database.
• https://github.com/bicofino/Pyora Pyora – Python script to monitor Oracle Databases.
• https://github.com/anetrusov/ZabbixDBA ZabbixDBA – ZabbixDBA is fast, flexible, and continuously developing plugin to monitor your RDBMS.

• https://github.com/dbfit/dbfit DbFit – A database testing framework that supports easy test-driven development of your database code.
• https://github.com/theory/pgtap pgTAP – Unit Testing for PostgreSQL.
• https://github.com/dimitri/regresql RegreSQL – Regression Testing your SQL queries.
• https://github.com/sqlancer/sqlancer SQLancer – Automatically test DBMS in order to find logic bugs in their implementation.

• https://github.com/citusdata/citus Citus – Postgres extension that distributes your data and your queries across multiple nodes.
• https://github.com/zalando/patroni patroni – A template for PostgreSQL High Availability with ZooKeeper, etcd, or Consul.
• https://github.com/percona/percona-xtradb-cluster Percona XtraDB Cluster – A High Scalability Solution for MySQL Clustering and High Availability.
• https://github.com/apache/shardingsphere ShardingSphere – Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
• https://github.com/sorintlab/stolon stolon – Cloud native PostgreSQL manager for PostgreSQL high availability.
• https://github.com/citusdata/pg_auto_failover pg_auto_failover – Postgres extension and service for automated failover and high-availability.
• https://github.com/aiven/pglookout pglookout – PostgreSQL replication monitoring and failover daemon.
• https://github.com/ankane/pgslice pgslice – Postgres partitioning as easy as pie.
• https://github.com/ClusterLabs/PAF PostgreSQL Automatic Failover – High-Availibility for Postgres, based on industry references Pacemaker and Corosync.
• https://github.com/vitabaks/postgresql_cluster postgresql_cluster – PostgreSQL High-Availability Cluster (based on “Patroni” and “DCS(etcd)”). Automating deployment with Ansible.
• https://github.com/vitessio/vitess Vitess – Database clustering system for horizontal scaling of MySQL through generalized sharding.

• https://kubedb.com KubeDB – Making running production-grade databases easy on Kubernetes.
• https://github.com/zalando/postgres-operator Postgres operator – The Postgres Operator enables highly-available PostgreSQL clusters on Kubernetes (K8s) powered by Patroni.
• https://github.com/zalando/spilo Spilo – HA PostgreSQL Clusters with Docker.
• https://gitlab.com/ongresinc/stackgres StackGres – Enterprise-grade, Full Stack PostgreSQL on Kubernetes.

• https://github.com/major/MySQLTuner-perl MySQLTuner-perl – Script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability.
• https://pgconfigurator.cybertec-postgresql.com PGConfigurator – Free online tool to generate an optimized `postgresql.conf`.
• https://github.com/gregs1104/pgtune pgtune – PostgreSQL configuration wizard.
• https://github.com/jfcoz/postgresqltuner postgresqltuner.pl – Simple script to analyse your PostgreSQL database configuration, and give tuning advice.

• https://www.dbmaestro.com DBmaestro – DBmaestro accelerates release cycles & supports agility across the entire IT ecosystem.
• https://www.quest.com/products/toad-devops-toolkit Toad DevOps Toolkit – Toad DevOps Toolkit executes key database development functions within your DevOps workflow —without compromising quality, performance or reliability.

• https://chartbrew.com Chartbrew – Create live dashboards, charts, and client reports from multiple databases and services.
• https://github.com/shzlw/poli Poli – An easy-to-use SQL reporting application built for SQL lovers.

• https://github.com/datacharmer/dbdeployer DBdeployer – Tool that deploys MySQL database servers easily.

• https://github.com/sqlcollaborative/dbatools dbatools – PowerShell module that you may think of like a command-line SQL Server Management Studio.

• https://github.com/PostgresApp/PostgresApp Postgres.app – Full-featured PostgreSQL installation packaged as a standard Mac app.
• https://www.bigsql.org BigSQL – A developer-friendly distribution of Postgres.
• https://github.com/credativ/elephant-shed Elephant Shed – Web-based PostgreSQL management front-end that bundles several utilities and applications for use with PostgreSQL.
• https://github.com/Vonng/pigsty Pigsty – Battery-Included Open-Source Distribution for PostgreSQL with ultimate observability & Database-as-Code toolbox for developers.

• https://github.com/cossacklabs/acra Acra – 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.
• https://github.com/securitybunker/databunker Databunker – Special GDPR compliant secure vault for customer records built on top of regular DB.
• https://github.com/poonai/inspektor Inspektor – Access control layer for databases. Inspektor leverages open policy agent to make policy decisions.

• https://holistic.dev Holistic.dev – Automatic detection service for database performance, security, and architecture issues.
• https://github.com/jarulraj/sqlcheck SQLCheck – Automatically detects common SQL anti-patterns.
• https://github.com/sqlfluff/sqlfluff SQLFluff – Dialect-flexible and configurable SQL linter.
• https://github.com/reata/sqllineage SQLLineage – SQL Lineage Analysis Tool powered by Python.
• https://github.com/tsqllint/tsqllint TSQLLint – A tool for describing, identifying, and reporting the presence of anti-patterns in TSQL scripts.

• https://partiql.org PartiQL – SQL-compatible access to relational, semi-structured, and nested data.

• https://calcite.apache.org Apache Calcite – Dynamic data management framework with advanced SQL features.
• https://github.com/google/zetasql ZetaSQL – Analyzer Framework for SQL.

• https://github.com/antlr/codebuff CodeBuff – Language-agnostic pretty-printing through machine learning.
• https://github.com/darold/pgFormatter pgFormatter – A PostgreSQL SQL syntax beautifier.
• https://poorsql.com Poor SQL – Instant free and open-source T-SQL formatting.
• https://github.com/zeroturnaround/sql-formatter SQL Formatter – JavaScript library for pretty-printing SQL queries.

• https://lost-at-sql.therobinlord.com Lost at SQL – A SQL learning game to help you pick up basic SQL skills - so that you can use queries to get information.
• https://datalemur.com/blog/games-to-learn-sql#schemaverse Schemaverse – A Space-based strategy game implemented entirely within a PostgreSQL database.
• https://sql-island.informatik.uni-kl.de SQL Island – After the survived plane crash, you will be stuck on SQL Island for the time being. By making progress in the game, you will find a way to escape from this island.
• https://mystery.knightlab.com SQL Murder Mystery – Designed to be both a self-directed lesson to learn SQL concepts and commands and a fun game for experienced SQL users to solve an intriguing crime.
• https://sqlpd.com SQL Police Department – In SQLPD, you get to solve crimes while learning SQL at the same time.

• https://www.sqlparser.com General SQL Parser – Parsing, formatting, modification and analysis for SQL.

• https://github.com/jOOQ/jOOQ jOOQ – Parses SQL, translates it to other dialects, and allows for expression tree transformations.

• https://github.com/JSQLParser/JSqlParser JSqlParser – Parses an SQL statement and translate it into a hierarchy of Java classes.
• https://github.com/pganalyze/libpg_query libpg_query – C library for accessing the PostgreSQL parser outside of the server environment.
• https://github.com/klahnakoski/mo-sql-parsing More SQL Parsing! – Parse SQL into JSON.
• https://github.com/andialbrecht/sqlparse sqlparse – Non-validating SQL parser for Python.
• https://github.com/tobymao/sqlglot SQLGlot – Pure Python SQL parser, transpiler, and builder.

Run SQL queries against anything

• https://github.com/cloudquery/cloudquery CloudQuery – Extracts, transforms, and loads your cloud assets into normalized PostgreSQL tables.
• https://github.com/mithrandie/csvq csvq – SQL-like query language for CSV.
• https://github.com/multiprocessio/dsq dsq – Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.
• https://github.com/vlsi/mat-calcite-plugin MAT Calcite plugin – This plugin for Eclipse Memory Analyzer allows to query heap dump via SQL.
• https://github.com/cube2222/octosql OctoSQL – Query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
• https://github.com/osquery/osquery osquery – SQL powered operating system instrumentation, monitoring, and analytics.
• https://www.resmo.com Resmo – Audit and evaluate resources using SQL.
• https://github.com/turbot/steampipe Steampipe – Use SQL to instantly query your cloud services (AWS, Azure, GCP and more).
• https://github.com/dinedal/textql TextQL – Execute SQL against structured text like CSV or TSV.
• https://github.com/noborus/trdsql trdsql – CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN.
• https://github.com/trinodb/trino Trino – Trino is a distributed SQL query engine designed to query large data sets distributed over one or more heterogeneous data sources.

• https://github.com/joe-re/sql-language-server SQLLanguageServer – SQL Language Server.
• https://github.com/lighttiger2505/sqls sqls – SQL Language Server written in Go.

Learning and puzzles for SQL

• https://github.com/smpetersgithub/AdvancedSQLPuzzles Advanced SQL Puzzles – Difficult set-based SQL puzzles.
• https://www.hackerrank.com/domains/sql Hackerrank – Practice coding, prepare for interviews, and get hired.
• https://www.manning.com/books/learn-sql-in-a-month-of-lunches Learn SQL in a Month of Lunches – A book about how to use SQL to retrieve, filter, and analyze data.
• https://leetcode.com/problemset/database LeetCode – Enhance your skills, expand your knowledge and prepare for technical interviews.
• https://selectstarsql.com Select Star SQL – Free interactive book which aims to be the best place on the internet for learning SQL.
• https://www.stratascratch.com/blog/categories/sql StrataScratch – Data science educational resources.
• https://github.com/NUKnightLab/sql-mysteries SQL Murder Mystery – Self-directed lesson to learn SQL concepts and commands and a fun game for experienced SQL users to solve an intriguing crime.

• https://github.com/dalibo/pev2 pev2 – A VueJS component to show a graphical vizualization of a PostgreSQL execution plan.
• https://github.com/mgartner/pg_flame pg_flame – A flamegraph generator for Postgres `EXPLAIN ANALYZE` output.

Useful SQL-scripts for various purposes

• https://github.com/LowlyDBA/dba-multitool DBA MultiTool – T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs for SQL Server.
• https://github.com/pgexperts/pgx_scripts pgx_scripts – A collection of useful little scripts for database analysis and administration, created by our team at PostgreSQL Experts.
• https://github.com/ioguix/pgsql-bloat-estimation pgsql-bloat-estimation – Queries to mesure statistical bloat in indexes and tables for PostgreSQL.
• https://gitlab.com/depesz/pgWikiDont pgWikiDont – SQL test that checks if your database follows rules from <https://wiki.postgresql.org/wiki/Don't_Do_This>.
• https://github.com/dataegret/pg-utils pg-utils – Useful PostgreSQL utilities.
• https://postgrescheatsheet.com Postgres cheat sheet – Useful SQL-scripts and commands by <timescale.com>.
• https://github.com/NikolayS/postgres_dba postgres_dba – The missing set of useful tools for Postgres DBAs and all engineers.
• https://gist.github.com/rgreenjr/3637525 postgres_queries_and_commands.sql – Useful PostgreSQL Queries and Commands.
• https://github.com/tanelpoder/tpt-oracle TPT – These sqlplus scripts are for Oracle Database performance optimization & troubleshooting.

• https://github.com/dbt-labs/dbt-core dbt – Transform your data by simply writing select statements, while dbt handles turning these statements into tables and views in a data warehouse.
• https://quicktable.io QuickTable – Empowers everyone to access, clean, analyze, transform, and model data with no code.

• https://github.com/amundsen-io/amundsen Amundsen – Metadata driven application for improving the productivity of data analysts, data scientists and engineers when interacting with data.
• https://github.com/datahub-project/datahub DataHub – The Metadata Platform for the Modern Data Stack.
• https://github.com/MarquezProject/marquez Marquez – Collect, aggregate, and visualize a data ecosystem's metadata.

• https://dwh.dev Dwh.dev – Nexgen data lineage for Snowflake.

• https://github.com/rapiddweller/rapiddweller-benerator-ce Benerator – Generate, obfuscate (anonymize / pseudonymize) and migrate data for development, testing and training purposes.
• https://www.devart.com/dbforge/mysql/data-generator dbForge Data Generator for MySQL – Powerful GUI tool for creating massive volumes of realistic test data.
• https://www.devart.com/dbforge/oracle/data-generator dbForge Data Generator for Oracle – Small but mighty GUI tool for populating Oracle schemas with tons of realistic test data.
• https://www.devart.com/dbforge/sql/data-generator dbForge Data Generator for SQL Server – Powerful GUI tool for a fast generation of meaningful test data for databases.
• https://github.com/faker-js/faker Faker – Generate massive amounts of fake data in the browser and Node.js.
• https://github.com/lesovsky/noisia Noisia – Harmful workload generator for PostgreSQL.
• https://soft-builder.com/sb-data-generator 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.
• https://docs.synthesized.io/tdk/latest Synthesized TDK – DevOps' best friend for database masking and generation.

• https://github.com/actiontech/dtle dtle – Distributed Data Transfer Service for MySQL.
• https://github.com/benbjohnson/litestream Litestream – Streaming replication for SQLite.
• https://github.com/ankane/pgsync pgsync – Sync Postgres data between databases.
• https://github.com/the4thdoctor/pg_chameleon pg_chameleon – 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.
• https://github.com/hasura/pgdeltastream PGDeltaStream – A Golang webserver to stream Postgres changes atleast-once over websockets, using Postgres logical decoding feature.
• https://github.com/2ndQuadrant/repmgr repmgr – The Most Popular Replication Manager for PostgreSQL.

• https://github.com/datafold/data-diff data-diff – Command-line tool and Python library to efficiently diff rows across two different databases.
• https://ksdbmerge.tools KS DB Merge Tools – GUI to compare and sync DB schema and data. For Oracle Database, MySQL, MariaDB, SQL Server, PostgreSQL, SQLite, MS Access and Cross-DBMS.

Documents, articles, manifestos and other theoretical materials on database tools

• https://github.com/mgramin/database-as-code The "Database as Code" Manifesto – Treat your database as Code.

• https://github.com/mindsdb/mindsdb MindsDB – In-database Machine Learning.
• https://github.com/sql-machine-learning/sqlflow SQLFlow – Brings SQL and AI together.

Fair Use Sources:

• https://github.com/mgramin/awesome-db-tools