Top 50 Awesome List

mgramin/awesome-db-tools

Databases  2 months ago  689
Everything that makes working with databases easier
View byDAY/WEEK/README
View on Github

Sep 6th

GUI Managers/Clients

  • MissionKontrol - Modern drag & drop admin panel/client with full user permissions for non-technical users.
  • sqlite-tuistars799 - A TUI for viewing sqlite databases, written in Go.
  • Reporting

  • Chartbrew - Create live dashboards, charts, and client reports from multiple databases and services.
  • Aug 23rd

    Migration tools

  • Bytebasestars1.3k - Web-based, zero-config, dependency-free database schema change and version control tool for teams.
  • Jul 15th

    GUI Managers/Clients

  • Jailerstars845 - Database Subsetting and Relational Data Browsing Tool/Client.
  • Jun 18th

    DevOps

  • 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.
  • Jun 11th

    GUI Managers/Clients

  • Beekeeper Studiostars7.5k - Open Source SQL Editor and Database Manager with a privacy commitment in their mission statement.
  • Jun 5th

    Wrappers

  • Saltcornstars523 - Open source no-code builder for web datatabase applications. Server and drag-and-drop UI builder, data stored in PostgreSQL or SQLite.
  • Jun 4th

    Monitoring/Statistics/Perfomance

    Prometheus

  • pgSCVstars115 - Metrics exporter for PostgreSQL and Postgres-related services.
  • postgres_exporterstars1.5k - Prometheus exporter for PostgreSQL server metrics.
  • Security

  • Databunkerstars904 - Special GDPR compliant secure vault for customer records built on top of regular DB.
  • Oct 19th, 2020

    Wrappers

  • FBSQL Frontend Backend SQLstars16 - Work (secure) with your backend database within HTML.
  • Sep 22nd, 2020

    Migration tools

  • Prisma Migratestars774 - Declarative database schema migration tool that uses a declarative data modeling syntax to describe your database schema.
  • May 30th, 2020

    Migration tools

  • yuniqlstars197 - Yet another schema versioning and migration tool just made with native .NET Core 3.0+ and hopefully better.
  • Mar 22nd, 2020

    Distributions

  • dbatoolsstars1.7k - PowerShell module that you may think of like a command-line SQL Server Management Studio.
  • Mar 1st, 2020

    GUI Managers/Clients

  • SQLToolsstars849 - Database management for VSCode.
  • DB-schema navigation and visualization

  • tblsstars1.2k - CI-Friendly tool for document a database, written in Go.
  • CLI tools

  • iredisstars1.6k - A Cli for Redis with AutoCompletion and Syntax Highlighting.
  • Feb 10th, 2020

    IDE

  • Toad Edge - Simplified database development tool for MySQL and Postgres.
  • PL/SQL Developer - IDE that is specifically targeted at the development of stored program units for Oracle Databases.
  • GUI Managers/Clients

  • SQLite Expert - Graphical interface supports all SQLite features.
  • Jan 31st, 2020

    Wrappers

  • sandman2stars1.7k - Automatically generate a RESTful API service for your legacy database.
  • Configuration Tuning

  • MySQLTuner-perlstars7.2k - Script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability.
  • postgresqltuner.plstars2.2k - Simple script to analyse your PostgreSQL database configuration, and give tuning advice.
  • Migration tools

  • Sqitchstars2.2k - Sensible database-native change management for framework-free development and dependable deployment.
  • SchemaHerostars480 - A Kubernetes operator for declarative database schema management (gitops for database schemas).
  • Code formatters

  • CodeBuffstars382 - Language-agnostic pretty-printing through machine learning.
  • Security

  • Acrastars808 - 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.
  • Distributions

  • DBdeployerstars524 - Tool that deploys MySQL database servers easily.
  • Postgres.appstars6k - Full-featured PostgreSQL installation packaged as a standard Mac app.
  • BigSQL - A developer-friendly distribution of Postgres.
  • Elephant Shedstars154 - Web-based PostgreSQL management front-end that bundles several utilities and applications for use with PostgreSQL.
  • Monitoring/Statistics/Perfomance

  • mssql-monitoringstars75 - Monitor your SQL Server on Linux performance using collectd, InfluxDB and Grafana.
  • ASH Viewerstars100 - Provides a graphical view of active session history data within the Oracle and PostgreSQL DB.
  • HA/Failover/Sharding

  • postgresql_clusterstars403 - PostgreSQL High-Availability Cluster (based on "Patroni" and "DCS(etcd)"). Automating deployment with Ansible.
  • Testing

  • RegreSQLstars212 - Regression Testing your SQL queries.
  • Scripts

  • Postgres cheat sheet - Useful SQL-scripts and commands by <timescale.com>.
  • pgWikiDont - SQL test that checks if your database follows rules from https://wiki.postgresql.org/wiki/Don't_Do_This.
  • Jan 18th, 2020

    Configuration Tuning

  • PGConfigurator - Free online tool to generate an optimized postgresql.conf.
  • Jan 1st, 2020

    Code generation tools

  • scheme2ddlstars62 - 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

  • restSQLstars129 - SQL generator with Java and HTTP APIs, uses a simple RESTful HTTP API with XML or JSON serialization.
  • Dec 23rd, 2019

    Replication/Data operation

  • repmgrstars1.3k - The Most Popular Replication Manager for PostgreSQL.
  • Monitoring/Statistics/Perfomance

  • Percona Monitoring and Managementstars218 - Open source platform for managing and monitoring MySQL and MongoDB performance.
  • HA/Failover/Sharding

  • Citusstars5.4k - Postgres extension that distributes your data and your queries across multiple nodes.
  • patronistars4.3k - A template for PostgreSQL High Availability with ZooKeeper, etcd, or Consul.
  • Percona XtraDB Clusterstars276 - A High Scalability Solution for MySQL Clustering and High Availability.
  • stolonstars3.4k - Cloud native PostgreSQL manager for PostgreSQL high availability.
  • pg_auto_failoverstars662 - Postgres extension and service for automated failover and high-availability.
  • pglookoutstars136 - PostgreSQL replication monitoring and failover daemon.
  • PostgreSQL Automatic Failoverstars294 - High-Availibility for Postgres, based on industry references Pacemaker and Corosync.
  • Kubernetes

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

  • pgtunestars951 - PostgreSQL configuration wizard.
  • Nov 8th, 2019

    Monitoring/Statistics/Perfomance

    Zabbix

  • pg_monzstars162 - This is the Zabbix monitoring template for PostgreSQL Database.
  • Nov 6th, 2019

    Monitoring/Statistics/Perfomance

    Zabbix

  • Mamonsustars160 - Monitoring agent for PostgreSQL.
  • ZabbixDBAstars73 - ZabbixDBA is fast, flexible, and continuously developing plugin to monitor your RDBMS.
  • Oct 23rd, 2019

    Wrappers

  • sql-boot - Advanced REST and UI wrapper for your SQL-queries.
  • Jul 9th, 2019

    IDE

  • IBExpert - Comprehensive GUI tool for Firebird and InterBase.
  • pgAdmin3 - Long Term Support for pgAdmin3.
  • Scripts

  • TPTstars468 - These sqlplus scripts are for Oracle Database performance optimization & troubleshooting.
  • Jul 8th, 2019

    Scripts

  • postgres_queries_and_commands.sql - Useful PostgreSQL Queries and Commands.
  • Monitoring/Statistics/Perfomance

  • Telegraf PostgreSQL plugin - Provides metrics for your postgres database.
  • postgres-checkup - New-generation diagnostics tool that allows users to do a deep analysis of the health of Postgres databases.
  • IDE

  • dbKodastars823 - Modern (JavaScript/Electron framework), open source IDE for MongoDB. It has features to support development, administration and performance tuning on MongoDB databases.
  • HA/Failover/Sharding

  • Vitessstars12.7k - Database clustering system for horizontal scaling of MySQL through generalized sharding.
  • GUI Managers/Clients

  • PopSQL - Modern, collaborative SQL editor for your team.
  • Reporting

  • Polistars1.8k - An easy-to-use SQL reporting application built for SQL lovers.
  • Mar 30th, 2019

    Migration tools

  • migrastars2k - Like diff but for PostgreSQL schemas.
  • Wrappers

  • jl-sqlstars50 - SQL for JSON and CSV streams.
  • Hasura GraphQL Enginestars24.2k - Blazing fast, instant realtime GraphQL APIs on Postgres with fine grained access control, also trigger webhooks on database events.
  • CLI tools

    dbcli

  • athenaclistars164 - 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.1k - A command-line client for SQL Server with auto-completion and syntax highlighting.
  • myclistars9.9k - A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.
  • pgclistars9.9k - Postgres CLI with autocompletion and syntax highlighting.
  • vclistars76 - Vertica CLI with auto-completion and syntax highlighting.
  • GUI Managers/Clients

  • sqlpadstars4k - Web-based SQL editor run in your own private cloud.
  • JackDB - Direct SQL access to all your data, no matter where it lives.
  • DbVisualizer - Universal database tool for developers, DBAs and analysts.
  • SQLyog - The most complete and easy to use MySQL GUI.
  • 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.
  • Sequel Prostars8.5k - Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL & MariaDB databases.
  • phpLiteAdmin - Web-based SQLite database admin tool written in PHP with support for SQLite3 and SQLite2.
  • SQLPro - A simple, powerful Postgres manager for macOS.
  • psequel - PSequel provides a clean and simple interface for you to perform common PostgreSQL tasks quickly.
  • TeamPostgreSQL - PostgreSQL Web Administration GUI - use your PostgreSQL databases from anywhere, with rich, lightning-fast AJAX web interface.
  • Replication/Data operation

  • dtlestars392 - Distributed Data Transfer Service for MySQL.
  • Datasettestars5.5k - A tool for exploring and publishing data.
  • pgsyncstars2.1k - Sync Postgres data between databases.
  • Administration

  • pgslicestars757 - Postgres partitioning as easy as pie.
  • pgbedrockstars277 - Manage a Postgres cluster's roles, role memberships, schema ownership, and privileges.
  • Monitoring/Statistics/Perfomance

  • Monyog - Agentless & Cost-effective MySQL Monitoring Tool.
  • IDE

  • Valentina Studio - Create, administer, query and explore Valentina DB, MySQL, MariaDB, PostgreSQL and SQLite databases for FREE.
  • MySQL Workbench - MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.
  • PostgreSQL Maestro - Complete and powerful database management, admin and development tool for PostgreSQL.
  • AnySQL Maestro - Premier multi-purpose admin tool for database management, control and development.
  • TOrastars251 - TOra is an open source SQL IDE for Oracle, MySQL and PostgreSQL dbs.
  • CLI tools

  • pg_topstars99 - 'top' for PostgreSQL.
  • Mar 27th, 2019

    Monitoring/Statistics/Perfomance

  • pgMustard - A user interface for Postgres explain plans, plus tips to improve performance.
  • Oct 6th, 2018

    Migration tools

  • gh-oststars9.4k - Online schema migration for MySQL.
  • GUI Managers/Clients

  • Pgwebstars7.1k - Web-based database browser for PostgreSQL, written in Go and works on macOS, Linux and Windows machines.
  • Testing

    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).
  • Schema samples

  • Oracle Database Sample Schemasstars436 - Oracle Database Sample Schemas.
  • 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.
  • Code generation tools

  • ddl-generatorstars230 - Infers SQL DDL (Data Definition Language) from table data.
  • CLI tools

  • ipython-sqlstars1.4k - Connect to a database for issue SQL commands within IPython or IPython Notebook.
  • Oct 3rd, 2018

    CLI tools

  • pg_activitystars14 - Top like application for PostgreSQL server activity monitoring.
  • Sep 26th, 2018

    Wrappers

  • mysql_fdwstars381 - PostgreSQL foreign data wrapper for MySQL.
  • Replication/Data operation

  • pg_chameleonstars292 - 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.
  • Sep 16th, 2018

    Testing

    Data generator

  • 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.
  • GUI Managers/Clients

  • HouseOpsstars232 - Enterprise ClickHouse Ops UI for you run querys, monitoring ClickHouse health and make a lot of others thinks.
  • Sep 7th, 2018

    IDE

  • 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.
  • Jul 31st, 2018

    GUI Managers/Clients

  • OmniDBstars2.6k - Web tool for database management.
  • SQL Operations Studiostars6.5k - A data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.
  • Wrappers

  • DreamFactorystars1.2k - A open source REST API backend for mobile, web, and IoT applications.
  • Replication/Data operation

  • PGDeltaStreamstars216 - A Golang webserver to stream Postgres changes atleast-once over websockets, using Postgres logical decoding feature.
  • Monitoring/Statistics/Perfomance

  • pgDash - Measure and track every aspect of your PostgreSQL databases.
  • Jul 3rd, 2018

    Monitoring/Statistics/Perfomance

  • pgwatch2stars1.1k - Flexible self-contained PostgreSQL metrics monitoring/dashboarding solution.
  • Jun 22nd, 2018

    Migration tools

  • node-pg-migratestars970 - Node.js database migration management built exclusively for postgres. (But can also be used for other DBs conforming to SQL standard - e.g. CockroachDB.)
  • Jun 21st, 2018

    GUI Managers/Clients

  • Robo 3Tstars8.7k - Robo 3T (formerly Robomongo) is a shell-centric cross-platform MongoDB management tool.
  • Tabixstars1.4k - SQL Editor & Open source simple business intelligence for Clickhouse.
  • Monitoring/Statistics/Perfomance

  • PgHerostars6.1k - A performance dashboard for Postgres - health checks, suggested indexes, and more.
  • pganalyze collectorstars213 - Pganalyze statistics collector for gathering PostgreSQL metrics and log data.
  • IDE

  • Toad - Toad is the premier database solution for developers, admins and data analysts. Manage complex database changes with a single database management tool.
  • 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.
  • DevOps

  • Toad DevOps Toolkit - Toad DevOps Toolkit executes key database development functions within your DevOps workflow —without compromising quality, performance or reliability.
  • Modelers

  • Oracle SQL Developer Data Modeler - Oracle SQL Developer Data Modeler is a free graphical tool that enhances productivity and simplifies data modeling tasks.
  • CLI tools

  • SQLcl - Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database.
  • Jun 20th, 2018

    Testing

  • DbFitstars200 - A database testing framework that supports easy test-driven development of your database code.
  • DB-schema navigation and visualization

  • ERAlchemystars853 - Entity Relation Diagrams generation tool.
  • SchemaCrawlerstars1.1k - A free database schema discovery and comprehension tool.
  • Schema Spystars2k - Generating your database to HTML documentation, including Entity Relationship diagrams.
  • Jun 18th, 2018

    Administration

  • pgbadgerstars21 - A fast PostgreSQL Log Analyzer.
  • Monitoring/Statistics/Perfomance

  • pgstatsstars97 - Collects PostgreSQL statistics, and either saves them in CSV files or print them on the stdout.
  • Jun 17th, 2018

    IDE

  • Aqua Data Studio - Aqua Data Studio is productivity software for Database Developers, DBAs, and Analysts.
  • HeidiSQLstars2.8k - A lightweight client for managing MySQL, MSSQL and PostgreSQL, written in Delphi.
  • 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.
  • pgAdmin - The most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
  • GUI Managers/Clients

  • Adminerstars4.9k - Database management in a single PHP file.
  • phpMyAdminstars5.7k - A web interface for MySQL and MariaDB.
  • Postico - A Modern PostgreSQL Client for the Mac.
  • Modelers

  • Navicat Data Modeler - A powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models.
  • Scripts

  • pgx_scriptsstars957 - A collection of useful little scripts for database analysis and administration, created by our team at PostgreSQL Experts.
  • pgsql-bloat-estimationstars310 - Queries to mesure statistical bloat in indexes and tables for PostgreSQL.
  • pg-utilsstars577 - Useful PostgreSQL utilities.
  • postgres_dbastars569 - The missing set of useful tools for Postgres DBAs and all engineers.
  • Monitoring/Statistics/Perfomance

  • Navicat Monitor - A safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible.
  • DevOps

  • DBmaestro - DBmaestro accelerates release cycles & supports agility across the entire IT ecosystem.
  • Jun 14th, 2018

    Backup tools

  • pgbackreststars925 - Reliable PostgreSQL Backup & Restore.
  • Jun 13th, 2018

    CLI tools

  • usqlstars6.8k - A universal command-line interface for PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, and many other databasesstars6.8k including NoSQL and non-relational databases!
  • Jun 9th, 2018

    Wrappers

  • preststars2.9k - Is a way to serve a RESTful API from any databases written in Go.
  • resquelstars88 - Easily convert your SQL database into a REST API.
  • 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.
  • IDE

  • DataGrip - Cross-Platform IDE for Databases & SQL by JetBrains.
  • DBeaverstars22.8k - Free universal database manager and SQL client.
  • CLI tools

  • pspgstars1.7k - Postgres Pager.
  • Backup tools

  • BaRManstars1.2k - Backup and Recovery Manager for PostgreSQL.
  • Monitoring/Statistics/Perfomance

  • pgmetricsstars687 - Collect and display information and stats from a running PostgreSQL server.
  • Monitoring/Statistics/Perfomance

    Zabbix

  • 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.
  • Pyorastars96 - Python script to monitor Oracle Databases.
  • May 28th, 2018

    CLI tools

  • pgcenterstars1.3k - Top-like admin tool for PostgreSQL.
  • May 19th, 2018

    IDE

  • Database .net - Multiple database management tool with support for 20+ databases.
  • May 18th, 2018

    GUI Managers/Clients

  • TablePlusstars2.5k - Modern, native, and friendly GUI tool for relational databases: MySQL, PostgreSQL, SQLite & more.
  • Modelers

  • pgmodelerstars2.3k - Data modeling tool designed for PostgreSQL.
  • Migration tools

  • 2bassstars32 - Database configuration-as-code tool that utilizes concept of idempotent DDL scripts.
  • flywaystars6.2k - Database migration tool.
  • liquibasestars2.8k - Database-independent library for tracking, managing and applying database schema changes.
  • Pyrseasstars316 - Provides utilities to describe a PostgreSQL database schema as YAML.
  • Wrappers

  • Prismastars16.8k - Prisma turns your database into a realtime GraphQL API.
  • PostgRESTstars17.8k - REST API for any Postgres database.
  • Last Checked At: 2021-10-25T04:22:13.567Z
    Previous
    softwarebycl/awesome-contexture
    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