Top 50 Awesome List

mgramin/awesome-db-tools

Databases  11 days ago  757
Everything that makes working with databases easier
View byDAY/WEEK/README
View on Github

Awesome Database Tools Awesome

Community driven list of database tools

Here we will collect information about awesome useful and awesome experimental tools that simplify working with databases for DBA, DevOps, Developers and mere mortals.

Feel free to add information about your own db-tools or your favorite third-party db-tools.

For updates on awesome-db-tools and thoughts/news about databases/tools/SQL follow me at @GraminMaksim

Contents

IDE

  • AnySQL Maestro - Premier multi-purpose admin tool for database management, control and development.
  • Aqua Data Studio - Aqua Data Studio is productivity software for Database Developers, DBAs, and Analysts.
  • Database .net - Multiple database management tool with support for 20+ databases.
  • DataGrip - Cross-Platform IDE for Databases & SQL by JetBrains.
  • DataStationstars989 - Easily query, script, and visualize data from every database, file, and API.
  • DBeaverstars24.2k - Free universal database manager and SQL client.
  • dbForge Studio for MySQL - Universal IDE for MySQL and MariaDB database development, management, and administration.
  • dbForge Studio for Oracle - Powerful IDE for Oracle management, administration, and development.
  • dbForge Studio for PostgreSQL - GUI tool for managing and developing databases and objects.
  • dbForge Studio for SQL Server - Powerful integrated development environment for SQL Server development, management, administration, data analysis, and reporting.
  • dbKodastars833 - Modern (JavaScript/Electron framework), open source IDE for MongoDB. It has features to support development, administration and performance tuning on MongoDB databases.
  • IBExpert - Comprehensive GUI tool for Firebird and InterBase.
  • HeidiSQLstars2.9k - A lightweight client for managing MySQL, MSSQL and PostgreSQL, written in Delphi.
  • MySQL Workbench - MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.
  • Navicat - 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 - Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments.
  • pgAdmin - The most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
  • pgAdmin3 - Long Term Support for pgAdmin3.
  • PL/SQL Developer - IDE that is specifically targeted at the development of stored program units for Oracle Databases.
  • PostgreSQL Maestro - Complete and powerful database management, admin and development tool for PostgreSQL.
  • Toad - Toad is the premier database solution for developers, admins and data analysts. Manage complex database changes with a single database management tool.
  • Toad Edge - Simplified database development tool for MySQL and Postgres.
  • TOrastars258 - TOra is an open source SQL IDE for Oracle, MySQL and PostgreSQL dbs.
  • Valentina Studio - Create, administer, query and explore Valentina DB, MySQL, MariaDB, PostgreSQL and SQLite databases for FREE.

GUI Managers/Clients

  • Adminerstars5k - Database management in a single PHP file.
  • Beekeeper Studiostars8.4k - Open Source SQL Editor and Database Manager with a privacy commitment in their mission statement.
  • DbGatestars1.2k - Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application.
  • DbVisualizer - Universal database tool for developers, DBAs and analysts.
  • HouseOpsstars243 - Enterprise ClickHouse Ops UI for you run querys, monitoring ClickHouse health and make a lot of others thinks.
  • JackDB - Direct SQL access to all your data, no matter where it lives.
  • Jailerstars1k - Database Subsetting and Relational Data Browsing Tool/Client.
  • MissionKontrol - Modern drag & drop admin panel/client with full user permissions for non-technical users.
  • ocelotguistars52 - For MySQL, MariaDB, and Tarantool. Developed for Linux but can run on Windows.
  • OmniDBstars2.7k - Web tool for database management.
  • Pgwebstars7.2k - Web-based database browser for PostgreSQL, written in Go and works on macOS, Linux and Windows machines.
  • phpLiteAdmin - Web-based SQLite database admin tool written in PHP with support for SQLite3 and SQLite2.
  • phpMyAdminstars5.8k - A web interface for MySQL and MariaDB.
  • psequel - PSequel provides a clean and simple interface for you to perform common PostgreSQL tasks quickly.
  • PopSQL - Modern, collaborative SQL editor for your team.
  • Postico - A Modern PostgreSQL Client for the Mac.
  • Robo 3Tstars8.8k - Robo 3T (formerly Robomongo) is a shell-centric cross-platform MongoDB management tool.
  • Sequel Prostars8.6k - Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL & MariaDB databases.
  • SQL Operations Studiostars6.6k - A data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.
  • SQLite Expert - Graphical interface supports all SQLite features.
  • sqlite-tuistars919 - A TUI for viewing sqlite databases, written in Go.
  • sqlpadstars4.2k - Web-based SQL editor run in your own private cloud.
  • SQLPro - A simple, powerful Postgres manager for macOS.
  • SQuirreL - 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.
  • SQLToolsstars878 - Database management for VSCode.
  • SQLyog - The most complete and easy to use MySQL GUI.
  • Tabixstars1.5k - SQL Editor & Open source simple business intelligence for Clickhouse.
  • TablePlusstars2.6k - Modern, native, and friendly GUI tool for relational databases: MySQL, PostgreSQL, SQLite & more.
  • TeamPostgreSQL - PostgreSQL Web Administration GUI - use your PostgreSQL databases from anywhere, with rich, lightning-fast AJAX web interface.

