DataGrip favicon

DataGrip

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. — 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.