DataGrip

为适应专业 SQL 开发人员和DBA的特定需要定制的数据库 IDE。

由以下开发商制作:JetBrains
ComponentSource开始代理销售的日期:2007年

价格从： US$ 253.82 版本:2026.1.2 新增功能 更新: Apr 9, 2026

DataGrip 屏幕截图

DataGrip 新版本发表

Released: Aug 12, 2024

2024.2 中的更新

特性

The new UI has become the default

  • Starting with this release, the new UI will become the default option. If you prefer the classic UI, you can still use it by installing the corresponding plugin, which is available on JetBrains Marketplace.

AI Assistant features

  • Text-to-SQL - Ask AI Assistant to generate SQL code right in the editor. After AI Assistant generates the code, you can accept the result, regenerate it, or specify your prompt by clicking the corresponding buttons at the bottom of...
阅读更多

Released: Jun 10, 2024

2024.1.4 中的更新

修补程序

  • Database session "Filter rows" is hiding unsubmitted changes.
  • Duplicated items when creating / dropping object in non default schema with disabled auto sync.
  • Introspection of a family misses newly created tables.
  • Unable to attach script to database session.
  • Dump tools in container: Notify user when dump is finished.
  • Dump tools in container: File template resets on path selection.
  • Dump tools in container: Path to dump by default set to local file system.
  • Dump tools in container: Can't...
阅读更多

Released: May 15, 2024

2024.1.3 中的更新

特性

  • Snowflake: Added support for DYNAMIC and other tables.

Released: Apr 3, 2024

2024.1 中的更新

特性

AI Assistant: option to attach schemas

  • AI Assistant now allows you to improve the quality of generated SQL queries by attaching a database schema for context in the chat. For now, only table and column names are attached and there is a maximum limit of 50 tables.
  • Context menu features in the editor, such as Explain Code, now understand the current schema when invoked from database consoles.
  • Because AI Assistant is aware of your schema, you can:
    • Generate queries from natural language requests...
阅读更多

Released: Dec 6, 2023

2023.3 中的更新

特性

Data visualization

  • Added the ability to visualize data using the Lets-Plot library integration. The visualization is available on all three types of grids:
    • Main tab: When you open the table, view, or CSV file, the plot is displayed in split mode.
    • Result tab: When you observe the result of a query in the Services tool window, the plot can be displayed instead of the grid.
    • In-editor results: You can display the plot instead of the grid.

New import functionality

  • The import functionality has been...
阅读更多

Released: Jul 20, 2023

2023.2.x 中的更新

2023.2

Updated Jul 20, 2023

Features

  • User Interface
    • New UI:
      • The new UI is now enabled by default.
      • Introduced the alternate Light with Light Header option to the Light theme, featuring matching light colors for window headers, tooltips, and notification balloons.
      • All the toolbar icons in DataGrip have been moved to the header. The list of icons here is fixed by default: Database Explorer, Services, and Files.
    • Improved main toolbar customization - Expanded customization options for the whole...
阅读更多

Released: Mar 28, 2023

2023.1.x 中的更新

2023.1.2

Updated May 17, 2023

Features

  • Snowflake
    • The LIKE ALL operator is now supported.
    • New aggregate functions are now supported.
    • The functions MIN_BY and MAX_BY are now supported.
    • Added support for string literals as a body for Snowflake Scripting procedures.

Fixes

  • A memory leak that occurred when exporting data to a file has been fixed.
  • Add/Clone/Delete Column menu items no longer disappear when editing a CSV file in table mode.
  • Several bugs in the SQL formatter have been fixed.
  • The source...
阅读更多

Released: Dec 1, 2022

2022.3.x 中的更新

2022.3.3

Updated Jan 12, 2023

Features

  • Adds auto-refresh feature allowing you to run queries periodically.
  • Setup auto-refresh for sessions in Virtual views to monitor sessions in real time.
  • Added a list of settings to the Object Migration dialog.
  • Diagnostic Refresh log adds more details related to obtaining stored object sources. This helps investigate problems when some object sources are not retrieved by the introspector properly.

Fixes

  • The Custom color chooser for databases now works...
阅读更多

Released: Jul 21, 2022

2022.2.x 中的更新

2022.2.5

Updated Sep 29, 2022

Fixes

  • Fixed the DataGrip freezing issue that occurred due to INSERT AS SELECT queries.
  • Database renaming now works correctly.
  • [PostgreSQL]: Fixed the bug with incorrect max values for BIGINT identity columns.
  • [Microsoft SQL Server]: INCLUDE columns are now recognized correctly.
  • [PostgreSQL]: Fixed the issue with extra grant/revoke permissions.
  • [Snowflake and BigQuery]: QUALIFY clause is now supported.
  • [BigQuery]: Database introspection now works correctly...
阅读更多

Released: Apr 7, 2022

2022.1.x 中的更新

2022.1.5

Updated Jun 7, 2022

Features

  • [Snowflake] Added the ability to skip table stage property introspection if it’s taking too long to get the properties.
  • TiDB is now detected, and DataGrip only uses statements that are supported by the database.
  • [Exasol] Added support for 'IMPERSONATE' command.

Fixes

  • [ClickHouse] Fixed type deduction for map literals.
  • [PostgreSQL and Azure] Fixed the introspection problem that was occurring when several databases were selected in one data source.
  • [Oracle...
阅读更多