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
4k stars
74 watching
348 forks
last commit: 30 days 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,903 | about 1 year ago | Easily query, script, and visualize data from every database, file, and API |
| DBeaver | 40,507 | 3 days 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 | almost 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,807 | 4 days 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,955 | 6 days ago | Querybook is a Pinterest open-source Big Data Querying UI, combining collocated table metadata and a simple notebook IDE interface |
| Slashbase | 1,303 | 7 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 | 9 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,263 | 6 months ago | Database management in a single PHP file |
| Another Redis Desktop Manager | 30,713 | 13 days ago | Free Open Source Redis Manager. Available on Mac, Linux, Windows, Homebrew, Snap, winget, and more |
| Azure Data Studio | 7,581 | 4 days 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,751 | 6 days ago | Open Source SQL Editor and Database Manager with a privacy commitment in their mission statement |
| Clidey WhoDB | 1,862 | 6 days ago | A lightweight database explorer with next-gen UX for all SQL, NoSQL, Caches, and Queues |
| DbGate | 5,408 | 6 days ago | Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application |
| DB Lens | 256 | 4 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,885 | 3 days ago | Database Subsetting and Relational Data Browsing Tool/Client |
| Malewicz | 64 | about 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 | 61 | about 1 month ago | For MySQL, MariaDB, and Tarantool. Developed for Linux but can run on Windows |
| OmniDB | 3,183 | almost 2 years ago | Web tool for database management |
| Pgweb | 8,647 | 19 days 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,271 | 5 days 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,310 | about 2 years ago | Robo 3T (formerly Robomongo) is a shell-centric cross-platform MongoDB management tool |
| Sequel Ace | 6,737 | 16 days ago | MySQL/MariaDB database management for macOS |
| Sequel Pro | 9,071 | over 1 year 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,705 | over 2 years ago | A TUI for viewing sqlite databases, written in Go |
| sqlpad | 5,056 | 18 days 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,508 | 6 days ago | Database management for VSCode |
| SQLyog | The most complete and easy to use MySQL GUI | ||
| Tabix | 2,160 | almost 2 years ago | SQL Editor & Open source simple business intelligence for Clickhouse |
| TablePlus | 3,449 | 8 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,787 | 4 months ago | Connect to a database for issue SQL commands within IPython or IPython Notebook |
| iredis | 2,564 | 7 months ago | A Cli for Redis with AutoCompletion and Syntax Highlighting |
| pgcenter | 1,551 | 6 months ago | Top-like admin tool for PostgreSQL |
| pg_activity | 2,483 | about 1 month ago | Top-like application for PostgreSQL server activity monitoring |
| pg_top | 112 | 6 months ago | Top for PostgreSQL |
| pspg | 2,500 | about 2 months ago | Postgres Pager |
| SQLcl | Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database | ||
| sqlite-utils | 1,671 | 12 days ago | CLI tools for manipulating SQLite database files - inserting data, running queries, creating indexes, configuring full-text search and more |
| SQLLine | 620 | over 1 year ago | Command-line shell for issuing SQL to relational databases via JDBC |
| usql | 8,990 | 9 days 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,778 | 10 days ago | CLI for SQLite Databases with auto-completion and syntax highlighting |
| mssql-cli | 1,362 | 9 months ago | A command-line client for SQL Server with auto-completion and syntax highlighting |
| mycli | 11,481 | 11 days ago | A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting |
| pgcli | 12,140 | about 2 months ago | Postgres CLI with autocompletion and syntax highlighting |
| vcli | 76 | over 7 years ago | Vertica CLI with auto-completion and syntax highlighting |
Awesome Database Tools / Schema / Changes | |||
| 2bass | 42 | 9 days ago | Database configuration-as-code tool that utilizes concept of idempotent DDL scripts |
| Atlas | 5,964 | 7 days ago | Inspect and Apply changes to your database schema |
| Bytebase | 11,445 | 6 days ago | Web-based, zero-config, dependency-free database schema change and version control tool for teams |
| flyway | 8,236 | 14 days ago | Database migration tool |
| gh-ost | 12,411 | 21 days ago | Online schema migration for MySQL |
| liquibase | 4,743 | 6 days ago | Database-independent library for tracking, managing and applying database schema changes |
| migra | 2,922 | 6 months ago | Like diff but for PostgreSQL schemas |
| node-pg-migrate | 1,295 | 3 days 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 | 540 | 18 days ago | Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL |
| Prisma Migrate | 766 | almost 4 years ago | Declarative database schema migration tool that uses a declarative data modeling syntax to describe your database schema |
| Pyrseas | 396 | 4 months ago | Provides utilities to describe a PostgreSQL database schema as YAML |
| Reshape | 1,725 | about 2 months ago | An easy-to-use, zero-downtime schema migration tool for Postgres |
| SchemaHero | 1,001 | 15 days ago | A Kubernetes operator for declarative database schema management (gitops for database schemas) |
| Skeema | 1,269 | 6 days ago | Declarative pure-SQL schema management system for MySQL and MariaDB, with support for sharding and external online schema change tools |
| Sqitch | 2,780 | 6 months ago | Sensible database-native change management for framework-free development and dependable deployment |
| sqldef | 1,966 | 20 days ago | Idempotent schema management for MySQL, PostgreSQL, and more |
| yuniql | 419 | 4 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 | 273 | about 2 years ago | Infers SQL DDL (Data Definition Language) from table data |
| scheme2ddl | 82 | 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,325 | 6 days ago | An Entity Relationship diagram (ERD) visualization tool, with various filters and inputs to help understand your database schema |
| ChartDB | 9,559 | 7 days ago | Free and Open-source database diagrams editor, visualize and design your DB with a single query |
| DrawDB | 22,553 | 9 days ago | Free, simple, and intuitive online database design tool and SQL generator |
| ERAlchemy | 1,162 | 2 months 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,894 | 21 days ago | Database Markup Language, designed to define and document database structures |
| SchemaCrawler | 1,624 | 3 days ago | A free database schema discovery and comprehension tool |
| Schema Spy | 3,213 | 3 months ago | Generating your database to HTML documentation, including Entity Relationship diagrams |
| tbls | 3,495 | 6 days ago | CI-Friendly tool for document a database, written in Go |
Awesome Database Tools / Schema / Design | |||
| Database Design | 448 | 9 days 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,123 | 8 days ago | Data modeling tool designed for PostgreSQL |
| WWW SQL Designer | 2,879 | 2 months ago | Online SQL diagramming tool |
Awesome Database Tools / Schema / Samples | |||
| Oracle Database Sample Schemas | 750 | 8 months ago | Oracle Database Sample Schemas |
Awesome Database Tools / API | |||
| Datasette | 9,562 | 6 days ago | A tool for exploring and publishing data |
| DreamFactory | 1,569 | 6 days ago | A open source REST API backend for mobile, web, and IoT applications |
| Graphweaver | 491 | 7 days ago | Turn multiple data sources into a single GraphQL API |
| Hasura GraphQL Engine | 31,179 | 7 days 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,539 | about 2 years ago | Prisma turns your database into a realtime GraphQL API |
| PostGraphile | 12,613 | 6 days ago | Instantly spin-up a GraphQL API server by pointing PostGraphile at your existing PostgreSQL database |
| PostgREST | 23,440 | 6 days ago | REST API for any Postgres database |
| prest | 4,236 | 16 days ago | Is a way to serve a RESTful API from any databases written in Go |
| Remult | 2,894 | 4 days ago | End-to-end type-safe CRUD via REST API for your database, with fine-grained access control |
| restSQL | 147 | almost 6 years ago | SQL generator with Java and HTTP APIs, uses a simple RESTful HTTP API with XML or JSON serialization |
| resquel | 127 | 3 months ago | Easily convert your SQL database into a REST API |
| sandman2 | 2,008 | 10 days ago | Automatically generate a RESTful API service for your legacy database |
| soul | 1,531 | about 1 month ago | Automatic SQLite RESTful and realtime API server |
| VulcanSQL | 643 | 5 months ago | Write templated SQL to automatically exposing RESTful APIs from your database/data warehouse/data lake |
Awesome Database Tools / Application platforms | |||
| Appsmith | 34,598 | 6 days ago | Powerful open source low code framework to build internal applications really quickly |
| Budibase | 22,721 | 6 days ago | Low-code platform for creating internal apps in minutes |
| ILLA Cloud | 11,630 | 2 months ago | Low-code internal tool building platform |
| Nhost | 7,941 | 3 days ago | The Open Source Firebase Alternative with GraphQL |
| Saltcorn | 1,694 | 6 days ago | Open source no-code builder for web datatabase applications. Server and drag-and-drop UI builder, data stored in PostgreSQL or SQLite |
| Tooljet | 32,923 | 3 days ago | Open-source low-code platform to build internal tools |
Awesome Database Tools / Backup | |||
| BaRMan | 2,131 | 22 days ago | Backup and Recovery Manager for PostgreSQL |
| pgbackrest | 2,624 | 6 days ago | Reliable PostgreSQL Backup & Restore |
| pgcopydb | 1,192 | 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 | 174 | 5 days 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 | 167 | 12 months 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 | 674 | 4 days ago | Open source platform for managing and monitoring MySQL and MongoDB performance |
| pganalyze collector | 337 | 3 days ago | Pganalyze statistics collector for gathering PostgreSQL metrics and log data |
| pgbadger | 23 | about 6 years ago | A fast PostgreSQL Log Analyzer |
| pgDash | Measure and track every aspect of your PostgreSQL databases | ||
| PgHero | 8,181 | 14 days ago | A performance dashboard for Postgres - health checks, suggested indexes, and more |
| pgmetrics | 965 | about 1 month ago | Collect and display information and stats from a running PostgreSQL server |
| pgMonitor | 591 | 16 days 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 | 118 | about 1 month ago | Collects PostgreSQL statistics, and either saves them in CSV files or print them on the stdout |
| pgwatch2 | 1,820 | 8 days ago | Flexible self-contained PostgreSQL metrics monitoring/dashboarding solution |
| PostgreSQL Metrics | 590 | 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,328 | 8 months ago | The open-source observability backend for metrics and traces powered by SQL |
| Telegraf PostgreSQL plugin | 14,693 | 7 days ago | Provides metrics for your postgres database |
Awesome Database Tools / Monitoring/Statistics/Perfomance / Prometheus | |||
| pgSCV | 166 | 3 months ago | Metrics exporter for PostgreSQL and Postgres-related services |
| postgres_exporter | 2,814 | 9 days ago | Prometheus exporter for PostgreSQL server metrics |
| pg_exporter | 177 | 2 months 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 | 12 months ago | Python script to monitor Oracle Databases |
| ZabbixDBA | 98 | over 4 years ago | ZabbixDBA is fast, flexible, and continuously developing plugin to monitor your RDBMS |
Awesome Database Tools / Testing | |||
| DbFit | 232 | over 2 years ago | A database testing framework that supports easy test-driven development of your database code |
| pgTAP | 990 | 16 days ago | Unit Testing for PostgreSQL |
| RegreSQL | 278 | 3 months ago | Regression Testing your SQL queries |
| SQLancer | 1,498 | 13 days ago | Automatically test DBMS in order to find logic bugs in their implementation |
Awesome Database Tools / HA/Failover/Sharding | |||
| Citus | 10,609 | 6 days ago | Postgres extension that distributes your data and your queries across multiple nodes |
| patroni | 6,832 | 9 days ago | A template for PostgreSQL High Availability with ZooKeeper, etcd, or Consul |
| Percona XtraDB Cluster | 344 | 14 days ago | A High Scalability Solution for MySQL Clustering and High Availability |
| ShardingSphere | 19,966 | 6 days ago | Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database |
| stolon | 4,661 | 5 months ago | Cloud native PostgreSQL manager for PostgreSQL high availability |
| pg_auto_failover | 1,128 | 5 months ago | Postgres extension and service for automated failover and high-availability |
| pglookout | 186 | about 2 months ago | PostgreSQL replication monitoring and failover daemon |
| pgslice | 1,112 | 9 days ago | Postgres partitioning as easy as pie |
| PostgreSQL Automatic Failover | 342 | 5 months ago | High-Availibility for Postgres, based on industry references Pacemaker and Corosync |
| postgresql_cluster | 1,811 | 7 days ago | PostgreSQL High-Availability Cluster (based on "Patroni" and "DCS(etcd)"). Automating deployment with Ansible |
| Vitess | 18,670 | 6 days 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,372 | 15 days ago | The Postgres Operator enables highly-available PostgreSQL clusters on Kubernetes (K8s) powered by Patroni |
| Spilo | 1,567 | 3 days ago | HA PostgreSQL Clusters with Docker |
| StackGres | Enterprise-grade, Full Stack PostgreSQL on Kubernetes | ||
Awesome Database Tools / Configuration Tuning | |||
| MySQLTuner-perl | 8,966 | 7 days 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,053 | over 3 years ago | PostgreSQL configuration wizard |
| postgresqltuner.pl | 2,604 | 11 months 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 | almost 2 years ago | An easy-to-use SQL reporting application built for SQL lovers |
Awesome Database Tools / Distributions | |||
| DBdeployer | 706 | about 1 year ago | Tool that deploys MySQL database servers easily |
| dbatools | 2,471 | 4 days ago | PowerShell module that you may think of like a command-line SQL Server Management Studio |
| Postgres.app | 7,348 | 4 days ago | Full-featured PostgreSQL installation packaged as a standard Mac app |
| BigSQL | A developer-friendly distribution of Postgres | ||
| Elephant Shed | 210 | 7 months ago | Web-based PostgreSQL management front-end that bundles several utilities and applications for use with PostgreSQL |
| Pigsty | 3,470 | 6 days ago | Battery-Included Open-Source Distribution for PostgreSQL with ultimate observability & Database-as-Code toolbox for developers |
Awesome Database Tools / Security | |||
| Acra | 1,357 | 2 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,256 | 17 days ago | Special GDPR compliant secure vault for customer records built on top of regular DB |
| Inspektor | 283 | 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,432 | 9 months ago | Automatically detects common SQL anti-patterns |
| SQLFluff | 7,927 | 8 days ago | Dialect-flexible and configurable SQL linter |
| SQLLineage | 1,341 | 2 months ago | SQL Lineage Analysis Tool powered by Python |
| TSQLLint | 214 | 2 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,325 | 8 days ago | Analyzer Framework for SQL |
Awesome Database Tools / SQL / Formatters | |||
| CodeBuff | 445 | over 4 years ago | Language-agnostic pretty-printing through machine learning |
| pgFormatter | 1,692 | 15 days ago | A PostgreSQL SQL syntax beautifier |
| Poor SQL | Instant free and open-source T-SQL formatting | ||
| SQL Formatter | 2,359 | 4 days 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,170 | 6 days ago | Parses SQL, translates it to other dialects, and allows for expression tree transformations |
| JSqlParser | 5,407 | 5 days ago | Parses an SQL statement and translate it into a hierarchy of Java classes |
| libpg_query | 1,210 | 21 days ago | C library for accessing the PostgreSQL parser outside of the server environment |
| More SQL Parsing! | 261 | 12 days ago | Parse SQL into JSON |
| sqlparse | 3,752 | 7 days ago | Non-validating SQL parser for Python |
| SQLGlot | 6,745 | 4 days ago | Pure Python SQL parser, transpiler, and builder |
Awesome Database Tools / SQL / Über SQL | |||
| CloudQuery | 5,877 | 6 days ago | Extracts, transforms, and loads your cloud assets into normalized PostgreSQL tables |
| csvq | 1,520 | 4 months ago | SQL-like query language for CSV |
| dsq | 3,712 | about 1 year ago | Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more |
| MAT Calcite plugin | 156 | 3 months ago | This plugin for Eclipse Memory Analyzer allows to query heap dump via SQL |
| OctoSQL | 4,831 | 6 months ago | Query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL |
| osquery | 21,887 | 11 days ago | SQL powered operating system instrumentation, monitoring, and analytics |
| Resmo | Audit and evaluate resources using SQL | ||
| Steampipe | 6,980 | 8 days ago | Use SQL to instantly query your cloud services (AWS, Azure, GCP and more) |
| TextQL | 9,066 | about 1 year ago | Execute SQL against structured text like CSV or TSV |
| trdsql | 2,012 | 24 days ago | CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN |
| Trino | 10,467 | 4 days 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 | 693 | 8 days ago | SQL Language Server |
| sqls | 1,001 | 3 months ago | SQL Language Server written in Go |
Awesome Database Tools / SQL / Learning | |||
| Advanced SQL Puzzles | 595 | 7 days 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,690 | 10 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,653 | about 1 month ago | A VueJS component to show a graphical vizualization of a PostgreSQL execution plan |
| pg_flame | 1,575 | almost 5 years ago | A flamegraph generator for Postgres output |
Awesome Database Tools / SQL / Scripts | |||
| DBA MultiTool | 88 | 26 days ago | T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs for SQL Server |
| pgx_scripts | 1,384 | 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 | 515 | about 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,043 | 3 months ago | Useful PostgreSQL utilities |
| Postgres cheat sheet | Useful SQL-scripts and commands by <timescale.com> | ||
| postgres_dba | 1,126 | 29 days ago | The missing set of useful tools for Postgres DBAs and all engineers |
| postgres_queries_and_commands.sql | Useful PostgreSQL Queries and Commands | ||
| TPT | 656 | 4 months ago | These sqlplus scripts are for Oracle Database performance optimization & troubleshooting |
Awesome Database Tools / Data | |||
| dbt | 9,950 | 6 days 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,440 | 10 days ago | Metadata driven application for improving the productivity of data analysts, data scientists and engineers when interacting with data |
| DataHub | 9,916 | 4 days ago | The Metadata Platform for the Modern Data Stack |
| Marquez | 1,779 | 8 days 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 | 142 | 6 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 | 12,985 | 4 days 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 | 551 | 11 months ago | Distributed Data Transfer Service for MySQL |
| Litestream | 11,070 | 13 days ago | Streaming replication for SQLite |
| pgsync | 3,178 | about 1 month ago | Sync Postgres data between databases |
| pg_chameleon | 384 | 5 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 | 253 | over 6 years ago | A Golang webserver to stream Postgres changes atleast-once over websockets, using Postgres logical decoding feature |
| repmgr | 1,572 | 7 days ago | The Most Popular Replication Manager for PostgreSQL |
Awesome Database Tools / Data / Compare | |||
| data-diff | 2,945 | 6 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 | 95 | almost 2 years ago | Treat your database as Code |
Awesome Database Tools / Machine Learning | |||
| MindsDB | 26,793 | 6 days ago | In-database Machine Learning |
| SQLFlow | 5,096 | 7 months ago | Brings SQL and AI together |
Awesome Database Tools / Contributing | |||
| contribution guidelines | Your contributions are always welcome! Please read the first | ||
sindresorhus/awesome
jnv/lists
agarcialeon/awesome-database
0ex/more-awesome
go-reform/reform
xo/xo
marlow/marlow
ankane/production_rails
melkeydev/go-blueprint
rocketlaunchr/dbq
mattn/go-sqlite3
nektro/andesite
volatiletech/sqlboiler
alexedwards/scs