Scripts for PostgreSQL, MySQL, AWS Athena and Google BigQuery:
Preference is given to free tools.
- DBeaver
- CloudBeaver - web UI SQL client
- DBGate - SQL + NoSQL client
- BeeKeeperStudio
- SQLectron - lightweight client
- HeidiSQL
- DBVisualizer
- SQuirreL
- Tora
- PgAdmin - PostgreSQL web UI
- phpMyAdmin - MySQL web UI
- SQL Chat - chat-based interface to querying DBs
- SQLFluff - Extensible and customizable SQL linter with support for multiple dialects, allowing for strict style enforcement
- SQLLint (SQL-Lint) - Simple, fast, and open-source SQL linter that checks for common issues in SQL queries
- SQLCheck - Focuses on detecting anti-patterns in SQL queries to optimize performance and maintainability
- SQLint - Minimalist linter for SQL code, primarily for catching syntax errors in your queries
- Popeye - A Kubernetes reporting tool that also helps analyze and lint database configurations
- SonarQube with SQL Plugin - SonarQube supports SQL linting through its plugin system, helping enforce best practices and maintainability
- ALE (Asynchronous Lint Engine) - A linter for many languages, including SQL, integrated into Vim/Neovim for real-time feedback
- SQLcodegen - A tool that can help generate SQL code based on linting requirements and other features
TODO
Atomic, Consistent, Isolated & Durable.
ACID compliance is a standard feature of RDBMS SQL databases.
Be careful and remember to SELECT with WHERE clause before editing it to an UPDATE!
