About
JetBrains DataGrip is a tool designed specifically for SQL developers, enabling convenient work with various databases.The solution offers all the necessary tools, such as navigation, code completion and analysis, refactoring, version control, and much more.
**Smart Query Console**
Run queries in different modes: standard or "read-only."The console stores a history of queries and keyboard input, and saves automatically.
**Database Navigation**
Find any object by simply typing its name in the search window.Jump directly from an SQL script to an object's source code or data.
**Query Planner**
Choose your preferred planner: tree-view or graphical.Analyze the efficiency of your queries.
**Smart Code Completion**
Code completion is context-aware: it suggests keywords or objects based on what is appropriate for a specific location in the code.It takes into account foreign keys, object structures, and even objects created within the same script.
**Code Analysis and Quick-Fixes**
DataGrip detects issues in your queries and offers automatic fixes.
**Refactoring**
DataGrip understands which objects are involved in a script.When a user renames an alias or variable, it is automatically renamed in all places where it is used.Optionally, object names can also be updated within the database itself if they are renamed within a query.The IDE clearly indicates which procedures or functions utilize these objects;in such cases, the source code of those procedures is updated as well.
**Version Control Support**
DataGrip supports integration with Git, SVN, Mercurial, and other version control systems.