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.
Easily query, script, and visualize data from every database, file, and API.
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
Collaborative in-browser database IDE for your team. Supports PostgreSQL & MongoDB.
TOra is an open source SQL IDE for Oracle, MySQL and PostgreSQL dbs
Database management in a single PHP file
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.
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
Database explorer for Mac, Windows & Linux
Database Subsetting and Relational Data Browsing Tool.
Suprematistic hackable GUI SQL-manager written in SQL itself
GUI client for MySQL or MariaDB, including debugger
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
MySQL/MariaDB database management for macOS
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.
Python CLI utility and library for manipulating SQLite databases
Shell for issuing SQL to relational databases via JDBC
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 as code tool
A database toolkit
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
Easy CLI tool for making zero downtime schema changes and backfills in 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.
An easy-to-use, zero-downtime schema migration tool for Postgres
A Kubernetes operator for declarative database schema management (gitops for database schemas)
Declarative pure-SQL schema management for MySQL and MariaDB
Sensible database change management
Idempotent schema management for MySQL, PostgreSQL, and more
Free and open source schema versioning and database migration made natively with .NET Core.
Guesses table DDL based on data
Command line util for export oracle schema to set of ddl scripts
An Entity Relationship diagram (ERD) visualization tool, with various filters and inputs to help understand your database schema
Entity Relation Diagrams generation tool
Database Markup Language (DBML), designed to define and document database structures
Free database schema discovery and comprehension tool
SchemaSpy code home
tbls is a CI-Friendly tool for document a database, written in Go.
Ideas on better database design
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:
WWW SQL Designer, your online SQL diagramming tool
Oracle Database Sample Schemas
An open source multi-tool for exploring and publishing data
DreamFactory API Management Platform
Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
💾 Database Tools incl. ORM, Migrations and Admin UI (Postgres, MySQL & MongoDB)
Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database!
REST API for any Postgres database
PostgreSQL ➕ REST, low-code, simplify and accelerate development, ⚡ instant, realtime, high-performance on any Postgres application, existing or new
A CRUD framework for full stack TypeScript
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!
Budibase is an open-source low-code platform for creating internal apps in minutes. Supports PostgreSQL, MySQL, MSSQL, MongoDB, Rest API, Docker, K8s 🚀
The Open Source Firebase Alternative with GraphQL.
Free and open source no-code application builder
Barman - Backup and Recovery Manager for PostgreSQL
Reliable PostgreSQL Backup & Restore
Copy a Postgres database to a target Postgres server (pg_dump | pg_restore on steroids)
Postgres clone schema utility without need of going outside of database. Makes developers life easy by running single function to clone schema with all objects. It is very handy on Postgres RDS. Utility is sponsored by http://elephas.io/
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
PostgreSQL Monitoring, Metrics Collection and Alerting Resources from Crunchy Data
Collects PostgreSQL statistics, and either saves them in CSV files or print them on the stdout
PostgreSQL metrics monitor/dashboard
Tool that extracts and provides metrics on your PostgreSQL database
The open-source observability backend for metrics and traces powered by SQL 🚀
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
postgres 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
Detecting Logic Bugs in DBMS
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
Postgres partitioning as easy as pie
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
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
Pigsty - Battery-Included Open-Source Distribution for PostgreSQL
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
Open Policy for your Data layer 👮
Automatically identify anti-patterns in SQL queries
A SQL linter and auto-formatter for Humans
SQL Lineage Analysis Tool powered by Python
Configurable linting for TSQL
Language-agnostic pretty-printing through machine learning (uh, like, is this possible? YES, apparently).
A PostgreSQL SQL syntax beautifier that can work as a console program or as a CGI. On-line demo site at http://sqlformat.darold.net/
A whitespace formatter for different query languages
jOOQ is the best way to write SQL in Java
JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern
C library for accessing the PostgreSQL parser outside of the server environment
Let's make a SQL parser so we can provide a familiar interface to non-sql datastores!
A non-validating SQL parser module for Python
Python SQL Parser and Transpiler
The open-source cloud asset inventory powered by SQL.
SQL-like query language for csv
Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.
OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
SQL powered operating system instrumentation, monitoring, and analytics.
Use SQL to instantly query your cloud services (AWS, Azure, GCP and more). Open source CLI. No DB required.
Execute SQL against structured text like CSV or TSV
CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN. Can output to various formats.
Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
Language Server Protocol
SQL Language Server
SQL language server written in Go.
Welcome to my GitHub repository. I hope you enjoy solving these puzzles as much as I have enjoyed creating them.
Inspired by @veltman's command-line mystery, use SQL to research clues and find out whodunit!
Postgres Explain Visualizer 2
A flamegraph generator for Postgres EXPLAIN ANALYZE output.
T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs.
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
dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
Amundsen is a metadata driven application for improving the productivity of data analysts, data scientists and engineers when interacting with data.
The Metadata Platform for the Modern Data Stack
Collect, aggregate, and visualize a data ecosystem's metadata
Benerator is a leading software solution to generate, obfuscate, pseudonymize and migrate data for development, testing, and training purposes.
Generate massive amounts of fake data in the browser and node.js
Harmful workload generator for PostgreSQL
Distributed Data Transfer Service for MySQL
Streaming replication for SQLite.
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)
Efficiently diff rows across two different databases.
The "Database as Code" Manifesto