awesome-db-tools

Database toolkit

A community-driven collection of tools and resources to simplify working with databases

Everything that makes working with databases easier

GitHub
4k stars
73 watching
354 forks
last commit: 3 months ago
Linked from 4 awesome lists

awesomeawesome-listcross-databasedatabasedatabase-managementidemonitoringsql-clientvisualization

Awesome Database Tools / 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
Coginiti Pro Modern IDE for analyst and analytics engineers with proweful script and grid functionality
Database .net Multiple database management tool with support for 20+ databases
DataGrip Cross-Platform IDE for Databases & SQL by JetBrains
DataStation 2,907 about 1 year ago Easily query, script, and visualize data from every database, file, and API
DBeaver 40,942 about 1 month ago 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
DBHawk Datasparc offers database security, database management, database governance and data analytics - all in one solution
dbKoda 869 about 2 years ago 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
HeidiSQL 4,863 about 1 month ago A lightweight client for managing MySQL, MSSQL and PostgreSQL, written in Delphi
KeepTool A professional suite of tools for Oracle Database developers, administrators and advanced application users
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
Querybook 1,974 about 1 month ago Querybook is a Pinterest open-source Big Data Querying UI, combining collocated table metadata and a simple notebook IDE interface
Slashbase 1,303 9 months ago 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
Sql Server Management Studio SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, for SQL Server and Azure SQL Databases
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
TOra 290 11 months ago 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
WebDB Free Efficient Database IDE. Featuring Server Discovery, ERD, Data Generator, AI, NoSQL Structure Manager, Database Versioning and many more

Awesome Database Tools / GUI
Adminer 6,283 8 months ago Database management in a single PHP file
Another Redis Desktop Manager 30,995 about 1 month ago Free Open Source Redis Manager. Available on Mac, Linux, Windows, Homebrew, Snap, winget, and more
Azure Data Studio 7,607 about 1 month ago A data management tool that enables working with SQL Server, PostgreSQL, Azure SQL DB and SQL DW from Windows, macOS and Linux
Beekeeper Studio 16,974 about 1 month ago Open Source SQL Editor and Database Manager with a privacy commitment in their mission statement
Clidey WhoDB 2,077 about 1 month ago A lightweight database explorer with next-gen UX for all SQL, NoSQL, Caches, and Queues
DbGate 5,584 about 1 month ago Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application
DB Lens 256 6 months ago Open Source Postgres GUI - Automatic ER diagrams, Internal DB Insights, Disk Utilisation, Performance Metrics, Index Usage, Sequential scan counts and more
DbVisualizer Universal database tool for developers, DBAs and analysts
JackDB Direct SQL access to all your data, no matter where it lives
Jailer 2,895 about 1 month ago Database Subsetting and Relational Data Browsing Tool/Client
Malewicz 65 over 2 years ago Yet Another WEB client for DB schema exploring and performance analysis, but originally created specifically for hacking and extending
MissionKontrol Modern drag & drop admin panel/client with full user permissions for non-technical users
ocelotgui 62 3 months ago For MySQL, MariaDB, and Tarantool. Developed for Linux but can run on Windows
OmniDB 3,195 almost 2 years ago Web tool for database management
Pgweb 8,678 about 1 month ago 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
phpMyAdmin 7,307 about 1 month ago 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 3T 9,315 over 2 years ago Robo 3T (formerly Robomongo) is a shell-centric cross-platform MongoDB management tool
Sequel Ace 6,776 about 2 months ago MySQL/MariaDB database management for macOS
Sequel Pro 9,084 almost 2 years ago Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL & MariaDB databases
SQLite Expert Graphical interface supports all SQLite features
sqlite-tui 1,713 over 2 years ago A TUI for viewing sqlite databases, written in Go
sqlpad 5,071 about 2 months ago 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
SQLTools 1,527 about 1 month ago Database management for VSCode
SQLyog The most complete and easy to use MySQL GUI
Tabix 2,173 about 2 years ago SQL Editor & Open source simple business intelligence for Clickhouse
TablePlus 3,488 10 months ago 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
Query.me Collaborative SQL editor in Notebook format. Let's you reference query results using JINJA, visualize data, and schedule runs and exports

