JetBrains DataGrip 2021 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.
JetBrains DataGrip 2021 Features
- Database 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.
- Table editor
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.
- Code completion
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.
- Code generation
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.