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:
DataGrip introspects all objects in your databases and displays them in folders grouped by schemas. It also provides a UI for adding and editing tables, columns, indexes, and constraints etc.Learn more
The powerful data editor lets you add, remove, edit, and clone data rows. Navigate through the data by foreign keys and use the text search to find anything in the data displayed in the data editor.Learn more
Quick navigation takes you to an object independent of whether it has just been created in your code, or it has already been read from a database. Navigate to symbol action lets you find objects by their name.Learn more
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.
Smart text editor
Just as with any IntelliJ platform IDE, DataGrip includes a code editor which helps you be more productive. Transform and move blocks of code, use multi-cursors to manage selection, format code according to a specific style, and much more.Learn more
DataGrip provides context-sensitive, schema-aware code completion, helping you to write code faster. Completion is aware of the tables structure, foreign keys, and even database objects created in the code you're editing.Learn more
Forget about writing typical code manually: DataGrip will do that for you. It generates code for changing objects like tables, columns, etc., based on UI. Moreover, it helps you to get DDL for tables and provides DML queries from result-sets.Learn more
Code analysis and quick-fixes
DataGrip detects where probable bugs may occur in your SQL code and suggests the best options to fix them on the fly. It will immediately let you know about unresolved objects, the use of keywords as identifiers, and always offers you a way to fix the problem.Learn more
Refactoring and finding usages
DataGrip correctly resolves all references in your SQL files. When you're renaming database objects from SQL, they will also be renamed in the database. You can quickly find in which stored procedures, functions and views your tables are used.Learn more
DataGrip comes with light and dark look and feel themes. Each of them can be fully customized, so you can create the one that suits you best. The same works for more than ten pre-configured keymaps.Learn more
The query console in DataGrip is a basic necessity for any SQL developer. Create multiple consoles, each with their own schema and query options.
Import data from CSV or any DSV file. DataGrip also has a powerful engine to export data in various formats. You can even create your own export formats.
Among other things, DataGrip comes with user parameters support, CSV editor, diagram builder, version control support and many other features.