Awesome Database Tools / CLI
ipython-sql 1,790 6 months ago Connect to a database for issue SQL commands within IPython or IPython Notebook
iredis 2,577 9 months ago A Cli for Redis with AutoCompletion and Syntax Highlighting
pgcenter 1,551 about 1 month ago Top-like admin tool for PostgreSQL
pg_activity 2,493 about 2 months ago Top-like application for PostgreSQL server activity monitoring
pg_top 113 8 months ago Top for PostgreSQL
pspg 2,517 4 months ago Postgres Pager
SQLcl Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database
sqlite-utils 1,708 about 2 months ago CLI tools for manipulating SQLite database files - inserting data, running queries, creating indexes, configuring full-text search and more
SQLLine 625 over 1 year ago Command-line shell for issuing SQL to relational databases via JDBC
usql 9,125 about 1 month ago A universal command-line interface for PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, and many other databases including NoSQL and non-relational databases!

Awesome Database Tools / CLI / dbcli
athenacli 210 over 2 years ago AthenaCLI is a CLI tool for AWS Athena service that can do auto-completion and syntax highlighting
litecli 2,835 about 1 month ago CLI for SQLite Databases with auto-completion and syntax highlighting
mssql-cli 1,368 11 months ago A command-line client for SQL Server with auto-completion and syntax highlighting
mycli 11,513 about 1 month ago A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting
pgcli 12,182 about 2 months ago Postgres CLI with autocompletion and syntax highlighting
vcli 76 almost 8 years ago Vertica CLI with auto-completion and syntax highlighting

Awesome Database Tools / Schema / Changes
2bass 42 2 months ago Database configuration-as-code tool that utilizes concept of idempotent DDL scripts
Atlas 6,124 about 1 month ago Inspect and Apply changes to your database schema
Bytebase 11,605 about 1 month ago Web-based, zero-config, dependency-free database schema change and version control tool for teams
flyway 8,342 about 1 month ago Database migration tool
gh-ost 12,468 about 1 month ago Online schema migration for MySQL
liquibase 4,793 about 1 month ago Database-independent library for tracking, managing and applying database schema changes
migra 2,930 8 months ago Like diff but for PostgreSQL schemas
node-pg-migrate 1,303 about 1 month ago Node.js database migration management built exclusively for postgres. (But can also be used for other DBs conforming to SQL standard - e.g. CockroachDB.)
pg-osc 554 about 1 month ago Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL
Prisma Migrate 765 about 4 years ago Declarative database schema migration tool that uses a declarative data modeling syntax to describe your database schema
Pyrseas 400 6 months ago Provides utilities to describe a PostgreSQL database schema as YAML
Reshape 1,733 4 months ago An easy-to-use, zero-downtime schema migration tool for Postgres
SchemaHero 1,010 about 2 months ago A Kubernetes operator for declarative database schema management (gitops for database schemas)
Skeema 1,273 about 1 month ago Declarative pure-SQL schema management system for MySQL and MariaDB, with support for sharding and external online schema change tools
Sqitch 2,881 8 months ago Sensible database-native change management for framework-free development and dependable deployment
sqldef 1,979 about 2 months ago Idempotent schema management for MySQL, PostgreSQL, and more
yuniql 416 6 months ago Yet another schema versioning and migration tool just made with native .NET Core 3.0+ and hopefully better

Awesome Database Tools / Schema / Code generation
ddl-generator 274 over 2 years ago Infers SQL DDL (Data Definition Language) from table data
scheme2ddl 83 about 2 months ago 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

Awesome Database Tools / Schema / Diagrams
Azimutt 1,456 about 1 month ago An Entity Relationship diagram (ERD) visualization tool, with various filters and inputs to help understand your database schema
ChartDB 10,938 about 1 month ago Free and Open-source database diagrams editor, visualize and design your DB with a single query
DrawDB 23,081 about 1 month ago Free, simple, and intuitive online database design tool and SQL generator
ERAlchemy 1,176 about 1 month ago Entity Relation Diagrams generation tool
ERD Lab Free cloud based entity relationship diagram (ERD) tool made for developers
QuickDBD Simple online tool to quickly draw database diagrams

Awesome Database Tools / Schema / Documentations
dbdocs Create web-based database documentation using DSL code
DBML 2,937 about 1 month ago Database Markup Language, designed to define and document database structures
SchemaCrawler 1,631 about 1 month ago A free database schema discovery and comprehension tool
Schema Spy 3,234 5 months ago Generating your database to HTML documentation, including Entity Relationship diagrams
tbls 3,530 about 1 month ago CI-Friendly tool for document a database, written in Go

