SQL-Engineering-Handbook
🛠️ Awesome Tools
Part of the Resources Library — SQL Engineering Handbook
Editors, clients, ERD tools, and formatters — the software around the SQL, not the SQL itself.
| Tool | Category | What It’s For | Free / Paid |
|---|---|---|---|
| DBeaver | Database Client | Free, universal database client supporting nearly every SQL dialect — a solid single default if you don’t already have a preference | Free (Community Edition); paid Enterprise tier |
| TablePlus | Database Client | Fast, clean native client, popular on macOS specifically, with a genuinely pleasant query and table-editing UI | Free tier (limited); paid for full use |
| DataGrip | Database IDE | JetBrains’ full SQL IDE — refactoring, smart code completion, and version control integration for serious schema work | Paid (free for students/OSS via JetBrains’ education program) |
| dbdiagram.io | ERD Tool | Text-to-diagram ERD tool — describe a schema in a simple DSL and get a clean visual diagram out | Free tier; paid for private diagrams |
| DrawSQL | ERD Tool | Visual, drag-and-drop ERD builder with schema export | Free tier; paid for team features |
| pgAdmin | Database Client | The official PostgreSQL administration and development client | Free |
| SQLFluff | Formatter / Linter | A configurable SQL linter and auto-formatter supporting multiple dialects — useful for keeping this repo’s own query style consistent | Free, open source |
[!TIP] Pick one primary client and learn its keyboard shortcuts properly rather than switching between three. The tool matters far less than fluency with whichever one you pick.
This closes the full Resources Library — all 13 files are now in place. Back to Resources Library.