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.
Thank you mgramin & contributors
View Topic on GitHub:
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.
Free universal database tool and SQL client
State of the art MongoDB IDE
A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL and SQLite, written in Delphi
TOra is an open source SQL IDE for Oracle, MySQL and PostgreSQL dbs
Premier multi-purpose admin tool for database management, control and development.
Aqua Data Studio is productivity software for Database Developers, DBAs, and Analysts.
Multiple database management tool with support for 20+ databases.
Universal IDE for MySQL and MariaDB database development, management, and administration.
Powerful IDE for Oracle management, administration, and development.
GUI tool for managing and developing databases and objects.
Powerful integrated development environment for SQL Server development, management, administration, data analysis, and reporting.
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.
A database development tool that allows you to simultaneously connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application.
Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments.
The most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
IDE that is specifically targeted at the development of stored program units for Oracle Databases.
Complete and powerful database management, admin and development tool for PostgreSQL.
Toad is the premier database solution for developers, admins and data analysts. Manage complex database changes with a single database management tool.
Simplified database development tool for MySQL and Postgres.
Database management in a single PHP file
A simple ClickHouse client.
Web tool for database management
Cross-platform client for PostgreSQL databases
A web interface for MySQL and MariaDB
Native cross-platform MongoDB management tool
MySQL/MariaDB database management for macOS
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.
Web-based SQL editor run in your own private cloud. Supports MySQL, Postgres, SQL Server, Vertica, Crate, ClickHouse, Presto, SAP HANA, Cassandra, Snowflake, BigQuery, SQLite, and more with ODBC
Database management for VSCode
TablePlus macOS issue tracker
Web-based SQLite database admin tool written in PHP with support for SQLite3 and SQLite2.
PSequel provides a clean and simple interface for you to perform common PostgreSQL tasks quickly.
Graphical interface supports all SQLite features.
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.
%%sql magic for IPython, hopefully evolving into full SQL client
Interactive Redis: A Terminal Client for Redis with AutoCompletion and Syntax Highlighting.
Command-line admin tool for observing and troubleshooting Postgres.
WARNING: Personal fork. pg_activity repository is now hosted here https://github.com/dalibo/pg_activity
Mirror of https://gitlab.com/pg_top/pg_top
Unix pager designed for work with tables. Designed for PostgreSQL, but MySQL is supported too. Now it can be used as CSV or TSV viewer. Works well with pgcli too.
Universal command-line interface for SQL databases
AthenaCLI is a CLI tool for AWS Athena service that can do auto-completion and syntax highlighting.
CLI for SQLite Databases with auto-completion and syntax highlighting
A command-line client for SQL Server with auto-completion and syntax highlighting
A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.
Postgres CLI with autocompletion and syntax highlighting
Vertica CLI with auto-completion and syntax highlighting
DB-schema navigation and visualization
Entity Relation Diagrams generation tool
Free database schema discovery and comprehension tool
SchemaSpy code home
tbls is a CI-Friendly tool for document a database, written in Go.
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:
Powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. ![App Store][app-store Icon]
DB schema as code tool
Flyway by Redgate • Database Migrations Made Easy.
GitHub's Online Schema Migrations for MySQL
Main Liquibase Source
Like diff but for PostgreSQL schemas
Node.js database migration management for Postgresql
Declarative data modeling & database migrations
Provides utilities for Postgres database schema versioning.
A Kubernetes operator for declarative database schema management (gitops for database schemas)
Sensible database change management
Free and open source schema versioning and database migration made natively with .NET Core.
Code generation tools
Guesses table DDL based on data
Command line util for export oracle schema to set of ddl scripts
DreamFactory API Management Platform
Work (secure) with your backend database within HTML
Blazing fast, instant realtime GraphQL APIs on Postgres with fine grained access control, also trigger webhooks on database events.
SQL for JSON and CSV streams
PostgreSQL foreign data wrapper for MySQL
💾 Database Tools incl. ORM, Migrations and Admin UI (Postgres, MySQL & MongoDB)
REST API for any Postgres database
pREST (PostgreSQL REST), simplify and accelerate development, ⚡ instant, realtime, high-performance on any Postgres application, existing or new
restSQL service and core framework
Easily convert your SQL database into a REST API using Express.js
Automatically generate a RESTful API service for your legacy database. No code required!
Advanced REST-wrapper for your SQL-queries (actually not only SQL)
Reliable PostgreSQL Backup & Restore
Barman - Backup and Recovery Manager for PostgreSQL
An open source multi-tool for exploring and publishing data
Distributed Data Transfer Service for MySQL
Sync data from one Postgres database to another
MySQL to PostgreSQL replica system
Streaming Postgres logical replication changes atleast-once over websockets
The Most Popular Replication Manager for PostgreSQL (Postgres) - latest version 5.2.1 (2020-12-07)
A collection of useful little scripts for database analysis and administration, created by our team at PostgreSQL Experts.
Queries to mesure statistical bloat in indexes and tables for PostgreSQL
Useful PostgreSQL utilities
The missing set of useful tools for Postgres DBAs and all engineers
Tanel Poder's Troubleshooting & Performance Tools for Oracle Databases
SQL test that checks if your database follows rules from https://wiki.postgresql.org/wiki/Don't_Do_This.
ASH Viewer provides a graphical view of active session history data within the Oracle and PostgreSQL DB
Monitor your SQL Server on Linux performance using collectd, InfluxDB and Grafana
PMM general repo
pganalyze statistics collector for gathering PostgreSQL metrics and log data
A PostgresSQL metric exporter for Prometheus
A performance dashboard for Postgres
Collect and display information and stats from a running PostgreSQL server
Collects PostgreSQL statistics, and either saves them in CSV files or print them on the stdout
PostgreSQL metrics monitor/dashboard
The plugin-driven server agent for collecting & reporting metrics.
A safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible.
a new-generation diagnostics tool that allows users to collect deep analysis of the health of a Postgres database.
This is the Zabbix monitoring template for PostgreSQL Database.
Python script to monitor Oracle Databases
Zabbix Database Monitoring Service (Oracle, Pg, MySQL, MS SQL, DB2, etc.)
DbFit is a database testing framework that supports easy test-driven development of your database code.
Regression Testing your SQL queries
It is a framework for generating realistic and valid high-volume test data for your system under test (avoiding the Datalite anti-pattern).
Powerful GUI tool for creating massive volumes of realistic test data.
Small but mighty GUI tool for populating Oracle schemas with tons of realistic test data.
Manage a Postgres cluster's roles, role memberships, schema ownership, and privileges
Postgres partitioning as easy as pie
Distributed PostgreSQL as an extension - for multi-tenant and real-time analytics workloads
A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes
A High Scalability Solution for MySQL Clustering and High Availability
PostgreSQL cloud native High Availability and more.
Postgres extension and service for automated failover and high-availability
PostgreSQL replication monitoring and failover daemon
PostgreSQL Automatic Failover: High-Availibility for Postgres, based on Pacemaker and Corosync.
PostgreSQL High-Availability Cluster (based on "Patroni" and "DCS(etcd)"). Automating deployment with Ansible.
Vitess is a database clustering system for horizontal scaling of MySQL.
Postgres operator creates and manages PostgreSQL clusters running in Kubernetes
Highly available elephant herd: HA PostgreSQL cluster using Docker
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.
PostgreSQL configuration wizard
Simple script to analyse your PostgreSQL database configuration, and give tuning advice
DBmaestro accelerates release cycles & supports agility across the entire IT ecosystem.
Oracle Database Sample Schemas
An easy-to-use BI server built for SQL lovers. Power data analysis in SQL and gain faster business insights.
DBdeployer is a tool that deploys MySQL database servers easily.
🚀 SQL Server automation and instance migrations have never been safer, faster or freer
The easiest way to get started with PostgreSQL on the Mac
PostgreSQL Management Appliance
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.
Language-agnostic pretty-printing through machine learning (uh, like, is this possible? YES, apparently).