Database Tools
Everything that makes working with databases easier.
Contents
IDE
Easily query, script, and visualize data from every database, file, and API.
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.
A 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.
GUI
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.
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-based database browser for PostgreSQL, written in Go and works on macOS, Linux and Windows machines.
CLI
Schema
Changes
Database configuration-as-code tool that utilizes concept of idempotent DDL scripts.
Web-based, zero-config, dependency-free database schema change and version control tool for teams.
Database-independent library for tracking, managing and applying database schema changes.
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.
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.
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.
Documentations
Design
API
A open source REST API backend for mobile, web, and IoT applications.
Blazing fast, instant realtime GraphQL APIs on PostgreSQL with fine grained access control, also trigger webhooks on database events.
Instantly spin-up a GraphQL API server by pointing PostGraphile at your existing PostgreSQL database.
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.
Application platforms
Powerful open source low code framework to build internal applications really quickly.
Open source no-code builder for web datatabase applications. Server and drag-and-drop UI builder, data stored in PostgreSQL or SQLite.
Backup
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.
Cloning
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 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.
Prometheus
Zabbix
Testing
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.
PostgreSQL extension and service for automated failover and high-availability.
High-Availibility for PostgreSQL, based on industry references Pacemaker and Corosync.
Kubernetes
Configuration Tuning
Distributions
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.
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.
SQL
A tool for describing, identifying, and reporting the presence of anti-patterns in TSQL scripts.
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.
Extracts, transforms, and loads your cloud assets into normalized PostgreSQL tables.
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).
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>.
Data
Catalog
Generation/Masking/Subsetting
Generate, obfuscate (anonymize / pseudonymize) and migrate data for development, testing and training purposes.
Database anonymization and synthetic data generation tool for MySQL and PostgreSQL.
Data Profilers
Replication
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.