CLI tools

dbcli

  • athenaclistars174 - AthenaCLI is a CLI tool for AWS Athena service that can do auto-completion and syntax highlighting.
  • liteclistars1.5k - CLI for SQLite Databases with auto-completion and syntax highlighting.
  • mssql-clistars1.2k - A command-line client for SQL Server with auto-completion and syntax highlighting.
  • myclistars10.1k - A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.
  • pgclistars10k - Postgres CLI with autocompletion and syntax highlighting.
  • vclistars76 - Vertica CLI with auto-completion and syntax highlighting.

DB-schema navigation and visualization

  • dbdiagram.io - Quick and simple tool for help you draw your database relationship diagrams and flow quickly using simple DSL language.
  • ERAlchemystars871 - Entity Relation Diagrams generation tool.
  • SchemaCrawlerstars1.2k - A free database schema discovery and comprehension tool.
  • Schema Spystars2.1k - Generating your database to HTML documentation, including Entity Relationship diagrams.
  • tblsstars1.2k - CI-Friendly tool for document a database, written in Go.

Modelers

  • ERBuilder Data Modeler - Easy-to-use database modeling software for high-quality data models. It's a complete data modeling solution for data modelers and data architects.
  • Navicat Data Modeler - A powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models.
  • Oracle SQL Developer Data Modeler - Oracle SQL Developer Data Modeler is a free graphical tool that enhances productivity and simplifies data modeling tasks.
  • pgmodelerstars2.3k - Data modeling tool designed for PostgreSQL.

Migration tools

  • 2bassstars32 - Database configuration-as-code tool that utilizes concept of idempotent DDL scripts.
  • Bytebasestars2.1k - Web-based, zero-config, dependency-free database schema change and version control tool for teams.
  • flywaystars6.3k - Database migration tool.
  • gh-oststars9.6k - Online schema migration for MySQL.
  • liquibasestars3k - Database-independent library for tracking, managing and applying database schema changes.
  • migrastars2.1k - Like diff but for PostgreSQL schemas.
  • node-pg-migratestars995 - Node.js database migration management built exclusively for postgres. (But can also be used for other DBs conforming to SQL standard - e.g. CockroachDB.)
  • Prisma Migratestars774 - Declarative database schema migration tool that uses a declarative data modeling syntax to describe your database schema.
  • Pyrseasstars322 - Provides utilities to describe a PostgreSQL database schema as YAML.
  • SchemaHerostars544 - A Kubernetes operator for declarative database schema management (gitops for database schemas).
  • Sqitchstars2.3k - Sensible database-native change management for framework-free development and dependable deployment.
  • yuniqlstars214 - Yet another schema versioning and migration tool just made with native .NET Core 3.0+ and hopefully better.

Code generation tools

  • ddl-generatorstars231 - Infers SQL DDL (Data Definition Language) from table data.
  • scheme2ddlstars67 - Command line util for export Oracle schema to set of ddl init scripts with ability to filter undesirable information, separate DDL in different files, pretty format output.

