JetBrains' commercial Database IDE(formerly 0xdbe). This is a cross platform database IDE that supports most relational databases.
DataGrip is a multi-engine database environment from JetBrains. It supports:
- Oracle
- PostgreSQL
- AWS Redshift
- MySQL
- Microsoft SQL Server
- Microsoft Azure
- DB2
- Sybase
- SQLite
- HyperSQL
- Apache Derby
- H2
- Exasol
Targeting the needs of professional SQL developers, DataGrip makes working with databases an enjoyable experience.
Main features
Database objects
DataGrip introspects objects in your databases and displays them grouped in folders by schemas. It also provides a UI for adding and editing tables, columns, indexes, constraints, etc. Quick navigation brings you to any object, whether it has just been created in your code or has been read from a database.
Data editor
A 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. All your changes are stored locally and can be submitted at once. Multiple fields can also be edited at once.
Query editor
Transform and move blocks of code, use multi-cursors to manage selection, format code according to specific style. DataGrip provides context-sensitive, schema-aware code completion, helping you write code faster. Completion is aware of table structure, foreign keys, and even database objects created in the code you're editing.
Additional Features
Code Reformatting
Reformat queries with a single click through user-definable code style schemes. Formatting currently supports: SQL, JSON, HTML, XML, and CSV.
Query Templates (Live Templates)
Ability to define custom, commonly-used SQL snippets that can be generated via an alias using smart code completion (e.g. define a common set of joins to auto-generate when typing 'common' into the SQL editor).
Safe Refactor
Refactor code without worrying that your changes will break other portions of your project. DataGrip will automatically check and alert, if a refactor change has the potential to break other portions of code within your project.
Links
