[Database GUI] DataGrip: A powerful IDE from JetBrains for SQL on macOS, Windows, and Linux


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.


  • 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.



Homebrew - https://brew.sh/ is the preferred way to install:

$ brew install --cask datagrip

See Install DataGrip | DataGrip - https://www.jetbrains.com/help/datagrip/installation-guide.html to learn more.


[1] DataGrip: The Cross-Platform IDE for Databases & SQL by JetBrains - https://www.jetbrains.com/datagrip/

[3] datagrip — Homebrew Formulae - https://formulae.brew.sh/cask/datagrip

[4] Homebrew - https://brew.sh/