Wrappers

  • DreamFactorystars1.2k - A open source REST API backend for mobile, web, and IoT applications.
  • FBSQL Frontend Backend SQLstars16 - Work (secure) with your backend database within HTML.
  • Hasura GraphQL Enginestars25.3k - Blazing fast, instant realtime GraphQL APIs on Postgres with fine grained access control, also trigger webhooks on database events.
  • jl-sqlstars53 - SQL for JSON and CSV streams.
  • mysql_fdwstars392 - PostgreSQL foreign data wrapper for MySQL.
  • Oracle REST Data Services - A mid-tier Java application, ORDS maps HTTP(S) verbs (GET, POST, PUT, DELETE, etc.) to database transactions and returns any results formatted using JSON.
  • Prismastars16.8k - Prisma turns your database into a realtime GraphQL API.
  • PostgRESTstars18.3k - REST API for any Postgres database.
  • preststars3.1k - Is a way to serve a RESTful API from any databases written in Go.
  • restSQLstars130 - SQL generator with Java and HTTP APIs, uses a simple RESTful HTTP API with XML or JSON serialization.
  • resquelstars93 - Easily convert your SQL database into a REST API.
  • Saltcornstars629 - Open source no-code builder for web datatabase applications. Server and drag-and-drop UI builder, data stored in PostgreSQL or SQLite.
  • sandman2stars1.8k - Automatically generate a RESTful API service for your legacy database.
  • sql-bootstars55 - Advanced REST and UI wrapper for your SQL-queries.

Backup/Cloning tools

Replication/Data operation

  • Datasettestars5.7k - A tool for exploring and publishing data.
  • dtlestars428 - Distributed Data Transfer Service for MySQL.
  • pgsyncstars2.2k - Sync Postgres data between databases.
  • pg_chameleonstars297 - 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.
  • PGDeltaStreamstars219 - A Golang webserver to stream Postgres changes atleast-once over websockets, using Postgres logical decoding feature.
  • repmgrstars1.3k - The Most Popular Replication Manager for PostgreSQL.

Scripts

Monitoring/Statistics/Perfomance

  • ASH Viewerstars110 - Provides a graphical view of active session history data within the Oracle and PostgreSQL DB.
  • Monyog - Agentless & Cost-effective MySQL Monitoring Tool.
  • mssql-monitoringstars75 - Monitor your SQL Server on Linux performance using collectd, InfluxDB and Grafana.
  • Navicat Monitor - A safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible.
  • Percona Monitoring and Managementstars228 - Open source platform for managing and monitoring MySQL and MongoDB performance.
  • pganalyze collectorstars215 - Pganalyze statistics collector for gathering PostgreSQL metrics and log data.
  • postgres-checkup - New-generation diagnostics tool that allows users to do a deep analysis of the health of Postgres databases.
  • pgDash - Measure and track every aspect of your PostgreSQL databases.
  • PgHerostars6.2k - A performance dashboard for Postgres - health checks, suggested indexes, and more.
  • pgmetricsstars721 - Collect and display information and stats from a running PostgreSQL server.
  • pgMustard - A user interface for Postgres explain plans, plus tips to improve performance.
  • pgstatsstars97 - Collects PostgreSQL statistics, and either saves them in CSV files or print them on the stdout.
  • pgwatch2stars1.1k - Flexible self-contained PostgreSQL metrics monitoring/dashboarding solution.
  • Telegraf PostgreSQL plugin - Provides metrics for your postgres database.

Prometheus

Zabbix

  • Mamonsustars165 - Monitoring agent for PostgreSQL.
  • Orabbix - Orabbix is a plugin designed to work with Zabbix Enterprise Monitor to provide multi-tiered monitoring, performance and availability reporting and measurement for Oracle Databases, along with server performance metrics.
  • pg_monzstars160 - This is the Zabbix monitoring template for PostgreSQL Database.
  • Pyorastars96 - Python script to monitor Oracle Databases.
  • ZabbixDBAstars73 - ZabbixDBA is fast, flexible, and continuously developing plugin to monitor your RDBMS.

Testing

  • DbFitstars204 - A database testing framework that supports easy test-driven development of your database code.
  • RegreSQLstars224 - Regression Testing your SQL queries.

Data generator

  • Databene Benerator - It is a framework for generating realistic and valid high-volume test data for your system under test (avoiding the Datalite anti-pattern).
  • dbForge Data Generator for MySQL - Powerful GUI tool for creating massive volumes of realistic test data.
  • dbForge Data Generator for Oracle - Small but mighty GUI tool for populating Oracle schemas with tons of realistic test data.
  • dbForge Data Generator for SQL Server - Powerful GUI tool for a fast generation of meaningful test data for databases.
  • Noisiastars666 - Harmful workload generator for PostgreSQL.
  • SB Data Generator - Simple and powerful tool to generate and populate selected tables or entire databases with realistic test data for your applications. Generate test data for: Oracle, MS SQL Server, MySQL, PostgreSQL, Firebird, SQLite, Azure SQL Database, Amazon Redshift and Amazon RDS.