Awesome Database Tools / Schema / Design
Database Design 450 2 months ago Useful tips for designing robust database schema
DBDiagram A free, simple tool to draw ER diagrams by just writing code
DbSchema 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
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
Moon Modeler Data modeling tool for both noSQL and relational databases. Available for Windows, Linux and macOS
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 3,147 about 1 month ago Data modeling tool designed for PostgreSQL
WWW SQL Designer 2,886 4 months ago Online SQL diagramming tool

Awesome Database Tools / Schema / Samples
Oracle Database Sample Schemas 757 10 months ago Oracle Database Sample Schemas

Awesome Database Tools / API
Datasette 9,639 about 2 months ago A tool for exploring and publishing data
DreamFactory 1,574 about 1 month ago A open source REST API backend for mobile, web, and IoT applications
Graphweaver 494 about 1 month ago Turn multiple data sources into a single GraphQL API
Hasura GraphQL Engine 31,236 about 1 month ago Blazing fast, instant realtime GraphQL APIs on Postgres with fine grained access control, also trigger webhooks on database events
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 16,529 over 2 years ago Prisma turns your database into a realtime GraphQL API
PostGraphile 12,633 about 1 month ago Instantly spin-up a GraphQL API server by pointing PostGraphile at your existing PostgreSQL database
PostgREST 24,080 about 1 month ago REST API for any Postgres database
prest 4,247 about 2 months ago Is a way to serve a RESTful API from any databases written in Go
Remult 2,935 about 1 month ago End-to-end type-safe CRUD via REST API for your database, with fine-grained access control
restSQL 147 about 6 years ago SQL generator with Java and HTTP APIs, uses a simple RESTful HTTP API with XML or JSON serialization
resquel 127 4 months ago Easily convert your SQL database into a REST API
sandman2 2,011 about 1 month ago Automatically generate a RESTful API service for your legacy database
soul 1,544 about 1 month ago Automatic SQLite RESTful and realtime API server
VulcanSQL 648 7 months ago Write templated SQL to automatically exposing RESTful APIs from your database/data warehouse/data lake

Awesome Database Tools / Application platforms
Appsmith 34,902 about 1 month ago Powerful open source low code framework to build internal applications really quickly
Budibase 22,939 about 1 month ago Low-code platform for creating internal apps in minutes
ILLA Cloud 11,712 about 2 months ago Low-code internal tool building platform
Nhost 7,990 about 1 month ago The Open Source Firebase Alternative with GraphQL
Saltcorn 1,717 about 1 month ago Open source no-code builder for web datatabase applications. Server and drag-and-drop UI builder, data stored in PostgreSQL or SQLite
Tooljet 33,439 about 1 month ago Open-source low-code platform to build internal tools

Awesome Database Tools / Backup
BaRMan 2,178 about 1 month ago Backup and Recovery Manager for PostgreSQL
pgbackrest 2,695 about 1 month ago Reliable PostgreSQL Backup & Restore
pgcopydb 1,216 about 1 month ago Copy a Postgres database to a target Postgres server (pg_dump | pg_restore on steroids)

Awesome Database Tools / Cloning
Database Lab Engine Instant thin cloning for Postgres to scale the development process
clone_schema 177 about 1 month ago Postgres clone schema utility without need of going outside of database
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

