Properly manage all your databases from a single place with the help of JetBrains’ specialized IDE
JetBrains has a reputation for building strong, feature-packed, and very well-designed IDEs for a plethora of programming languages.
DataGrip is no exception, despite being an IDE geared towards database management.
Support for some of the most popular databases
DataGrip is a multi-engine database IDE that provides users with all the necessary tools to manage a vast number of databases from a single place.
Some of the supported database engines are as follows: PostgreSQL, MySQL, Oracle, SQL Server, Azure, Amazon Redshift, SQLite, DB2, H2, Sybase, Exasol, Apache Derby, MariaDB, HyperSQL, Snowflake, Cassandra, Greenplum, Vertica, MongoDB, and a few others.
All the tools you need to manage databases
One of the best aspects of all JetBrains products is their GUI. In the case of DataGrip, navigation is fast and easy (navigation to a symbol action allows you to find objects by their name), and all database objects are displayed in a friendly manner (in folders grouped by schemas).
DataGrip is also equipped with all the tools one might expect to find in a top-tier IDE. Smart code completion, code inspections, quick-fixes, live error handling, and various refactoring capabilities are all part of DataGrip’s kit.
The ability to run queries is also present. You can create multiple consoles, each one with its own schema and query parameters. The Diff viewer helps you compare two consoles in local history or two query results. The differences are highlighted and you’re provided with various management options.
The app also provides you with various import/export options. You can import data from CSV or any DSV file, and you can export as text and as queries. Other notewothy features include the VCS support (support for Subversions, Git, GitHub, Mercurial, CSV, perforce, and TFS), and the ability to explore tables via insightful diagrams.
Verdict
With powerful features such as auto-complete, integrations with the most popular database products out there, and a very user-friendly and customizable GUI, DataGrip is one of the best apps out there for database querying and manipulation.
