DataGrip

DataGrip 2020.1

A database IDE supporting multiple languages, autocompletion and refactoring.
5.0  (95 votes)
2020.1.5 (See all)

DataGrip is a database IDE supporting multiple languages, including but not limited to PostgreSQL, SQLite, Derby, Microsoft SQL Server, Oracle and MySQL. And, in case a particular language is not readily supported, it is possible to specify additional JDBC drivers. The tool has a nice interface. In this regard, there is a left panel, mainly intended for navigation, as well as a working area, which can be subdivided into tabs to allow working on simultaneous tasks. Additionally, there are other views, like a diagram showing table relationships.

DataGrip allows all the common operations performed on databases, such as adding, removing and closing data records. Likewise, it allows browsing the data with support of foreign keys. Luckily, multiple VCS tools are built-in so there is practically no need to use third-party tools to manipulate databases. It is also excellent that DataGrip can debug your SQL code and make suggestions on how to solve the errors found.

When writing code, DataGrip comes with various features that can increase your productivity and reduce the risk of making errors. These include context-sensitive and schema-aware autocompletion and version control. As to refactoring, DataGrip can update references automatically every time a change, like renaming objects or variables, is made.

All in all, DataGrip is a highly convenient IDE. It supports multiple languages and certainly helps you boost your productivity. However, as most similar applications, it may turn slow if you open a very large database, but that also depends on the available hardware. Finally, you may be pleased to know that the product can be tried at no cost.

Pedro Castro
Editor rating:

Review summary

Pros

  • Supports refactoring
  • Powerful debugging feature
  • Supports multiple languages and database types
  • Code autocompletion

Cons

  • May get slow when working with large databases
Info updated on: