Awesome Database Tools

Community driven list of database 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.

Feel free to add information about your own db-tools or your favorite third-party db-tools.

For updates on awesome-db-tools and thoughts/news about databases/tools/SQL follow me at @GraminMaksim

Contents

• IDE
• GUI
• CLI
• Schema
  • Changes
  • Code generation
  • Diagrams
  • Documentations
  • Design
  • Samples
• API
• Application platforms
• Backup
• Cloning
• Monitoring/Statistics/Perfomance
  • Prometheus
  • Zabbix
• Testing
• HA/Failover/Sharding
• Kubernetes
• Configuration Tuning
• DevOps
• Reporting
• Distributions
• Security
• SQL
  • Analyzers
  • Extensions
  • Frameworks
  • Formatters
  • Games
  • Parsers
  • Über SQL
  • Language Server Protocol
  • Learning
  • Plan
  • Scripts
• Data
  • Catalog
  • Lineage
  • Generation/Masking/Subsetting
  • Replication
  • Compare
• Papers
• Machine Learning

IDE

• AnySQL Maestro - Premier multi-purpose admin tool for database management, control and development.
• Aqua Data Studio - Aqua Data Studio is productivity software for Database Developers, DBAs, and Analysts.
• Coginiti Pro - Modern IDE for analyst and analytics engineers with proweful script and grid functionality.
• Database .net - Multiple database management tool with support for 20+ databases.
• DataGrip - Cross-Platform IDE for Databases & SQL by JetBrains.
• DataStation - Easily query, script, and visualize data from every database, file, and API.
• DBeaver - Free universal database manager and SQL client.
• 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.
• DBHawk - Datasparc offers database security, database management, database governance and data analytics - all in one solution.
• dbKoda - Modern (JavaScript/Electron framework), open source IDE for MongoDB. It has features to support development, administration and performance tuning on MongoDB databases.
• IBExpert - Comprehensive GUI tool for Firebird and InterBase.
• HeidiSQL - A lightweight client for managing MySQL, MSSQL and PostgreSQL, written in Delphi.
• KeepTool - A professional suite of tools for Oracle Database developers, administrators and advanced application users.
• MySQL Workbench - MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.
• 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.
• 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.
• pgAdmin - The most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
• pgAdmin3 - Long Term Support for pgAdmin3.
• PL/SQL Developer - IDE that is specifically targeted at the development of stored program units for Oracle Databases.
• PostgreSQL Maestro - Complete and powerful database management, admin and development tool for PostgreSQL.
• Querybook - Querybook is a Pinterest open-source Big Data Querying UI, combining collocated table metadata and a simple notebook IDE interface.
• 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.
• 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.
• Toad - Toad is the premier database solution for developers, admins and data analysts. Manage complex database changes with a single database management tool.
• Toad Edge - Simplified database development tool for MySQL and Postgres.
• TOra - TOra is an open source SQL IDE for Oracle, MySQL and PostgreSQL dbs.
• Valentina Studio - Create, administer, query and explore Valentina DB, MySQL, MariaDB, PostgreSQL and SQLite databases for FREE.
• WebDB - Free Efficient Database IDE. Featuring Server Discovery, ERD, Data Generator, AI, NoSQL Structure Manager, Database Versioning and many more.

GUI

