1055 lines
52 KiB
HTML
1055 lines
52 KiB
HTML
<h1 id="awesome-database-tools-awesome">Awesome Database Tools <a
|
||
href="https://awesome.re"><img src="https://awesome.re/badge.svg"
|
||
alt="Awesome" /></a></h1>
|
||
<blockquote>
|
||
<p>Community driven list of database tools</p>
|
||
</blockquote>
|
||
<p>Here we will collect information about awesome useful and awesome
|
||
experimental tools that simplify working with databases for DBA, DevOps,
|
||
Developers and mere mortals.</p>
|
||
<p>Feel free to add information about your own db-tools or your favorite
|
||
third-party db-tools.</p>
|
||
<p>For updates on <code>awesome-db-tools</code> and thoughts/news about
|
||
databases/tools/SQL follow me at <a
|
||
href="https://twitter.com/GraminMaksim"><span class="citation"
|
||
data-cites="GraminMaksim">@GraminMaksim</span></a></p>
|
||
<h2 id="contents">Contents</h2>
|
||
<ul>
|
||
<li><a href="#ide">IDE</a></li>
|
||
<li><a href="#gui">GUI</a></li>
|
||
<li><a href="#cli">CLI</a></li>
|
||
<li><a href="#schema">Schema</a>
|
||
<ul>
|
||
<li><a href="#changes">Changes</a></li>
|
||
<li><a href="#code-generation">Code generation</a></li>
|
||
<li><a href="#diagrams">Diagrams</a></li>
|
||
<li><a href="#documentations">Documentations</a></li>
|
||
<li><a href="#design">Design</a></li>
|
||
<li><a href="#samples">Samples</a></li>
|
||
</ul></li>
|
||
<li><a href="#api">API</a></li>
|
||
<li><a href="#application-platforms">Application platforms</a></li>
|
||
<li><a href="#backup">Backup</a></li>
|
||
<li><a href="#cloning">Cloning</a></li>
|
||
<li><a
|
||
href="#monitoringstatisticsperfomance">Monitoring/Statistics/Perfomance</a>
|
||
<ul>
|
||
<li><a href="#prometheus">Prometheus</a></li>
|
||
<li><a href="#zabbix">Zabbix</a></li>
|
||
</ul></li>
|
||
<li><a href="#testing">Testing</a></li>
|
||
<li><a href="#hafailoversharding">HA/Failover/Sharding</a></li>
|
||
<li><a href="#kubernetes">Kubernetes</a></li>
|
||
<li><a href="#configuration-tuning">Configuration Tuning</a></li>
|
||
<li><a href="#devops">DevOps</a></li>
|
||
<li><a href="#reporting">Reporting</a></li>
|
||
<li><a href="#distributions">Distributions</a></li>
|
||
<li><a href="#security">Security</a></li>
|
||
<li><a href="#sql">SQL</a>
|
||
<ul>
|
||
<li><a href="#analyzers">Analyzers</a></li>
|
||
<li><a href="#extensions">Extensions</a></li>
|
||
<li><a href="#frameworks">Frameworks</a></li>
|
||
<li><a href="#formatters">Formatters</a></li>
|
||
<li><a href="#games">Games</a></li>
|
||
<li><a href="#parsers">Parsers</a></li>
|
||
<li><a href="#über-sql">Über SQL</a></li>
|
||
<li><a href="#language-server-protocol">Language Server
|
||
Protocol</a></li>
|
||
<li><a href="#learning">Learning</a></li>
|
||
<li><a href="#plan">Plan</a></li>
|
||
<li><a href="#scripts">Scripts</a></li>
|
||
</ul></li>
|
||
<li><a href="#data">Data</a>
|
||
<ul>
|
||
<li><a href="#catalog">Catalog</a></li>
|
||
<li><a href="#lineage">Lineage</a></li>
|
||
<li><a
|
||
href="#generationmaskingsubsetting">Generation/Masking/Subsetting</a></li>
|
||
<li><a href="#replication">Replication</a></li>
|
||
<li><a href="#compare">Compare</a></li>
|
||
</ul></li>
|
||
<li><a href="#papers">Papers</a></li>
|
||
<li><a href="#machine-learning">Machine Learning</a></li>
|
||
</ul>
|
||
<h2 id="ide">IDE</h2>
|
||
<ul>
|
||
<li><a href="https://www.sqlmaestro.com/products/anysql/maestro">AnySQL
|
||
Maestro</a> - Premier multi-purpose admin tool for database management,
|
||
control and development.</li>
|
||
<li><a href="https://www.aquafold.com/aquadatastudio">Aqua Data
|
||
Studio</a> - Aqua Data Studio is productivity software for Database
|
||
Developers, DBAs, and Analysts.</li>
|
||
<li><a href="https://www.coginiti.co/products/coginiti-pro/">Coginiti
|
||
Pro</a> - Modern IDE for analyst and analytics engineers with proweful
|
||
script and grid functionality.</li>
|
||
<li><a href="http://fishcodelib.com/Database.htm">Database .net</a> -
|
||
Multiple database management tool with support for 20+ databases.</li>
|
||
<li><a href="https://www.jetbrains.com/datagrip">DataGrip</a> -
|
||
Cross-Platform IDE for Databases & SQL by JetBrains.</li>
|
||
<li><a
|
||
href="https://github.com/multiprocessio/datastation">DataStation</a> -
|
||
Easily query, script, and visualize data from every database, file, and
|
||
API.</li>
|
||
<li><a href="https://github.com/dbeaver/dbeaver">DBeaver</a> - Free
|
||
universal database manager and SQL client.</li>
|
||
<li><a href="https://www.devart.com/dbforge/edge/">dbForge Edge</a> -
|
||
Multidatabase solution for DB development, design, management, and
|
||
administration of MySQL, MariaDB, SQL Server, Oracle, PostgreSQL
|
||
databases, and various cloud services.</li>
|
||
<li><a href="https://www.devart.com/dbforge/mysql/studio">dbForge Studio
|
||
for MySQL</a> - Universal IDE for MySQL and MariaDB database
|
||
development, management, and administration.</li>
|
||
<li><a href="https://www.devart.com/dbforge/oracle/studio">dbForge
|
||
Studio for Oracle</a> - Powerful IDE for Oracle management,
|
||
administration, and development.</li>
|
||
<li><a href="https://www.devart.com/dbforge/postgresql/studio">dbForge
|
||
Studio for PostgreSQL</a> - GUI tool for managing and developing
|
||
databases and objects.</li>
|
||
<li><a href="https://www.devart.com/dbforge/sql/studio">dbForge Studio
|
||
for SQL Server</a> - Powerful integrated development environment for SQL
|
||
Server development, management, administration, data analysis, and
|
||
reporting.</li>
|
||
<li><a href="https://www.datasparc.com/">DBHawk</a> - Datasparc offers
|
||
database security, database management, database governance and data
|
||
analytics - all in one solution.</li>
|
||
<li><a href="https://github.com/SouthbankSoftware/dbkoda">dbKoda</a> -
|
||
Modern (JavaScript/Electron framework), open source IDE for MongoDB. It
|
||
has features to support development, administration and performance
|
||
tuning on MongoDB databases.</li>
|
||
<li><a href="http://www.ibexpert.net/ibe">IBExpert</a> - Comprehensive
|
||
GUI tool for Firebird and InterBase.</li>
|
||
<li><a href="https://github.com/HeidiSQL/HeidiSQL">HeidiSQL</a> - A
|
||
lightweight client for managing MySQL, MSSQL and PostgreSQL, written in
|
||
Delphi.</li>
|
||
<li><a href="https://github.com/dbkangaroo/kangaroo">Kangaroo</a> - 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.</li>
|
||
<li><a href="https://keeptool.com">KeepTool</a> - A professional suite
|
||
of tools for Oracle Database developers, administrators and advanced
|
||
application users.</li>
|
||
<li><a href="https://www.mysql.com/products/workbench">MySQL
|
||
Workbench</a> - MySQL Workbench is a unified visual tool for database
|
||
architects, developers, and DBAs.</li>
|
||
<li><a href="https://www.navicat.com/en/products#navicat">Navicat</a> -
|
||
A database development tool that allows you to simultaneously connect to
|
||
MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases
|
||
from a single application.</li>
|
||
<li><a
|
||
href="http://www.oracle.com/technetwork/developer-tools/sql-developer">Oracle
|
||
SQL Developer</a> - Oracle SQL Developer is a free, integrated
|
||
development environment that simplifies the development and management
|
||
of Oracle Database in both traditional and Cloud deployments.</li>
|
||
<li><a href="https://www.pgadmin.org">pgAdmin</a> - The most popular and
|
||
feature rich Open Source administration and development platform for
|
||
PostgreSQL, the most advanced Open Source database in the world.</li>
|
||
<li><a href="https://www.bigsql.org/pgadmin3">pgAdmin3</a> - Long Term
|
||
Support for pgAdmin3.</li>
|
||
<li><a
|
||
href="https://www.allroundautomations.com/products/pl-sql-developer">PL/SQL
|
||
Developer</a> - IDE that is specifically targeted at the development of
|
||
stored program units for Oracle Databases.</li>
|
||
<li><a
|
||
href="https://www.sqlmaestro.com/products/postgresql/maestro">PostgreSQL
|
||
Maestro</a> - Complete and powerful database management, admin and
|
||
development tool for PostgreSQL.</li>
|
||
<li><a href="https://github.com/pinterest/querybook">Querybook</a> -
|
||
Querybook is a Pinterest open-source Big Data Querying UI, combining
|
||
collocated table metadata and a simple notebook IDE interface.</li>
|
||
<li><a href="https://github.com/slashbaseide/slashbase">Slashbase</a> -
|
||
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.</li>
|
||
<li><a
|
||
href="https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-ssms">Sql
|
||
Server Management Studio</a> - SQL Server Management Studio (SSMS) is an
|
||
integrated environment for managing any SQL infrastructure, for SQL
|
||
Server and Azure SQL Databases.</li>
|
||
<li><a href="https://www.quest.com/toad/">Toad</a> - Toad is the premier
|
||
database solution for developers, admins and data analysts. Manage
|
||
complex database changes with a single database management tool.</li>
|
||
<li><a href="https://www.toadworld.com/products/toad-edge">Toad Edge</a>
|
||
- Simplified database development tool for MySQL and Postgres.</li>
|
||
<li><a href="https://github.com/tora-tool/tora">TOra</a> - TOra is an
|
||
open source SQL IDE for Oracle, MySQL and PostgreSQL dbs.</li>
|
||
<li><a
|
||
href="https://www.valentina-db.com/en/valentina-studio-overview">Valentina
|
||
Studio</a> - Create, administer, query and explore Valentina DB, MySQL,
|
||
MariaDB, PostgreSQL and SQLite databases for FREE.</li>
|
||
<li><a href="https://webdb.app">WebDB</a> - Free Efficient Database IDE.
|
||
Featuring Server Discovery, ERD, Data Generator, AI, NoSQL Structure
|
||
Manager, Database Versioning and many more.</li>
|
||
</ul>
|
||
<h2 id="gui">GUI</h2>
|
||
<ul>
|
||
<li><a href="https://github.com/vrana/adminer">Adminer</a> - Database
|
||
management in a single PHP file.</li>
|
||
<li><a
|
||
href="https://github.com/qishibo/AnotherRedisDesktopManager">Another
|
||
Redis Desktop Manager</a> - Free Open Source Redis Manager. Available on
|
||
Mac, Linux, Windows, Homebrew, Snap, winget, and more.</li>
|
||
<li><a href="https://github.com/antares-sql/antares">Antares SQL</a> - A
|
||
modern, fast and productivity driven SQL client with a focus in UX.
|
||
Available for Mac, Linux and Windows.</li>
|
||
<li><a href="https://github.com/microsoft/azuredatastudio">Azure Data
|
||
Studio</a> - A data management tool that enables working with SQL
|
||
Server, PostgreSQL, Azure SQL DB and SQL DW from Windows, macOS and
|
||
Linux.</li>
|
||
<li><a
|
||
href="https://github.com/beekeeper-studio/beekeeper-studio">Beekeeper
|
||
Studio</a> - Open Source SQL Editor and Database Manager with a privacy
|
||
commitment in their mission statement.</li>
|
||
<li><a href="https://github.com/clidey/whodb">Clidey WhoDB</a> - A
|
||
lightweight database explorer with next-gen UX for all SQL, NoSQL,
|
||
Caches, and Queues.</li>
|
||
<li><a href="https://github.com/dbgate/dbgate">DbGate</a> - Database
|
||
manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others.
|
||
Runs under Windows, Linux, Mac or as web application.</li>
|
||
<li><a href="https://github.com/dblens/app">DB Lens</a> - Open Source
|
||
Postgres GUI - Automatic ER diagrams, Internal DB Insights, Disk
|
||
Utilisation, Performance Metrics, Index Usage, Sequential scan counts
|
||
and more.</li>
|
||
<li><a href="https://www.dbvis.com">DbVisualizer</a> - Universal
|
||
database tool for developers, DBAs and analysts.</li>
|
||
<li><a href="https://www.jackdb.com">JackDB</a> - Direct SQL access to
|
||
all your data, no matter where it lives.</li>
|
||
<li><a href="https://github.com/Wisser/Jailer">Jailer</a> - Database
|
||
Subsetting and Relational Data Browsing Tool/Client.</li>
|
||
<li><a href="https://github.com/mgramin/malewicz">Malewicz</a> - Yet
|
||
Another WEB client for DB schema exploring and performance analysis, but
|
||
originally created specifically for hacking and extending.</li>
|
||
<li><a href="https://www.missionkontrol.io">MissionKontrol</a> - Modern
|
||
drag & drop admin panel/client with full user permissions for
|
||
non-technical users.</li>
|
||
<li><a href="https://github.com/ocelot-inc/ocelotgui">ocelotgui</a> -
|
||
For MySQL, MariaDB, and Tarantool. Developed for Linux but can run on
|
||
Windows.</li>
|
||
<li><a href="https://github.com/OmniDB/OmniDB">OmniDB</a> - Web tool for
|
||
database management.</li>
|
||
<li><a href="https://github.com/sosedoff/pgweb">Pgweb</a> - Web-based
|
||
database browser for PostgreSQL, written in Go and works on macOS, Linux
|
||
and Windows machines.</li>
|
||
<li><a href="https://www.phpliteadmin.org">phpLiteAdmin</a> - Web-based
|
||
SQLite database admin tool written in PHP with support for SQLite3 and
|
||
SQLite2.</li>
|
||
<li><a href="https://github.com/phpmyadmin/phpmyadmin">phpMyAdmin</a> -
|
||
A web interface for MySQL and MariaDB.</li>
|
||
<li><a href="http://www.psequel.com">psequel</a> - PSequel provides a
|
||
clean and simple interface for you to perform common PostgreSQL tasks
|
||
quickly.</li>
|
||
<li><a href="https://popsql.com">PopSQL</a> - Modern, collaborative SQL
|
||
editor for your team.</li>
|
||
<li><a href="https://eggerapps.at/postico">Postico</a> - A Modern
|
||
PostgreSQL Client for the Mac.</li>
|
||
<li><a href="https://github.com/Studio3T/robomongo">Robo 3T</a> - Robo
|
||
3T (formerly Robomongo) is a shell-centric cross-platform MongoDB
|
||
management tool.</li>
|
||
<li><a href="https://github.com/Sequel-Ace/Sequel-Ace">Sequel Ace</a> -
|
||
MySQL/MariaDB database management for macOS.</li>
|
||
<li><a href="https://github.com/sequelpro/sequelpro">Sequel Pro</a> -
|
||
Sequel Pro is a fast, easy-to-use Mac database management application
|
||
for working with MySQL & MariaDB databases.</li>
|
||
<li><a href="http://www.sqliteexpert.com/index.html">SQLite Expert</a> -
|
||
Graphical interface supports all SQLite features.</li>
|
||
<li><a href="https://github.com/mathaou/sqlite-tui">sqlite-tui</a> - A
|
||
TUI for viewing sqlite databases, written in Go.</li>
|
||
<li><a href="https://github.com/rickbergfalk/sqlpad">sqlpad</a> -
|
||
Web-based SQL editor run in your own private cloud.</li>
|
||
<li><a href="https://www.macpostgresclient.com">SQLPro</a> - A simple,
|
||
powerful Postgres manager for macOS.</li>
|
||
<li><a href="https://sourceforge.net/projects/squirrel-sql">SQuirreL</a>
|
||
- 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.</li>
|
||
<li><a href="https://github.com/mtxr/vscode-sqltools">SQLTools</a> -
|
||
Database management for VSCode.</li>
|
||
<li><a href="https://www.webyog.com/product/sqlyog">SQLyog</a> - The
|
||
most complete and easy to use MySQL GUI.</li>
|
||
<li><a href="https://github.com/tabixio/tabix">Tabix</a> - SQL Editor
|
||
& Open source simple business intelligence for Clickhouse.</li>
|
||
<li><a href="https://github.com/TablePlus/TablePlus">TablePlus</a> -
|
||
Modern, native, and friendly GUI tool for relational databases: MySQL,
|
||
PostgreSQL, SQLite & more.</li>
|
||
<li><a href="http://www.teampostgresql.com">TeamPostgreSQL</a> -
|
||
PostgreSQL Web Administration GUI - use your PostgreSQL databases from
|
||
anywhere, with rich, lightning-fast AJAX web interface.</li>
|
||
<li><a href="https://query.me">Query.me</a> - Collaborative SQL editor
|
||
in Notebook format. Let’s you reference query results using JINJA,
|
||
visualize data, and schedule runs and exports.</li>
|
||
</ul>
|
||
<h2 id="cli">CLI</h2>
|
||
<ul>
|
||
<li><a
|
||
href="https://github.com/catherinedevlin/ipython-sql">ipython-sql</a> -
|
||
Connect to a database for issue SQL commands within IPython or IPython
|
||
Notebook.</li>
|
||
<li><a href="https://github.com/laixintao/iredis">iredis</a> - A Cli for
|
||
Redis with AutoCompletion and Syntax Highlighting.</li>
|
||
<li><a href="https://github.com/lesovsky/pgcenter">pgcenter</a> -
|
||
Top-like admin tool for PostgreSQL.</li>
|
||
<li><a href="https://github.com/julmon/pg_activity">pg_activity</a> -
|
||
Top-like application for PostgreSQL server activity monitoring.</li>
|
||
<li><a href="https://github.com/markwkm/pg_top">pg_top</a> - Top for
|
||
PostgreSQL.</li>
|
||
<li><a href="https://github.com/okbob/pspg">pspg</a> - Postgres
|
||
Pager.</li>
|
||
<li><a
|
||
href="http://www.oracle.com/technetwork/developer-tools/sqlcl/overview/index.html">SQLcl</a>
|
||
- Oracle SQL Developer Command Line (SQLcl) is a free command line
|
||
interface for Oracle Database.</li>
|
||
<li><a href="https://github.com/simonw/sqlite-utils">sqlite-utils</a> -
|
||
CLI tools for manipulating SQLite database files - inserting data,
|
||
running queries, creating indexes, configuring full-text search and
|
||
more.</li>
|
||
<li><a href="https://github.com/julianhyde/sqlline">SQLLine</a> -
|
||
Command-line shell for issuing SQL to relational databases via
|
||
JDBC.</li>
|
||
<li><a href="https://github.com/xo/usql">usql</a> - A universal
|
||
command-line interface for PostgreSQL, MySQL, Oracle Database, SQLite3,
|
||
Microsoft SQL Server, and many other databases including NoSQL and
|
||
non-relational databases!</li>
|
||
</ul>
|
||
<h3 id="dbcli">dbcli</h3>
|
||
<ul>
|
||
<li><a href="https://github.com/dbcli/athenacli">athenacli</a> -
|
||
AthenaCLI is a CLI tool for AWS Athena service that can do
|
||
auto-completion and syntax highlighting.</li>
|
||
<li><a href="https://github.com/dbcli/litecli">litecli</a> - CLI for
|
||
SQLite Databases with auto-completion and syntax highlighting.</li>
|
||
<li><a href="https://github.com/dbcli/mssql-cli">mssql-cli</a> - A
|
||
command-line client for SQL Server with auto-completion and syntax
|
||
highlighting.</li>
|
||
<li><a href="https://github.com/dbcli/mycli">mycli</a> - A Terminal
|
||
Client for MySQL with AutoCompletion and Syntax Highlighting.</li>
|
||
<li><a href="https://github.com/dbcli/pgcli">pgcli</a> - Postgres CLI
|
||
with autocompletion and syntax highlighting.</li>
|
||
<li><a href="https://github.com/dbcli/vcli">vcli</a> - Vertica CLI with
|
||
auto-completion and syntax highlighting.</li>
|
||
</ul>
|
||
<h2 id="schema">Schema</h2>
|
||
<h3 id="changes">Changes</h3>
|
||
<ul>
|
||
<li><a href="https://github.com/CourseOrchestra/2bass">2bass</a> -
|
||
Database configuration-as-code tool that utilizes concept of idempotent
|
||
DDL scripts.</li>
|
||
<li><a href="https://github.com/ariga/atlas">Atlas</a> - Inspect and
|
||
Apply changes to your database schema.</li>
|
||
<li><a href="https://github.com/bytebase/bytebase">Bytebase</a> -
|
||
Web-based, zero-config, dependency-free database schema change and
|
||
version control tool for teams.</li>
|
||
<li><a href="https://github.com/flyway/flyway">flyway</a> - Database
|
||
migration tool.</li>
|
||
<li><a href="https://github.com/github/gh-ost">gh-ost</a> - Online
|
||
schema migration for MySQL.</li>
|
||
<li><a href="https://github.com/liquibase/liquibase">liquibase</a> -
|
||
Database-independent library for tracking, managing and applying
|
||
database schema changes.</li>
|
||
<li><a href="https://github.com/djrobstep/migra">migra</a> - Like diff
|
||
but for PostgreSQL schemas.</li>
|
||
<li><a
|
||
href="https://github.com/salsita/node-pg-migrate">node-pg-migrate</a> -
|
||
Node.js database migration management built exclusively for postgres.
|
||
(But can also be used for other DBs conforming to SQL standard -
|
||
e.g. CockroachDB.)</li>
|
||
<li><a href="https://github.com/shayonj/pg-osc">pg-osc</a> - Easy CLI
|
||
tool for making zero downtime schema changes and backfills in
|
||
PostgreSQL.</li>
|
||
<li><a href="https://github.com/prisma/migrate">Prisma Migrate</a> -
|
||
Declarative database schema migration tool that uses a declarative data
|
||
modeling syntax to describe your database schema.</li>
|
||
<li><a href="https://github.com/perseas/Pyrseas">Pyrseas</a> - Provides
|
||
utilities to describe a PostgreSQL database schema as YAML.</li>
|
||
<li><a href="https://github.com/fabianlindfors/reshape">Reshape</a> - An
|
||
easy-to-use, zero-downtime schema migration tool for Postgres.</li>
|
||
<li><a href="https://github.com/schemahero/schemahero">SchemaHero</a> -
|
||
A Kubernetes operator for declarative database schema management (gitops
|
||
for database schemas).</li>
|
||
<li><a href="https://github.com/skeema/skeema">Skeema</a> - Declarative
|
||
pure-SQL schema management system for MySQL and MariaDB, with support
|
||
for sharding and external online schema change tools.</li>
|
||
<li><a href="https://github.com/sqitchers/sqitch">Sqitch</a> - Sensible
|
||
database-native change management for framework-free development and
|
||
dependable deployment.</li>
|
||
<li><a href="https://github.com/k0kubun/sqldef">sqldef</a> - Idempotent
|
||
schema management for MySQL, PostgreSQL, and more.</li>
|
||
<li><a href="https://github.com/rdagumampan/yuniql">yuniql</a> - Yet
|
||
another schema versioning and migration tool just made with native .NET
|
||
Core 3.0+ and hopefully better.</li>
|
||
</ul>
|
||
<h3 id="code-generation">Code generation</h3>
|
||
<ul>
|
||
<li><a
|
||
href="https://github.com/catherinedevlin/ddl-generator">ddl-generator</a>
|
||
- Infers SQL DDL (Data Definition Language) from table data.</li>
|
||
<li><a href="https://github.com/qwazer/scheme2ddl">scheme2ddl</a> -
|
||
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.</li>
|
||
</ul>
|
||
<h3 id="diagrams">Diagrams</h3>
|
||
<ul>
|
||
<li><a href="https://github.com/azimuttapp/azimutt">Azimutt</a> - An
|
||
Entity Relationship diagram (ERD) visualization tool, with various
|
||
filters and inputs to help understand your database schema.</li>
|
||
<li><a href="https://github.com/chartdb/chartdb">ChartDB</a> - Free and
|
||
Open-source database diagrams editor, visualize and design your DB with
|
||
a single query.</li>
|
||
<li><a href="https://github.com/drawdb-io/drawdb">DrawDB</a> - Free,
|
||
simple, and intuitive online database design tool and SQL
|
||
generator.</li>
|
||
<li><a href="https://github.com/Alexis-benoist/eralchemy">ERAlchemy</a>
|
||
- Entity Relation Diagrams generation tool.</li>
|
||
<li><a href="https://www.erdlab.io/">ERD Lab</a> - Free cloud based
|
||
entity relationship diagram (ERD) tool made for developers.</li>
|
||
<li><a href="https://github.com/liam-hq/liam">Liam ERD</a> - Open-source
|
||
tool that generates beautiful and easy-to-read Entity Relationship
|
||
Diagrams from your database and ORMs.</li>
|
||
<li><a href="https://www.quickdatabasediagrams.com/">QuickDBD</a> -
|
||
Simple online tool to quickly draw database diagrams.</li>
|
||
</ul>
|
||
<h3 id="documentations">Documentations</h3>
|
||
<ul>
|
||
<li><a href="https://dbdocs.io/">dbdocs</a> - Create web-based database
|
||
documentation using DSL code.</li>
|
||
<li><a href="https://github.com/holistics/dbml">DBML</a> - Database
|
||
Markup Language, designed to define and document database
|
||
structures.</li>
|
||
<li><a
|
||
href="https://github.com/schemacrawler/SchemaCrawler">SchemaCrawler</a>
|
||
- A free database schema discovery and comprehension tool.</li>
|
||
<li><a href="https://github.com/schemaspy/schemaspy">Schema Spy</a> -
|
||
Generating your database to HTML documentation, including Entity
|
||
Relationship diagrams.</li>
|
||
<li><a href="https://github.com/k1LoW/tbls">tbls</a> - CI-Friendly tool
|
||
for document a database, written in Go.</li>
|
||
</ul>
|
||
<h3 id="design">Design</h3>
|
||
<ul>
|
||
<li><a href="https://github.com/alextanhongpin/database-design">Database
|
||
Design</a> - Useful tips for designing robust database schema.</li>
|
||
<li><a href="https://dbdiagram.io">DBDiagram</a> - A free, simple tool
|
||
to draw ER diagrams by just writing code.</li>
|
||
<li><a href="https://dbschema.com/">DbSchema</a> - Universal database
|
||
designer for out-of-the-box schema management, schema documentation,
|
||
design in a team, and deployment on multiple databases. DbSchema
|
||
features tools for writing and executing queries, exploring the data,
|
||
generating data, and building reports.</li>
|
||
<li><a href="https://soft-builder.com/erbuilder-data-modeler">ERBuilder
|
||
Data Modeler</a> - Easy-to-use database modeling software for
|
||
high-quality data models. It’s a complete data modeling solution for
|
||
data modelers and data architects.</li>
|
||
<li><a href="https://www.datensen.com">Moon Modeler</a> - Data modeling
|
||
tool for both noSQL and relational databases. Available for Windows,
|
||
Linux and macOS.</li>
|
||
<li><a
|
||
href="https://www.navicat.com/en/products/navicat-data-modeler">Navicat
|
||
Data Modeler</a> - A powerful and cost-effective database design tool
|
||
which helps you build high-quality conceptual, logical and physical data
|
||
models.</li>
|
||
<li><a
|
||
href="http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html">Oracle
|
||
SQL Developer Data Modeler</a> - Oracle SQL Developer Data Modeler is a
|
||
free graphical tool that enhances productivity and simplifies data
|
||
modeling tasks.</li>
|
||
<li><a href="https://github.com/pgmodeler/pgmodeler">pgmodeler</a> -
|
||
Data modeling tool designed for PostgreSQL.</li>
|
||
<li><a href="https://github.com/ondras/wwwsqldesigner">WWW SQL
|
||
Designer</a> - Online SQL diagramming tool.</li>
|
||
</ul>
|
||
<h3 id="samples">Samples</h3>
|
||
<ul>
|
||
<li><a href="https://github.com/oracle/db-sample-schemas">Oracle
|
||
Database Sample Schemas</a> - Oracle Database Sample Schemas.</li>
|
||
</ul>
|
||
<h2 id="api">API</h2>
|
||
<p>Building API for your Data - <a
|
||
href="https://github.com/simonw/datasette">Datasette</a> - A tool for
|
||
exploring and publishing data. - <a
|
||
href="https://github.com/dreamfactorysoftware/dreamfactory">DreamFactory</a>
|
||
- A open source REST API backend for mobile, web, and IoT applications.
|
||
- <a
|
||
href="https://github.com/exogee-technology/graphweaver">Graphweaver</a>
|
||
- Turn multiple data sources into a single GraphQL API. - <a
|
||
href="https://github.com/hasura/graphql-engine">Hasura GraphQL
|
||
Engine</a> - Blazing fast, instant realtime GraphQL APIs on Postgres
|
||
with fine grained access control, also trigger webhooks on database
|
||
events. - <a
|
||
href="http://www.oracle.com/technetwork/developer-tools/rest-data-services">Oracle
|
||
REST Data Services</a> - 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. - <a
|
||
href="https://github.com/prismagraphql/prisma">Prisma</a> - Prisma turns
|
||
your database into a realtime GraphQL API. - <a
|
||
href="https://github.com/graphile/postgraphile">PostGraphile</a> -
|
||
Instantly spin-up a GraphQL API server by pointing PostGraphile at your
|
||
existing PostgreSQL database. - <a
|
||
href="https://github.com/PostgREST/postgrest">PostgREST</a> - REST API
|
||
for any Postgres database. - <a
|
||
href="https://github.com/prest/prest">prest</a> - Is a way to serve a
|
||
RESTful API from any databases written in Go. - <a
|
||
href="https://github.com/remult/remult">Remult</a> - End-to-end
|
||
type-safe CRUD via REST API for your database, with fine-grained access
|
||
control. - <a href="https://github.com/restsql/restsql">restSQL</a> -
|
||
SQL generator with Java and HTTP APIs, uses a simple RESTful HTTP API
|
||
with XML or JSON serialization. - <a
|
||
href="https://github.com/formio/resquel">resquel</a> - Easily convert
|
||
your SQL database into a REST API. - <a
|
||
href="https://github.com/jeffknupp/sandman2">sandman2</a> -
|
||
Automatically generate a RESTful API service for your legacy database. -
|
||
<a href="https://github.com/thevahidal/soul">soul</a> - Automatic SQLite
|
||
RESTful and realtime API server. - <a
|
||
href="https://github.com/Canner/vulcan-sql">VulcanSQL</a> - Write
|
||
templated SQL to automatically exposing RESTful APIs from your
|
||
database/data warehouse/data lake.</p>
|
||
<h2 id="application-platforms">Application platforms</h2>
|
||
<p>Low-code and no-code platforms for application building - <a
|
||
href="https://github.com/appsmithorg/appsmith">Appsmith</a> - Powerful
|
||
open source low code framework to build internal applications really
|
||
quickly. - <a href="https://github.com/Budibase/budibase">Budibase</a> -
|
||
Low-code platform for creating internal apps in minutes. - <a
|
||
href="https://github.com/illacloud/illa-builder">ILLA Cloud</a> -
|
||
Low-code internal tool building platform. - <a
|
||
href="https://github.com/nhost/nhost">Nhost</a> - The Open Source
|
||
Firebase Alternative with GraphQL. - <a
|
||
href="https://github.com/saltcorn/saltcorn">Saltcorn</a> - Open source
|
||
no-code builder for web datatabase applications. Server and
|
||
drag-and-drop UI builder, data stored in PostgreSQL or SQLite. - <a
|
||
href="https://github.com/sqlpage/SQLPage">SQLPage</a> - Fast SQL-only
|
||
data application builder. Automatically build a UI on top of SQL
|
||
queries. - <a href="https://github.com/ToolJet/ToolJet">Tooljet</a> -
|
||
Open-source low-code platform to build internal tools.</p>
|
||
<h2 id="backup">Backup</h2>
|
||
<ul>
|
||
<li><a href="https://github.com/2ndquadrant-it/barman">BaRMan</a> -
|
||
Backup and Recovery Manager for PostgreSQL.</li>
|
||
<li><a href="https://github.com/pgbackrest/pgbackrest">pgbackrest</a> -
|
||
Reliable PostgreSQL Backup & Restore.</li>
|
||
<li><a href="https://github.com/dimitri/pgcopydb">pgcopydb</a> - Copy a
|
||
Postgres database to a target Postgres server (pg_dump | pg_restore on
|
||
steroids).</li>
|
||
</ul>
|
||
<h2 id="cloning">Cloning</h2>
|
||
<ul>
|
||
<li><a href="https://gitlab.com/postgres-ai/database-lab">Database Lab
|
||
Engine</a> - Instant thin cloning for Postgres to scale the development
|
||
process.</li>
|
||
<li><a
|
||
href="https://github.com/denishpatel/pg-clone-schema">clone_schema</a> -
|
||
Postgres clone schema utility without need of going outside of
|
||
database.</li>
|
||
<li><a href="https://spawn.cc/">Spawn</a> - 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.</li>
|
||
</ul>
|
||
<h2
|
||
id="monitoringstatisticsperfomance">Monitoring/Statistics/Perfomance</h2>
|
||
<ul>
|
||
<li><a href="https://github.com/akardapolov/ASH-Viewer">ASH Viewer</a> -
|
||
Provides a graphical view of active session history data within the
|
||
Oracle and PostgreSQL DB.</li>
|
||
<li><a href="https://www.metisdata.io/product/troubleshooting">Metis</a>
|
||
- Metis provides observability and performance tuning for SQL
|
||
databases.</li>
|
||
<li><a href="https://www.webyog.com/product/monyog">Monyog</a> -
|
||
Agentless & Cost-effective MySQL Monitoring Tool.</li>
|
||
<li><a
|
||
href="https://github.com/microsoft/mssql-monitoring">mssql-monitoring</a>
|
||
- Monitor your SQL Server on Linux performance using collectd, InfluxDB
|
||
and Grafana.</li>
|
||
<li><a
|
||
href="https://www.navicat.com/en/products/navicat-monitor">Navicat
|
||
Monitor</a> - A safe, simple and agentless remote server monitoring tool
|
||
that is packed with powerful features to make your monitoring effective
|
||
as possible.</li>
|
||
<li><a href="https://github.com/percona/pmm">Percona Monitoring and
|
||
Management</a> - Open source platform for managing and monitoring MySQL
|
||
and MongoDB performance.</li>
|
||
<li><a href="https://github.com/pganalyze/collector">pganalyze
|
||
collector</a> - Pganalyze statistics collector for gathering PostgreSQL
|
||
metrics and log data.</li>
|
||
<li><a href="https://github.com/dalibo/pgbadger">pgbadger</a> - A fast
|
||
PostgreSQL Log Analyzer.</li>
|
||
<li><a href="https://pgdash.io">pgDash</a> - Measure and track every
|
||
aspect of your PostgreSQL databases.</li>
|
||
<li><a href="https://github.com/ankane/pghero">PgHero</a> - A
|
||
performance dashboard for Postgres - health checks, suggested indexes,
|
||
and more.</li>
|
||
<li><a href="https://github.com/rapidloop/pgmetrics">pgmetrics</a> -
|
||
Collect and display information and stats from a running PostgreSQL
|
||
server.</li>
|
||
<li><a href="https://github.com/CrunchyData/pgmonitor">pgMonitor</a> -
|
||
All-in-one tool to easily create an environment to visualize the health
|
||
and performance of your PostgreSQL cluster.</li>
|
||
<li><a href="https://www.pgmustard.com">pgMustard</a> - A user interface
|
||
for Postgres explain plans, plus tips to improve performance.</li>
|
||
<li><a href="https://github.com/gleu/pgstats">pgstats</a> - Collects
|
||
PostgreSQL statistics, and either saves them in CSV files or print them
|
||
on the stdout.</li>
|
||
<li><a
|
||
href="https://github.com/cybertec-postgresql/pgwatch2">pgwatch2</a> -
|
||
Flexible self-contained PostgreSQL metrics monitoring/dashboarding
|
||
solution.</li>
|
||
<li><a href="https://github.com/spotify/postgresql-metrics">PostgreSQL
|
||
Metrics</a> - Service to extract and provide metrics on your PostgreSQL
|
||
database.</li>
|
||
<li><a href="https://postgresmonitor.com">Postgres Monitor</a> - An
|
||
easy-to-use monitoring service for PostgreSQL providing alerts,
|
||
dashboards, query stats and dynamic recommendations.</li>
|
||
<li><a
|
||
href="https://gitlab.com/postgres-ai/postgres-checkup">postgres-checkup</a>
|
||
- New-generation diagnostics tool that allows users to do a deep
|
||
analysis of the health of Postgres databases.</li>
|
||
<li><a href="https://github.com/timescale/promscale">Promscale</a> - The
|
||
open-source observability backend for metrics and traces powered by
|
||
SQL.</li>
|
||
<li><a
|
||
href="https://github.com/influxdata/telegraf/tree/master/plugins/inputs/postgresql">Telegraf
|
||
PostgreSQL plugin</a> - Provides metrics for your postgres
|
||
database.</li>
|
||
</ul>
|
||
<h3 id="prometheus">Prometheus</h3>
|
||
<ul>
|
||
<li><a href="https://github.com/weaponry/pgscv">pgSCV</a> - Metrics
|
||
exporter for PostgreSQL and Postgres-related services.</li>
|
||
<li><a
|
||
href="https://github.com/wrouesnel/postgres_exporter">postgres_exporter</a>
|
||
- Prometheus exporter for PostgreSQL server metrics.</li>
|
||
<li><a href="https://github.com/Vonng/pg_exporter">pg_exporter</a> -
|
||
Fully customizable Prometheus exporter for PostgreSQL & Pgbouncer
|
||
with fine-grained execution control.</li>
|
||
</ul>
|
||
<h3 id="zabbix">Zabbix</h3>
|
||
<ul>
|
||
<li><a href="https://github.com/postgrespro/mamonsu">Mamonsu</a> -
|
||
Monitoring agent for PostgreSQL.</li>
|
||
<li><a
|
||
href="http://www.smartmarmot.com/wiki/index.php?title=Orabbix">Orabbix</a>
|
||
- 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.</li>
|
||
<li><a href="https://github.com/pg-monz/pg_monz">pg_monz</a> - This is
|
||
the Zabbix monitoring template for PostgreSQL Database.</li>
|
||
<li><a href="https://github.com/bicofino/Pyora">Pyora</a> - Python
|
||
script to monitor Oracle Databases.</li>
|
||
<li><a href="https://github.com/anetrusov/ZabbixDBA">ZabbixDBA</a> -
|
||
ZabbixDBA is fast, flexible, and continuously developing plugin to
|
||
monitor your RDBMS.</li>
|
||
</ul>
|
||
<h2 id="testing">Testing</h2>
|
||
<ul>
|
||
<li><a href="https://github.com/dbfit/dbfit">DbFit</a> - A database
|
||
testing framework that supports easy test-driven development of your
|
||
database code.</li>
|
||
<li><a href="https://github.com/theory/pgtap">pgTAP</a> - Unit Testing
|
||
for PostgreSQL.</li>
|
||
<li><a href="https://github.com/dimitri/regresql">RegreSQL</a> -
|
||
Regression Testing your SQL queries.</li>
|
||
<li><a href="https://github.com/sqlancer/sqlancer">SQLancer</a> -
|
||
Automatically test DBMS in order to find logic bugs in their
|
||
implementation.</li>
|
||
</ul>
|
||
<h2 id="hafailoversharding">HA/Failover/Sharding</h2>
|
||
<ul>
|
||
<li><a href="https://github.com/citusdata/citus">Citus</a> - Postgres
|
||
extension that distributes your data and your queries across multiple
|
||
nodes.</li>
|
||
<li><a href="https://github.com/zalando/patroni">patroni</a> - A
|
||
template for PostgreSQL High Availability with ZooKeeper, etcd, or
|
||
Consul.</li>
|
||
<li><a href="https://github.com/percona/percona-xtradb-cluster">Percona
|
||
XtraDB Cluster</a> - A High Scalability Solution for MySQL Clustering
|
||
and High Availability.</li>
|
||
<li><a
|
||
href="https://github.com/apache/shardingsphere">ShardingSphere</a> -
|
||
Distributed SQL transaction & query engine for data sharding,
|
||
scaling, encryption, and more - on any database.</li>
|
||
<li><a href="https://github.com/sorintlab/stolon">stolon</a> - Cloud
|
||
native PostgreSQL manager for PostgreSQL high availability.</li>
|
||
<li><a
|
||
href="https://github.com/citusdata/pg_auto_failover">pg_auto_failover</a>
|
||
- Postgres extension and service for automated failover and
|
||
high-availability.</li>
|
||
<li><a href="https://github.com/aiven/pglookout">pglookout</a> -
|
||
PostgreSQL replication monitoring and failover daemon.</li>
|
||
<li><a href="https://github.com/ankane/pgslice">pgslice</a> - Postgres
|
||
partitioning as easy as pie.</li>
|
||
<li><a href="https://github.com/ClusterLabs/PAF">PostgreSQL Automatic
|
||
Failover</a> - High-Availibility for Postgres, based on industry
|
||
references Pacemaker and Corosync.</li>
|
||
<li><a href="https://github.com/vitabaks/autobase">autobase</a> -
|
||
Autobase for PostgreSQL® is an open-source DBaaS that automates the
|
||
deployment and management of highly available PostgreSQL clusters.</li>
|
||
<li><a href="https://github.com/vitessio/vitess">Vitess</a> - Database
|
||
clustering system for horizontal scaling of MySQL through generalized
|
||
sharding.</li>
|
||
</ul>
|
||
<h2 id="kubernetes">Kubernetes</h2>
|
||
<ul>
|
||
<li><a href="https://kubedb.com">KubeDB</a> - Making running
|
||
production-grade databases easy on Kubernetes.</li>
|
||
<li><a href="https://github.com/zalando/postgres-operator">Postgres
|
||
operator</a> - The Postgres Operator enables highly-available PostgreSQL
|
||
clusters on Kubernetes (K8s) powered by Patroni.</li>
|
||
<li><a href="https://github.com/zalando/spilo">Spilo</a> - HA PostgreSQL
|
||
Clusters with Docker.</li>
|
||
<li><a href="https://gitlab.com/ongresinc/stackgres">StackGres</a> -
|
||
Enterprise-grade, Full Stack PostgreSQL on Kubernetes.</li>
|
||
</ul>
|
||
<h2 id="configuration-tuning">Configuration Tuning</h2>
|
||
<ul>
|
||
<li><a
|
||
href="https://github.com/major/MySQLTuner-perl">MySQLTuner-perl</a> -
|
||
Script written in Perl that allows you to review a MySQL installation
|
||
quickly and make adjustments to increase performance and stability.</li>
|
||
<li><a
|
||
href="https://pgconfigurator.cybertec-postgresql.com">PGConfigurator</a>
|
||
- Free online tool to generate an optimized
|
||
<code>postgresql.conf</code>.</li>
|
||
<li><a href="https://github.com/gregs1104/pgtune">pgtune</a> -
|
||
PostgreSQL configuration wizard.</li>
|
||
<li><a
|
||
href="https://github.com/jfcoz/postgresqltuner">postgresqltuner.pl</a> -
|
||
Simple script to analyse your PostgreSQL database configuration, and
|
||
give tuning advice.</li>
|
||
</ul>
|
||
<h2 id="devops">DevOps</h2>
|
||
<ul>
|
||
<li><a href="https://www.dbmaestro.com">DBmaestro</a> - DBmaestro
|
||
accelerates release cycles & supports agility across the entire IT
|
||
ecosystem.</li>
|
||
<li><a href="https://www.quest.com/products/toad-devops-toolkit/">Toad
|
||
DevOps Toolkit</a> - Toad DevOps Toolkit executes key database
|
||
development functions within your DevOps workflow —without compromising
|
||
quality, performance or reliability.</li>
|
||
</ul>
|
||
<h2 id="reporting">Reporting</h2>
|
||
<ul>
|
||
<li><a href="https://chartbrew.com">Chartbrew</a> - Create live
|
||
dashboards, charts, and client reports from multiple databases and
|
||
services.</li>
|
||
<li><a href="https://github.com/shzlw/poli">Poli</a> - An easy-to-use
|
||
SQL reporting application built for SQL lovers.</li>
|
||
</ul>
|
||
<h2 id="distributions">Distributions</h2>
|
||
<ul>
|
||
<li><a href="https://github.com/datacharmer/dbdeployer">DBdeployer</a> -
|
||
Tool that deploys MySQL database servers easily.</li>
|
||
<li><a href="https://github.com/sqlcollaborative/dbatools">dbatools</a>
|
||
- PowerShell module that you may think of like a command-line SQL Server
|
||
Management Studio.</li>
|
||
<li><a
|
||
href="https://github.com/PostgresApp/PostgresApp">Postgres.app</a> -
|
||
Full-featured PostgreSQL installation packaged as a standard Mac
|
||
app.</li>
|
||
<li><a href="https://www.bigsql.org">BigSQL</a> - A developer-friendly
|
||
distribution of Postgres.</li>
|
||
<li><a href="https://github.com/credativ/elephant-shed">Elephant
|
||
Shed</a> - Web-based PostgreSQL management front-end that bundles
|
||
several utilities and applications for use with PostgreSQL.</li>
|
||
<li><a href="https://github.com/Vonng/pigsty">Pigsty</a> -
|
||
Battery-Included Open-Source Distribution for PostgreSQL with ultimate
|
||
observability & Database-as-Code toolbox for developers.</li>
|
||
</ul>
|
||
<h2 id="security">Security</h2>
|
||
<ul>
|
||
<li><a href="https://github.com/cossacklabs/acra">Acra</a> - 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.</li>
|
||
<li><a
|
||
href="https://github.com/securitybunker/databunker">Databunker</a> -
|
||
Special GDPR compliant secure vault for customer records built on top of
|
||
regular DB.</li>
|
||
<li><a href="https://github.com/poonai/inspektor">Inspektor</a> - Access
|
||
control layer for databases. Inspektor leverages open policy agent to
|
||
make policy decisions.</li>
|
||
</ul>
|
||
<h2 id="sql">SQL</h2>
|
||
<h3 id="analyzers">Analyzers</h3>
|
||
<ul>
|
||
<li><a href="https://holistic.dev">Holistic.dev</a> - Automatic
|
||
detection service for database performance, security, and architecture
|
||
issues.</li>
|
||
<li><a href="https://github.com/jarulraj/sqlcheck">SQLCheck</a> -
|
||
Automatically detects common SQL anti-patterns.</li>
|
||
<li><a href="https://github.com/sqlfluff/sqlfluff">SQLFluff</a> -
|
||
Dialect-flexible and configurable SQL linter.</li>
|
||
<li><a href="https://github.com/reata/sqllineage">SQLLineage</a> - SQL
|
||
Lineage Analysis Tool powered by Python.</li>
|
||
<li><a href="https://github.com/tsqllint/tsqllint">TSQLLint</a> - A tool
|
||
for describing, identifying, and reporting the presence of anti-patterns
|
||
in TSQL scripts.</li>
|
||
</ul>
|
||
<h3 id="extensions">Extensions</h3>
|
||
<ul>
|
||
<li><a href="https://partiql.org">PartiQL</a> - SQL-compatible access to
|
||
relational, semi-structured, and nested data.</li>
|
||
</ul>
|
||
<h3 id="frameworks">Frameworks</h3>
|
||
<ul>
|
||
<li><a href="https://calcite.apache.org">Apache Calcite</a> - Dynamic
|
||
data management framework with advanced SQL features.</li>
|
||
<li><a href="https://github.com/google/zetasql">ZetaSQL</a> - Analyzer
|
||
Framework for SQL.</li>
|
||
</ul>
|
||
<h3 id="formatters">Formatters</h3>
|
||
<ul>
|
||
<li><a href="https://github.com/antlr/codebuff">CodeBuff</a> -
|
||
Language-agnostic pretty-printing through machine learning.</li>
|
||
<li><a
|
||
href="https://github.com/manticore-projects/jsqlformatter">JSQLFormatter</a>
|
||
- Open Source Java SQL Formatter for many RDBMS based on
|
||
JSqlParser.</li>
|
||
<li><a href="https://sqlonline.in">SQL Online</a> - A Free Tool to
|
||
format your SQL Queries followed by content for Analysts.</li>
|
||
<li><a href="https://github.com/darold/pgFormatter">pgFormatter</a> - A
|
||
PostgreSQL SQL syntax beautifier.</li>
|
||
<li><a href="https://poorsql.com">Poor SQL</a> - Instant free and
|
||
open-source T-SQL formatting.</li>
|
||
<li><a href="https://github.com/zeroturnaround/sql-formatter">SQL
|
||
Formatter</a> - JavaScript library for pretty-printing SQL queries.</li>
|
||
</ul>
|
||
<h3 id="games">Games</h3>
|
||
<ul>
|
||
<li><a href="https://lost-at-sql.therobinlord.com">Lost at SQL</a> - A
|
||
SQL learning game to help you pick up basic SQL skills - so that you can
|
||
use queries to get information.</li>
|
||
<li><a href="https://codepip.com/games/querymon/">Querymon</a> - Learn
|
||
to use SQL queries on the Querydex, a database of monsters from common
|
||
to legendary.</li>
|
||
<li><a
|
||
href="https://datalemur.com/blog/games-to-learn-sql#schemaverse">Schemaverse</a>
|
||
- A Space-based strategy game implemented entirely within a PostgreSQL
|
||
database.</li>
|
||
<li><a href="https://sql-island.informatik.uni-kl.de">SQL Island</a> -
|
||
After the survived plane crash, you will be stuck on SQL Island for the
|
||
time being. By making progress in the game, you will find a way to
|
||
escape from this island.</li>
|
||
<li><a href="https://mystery.knightlab.com">SQL Murder Mystery</a> -
|
||
Designed to be both a self-directed lesson to learn SQL concepts and
|
||
commands and a fun game for experienced SQL users to solve an intriguing
|
||
crime.</li>
|
||
<li><a href="https://sqlpd.com">SQL Police Department</a> - In SQLPD,
|
||
you get to solve crimes while learning SQL at the same time.</li>
|
||
</ul>
|
||
<h3 id="parsers">Parsers</h3>
|
||
<ul>
|
||
<li><a href="https://www.sqlparser.com">General SQL Parser</a> -
|
||
Parsing, formatting, modification and analysis for SQL.</li>
|
||
<li><a href="https://github.com/jOOQ/jOOQ">jOOQ</a> - Parses SQL,
|
||
translates it to other dialects, and allows for expression tree
|
||
transformations.</li>
|
||
<li><a href="https://github.com/JSQLParser/JSqlParser">JSqlParser</a> -
|
||
Parses an SQL statement and translate it into a hierarchy of Java
|
||
classes.</li>
|
||
<li><a href="https://github.com/pganalyze/libpg_query">libpg_query</a> -
|
||
C library for accessing the PostgreSQL parser outside of the server
|
||
environment.</li>
|
||
<li><a href="https://github.com/klahnakoski/mo-sql-parsing">More SQL
|
||
Parsing!</a> - Parse SQL into JSON.</li>
|
||
<li><a href="https://github.com/andialbrecht/sqlparse">sqlparse</a> -
|
||
Non-validating SQL parser for Python.</li>
|
||
<li><a href="https://github.com/tobymao/sqlglot">SQLGlot</a> - Pure
|
||
Python SQL parser, transpiler, and builder.</li>
|
||
</ul>
|
||
<h3 id="über-sql">Über SQL</h3>
|
||
<p>Run SQL queries against anything - <a
|
||
href="https://github.com/cloudquery/cloudquery">CloudQuery</a> -
|
||
Extracts, transforms, and loads your cloud assets into normalized
|
||
PostgreSQL tables. - <a
|
||
href="https://github.com/mithrandie/csvq">csvq</a> - SQL-like query
|
||
language for CSV. - <a
|
||
href="https://github.com/multiprocessio/dsq">dsq</a> - Commandline tool
|
||
for running SQL queries against JSON, CSV, Excel, Parquet, and more. -
|
||
<a href="https://github.com/vlsi/mat-calcite-plugin">MAT Calcite
|
||
plugin</a> - This plugin for Eclipse Memory Analyzer allows to query
|
||
heap dump via SQL. - <a
|
||
href="https://github.com/cube2222/octosql">OctoSQL</a> - Query tool that
|
||
allows you to join, analyse and transform data from multiple databases
|
||
and file formats using SQL. - <a
|
||
href="https://github.com/osquery/osquery">osquery</a> - SQL powered
|
||
operating system instrumentation, monitoring, and analytics. - <a
|
||
href="https://www.resmo.com">Resmo</a> - Audit and evaluate resources
|
||
using SQL. - <a href="https://github.com/turbot/steampipe">Steampipe</a>
|
||
- Use SQL to instantly query your cloud services (AWS, Azure, GCP and
|
||
more). - <a href="https://github.com/dinedal/textql">TextQL</a> -
|
||
Execute SQL against structured text like CSV or TSV. - <a
|
||
href="https://github.com/noborus/trdsql">trdsql</a> - CLI tool that can
|
||
execute SQL queries on CSV, LTSV, JSON and TBLN. - <a
|
||
href="https://github.com/trinodb/trino">Trino</a> - Trino is a
|
||
distributed SQL query engine designed to query large data sets
|
||
distributed over one or more heterogeneous data sources.</p>
|
||
<h3 id="language-server-protocol">Language Server Protocol</h3>
|
||
<ul>
|
||
<li><a
|
||
href="https://github.com/joe-re/sql-language-server">SQLLanguageServer</a>
|
||
- SQL Language Server.</li>
|
||
<li><a href="https://github.com/lighttiger2505/sqls">sqls</a> - SQL
|
||
Language Server written in Go.</li>
|
||
</ul>
|
||
<h3 id="learning">Learning</h3>
|
||
<p>Learning and puzzles for SQL - <a
|
||
href="https://github.com/smpetersgithub/AdvancedSQLPuzzles">Advanced SQL
|
||
Puzzles</a> - Difficult set-based SQL puzzles. - <a
|
||
href="https://www.hackerrank.com/domains/sql">Hackerrank</a> - Practice
|
||
coding, prepare for interviews, and get hired. - <a
|
||
href="https://www.manning.com/books/learn-sql-in-a-month-of-lunches">Learn
|
||
SQL in a Month of Lunches</a> - A book about how to use SQL to retrieve,
|
||
filter, and analyze data. - <a
|
||
href="https://leetcode.com/problemset/database">LeetCode</a> - Enhance
|
||
your skills, expand your knowledge and prepare for technical interviews.
|
||
- <a href="https://selectstarsql.com">Select Star SQL</a> - Free
|
||
interactive book which aims to be the best place on the internet for
|
||
learning SQL. - <a
|
||
href="https://www.stratascratch.com/blog/categories/sql">StrataScratch</a>
|
||
- Data science educational resources. - <a
|
||
href="https://github.com/NUKnightLab/sql-mysteries">SQL Murder
|
||
Mystery</a> - Self-directed lesson to learn SQL concepts and commands
|
||
and a fun game for experienced SQL users to solve an intriguing
|
||
crime.</p>
|
||
<h3 id="plan">Plan</h3>
|
||
<ul>
|
||
<li><a href="https://github.com/dalibo/pev2">pev2</a> - A VueJS
|
||
component to show a graphical vizualization of a PostgreSQL execution
|
||
plan.</li>
|
||
<li><a href="https://github.com/mgartner/pg_flame">pg_flame</a> - A
|
||
flamegraph generator for Postgres <code>EXPLAIN ANALYZE</code>
|
||
output.</li>
|
||
</ul>
|
||
<h3 id="scripts">Scripts</h3>
|
||
<p>Useful SQL-scripts for various purposes - <a
|
||
href="https://github.com/LowlyDBA/dba-multitool">DBA MultiTool</a> -
|
||
T-SQL scripts for the long haul: optimizing storage, on-the-fly
|
||
documentation, and general administrative needs for SQL Server. - <a
|
||
href="https://github.com/pgexperts/pgx_scripts">pgx_scripts</a> - A
|
||
collection of useful little scripts for database analysis and
|
||
administration, created by our team at PostgreSQL Experts. - <a
|
||
href="https://github.com/ioguix/pgsql-bloat-estimation">pgsql-bloat-estimation</a>
|
||
- Queries to mesure statistical bloat in indexes and tables for
|
||
PostgreSQL. - <a
|
||
href="https://gitlab.com/depesz/pgWikiDont">pgWikiDont</a> - SQL test
|
||
that checks if your database follows rules from <a
|
||
href="https://wiki.postgresql.org/wiki/Don't_Do_This"
|
||
class="uri">https://wiki.postgresql.org/wiki/Don't_Do_This</a>. - <a
|
||
href="https://github.com/dataegret/pg-utils">pg-utils</a> - Useful
|
||
PostgreSQL utilities. - <a
|
||
href="https://postgrescheatsheet.com">Postgres cheat sheet</a> - Useful
|
||
SQL-scripts and commands by <timescale.com>. - <a
|
||
href="https://github.com/NikolayS/postgres_dba">postgres_dba</a> - The
|
||
missing set of useful tools for Postgres DBAs and all engineers. - <a
|
||
href="https://gist.github.com/rgreenjr/3637525">postgres_queries_and_commands.sql</a>
|
||
- Useful PostgreSQL Queries and Commands. - <a
|
||
href="https://github.com/tanelpoder/tpt-oracle">TPT</a> - These sqlplus
|
||
scripts are for Oracle Database performance optimization &
|
||
troubleshooting.</p>
|
||
<h2 id="data">Data</h2>
|
||
<ul>
|
||
<li><a href="https://github.com/dbt-labs/dbt-core">dbt</a> - Transform
|
||
your data by simply writing select statements, while dbt handles turning
|
||
these statements into tables and views in a data warehouse.</li>
|
||
<li><a href="https://quicktable.io">QuickTable</a> - Empowers everyone
|
||
to access, clean, analyze, transform, and model data with no code.</li>
|
||
</ul>
|
||
<h3 id="catalog">Catalog</h3>
|
||
<ul>
|
||
<li><a href="https://github.com/amundsen-io/amundsen">Amundsen</a> -
|
||
Metadata driven application for improving the productivity of data
|
||
analysts, data scientists and engineers when interacting with data.</li>
|
||
<li><a href="https://github.com/datahub-project/datahub">DataHub</a> -
|
||
The Metadata Platform for the Modern Data Stack.</li>
|
||
<li><a href="https://github.com/MarquezProject/marquez">Marquez</a> -
|
||
Collect, aggregate, and visualize a data ecosystem’s metadata.</li>
|
||
</ul>
|
||
<h3 id="lineage">Lineage</h3>
|
||
<ul>
|
||
<li><a href="https://dwh.dev">Dwh.dev</a> - Nexgen data lineage for
|
||
Snowflake.</li>
|
||
</ul>
|
||
<h3 id="generationmaskingsubsetting">Generation/Masking/Subsetting</h3>
|
||
<ul>
|
||
<li><a
|
||
href="https://github.com/rapiddweller/rapiddweller-benerator-ce">Benerator</a>
|
||
- Generate, obfuscate (anonymize / pseudonymize) and migrate data for
|
||
development, testing and training purposes.</li>
|
||
<li><a
|
||
href="https://www.devart.com/dbforge/mysql/data-generator">dbForge Data
|
||
Generator for MySQL</a> - Powerful GUI tool for creating massive volumes
|
||
of realistic test data.</li>
|
||
<li><a
|
||
href="https://www.devart.com/dbforge/oracle/data-generator">dbForge Data
|
||
Generator for Oracle</a> - Small but mighty GUI tool for populating
|
||
Oracle schemas with tons of realistic test data.</li>
|
||
<li><a href="https://www.devart.com/dbforge/sql/data-generator">dbForge
|
||
Data Generator for SQL Server</a> - Powerful GUI tool for a fast
|
||
generation of meaningful test data for databases.</li>
|
||
<li><a href="https://github.com/faker-js/faker">Faker</a> - Generate
|
||
massive amounts of fake data in the browser and Node.js.</li>
|
||
<li><a href="https://github.com/lesovsky/noisia">Noisia</a> - Harmful
|
||
workload generator for PostgreSQL.</li>
|
||
<li><a href="https://soft-builder.com/sb-data-generator">SB Data
|
||
Generator</a> - 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.</li>
|
||
<li><a href="https://docs.synthesized.io/tdk/latest">Synthesized TDK</a>
|
||
- DevOps’ best friend for database masking and generation.</li>
|
||
</ul>
|
||
<h3 id="replication">Replication</h3>
|
||
<ul>
|
||
<li><a href="https://github.com/actiontech/dtle">dtle</a> - Distributed
|
||
Data Transfer Service for MySQL.</li>
|
||
<li><a href="https://github.com/benbjohnson/litestream">Litestream</a> -
|
||
Streaming replication for SQLite.</li>
|
||
<li><a href="https://github.com/ankane/pgsync">pgsync</a> - Sync
|
||
Postgres data between databases.</li>
|
||
<li><a
|
||
href="https://github.com/the4thdoctor/pg_chameleon">pg_chameleon</a> -
|
||
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.</li>
|
||
<li><a href="https://github.com/hasura/pgdeltastream">PGDeltaStream</a>
|
||
- A Golang webserver to stream Postgres changes atleast-once over
|
||
websockets, using Postgres logical decoding feature.</li>
|
||
<li><a href="https://github.com/2ndQuadrant/repmgr">repmgr</a> - The
|
||
Most Popular Replication Manager for PostgreSQL.</li>
|
||
</ul>
|
||
<h3 id="compare">Compare</h3>
|
||
<ul>
|
||
<li><a href="https://github.com/datafold/data-diff">data-diff</a> -
|
||
Command-line tool and Python library to efficiently diff rows across two
|
||
different databases.</li>
|
||
<li><a href="https://ksdbmerge.tools">KS DB Merge Tools</a> - GUI to
|
||
compare and sync DB schema and data. For Oracle Database, MySQL,
|
||
MariaDB, SQL Server, PostgreSQL, SQLite, MS Access and Cross-DBMS.</li>
|
||
</ul>
|
||
<h2 id="papers">Papers</h2>
|
||
<p>Documents, articles, manifestos and other theoretical materials on
|
||
database tools - <a
|
||
href="https://github.com/mgramin/database-as-code">The “Database as
|
||
Code” Manifesto</a> - Treat your database as Code. - <a
|
||
href="https://www.manning.com/books/grokking-relational-database-design">Grokking
|
||
Relational Database Design</a> - A friendly illustrated guide to
|
||
designing and implementing your first database.</p>
|
||
<h2 id="machine-learning">Machine Learning</h2>
|
||
<ul>
|
||
<li><a href="https://github.com/mindsdb/mindsdb">MindsDB</a> -
|
||
In-database Machine Learning.</li>
|
||
<li><a
|
||
href="https://github.com/sql-machine-learning/sqlflow">SQLFlow</a> -
|
||
Brings SQL and AI together.</li>
|
||
</ul>
|
||
<h2 id="contributing">Contributing</h2>
|
||
<ul>
|
||
<li>Your contributions are always welcome! Please read the <a
|
||
href="contributing.md">contribution guidelines</a> first.</li>
|
||
</ul>
|
||
<p><a href="https://github.com/mgramin/awesome-db-tools">dbtools.md
|
||
Github</a></p>
|