Database Tools
Everything that makes working with databases easier.
Contents
IDE
Easily query, script, and visualize data from every database, file, and API.
Free universal database manager and SQL client.
Modern (JavaScript/Electron framework), open source IDE for MongoDB. It has features to support development, administration and performance tuning on MongoDB databases.
Lightweight client for managing MySQL, MSSQL and PostgreSQL, written in Delphi.
AI-powered SQL client and admin tool for popular databases(SQLite / MySQL / PostgreSQL / etc) on Windows / macOS / Linux, support table design, query, model, sync, export/import etc, focus on comfortable, fun and developer friendly.
Pinterest open-source Big Data Querying UI, combining collocated table metadata and a simple notebook IDE interface.
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.
Open source SQL IDE for Oracle, MySQL and PostgreSQL dbs.
GUI
Database management in a single PHP file.
Free Open Source Redis Manager. Available on Mac, Linux, Windows, Homebrew, Snap, winget, and more.
A modern, fast and productivity driven SQL client with a focus in UX. Available for Mac, Linux and Windows.
A data management tool that enables working with SQL Server, PostgreSQL, Azure SQL DB and SQL DW from Windows, macOS and Linux.
Open Source SQL Editor and Database Manager with a privacy commitment in their mission statement.
A lightweight database explorer with next-gen UX for all SQL, NoSQL, Caches, and Queues.
Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application.
Open Source PostgreSQL GUI - Automatic ER diagrams, Internal DB Insights, Disk Utilisation, Performance Metrics, Index Usage, Sequential scan counts and more.
Database Subsetting and Relational Data Browsing Tool/Client.
Yet Another WEB client for DB schema exploring and performance analysis, but originally created specifically for hacking and extending.
For MySQL, MariaDB, and Tarantool. Developed for Linux but can run on Windows.
Web tool for database management.
Web-based database browser for PostgreSQL, written in Go and works on macOS, Linux and Windows machines.
A web interface for MySQL and MariaDB.
Shell-centric cross-platform MongoDB management tool.
MySQL/MariaDB database management for macOS.
Fast, easy-to-use Mac database management application for working with MySQL & MariaDB databases.
A TUI for viewing SQLite databases, written in Go.
Web-based SQL editor run in your own private cloud.
Database management for VSCode.
SQL Editor & Open source simple business intelligence for Clickhouse.
Modern, native, and friendly GUI tool for relational databases: MySQL, PostgreSQL, SQLite & more.
CLI
Connect to a database for issue SQL commands within IPython or IPython Notebook.
A Cli for Redis with AutoCompletion and Syntax Highlighting.
Top-like admin tool for PostgreSQL.
Top-like application for PostgreSQL server activity monitoring.
Top for PostgreSQL.
PostgreSQL Pager.
CLI tools for manipulating SQLite database files - inserting data, running queries, creating indexes, configuring full-text search and more.
Command-line shell for issuing SQL to relational databases via JDBC.
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
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.
PostgreSQL CLI with autocompletion and syntax highlighting.
Vertica CLI with auto-completion and syntax highlighting.
Schema
Changes
Database configuration-as-code tool that utilizes concept of idempotent DDL scripts.
Inspect and Apply changes to your database schema.
Web-based, zero-config, dependency-free database schema change and version control tool for teams.
Database migration tool.
Online schema migration for MySQL.
Database-independent library for tracking, managing and applying database schema changes.
Like diff but for PostgreSQL schemas.
Node.js database migration management built exclusively for PostgreSQL. (But can also be used for other DBs conforming to SQL standard - e.g. CockroachDB.)
Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL.
Declarative database schema migration tool that uses a declarative data modeling syntax to describe your database schema.
Provides utilities to describe a PostgreSQL database schema as YAML.
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 system for MySQL and MariaDB, with support for sharding and external online schema change tools.
Sensible database-native change management for framework-free development and dependable deployment.
Idempotent schema management for MySQL, PostgreSQL, and more.
Yet another schema versioning and migration tool just made with native .NET Core 3.0+ and hopefully better.
Code generation
Diagrams
An Entity Relationship diagram (ERD) visualization tool, with various filters and inputs to help understand your database schema.
Free and Open-source database diagrams editor, visualize and design your DB with a single query.
Free, simple, and intuitive online database design tool and SQL generator.
Entity Relation Diagrams generation tool.
Open-source tool that generates beautiful and easy-to-read Entity Relationship Diagrams from your database and ORMs.
Documentations
Database Markup Language, designed to define and document database structures.
A free database schema discovery and comprehension tool.
Generating your database to HTML documentation, including Entity Relationship diagrams.
CI-Friendly tool for document a database, written in Go.
Design
API
A tool for exploring and publishing data.
A open source REST API backend for mobile, web, and IoT applications.
Turn multiple data sources into a single GraphQL API.
Blazing fast, instant realtime GraphQL APIs on PostgreSQL with fine grained access control, also trigger webhooks on database events.
Turns your database into a realtime GraphQL API.
Instantly spin-up a GraphQL API server by pointing PostGraphile at your existing PostgreSQL database.
REST API for any PostgreSQL database.
Is a way to serve a RESTful API from any databases written in Go.
End-to-end type-safe CRUD via REST API for your database, with fine-grained access control.
SQL generator with Java and HTTP APIs, uses a simple RESTful HTTP API with XML or JSON serialization.
Easily convert your SQL database into a REST API.
Automatically generate a RESTful API service for your legacy database.
Automatic SQLite RESTful and realtime API server.
Write templated SQL to automatically exposing RESTful APIs from your database/data warehouse/data lake.
Application platforms
Powerful open source low code framework to build internal applications really quickly.
Low-code platform for creating internal apps in minutes.
Low-code internal tool building platform.
The Open Source Firebase Alternative with GraphQL.
Open source no-code builder for web datatabase applications. Server and drag-and-drop UI builder, data stored in PostgreSQL or SQLite.
Fast SQL-only data application builder. Automatically build a UI on top of SQL queries.
Open-source low-code platform to build internal tools.
Backup
Backup and Recovery Manager for PostgreSQL.
Tool for scheduled PostgreSQL backups via web UI with external storages (local, S3, FTP, Google Drive, etc.), notifications (webhook, Discord, Slack, etc.) and team management.
Reliable PostgreSQL Backup & Restore.
Copy a PostgreSQL database to a target PostgreSQL server (pgdump | pgrestore on steroids).
A backup and recovery manager for PostgreSQL.
Agent-based platform for PostgreSQL backups and restores with decentralized execution and centralized orchestration.
Monitoring/Statistics/Perfomance
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.
Open source platform for managing and monitoring MySQL and MongoDB performance.
Pganalyze statistics collector for gathering PostgreSQL metrics and log data.
A fast PostgreSQL Log Analyzer.
A performance dashboard for PostgreSQL - health checks, suggested indexes, and more.
Collect and display information and stats from a running PostgreSQL server.
All-in-one tool to easily create an environment to visualize the health and performance of your PostgreSQL cluster.
Collects PostgreSQL statistics, and either saves them in CSV files or print them on the stdout.
Flexible self-contained PostgreSQL metrics monitoring/dashboarding solution.
Service to extract and provide metrics on your PostgreSQL database.
The open-source observability backend for metrics and traces powered by SQL.
Provides metrics for your PostgreSQL database.
Prometheus
Metrics exporter for PostgreSQL and PostgreSQL-related services.
Prometheus exporter for PostgreSQL server metrics.
Fully customizable Prometheus exporter for PostgreSQL & Pgbouncer with fine-grained execution control.
Testing
A database testing framework that supports easy test-driven development of your database code.
Unit Testing for PostgreSQL.
Regression Testing your SQL queries.
Automatically test DBMS in order to find logic bugs in their implementation.
HA/Failover/Sharding
PostgreSQL extension that distributes your data and your queries across multiple nodes.
A template for PostgreSQL High Availability with ZooKeeper, etcd, or Consul.
A High Scalability Solution for MySQL Clustering and High Availability.
Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Cloud native PostgreSQL manager for PostgreSQL high availability.
PostgreSQL extension and service for automated failover and high-availability.
PostgreSQL replication monitoring and failover daemon.
PostgreSQL partitioning as easy as pie.
High-Availibility for PostgreSQL, based on industry references Pacemaker and Corosync.
Open-source DBaaS that automates the deployment and management of highly available PostgreSQL clusters.
Database clustering system for horizontal scaling of MySQL through generalized sharding.
Kubernetes
Configuration Tuning
Script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability.
PostgreSQL configuration wizard.
Simple script to analyse your PostgreSQL database configuration, and give tuning advice.
Distributions
Tool that deploys MySQL database servers easily.
PowerShell module that you may think of like a command-line SQL Server Management Studio.
Full-featured PostgreSQL installation packaged as a standard Mac app.
Web-based PostgreSQL management front-end that bundles several utilities and applications for use with PostgreSQL.
Battery-Included Open-Source Distribution for PostgreSQL with ultimate observability & Database-as-Code toolbox for developers.
Security
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.
Special GDPR compliant secure vault for customer records built on top of regular DB.
Access control layer for databases. Inspektor leverages open policy agent to make policy decisions.
SQL
Automatically detects common SQL anti-patterns.
Dialect-flexible and configurable SQL linter.
SQL Lineage Analysis Tool powered by Python.
A tool for describing, identifying, and reporting the presence of anti-patterns in TSQL scripts.
Formatters
Language-agnostic pretty-printing through machine learning.
Open Source Java SQL Formatter for many RDBMS based on JSqlParser.
A PostgreSQL SQL syntax beautifier.
JavaScript library for pretty-printing SQL queries.
Parsers
Parses an SQL statement and translate it into a hierarchy of Java classes.
C library for accessing the PostgreSQL parser outside of the server environment.
Parse SQL into JSON.
Non-validating SQL parser for Python.
Pure Python SQL parser, transpiler, and builder.
Parses SQL, translates it to other dialects, and allows for expression tree transformations.
Über SQL
Extracts, transforms, and loads your cloud assets into normalized PostgreSQL tables.
SQL-like query language for CSV.
Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.
This plugin for Eclipse Memory Analyzer allows to query heap dump via SQL.
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).
Execute SQL against structured text like CSV or TSV.
CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN.
Distributed SQL query engine designed to query large data sets distributed over one or more heterogeneous data sources.
Language Server Protocol
Learning
Plan
Scripts
T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs for SQL Server.
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.
SQL test that checks if your database follows rules from <https://wiki.postgresql.org/wiki/Don'tDoThis>.
Useful PostgreSQL utilities.
The missing set of useful tools for PostgreSQL DBAs and all engineers.
These sqlplus scripts are for Oracle Database performance optimization & troubleshooting.
Data
Catalog
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.
Generation/Masking/Subsetting
Generate, obfuscate (anonymize / pseudonymize) and migrate data for development, testing and training purposes.
Generate massive amounts of fake data in the browser and Node.js.
Database anonymization and synthetic data generation tool for MySQL and PostgreSQL.
Streaming anonymizer for MySQL dump files. Reads mysqldump from stdin, writes anonymized version to stdout. Supports deterministic hashing, fixed values, JSON field anonymization, and Python extensions.
Harmful workload generator for PostgreSQL.
Database-agnostic seeding tool for generating realistic test data with support for PostgreSQL, MySQL, SQLite, Prisma, and Drizzle ORM.
Data Profilers
The DataProfiler is a Python library designed to make data analysis, monitoring, and sensitive data detection easy.
An open-source data profiler specifically focused on discovery and validation of complex patterns in data.
A general-purpose open-source data profiler for high-level analysis of a dataset.
Replication
Distributed Data Transfer Service for MySQL.
Streaming replication for SQLite.
Sync PostgreSQL data between databases.
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.
A Golang webserver to stream PostgreSQL changes atleast-once over websockets, using PostgreSQL logical decoding feature.
The Most Popular Replication Manager for PostgreSQL.