• Adminer - Database management in a single PHP file.
• Another Redis Desktop Manager - Free Open Source Redis Manager. Available on Mac, Linux, Windows, Homebrew, Snap, winget, and more.
• 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.
• Beekeeper Studio - Open Source SQL Editor and Database Manager with a privacy commitment in their mission statement.
• DbGate - Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application.
• DB Lens - Open Source Postgres GUI - Automatic ER diagrams, Internal DB Insights, Disk Utilisation, Performance Metrics, Index Usage, Sequential scan counts and more.
• DbVisualizer - Universal database tool for developers, DBAs and analysts.
• JackDB - Direct SQL access to all your data, no matter where it lives.
• Jailer - Database Subsetting and Relational Data Browsing Tool/Client.
• Malewicz - Yet Another WEB client for DB schema exploring and performance analysis, but originally created specifically for hacking and extending.
• MissionKontrol - Modern drag & drop admin panel/client with full user permissions for non-technical users.
• ocelotgui - For MySQL, MariaDB, and Tarantool. Developed for Linux but can run on Windows.
• OmniDB - Web tool for database management.
• Pgweb - Web-based database browser for PostgreSQL, written in Go and works on macOS, Linux and Windows machines.
• phpLiteAdmin - Web-based SQLite database admin tool written in PHP with support for SQLite3 and SQLite2.
• phpMyAdmin - A web interface for MySQL and MariaDB.
• psequel - PSequel provides a clean and simple interface for you to perform common PostgreSQL tasks quickly.
• PopSQL - Modern, collaborative SQL editor for your team.
• Postico - A Modern PostgreSQL Client for the Mac.
• Robo 3T - Robo 3T (formerly Robomongo) is a shell-centric cross-platform MongoDB management tool.
• Sequel Ace - MySQL/MariaDB database management for macOS.
• Sequel Pro - Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL & MariaDB databases.
• SQLite Expert - Graphical interface supports all SQLite features.
• sqlite-tui - A TUI for viewing sqlite databases, written in Go.
• sqlpad - Web-based SQL editor run in your own private cloud.
• SQLPro - A simple, powerful Postgres manager for macOS.
• 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.
• SQLTools - Database management for VSCode.
• SQLyog - The most complete and easy to use MySQL GUI.
• Tabix - SQL Editor & Open source simple business intelligence for Clickhouse.
• TablePlus - Modern, native, and friendly GUI tool for relational databases: MySQL, PostgreSQL, SQLite & more.
• TeamPostgreSQL - PostgreSQL Web Administration GUI - use your PostgreSQL databases from anywhere, with rich, lightning-fast AJAX web interface.
• Query.me - Collaborative SQL editor in Notebook format. Let's you reference query results using JINJA, visualize data, and schedule runs and exports.

CLI

• ipython-sql - Connect to a database for issue SQL commands within IPython or IPython Notebook.
• iredis - A Cli for Redis with AutoCompletion and Syntax Highlighting.
• pgcenter - Top-like admin tool for PostgreSQL.
• pg_activity - Top-like application for PostgreSQL server activity monitoring.
• pg_top - Top for PostgreSQL.
• pspg - Postgres Pager.
• SQLcl - Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database.
• sqlite-utils - CLI tools for manipulating SQLite database files - inserting data, running queries, creating indexes, configuring full-text search and more.
• SQLLine - Command-line shell for issuing SQL to relational databases via JDBC.
• 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!

dbcli

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

Schema

Changes

• 2bass - Database configuration-as-code tool that utilizes concept of idempotent DDL scripts.
• Atlas - Inspect and Apply changes to your database schema.
• Bytebase - Web-based, zero-config, dependency-free database schema change and version control tool for teams.
• flyway - Database migration tool.
• gh-ost - Online schema migration for MySQL.
• liquibase - Database-independent library for tracking, managing and applying database schema changes.
• migra - Like diff but for PostgreSQL schemas.
• 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.)
• pg-osc - Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL.
• Prisma Migrate - Declarative database schema migration tool that uses a declarative data modeling syntax to describe your database schema.
• Pyrseas - Provides utilities to describe a PostgreSQL database schema as YAML.
• Reshape - An easy-to-use, zero-downtime schema migration tool for Postgres.
• SchemaHero - A Kubernetes operator for declarative database schema management (gitops for database schemas).
• Skeema - Declarative pure-SQL schema management system for MySQL and MariaDB, with support for sharding and external online schema change tools.
• Sqitch - Sensible database-native change management for framework-free development and dependable deployment.
• sqldef - Idempotent schema management for MySQL, PostgreSQL, and more.
• yuniql - Yet another schema versioning and migration tool just made with native .NET Core 3.0+ and hopefully better.

Code generation

• ddl-generator - Infers SQL DDL (Data Definition Language) from table data.
• 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.

Diagrams