Administration

HA/Failover/Sharding

Kubernetes

  • KubeDB - Making running production-grade databases easy on Kubernetes.
  • Postgres operatorstars2.2k - The Postgres Operator enables highly-available PostgreSQL clusters on Kubernetes (K8s) powered by Patroni.
  • Spilostars924 - HA PostgreSQL Clusters with Docker.
  • StackGres - Enterprise-grade, Full Stack PostgreSQL on Kubernetes.

Configuration Tuning

  • MySQLTuner-perlstars7.3k - Script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability.
  • PGConfigurator - Free online tool to generate an optimized postgresql.conf.
  • pgtunestars959 - PostgreSQL configuration wizard.
  • postgresqltuner.plstars2.2k - Simple script to analyse your PostgreSQL database configuration, and give tuning advice.

DevOps

  • DBmaestro - DBmaestro accelerates release cycles & supports agility across the entire IT ecosystem.
  • Spawn - Cloud service for creating instant database copies for development and CI. No more local db installs, instant recovery to arbitrary save points, isolated copies for each feature branch or test. Instant provisioning regardless of database size.
  • Toad DevOps Toolkit - Toad DevOps Toolkit executes key database development functions within your DevOps workflow —without compromising quality, performance or reliability.

Schema samples

Reporting

  • Chartbrew - Create live dashboards, charts, and client reports from multiple databases and services.
  • Polistars1.9k - An easy-to-use SQL reporting application built for SQL lovers.

Distributions

  • DBdeployerstars546 - Tool that deploys MySQL database servers easily.
  • dbatoolsstars1.8k - PowerShell module that you may think of like a command-line SQL Server Management Studio.
  • Postgres.appstars6.2k - Full-featured PostgreSQL installation packaged as a standard Mac app.
  • BigSQL - A developer-friendly distribution of Postgres.
  • Elephant Shedstars159 - Web-based PostgreSQL management front-end that bundles several utilities and applications for use with PostgreSQL.

Security

  • Acrastars922 - 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.
  • Databunkerstars946 - Special GDPR compliant secure vault for customer records built on top of regular DB.

SQL

Analyzers

Extensions

  • PartiQL - SQL-compatible access to relational, semi-structured, and nested data.

Frameworks

Formatters

Parsers

Language Server Protocol

Contributing

ON THIS PAGE

  1. Awesome Database Tools Awesome
  2. Contents
  3. IDE
  4. GUI Managers/Clients
  5. CLI tools
  6. dbcli
  7. DB-schema navigation and visualization
  8. Modelers
  9. Migration tools
  10. Code generation tools
  11. Wrappers
  12. Backup/Cloning tools
  13. Replication/Data operation
  14. Scripts
  15. Monitoring/Statistics/Perfomance
  16. Prometheus
  17. Zabbix
  18. Testing
  19. Data generator
  20. Administration
  21. HA/Failover/Sharding
  22. Kubernetes
  23. Configuration Tuning
  24. DevOps
  25. Schema samples
  26. Reporting
  27. Distributions
  28. Security
  29. SQL
  30. Analyzers
  31. Extensions
  32. Frameworks
  33. Formatters
  34. Parsers
  35. Language Server Protocol
  36. Contributing
Last Checked At: 2022-01-24T04:38:00.209Z
Previous
erictleung/awesome-nosql-guides
Next
vaticle/typedb-awesome

About

Track your favorite github awesome repo, not just star it. trackawesomelist.com provides website, newsletter, RSS for tracking the popular awesome list by daily and weekly.
Contact us: [email protected]
Track Awesome List - Track your favorite Github awesome repos, not just star them | Product Hunt

Subscribe

Subscribe to our weekly newsletter to receive the awesome updates! We never send spam and you can unsubscribe instantly with one click. Here's past issues.

Links

Follow us on TwitterSubscribe us on TelegramSubmit awesome list repoNewsletterDonateSitemap