DataGrip is a database IDE from JetBrains that is tailored to suit specific needs of professional SQL developers.
— Intelligent query console
Allows you to write queries with coding assistance, errors indicating. Code completion is fast and context-aware. Executes queries in different modes and provides the local history that keeps track of all your activity and protects you from losing your work.
— Efficient schema navigation
Lets you jump to any table, view, or procedure by its name via the corresponding action, or directly from its usages in the SQL code. More Info »
— Data editor
Supports multiple submit/delete, multiple copy-paste, local changes, paste from external sources (like Excel), navigation by foreign keys.
— Explain plan
Gives you an extended insight into how your queries work and into database engine behavior so you can make your queries more efficient.
Supported database servers: MySQL, MariaDB, SQL Server, Oracle Database, PostgreSQL, AWS Redshift, MS Azure Database, SQLite, HyperSQL, Sybase, IBM DB2, H2, Exasol, Cassandra, ClickHouse.