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
Database management in a single PHP file
Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application
A simple ClickHouse client.
Database Subsetting and Relational Data Browsing Tool.
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.
A TUI for viewing and editing database files.
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
Database management for VSCode
TablePlus macOS issue tracker
%%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 (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.
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:
DB schema as code tool
Web-based, zero-config, dependency-free database schema change and version control tool for teams. Public demo: https://demo.bytebase.com
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
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.
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 your DB 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), low-code, 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
Free and open source no-code application builder
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
A lightweight replication manager for PostgreSQL (Postgres) - latest version 5.3.0 (2021-10-12)
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
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 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.
pgSCV is a multi-purpose monitoring agent and metrics exporter for Weaponry.IO
A PostgreSQL metric exporter for Prometheus
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
Manage a Postgres cluster's roles, role memberships, schema ownership, and privileges
Postgres partitioning as easy as pie
Distributed PostgreSQL as an extension
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
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.
Secure SDK/vault for personal records/PII built to comply with GDPR
Language-agnostic pretty-printing through machine learning (uh, like, is this possible? YES, apparently).