DataGrip
By JetBrains
DataGrip is a cross-platform database IDE from JetBrains that provides intelligent SQL editing, schema navigation, and management tools for a wide range of relational and other databases.
Definition
DataGrip is a cross-platform database IDE from JetBrains that provides intelligent SQL editing, schema navigation, and management tools for a wide range of relational and other databases.
Overview
DataGrip is part of the JetBrains IDE family, sharing much of its underlying engine with the database tools built into IntelliJ IDEA and other JetBrains products, but packaged as a dedicated, standalone application for database developers, analysts, and DBAs. It connects to databases over JDBC and understands the live schema of whatever it's connected to, which powers context-aware SQL completion, safe refactoring (such as renaming a column and updating every reference to it), and a searchable database explorer. A built-in data editor lets users view and edit table contents directly, and query consoles keep a history of executed statements per connection. DataGrip supports a broad range of engines, including PostgreSQL, MySQL, MariaDB, SQLite, and Oracle. It's typically used alongside — not instead of — a general-purpose code editor such as VS Code, reserved specifically for the SQL-heavy parts of a workflow: exploring schemas, writing complex queries, and managing migrations across several databases at once.
Key Features
- Context-aware SQL code completion based on the live database schema
- Support for numerous relational databases in a single IDE
- Smart schema navigation and a searchable database explorer
- Safe refactoring across SQL code, including renaming tables and columns
- Built-in data editor for viewing and editing table contents directly
- Query history and multiple simultaneous database connections
- Data import and export in formats like CSV, JSON, and SQL dumps