Awesome Database Tools / Monitoring/Statistics/Perfomance
ASH Viewer 168 about 1 year ago Provides a graphical view of active session history data within the Oracle and PostgreSQL DB
Metis Metis provides observability and performance tuning for SQL databases
Monyog Agentless & Cost-effective MySQL Monitoring Tool
mssql-monitoring 90 over 1 year ago 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 Management 688 about 1 month ago Open source platform for managing and monitoring MySQL and MongoDB performance
pganalyze collector 338 about 1 month ago Pganalyze statistics collector for gathering PostgreSQL metrics and log data
pgbadger 23 over 6 years ago A fast PostgreSQL Log Analyzer
pgDash Measure and track every aspect of your PostgreSQL databases
PgHero 8,223 about 1 month ago A performance dashboard for Postgres - health checks, suggested indexes, and more
pgmetrics 967 about 1 month ago Collect and display information and stats from a running PostgreSQL server
pgMonitor 601 about 1 month ago All-in-one tool to easily create an environment to visualize the health and performance of your PostgreSQL cluster
pgMustard A user interface for Postgres explain plans, plus tips to improve performance
pgstats 117 3 months ago Collects PostgreSQL statistics, and either saves them in CSV files or print them on the stdout
pgwatch2 1,836 about 1 month ago Flexible self-contained PostgreSQL metrics monitoring/dashboarding solution
PostgreSQL Metrics 591 over 1 year ago Service to extract and provide metrics on your PostgreSQL database
Postgres Monitor An easy-to-use monitoring service for PostgreSQL providing alerts, dashboards, query stats and dynamic recommendations
postgres-checkup New-generation diagnostics tool that allows users to do a deep analysis of the health of Postgres databases
Promscale 1,327 10 months ago The open-source observability backend for metrics and traces powered by SQL
Telegraf PostgreSQL plugin 14,974 about 1 month ago Provides metrics for your postgres database

Awesome Database Tools / Monitoring/Statistics/Perfomance / Prometheus
pgSCV 167 5 months ago Metrics exporter for PostgreSQL and Postgres-related services
postgres_exporter 2,845 2 months ago Prometheus exporter for PostgreSQL server metrics
pg_exporter 182 about 1 month ago Fully customizable Prometheus exporter for PostgreSQL & Pgbouncer with fine-grained execution control

Awesome Database Tools / Monitoring/Statistics/Perfomance / Zabbix
Mamonsu 186 about 1 month ago 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_monz 164 about 3 years ago This is the Zabbix monitoring template for PostgreSQL Database
Pyora 120 about 1 year ago Python script to monitor Oracle Databases
ZabbixDBA 97 over 4 years ago ZabbixDBA is fast, flexible, and continuously developing plugin to monitor your RDBMS

Awesome Database Tools / Testing
DbFit 233 over 2 years ago A database testing framework that supports easy test-driven development of your database code
pgTAP 1,000 about 2 months ago Unit Testing for PostgreSQL
RegreSQL 279 5 months ago Regression Testing your SQL queries
SQLancer 1,512 about 1 month ago Automatically test DBMS in order to find logic bugs in their implementation

Awesome Database Tools / HA/Failover/Sharding
Citus 10,728 about 1 month ago Postgres extension that distributes your data and your queries across multiple nodes
patroni 6,924 about 1 month ago A template for PostgreSQL High Availability with ZooKeeper, etcd, or Consul
Percona XtraDB Cluster 343 about 1 month ago A High Scalability Solution for MySQL Clustering and High Availability
ShardingSphere 20,034 about 1 month ago Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database
stolon 4,665 6 months ago Cloud native PostgreSQL manager for PostgreSQL high availability
pg_auto_failover 1,135 7 months ago Postgres extension and service for automated failover and high-availability
pglookout 185 4 months ago PostgreSQL replication monitoring and failover daemon
pgslice 1,122 2 months ago Postgres partitioning as easy as pie
PostgreSQL Automatic Failover 342 7 months ago High-Availibility for Postgres, based on industry references Pacemaker and Corosync
postgresql_cluster 1,960 about 1 month ago PostgreSQL High-Availability Cluster (based on "Patroni" and "DCS(etcd)"). Automating deployment with Ansible
Vitess 18,777 about 1 month ago Database clustering system for horizontal scaling of MySQL through generalized sharding

Awesome Database Tools / Kubernetes
KubeDB Making running production-grade databases easy on Kubernetes
Postgres operator 4,414 about 1 month ago The Postgres Operator enables highly-available PostgreSQL clusters on Kubernetes (K8s) powered by Patroni
Spilo 1,589 about 1 month ago HA PostgreSQL Clusters with Docker
StackGres Enterprise-grade, Full Stack PostgreSQL on Kubernetes

Awesome Database Tools / Configuration Tuning
MySQLTuner-perl 9,011 2 months ago 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
pgtune 1,054 over 3 years ago PostgreSQL configuration wizard
postgresqltuner.pl 2,612 about 1 year ago Simple script to analyse your PostgreSQL database configuration, and give tuning advice

Awesome Database Tools / 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

Awesome Database Tools / Reporting
Chartbrew Create live dashboards, charts, and client reports from multiple databases and services
Poli 1,968 about 2 years ago An easy-to-use SQL reporting application built for SQL lovers

