Skip to content

This is a community driven list of database tools (ide, cli, managing, monitoring, migrations, modelers, visualization etc)

Notifications You must be signed in to change notification settings

JordanS22/awesome-db-tools

 
 

Repository files navigation

Awesome

awesome-db-tools

Here we will collect information about various db-tools such as db-IDE, db-managment tools, db-migration tools, db-metric tools, db-ops tools etc etc.

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

Contents

IDE

  • 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.
  • DBeaver - Free universal database manager and SQL client.
  • HeidiSQL - 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.
  • 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.
  • Toad - Toad is the premier database solution for developers, admins and data analysts. Manage complex database changes with a single database management tool.

GUI Managers/Clients

  • Adminer - Database management in a single PHP file.
  • OmniDB - Web tool for database management.
  • phpMyAdmin - A web interface for MySQL and MariaDB.
  • Postico - A Modern PostgreSQL Client for the Mac.
  • Robo 3T - Robo 3T (formerly Robomongo) is a shell-centric cross-platform MongoDB management tool.
  • SQL Operations Studio - A data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.
  • Tabix - SQL Editor & Open source simple business intelligence for Clickhouse.
  • TablePlus - Modern, native, and friendly GUI tool for relational databases: MySQL, PostgreSQL, SQLite & more.

CLI tools

  • pgcenter - Top-like admin tool for PostgreSQL.
  • pspg - Postgres Pager.
  • SQLcl - Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database.
  • usql - A universal command-line interface for PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, and many other databases including NoSQL and non-relational databases!

DB-schema navigation and visualization

  • ERAlchemy - Entity Relation Diagrams generation tool.
  • SchemaCrawler - A free database schema discovery and comprehension tool.
  • Schema Spy - Generating your database to HTML documentation, including Entity Relationship diagrams.

Modelers

  • 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.
  • pgmodeler - Data modeling tool designed for PostgreSQL.

Migration tools

  • 2bass - Database configuration-as-code tool that utilizes concept of idempotent DDL scripts.
  • flyway - Database migration tool.
  • gh-ost - GitHub's online schema migration for MySQL.
  • liquibase - Database-independent library for tracking, managing and applying database schema changes.
  • node-pg-migrate - Node.js database migration management built exclusively for postgres. (But can also be used for other DBs conforming to SQL standard - e.g. CockroachDB.)
  • Pyrseas - Provides utilities to describe a PostgreSQL database schema as YAML.

HTTP wrappers

  • DreamFactory - A open source REST API backend for mobile, web, and IoT applications.
  • 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.
  • Prisma - Prisma turns your database into a realtime GraphQL API.
  • PostgREST - REST API for any Postgres database.
  • prest - Is a way to serve a RESTful API from any databases written in Go.
  • restSQL - Is a open-source, ultra-lightweight data access layer for HTTP clients.
  • resquel - Easily convert your SQL database into a REST API.

Backup tools

  • pgbackrest - Reliable PostgreSQL Backup & Restore.
  • BaRMan - Backup and Recovery Manager for PostgreSQL.

Replication

  • PGDeltaStream - A Golang webserver to stream Postgres changes atleast-once over websockets, using Postgres logical decoding feature.

Scripts

  • pgx_scripts - A collection of useful little scripts for database analysis and administration, created by our team at PostgreSQL Experts.
  • pgsql-bloat-estimation - Queries to mesure statistical bloat in indexes and tables for PostgreSQL.
  • pg-utils - Useful PostgreSQL utilities.
  • postgres_dba - 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.
  • pganalyze collector - Pganalyze statistics collector for gathering PostgreSQL metrics and log data.
  • pgDash - Measure and track every aspect of your PostgreSQL databases.
  • PgHero - A performance dashboard for Postgres - health checks, suggested indexes, and more.
  • pgmetrics - Collect and display information and stats from a running PostgreSQL server.
  • pgstats - Collects PostgreSQL statistics, and either saves them in CSV files or print them on the stdout.
  • pgwatch2 - Flexible self-contained PostgreSQL metrics monitoring/dashboarding solution.

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.
  • ZabbixDBA - ZabbixDBA is fast, flexible, and continuously developing plugin to monitor your RDBMS.
  • Pyora - Python script to monitor Oracle Databases.

Testing

  • DbFit - A database testing framework that supports easy test-driven development of your database code.

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).

Administration

  • patroni - A template for PostgreSQL High Availability with ZooKeeper, etcd, or Consul.
  • pgbadger - A fast PostgreSQL Log Analyzer.
  • pgtune - PostgreSQL configuration wizard.

DevOps

  • DBmaestro - DBmaestro accelerates release cycles & supports agility across the entire IT ecosystem.
  • Toad DevOps Toolkit - Toad DevOps Toolkit executes key database development functions within your DevOps workflow —without compromising quality, performance or reliability.

Contributing

License

CC0

About

This is a community driven list of database tools (ide, cli, managing, monitoring, migrations, modelers, visualization etc)

Resources

Code of conduct

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published