Exploring your databases
DataGrip is the multi-engine database environment. We support MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2. If the DBMS has a JDBC driver you can connect to it via DataGrip. For any of supported engines it provides database introspection and various instruments for creating and modifying objects.
DataGrip introspects all objects in your databases and displays them grouped in folders by schemas. It also provides UI for adding and editing tables, columns, indexes, constraints etc.
Quick navigation brings you to any object no matter if it has just been created in your code, or has already been read from a database. Navigate to symbol action lets you find objects by their name.
Powerful table 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 table editor.
Intelligent coding assistance
Just as any decent IDE should, DataGrip provides smart code completion, code inspections, on-the-fly error highlighting and quick-fixes, and refactoring capabilities. It saves your time by making the process of writing SQL code more efficient.
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 code you're editing.
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.
Renaming and finding usages
DataGrip correctly resolves all table and column references in your SQL files. If you rename any variable or alias, they are renamed throughout the entire code. When you're renaming database objects from SQL, they will also be renamed in the actual database.
Code analysis and quick-fixes
DataGrip detects probable bugs 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 a way to fix the problem.
Smart text editor
Just as any IntelliJ platform IDE, DataGrip includes the code editor that helps you to be more productive. Transform and move blocks of code, use multi-cursors to manage selection, format code according to specific style, and much 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. Same works for more than ten pre-configured keymaps.
Writing queries is nothing without being able to run them. Query console in DataGrip is the basic instrument for any SQL developer. Create multiple consoles, each with its own schema and query options.
Specify console behavior for running queries: choose what you want to execute—the smallest statement or the largest one. Each console support schema switching and provides local history that keeps track of all your activity and protects you from losing your work.learn more
Result-set is similar to the table editor, so they share many features: result-set is editable and supports text search with regular expressions, DDL generation, navigating over the structure.
Use the diff viewer to compare two console snapshots in local history or two query results DataGrip highlights the differences and lets you manage the comparison criteria via the tolerance parameter.
Among other things, DataGrip comes with user parameters support, CSV editor, diagram builder, version control support and many other features.
DataGrip supports running parametrized SQL queries. Add your own parameter patterns using regular expressions and choose SQL dialects to which these patterns will apply.
With DataGrip you can edit CSV files as tables with instant changes preview.
Also explore your tables and their relationships on an insightful diagram. Database objects can be modified directly from it, too.