Awesome Database Tools / Distributions
DBdeployer 707 about 1 year ago Tool that deploys MySQL database servers easily
dbatools 2,483 about 1 month ago PowerShell module that you may think of like a command-line SQL Server Management Studio
Postgres.app 7,384 about 2 months ago Full-featured PostgreSQL installation packaged as a standard Mac app
BigSQL A developer-friendly distribution of Postgres
Elephant Shed 213 about 2 months ago Web-based PostgreSQL management front-end that bundles several utilities and applications for use with PostgreSQL
Pigsty 3,627 about 1 month ago Battery-Included Open-Source Distribution for PostgreSQL with ultimate observability & Database-as-Code toolbox for developers

Awesome Database Tools / Security
Acra 1,368 4 months ago 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
Databunker 1,259 about 1 month ago Special GDPR compliant secure vault for customer records built on top of regular DB
Inspektor 281 over 2 years ago Access control layer for databases. Inspektor leverages open policy agent to make policy decisions

Awesome Database Tools / SQL / Analyzers
Holistic.dev Automatic detection service for database performance, security, and architecture issues
SQLCheck 2,435 11 months ago Automatically detects common SQL anti-patterns
SQLFluff 8,349 about 1 month ago Dialect-flexible and configurable SQL linter
SQLLineage 1,362 4 months ago SQL Lineage Analysis Tool powered by Python
TSQLLint 214 4 months ago A tool for describing, identifying, and reporting the presence of anti-patterns in TSQL scripts

Awesome Database Tools / SQL / Extensions
PartiQL SQL-compatible access to relational, semi-structured, and nested data

Awesome Database Tools / SQL / Frameworks
Apache Calcite Dynamic data management framework with advanced SQL features
ZetaSQL 2,337 2 months ago Analyzer Framework for SQL

Awesome Database Tools / SQL / Formatters
CodeBuff 448 over 4 years ago Language-agnostic pretty-printing through machine learning
pgFormatter 1,711 about 2 months ago A PostgreSQL SQL syntax beautifier
Poor SQL Instant free and open-source T-SQL formatting
SQL Formatter 2,402 2 months ago JavaScript library for pretty-printing SQL queries

Awesome Database Tools / SQL / Games
Lost at SQL A SQL learning game to help you pick up basic SQL skills - so that you can use queries to get information
Schemaverse A Space-based strategy game implemented entirely within a PostgreSQL database
SQL Island 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
SQL Murder Mystery 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
SQL Police Department In SQLPD, you get to solve crimes while learning SQL at the same time

Awesome Database Tools / SQL / Parsers
General SQL Parser Parsing, formatting, modification and analysis for SQL
jOOQ 6,196 about 1 month ago Parses SQL, translates it to other dialects, and allows for expression tree transformations
JSqlParser 5,443 about 1 month ago Parses an SQL statement and translate it into a hierarchy of Java classes
libpg_query 1,216 about 1 month ago C library for accessing the PostgreSQL parser outside of the server environment
More SQL Parsing! 263 about 2 months ago Parse SQL into JSON
sqlparse 3,778 about 1 month ago Non-validating SQL parser for Python
SQLGlot 6,866 about 1 month ago Pure Python SQL parser, transpiler, and builder

Awesome Database Tools / SQL / Über SQL
CloudQuery 5,913 about 1 month ago Extracts, transforms, and loads your cloud assets into normalized PostgreSQL tables
csvq 1,526 6 months ago SQL-like query language for CSV
dsq 3,754 over 1 year ago Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more
MAT Calcite plugin 157 5 months ago This plugin for Eclipse Memory Analyzer allows to query heap dump via SQL
OctoSQL 4,951 8 months ago Query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL
osquery 22,065 about 1 month ago SQL powered operating system instrumentation, monitoring, and analytics
Resmo Audit and evaluate resources using SQL
Steampipe 7,053 about 1 month ago Use SQL to instantly query your cloud services (AWS, Azure, GCP and more)
TextQL 9,070 about 1 year ago Execute SQL against structured text like CSV or TSV
trdsql 2,025 about 1 month ago CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN
Trino 10,601 about 1 month ago Trino is a distributed SQL query engine designed to query large data sets distributed over one or more heterogeneous data sources

