[Database GUI] DataGrip: A powerful IDE from JetBrains for SQL on macOS, Windows, and Linux
DataGrip
DataGrip is a powerful IDE from JetBrains for SQL on macOS, Windows, and Linux, correctly resolves all references in your SQL code and helps you refactor them. When you rename a variable or an alias, it will update their usages throughout the entire file. The actual table names in the database are updated when you rename references to them from your queries.
Features
-
Exploring your databases
DataGrip is the multi-engine database environment. If the DBMS has a JDBC driver you can connect to it via DataGrip. It provides database introspection and various instruments for creating and modifying objects for the supported engines:
-
Writing SQL
Just as any decent IDE should, DataGrip provides smart code completion, code inspections, on-the-fly error highlighting, quick-fixes, and refactoring capabilities. It saves you time by making the process of writing SQL code more efficient.
-
Running queries
The query console in DataGrip is a basic necessity for any SQL developer. Create multiple consoles, each with their own schema and query options.
-
Miscellaneous features
Among other things, DataGrip comes with user parameters support, CSV editor, diagram builder, version control support and many other features.
Installation
Homebrew - https://brew.sh/ is the preferred way to install:
1 | brew install --cask datagrip |
See Install DataGrip | DataGrip - https://www.jetbrains.com/help/datagrip/installation-guide.html to learn more.
References
[3] datagrip — Homebrew Formulae - https://formulae.brew.sh/cask/datagrip