DataGrip

About DataGrip

DataGrip is a cross-platform integrated development environment for relational and NoSQL databases, developed by JetBrains. It provides a query console for executing and tracking SQL queries with local history, context-sensitive code completion aware of table structure and foreign keys, on-the-fly code analysis with bug detection and quick-fixes, and import/export support for formats including CSV, TSV, JSON, HTML, Markdown, and Excel. It integrates with version control systems including Git, SVN, and Mercurial, and offers customizable themes, keymaps, and language plugins.

The tool includes AI assistance that is schema- and context-aware, supporting query writing, error fixing, query optimization, and conversion between SQL dialects, with a choice of AI models including Claude, GPT, Gemini, and Grok, or a local model. It also supports a multi-agent experience with tools such as Claude Agent, Codex, GitHub Copilot, and Cursor via ACP, and allows use of JetBrains AI credits or externally sourced AI subscriptions and API keys.

DataGrip connects to a wide range of databases, including PostgreSQL, MySQL, Oracle, Microsoft SQL, MongoDB, Redis, Azure SQL, Amazon Redshift, Amazon DynamoDB, SQLite, IBM Db2, Snowflake, Apache Cassandra, ClickHouse, Google BigQuery, and others. Its functionality is also integrated into other JetBrains IDEs. It is free for non-commercial use, with a 30-day free trial available, and JetBrains states the product adheres to SOC 2 security certification.

Key features

• Context-sensitive SQL code completion aware of table structure and foreign keys
• Schema- and context-aware AI assistance for writing, fixing, and optimizing queries
• Import/export data in CSV, TSV, JSON, HTML, Markdown, Excel, and more formats
• On-the-fly analysis with quick-fixes for detected bugs and unresolved objects
• Query history with parameterized SQL query support
• Version control integration with Git, SVN, Mercurial, and other systems

Frequently asked questions