DataGrip
Your Swiss Army Knife for Databases and SQL
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.
01Database 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.
02Navigation
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.
03Intelligent 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.
Intelligent coding assistance
Code completion01
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.
Renaming and finding usages02
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
Code analysis and quick-fixes03
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.
Executing queries04
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.
Query console05
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.
Query result06
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.
Diff viewer07
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.