Awesome Database Tools / SQL / Language Server Protocol
SQLLanguageServer 700 about 1 month ago SQL Language Server
sqls 1,023 5 months ago SQL Language Server written in Go

Awesome Database Tools / SQL / Learning
Advanced SQL Puzzles 617 about 1 month ago Difficult set-based SQL puzzles
Hackerrank Practice coding, prepare for interviews, and get hired
Learn SQL in a Month of Lunches A book about how to use SQL to retrieve, filter, and analyze data
LeetCode Enhance your skills, expand your knowledge and prepare for technical interviews
Select Star SQL Free interactive book which aims to be the best place on the internet for learning SQL
StrataScratch Data science educational resources
SQL Murder Mystery 1,718 12 months ago Self-directed lesson to learn SQL concepts and commands and a fun game for experienced SQL users to solve an intriguing crime

Awesome Database Tools / SQL / Plan
pev2 2,696 about 1 month ago A VueJS component to show a graphical vizualization of a PostgreSQL execution plan
pg_flame 1,578 about 5 years ago A flamegraph generator for Postgres output

Awesome Database Tools / SQL / Scripts
DBA MultiTool 89 3 months ago T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs for SQL Server
pgx_scripts 1,389 over 1 year ago A collection of useful little scripts for database analysis and administration, created by our team at PostgreSQL Experts
pgsql-bloat-estimation 519 over 2 years ago Queries to mesure statistical bloat in indexes and tables for PostgreSQL
pgWikiDont SQL test that checks if your database follows rules from
pg-utils 1,053 5 months ago Useful PostgreSQL utilities
Postgres cheat sheet Useful SQL-scripts and commands by <timescale.com>
postgres_dba 1,131 3 months ago The missing set of useful tools for Postgres DBAs and all engineers
postgres_queries_and_commands.sql Useful PostgreSQL Queries and Commands
TPT 660 6 months ago These sqlplus scripts are for Oracle Database performance optimization & troubleshooting

Awesome Database Tools / Data
dbt 10,071 about 1 month ago Transform your data by simply writing select statements, while dbt handles turning these statements into tables and views in a data warehouse
QuickTable Empowers everyone to access, clean, analyze, transform, and model data with no code

Awesome Database Tools / Data / Catalog
Amundsen 4,455 about 1 month ago Metadata driven application for improving the productivity of data analysts, data scientists and engineers when interacting with data
DataHub 10,046 about 1 month ago The Metadata Platform for the Modern Data Stack
Marquez 1,800 about 1 month ago Collect, aggregate, and visualize a data ecosystem's metadata

Awesome Database Tools / Data / Lineage
Dwh.dev Nexgen data lineage for Snowflake

Awesome Database Tools / Data / Generation/Masking/Subsetting
Benerator 145 8 months ago Generate, obfuscate (anonymize / pseudonymize) and migrate data for development, testing and training purposes
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
Faker 13,181 about 1 month ago Generate massive amounts of fake data in the browser and Node.js
Noisia 692 about 1 year ago 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
Synthesized TDK DevOps' best friend for database masking and generation

Awesome Database Tools / Data / Replication
dtle 550 about 1 year ago Distributed Data Transfer Service for MySQL
Litestream 11,217 about 1 month ago Streaming replication for SQLite
pgsync 3,201 3 months ago Sync Postgres data between databases
pg_chameleon 385 7 months ago 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
PGDeltaStream 254 over 6 years ago A Golang webserver to stream Postgres changes atleast-once over websockets, using Postgres logical decoding feature
repmgr 1,584 about 2 months ago The Most Popular Replication Manager for PostgreSQL

Awesome Database Tools / Data / Compare
data-diff 2,949 8 months ago Command-line tool and Python library to efficiently diff rows across two different databases
KS DB Merge Tools GUI to compare and sync DB schema and data. For Oracle Database, MySQL, MariaDB, SQL Server, PostgreSQL, SQLite, MS Access and Cross-DBMS

Awesome Database Tools / Papers
The "Database as Code" Manifesto 96 almost 2 years ago Treat your database as Code

Awesome Database Tools / Machine Learning
MindsDB 26,915 about 1 month ago In-database Machine Learning
SQLFlow 5,112 9 months ago Brings SQL and AI together

Awesome Database Tools / Contributing
contribution guidelines Your contributions are always welcome! Please read the first

Backlinks from these awesome lists:

More related projects: