Softpedia >Mac >Developer Tools >DataGrip >  Changelog

DataGrip Changelog

What's new in DataGrip 2024.1 Build 241.14494.251

Apr 6, 2024
  • AI Assistant:
  • AI Assistant now allows you to improve the quality of generated SQL queries by adding a database schema for context to the AI chat. You can now generate queries from natural language requests and get insights about your schemas.
  • Working with data:
  • Local filtering in the data editor allows you to filter rows by the values in the columns.
  • A single record view is now available.
  • We’ve introduced the ability to move columns in CSV files.
  • Working with UUIDs is now easier.
  • Simplification of sessions:
  • Users will no longer need to manually choose which session to run queries in, and this is now the case for all types of queries. Sessions are still there under the hood, but you won’t need to worry about them.
  • Working with code:
  • Column completion for GROUP BY clauses.
  • Warning for WHERE TRUE clauses.
  • Custom symbols to accept suggestions.
  • Sticky lines in the editor.
  • Aligned code style for multi-row INSERTS.

New in DataGrip 2023.3 Build 233.11799.235 (Dec 6, 2023)

  • DynamoDB support
  • Data visualization:
  • Integration with the Lets-Plot library for streamlined, no-code data visualization.
  • New import functionality:
  • You can now import to multiple targets and make simultaneous edits, such as by changing the formats, encoding for several files, or altering schemas for multiple targets.
  • Working with data:
  • Customizable number formats in the data editor.
  • The ability to render numbers as UNIX timestamps.
  • [SQL Server] Support for import/export tables via BCP.
  • Introspection:
  • Introspection intervals for each data source.
  • Automatic introspection level for Oracle.
  • Support for new objects in SQL Server: partition functions, partition schemes, partitions and related table and index properties, ledger tables, and filegroups.
  • Support for materialized views in Redshift, which are now introspected and displayed in a dedicated node.
  • Running queries:
  • [Oracle] Support for ref cursors in the query console.
  • Code generation:
  • Enable/disable database objects.

New in DataGrip 2023.3 Build 233.10527.14 EAP 2 (Oct 20, 2023)

  • Introspection scheduler:
  • It's now possible to set an introspection interval for each data source.
  • [Redshift] Support for materialized views:
  • Materialized views in Redshift are now introspected and displayed in a dedicated node in the Database Explorer.
  • Customizable number formats in the data editor:
  • There is now much greater flexibility in how you can see numbers in the data editor. Most significantly, you can specify decimal and grouping separators. Other options include the ability to define how infinity and NaN will be rendered.
  • [SQL Server] Support for new objects:
  • New objects are supported in SQL Server:
  • Partition functions and partition schemes: DBE-11948
  • Partitions and related table/index properties: DBE-4460

New in DataGrip 2023.3 Build 233.9102.70 EAP (Oct 8, 2023)

  • [Oracle]: Introspection level defaults:
  • DataGrip takes a long time to introspect schemas in Oracle because Oracle catalogs are very slow. To address this problem, introspection levels were introduced.
  • By default, the highest level was selected, which meant that selected schemas immediately began to be introspected at the third level, which was slow. Also, some users were unaware that the introspection level setting existed at all.
  • In 2023.3, DataGrip prioritizes the user experience and performance over the fullness of functionality. The default value for the introspection level now is Auto Select. Our new approach is to set the default introspection level for each schema based on the schema type and number of objects.
  • [SQLite] Warning if using WSL path:
  • Unfortunately, it is impossible to work with the SQLite database located under a WSL path. The reason is that WSL doesn't respect the SQLite file locking mechanism. For now, the only available solution for DataGrip is to show a warning in that particular case.

New in DataGrip 2023.2 Build 232.8660.111 (Jul 21, 2023)

  • User Interface:
  • New UI: The toolbar icons have been moved to the header
  • Improved main toolbar customization
  • Light theme with light header in the new UI
  • Colored project headers in the new UI
  • New UI for schema migration dialog
  • Artificial Intelligence – Limited access:
  • AI Assistant
  • AI Actions… submenu
  • Connectivity:
  • [Redis] Support for Redis Cluster
  • [Redshift] Support for external databases and datashares
  • More options for connecting with SSL certificates
  • HTTP proxy
  • Time stamp of the last refresh
  • Data editor:
  • Time zones
  • Preview in settings
  • Show all columns action to help you find any columns that you may have hidden before
  • Navigation:
  • Text search in Search Everywhere
  • Coding assistance:
  • New settings for qualifying objects
  • Syntax highlighting in inspection descriptions
  • Files tool window:
  • Sort by modification time
  • Open folders with a single click
  • Hiding Scratches and Consoles
  • Other:
  • WSL support for dump tools
  • Modify UI: List of objects of the same kind

New in DataGrip 2023.2 Build 232.8660.5 EAP 2 (Jul 7, 2023)

  • Support for Redis Cluster.
  • New UI for schema migration dialog.
  • Lots of new statements are supported: mostly in Redshift, MariaDB, and Oracle.
  • DBE-17327: [PostgreSQL] Full-Text search works with the CITEXT column.

New in DataGrip 2023.2 Build 232.7295.8 EAP 1 (Jun 7, 2023)

  • New UI:
  • The new UI is now enabled by default for this EAP cycle. Exclusively in DataGrip, all the toolbar icons have been moved to the header.
  • To configure which buttons you want to see in the header, click the … icon.
  • If you don't like the way that looks and would rather use the toolbar stripes, turn this setting off from the Find Action (Ctrl/Cmd+Shift+A).
  • Connectivity:
  • SSL:
  • There are now more options for connecting with SSL certificates. Now you can explicitly set which trust store DataGrip will use for SSL CA files.
  • Another improvement has to do with JKS KeyStore files. Now you can pass *.jks files instead of a CA Certificate and a Client Key.
  • HTTP proxy:
  • HTTP proxy settings are now also used in the remote development process. This means that if the driver also uses the HTTP proxy, you can set it in the settings and the connection will work.
  • Coding assistance:
  • We've added many new settings for qualifying objects. Now you can separately detect not only the objects to qualify identifiers with, but also where the qualification should happen.
  • The whole block of settings has been moved to the Code Completion section.
  • WSL support for dump tools:
  • The integration with MySQL and PostgreSQL import/export tools now supports using WSL paths.
  • The path to the file is specified in the Windows format, but when creating a process, DataGrip will automatically replace it with the Linux format.
  • Modify Object:
  • In the Modify Table dialog, putting the caret on the family node will open the table view, which helps you inspect similar objects.
  • Data editor:
  • Time zones:
  • With the new setting, you can now set the time zone in which the datetime value should be displayed.
  • Show all columns:
  • A new Show all columns action is now available from the header context menu. It helps you find any columns that you may have hidden before.
  • Preview in settings:
  • Now, when you change any settings in Settings/Preferences | Appearance & Behavior | Data Editor and Viewer, a preview is available.
  • [Redshift] Support for External Database/Datashare:
  • The shared databases and their contents are now introspected. The datashares that these databases are created on are also introspected.
  • Also:
  • Shared databases and datashares can be modified with Ctrl/Cmd + F6.
  • Last but not least, all the related statements are supported in the SQL editor.
  • Fixes and improvements:
  • DBE-13734 [MySQL] SELECT INTO is supported inside stored procedures.
  • DBE-17005 [MySQL] The JSON_TABLE function is supported.
  • DBE-15065 [Oracle] Code completion works for synonyms.
  • DBE-9175 [Oracle] The XMLELEMENT function is supported.
  • DBE-16823 [ClickHouse] IPv6 values are displayed correctly.
  • DBE-7474 [H2] There are no more false positives for the unresolved variable inspection.

New in DataGrip 2023.1.2 Build 231.9011.35 (May 18, 2023)

  • DBE-16982 A memory leak that occurred when exporting data to a file has been fixed.
  • DBE-17820 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.
  • DBE-18003 The source text is now generated correctly in the Create view dialog.
  • DBE-17929 Node disabling for SQL resolution scopes now works correctly.
  • DBE-17898 [PostgreSQL] PostgreSQL 16 detection has been fixed.
  • DBE-17796 [SQLite] Partial index generation has been fixed.
  • DBE-17783 [Azure] The default browser now opens as expected when connecting.
  • DBE-15989 [Redshift] External schemas are now clearly distinguished on the Schemas tab in data source properties.
  • DBE-17813 [MySQL] Explain plan submenus are displayed correctly for MySQL Aurora.
  • DBE-17846 [MySQL] Duplicated collations have been removed from DDL types.
  • DBE-16995 [Snowflake] The LIKE ALL operator is now supported.
  • DBE-17916 [Snowflake] New aggregate functions are now supported.
  • DBE-17261 [Snowflake] The functions MIN_BY and MAX_BY are now supported.
  • DBE-17833 [Snowflake] We’ve added support for string literals as a body for Snowflake Scripting procedures.
  • DBE-17912 [Snowflake] Highlighting for Python user-defined functions has been fixed.

New in DataGrip 2023.1.1 Build 231.8770.3 (Apr 13, 2023)

  • DBE-17815 The delay in showing database object tooltips is back.
  • DBE-13830 External schemas are now shown correctly in the Database Explorer.
  • DBE-17380 We’ve fixed an issue with the unresponsive Сancel button in the Modify dialog.
  • DBE-16138 Autocompletion in the data editor filter field functions properly.
  • DBE-17609 The Save LOB action works correctly for in-editor results.
  • DBE-17537 SingleStoreDB is now recognized correctly.
  • DBE-17822 [PostgreSQL] We’ve fixed the permission issue that was causing synchronization to stop.
  • DBE-17650 [MySQL] Unsupported SSL protocol errors are detected properly, and quick-fix suggestions are now shown.
  • DBE-17447 [MySQL] The ALTER COLUMN syntax that changes the column default value has been fixed.
  • DBE-17733 [MySQL] Creating users from the console now triggers automatic introspection. Users are shown in the database tree.
  • DBE-17849 [Microsoft SQL Server] We’ve fixed an introspection issue that previously occurred when connecting to Microsoft SQL Server 2005/2008.
  • DBE-16918 [Microsoft SQL Server] The Add Row action is now enabled for tables with generated columns.
  • DBE-17720 [SQLite] Automatic data source creation when opening SQLite files works correctly.
  • DBE-17388 [Snowflake] Schemas with over 10,000 columns now load successfully.

New in DataGrip 2023.1 Build 231.8109.78 EAP 3 (Mar 17, 2023)

  • Introspection:
  • [Oracle]: We've implemented several improvements to speed up the introspection on Level 1. Here are a few tips to speed up your work, especially if you're working with a large number of schemas and many database objects:
  • Switch the introspection level to Level 1, where DataGrip introspects only the names and types of objects.
  • On introspection Level 1, you can click Refresh selected object to edit a specific object or view its sources.
  • Check if you have the SELECT_CATALOG_ROLE and the SELECT ANY DICTIONARY permissions, which grant you access to the Oracle internal catalog. This makes introspection much faster.
  • Code highlighting:
  • DBE-11727, DBE-11500 [BigQuery]: Alias resolution in UNNEST queries now works correctly.
  • DBE-17291, DBE-17449 [ClickHouse]: EPHEMERAL columns, INTERSECT, and EXCEPT clauses are now supported.
  • Schema Diff:
  • [Microsoft SQL Server, PostgreSQL, Db2]: You can now use the Specify next value for sequences option to control the behavior of sequences that have a start value.
  • If the Specify next value for sequences option is not enabled, DataGrip generates the DDL of the sequence, adding the start value to the START WITH start_value.
  • When the Specify next value for sequences option is enabled, DataGrip adds the next value that the sequence should have to the DDL, with a few differences for the following databases:
  • [Microsoft SQL Server]: Instead of the sequence start value, the next sequence value is specified in the RESTART WITH clause in the CREATE and ALTER statements.
  • [PostgreSQL]: Instead of the sequence start value, the next sequence value is specified in the START WITH clause in the CREATE statement. The start value is specified in the START WITH clause, and the next value is in the RESTART WITH clause in the ALTER statement.
  • [Db2]: Instead of the sequence start value, the next sequence value is specified in the START WITH clause in the CREATE statement. The next value is specified in the RESTART WITH clause in the ALTER statement (changing the start value is not allowed in Db2).
  • Query console:
  • DBE-17479 Failing queries with the Read access is allowed from inside read-action (or EDT) only notification in the Query console has been fixed with regression.
  • DBE-12787, DBE-12109 [Oracle]: The CREATE PROCEDURE and CREATE FUNCTION now end with ";" – as expected.
  • [MongoDB]: Loss of values in IN (...) if there are more than 10 has been fixed.
  • Code completion:
  • DBE-13506 [MongoDB]: The bug with broken SQL completion for nested properties has been fixed.
  • Code completion:
  • We fixed the image preview in the data grid.
  • DBE-13329 [MongoDB]: We added the Change Default action to configure the default page size.

New in DataGrip 2023.1 Build 231.7864.19 EAP 2 (Mar 3, 2023)

  • Fixes:
  • DBE-7087: Usages search no longer looks in the installation bundled resources.
  • DBE-7466: [PostgreSQL] Fixed the issue with connecting via pg_bouncer.
  • DBE-16576: [PostgreSQL] It's possible to update a value in a view with the ENUM column.
  • DBE-17490: [PostgreSQL] The SQL generator quotes correctly in the EXCLUDE constraint.
  • DBE-17330: [MySQL] The DDL of a table is refreshed after changing a comment in the Modify dialog.
  • DBE-12758: [Oracle] Type attributes are now supported.
  • DBE-11949: [Oracle] Table types declared in the notation named in the package are now supported.
  • DBE-16452: [Oracle] Shortcut navigation works for packages.
  • DBE-14722: [Oracle] JSON columns are supported.
  • DBE-14303: [BigQuery] The precision for milliseconds in the TIMESTAMP values is no longer lost.
  • DBE-17434: The correct font color is used in the data editor header.
  • DBE-17292: The Quick Doc window doesn't freeze when counting rows.
  • DBE-17362: The schema switcher works properly in the new UI.
  • DBE-17375: .ids files can now be opened.
  • DBE-17166: Renamed folders in the database explorer no longer disappear.
  • DBE-16238: Errors no longer appear while saving a diagram.
  • DBE-17229: The Schema diff viewer now works properly - previously it opened empty if there were database or server objects included.
  • Support request: Image preview works correctly in the value editor.

New in DataGrip 2023.1 Build 231.6890.13 EAP 1 (Feb 10, 2023)

  • Working with code:
  • DBE-4469: We fixed the problem where SQL Formatter didn’t apply the right style for a subquery in the EXISTS clause.
  • Now it works as expected, and DataGrip can also add a space between the EXISTS keyword and the left parenthesis. For this part, we also added a new setting. Now, if you want to preserve the old Formatter behavior (without the space), you can change the Space after keyword setting to No in Preferences | Editor | Code Style | SQL (go to the Queries tab).
  • DBE-14440 [H2]: We fixed the bug with saving style settings. If you have configured a special style for SQL2016 and the Inherit general SQL style checkbox in Preferences is not enabled, then you will need to reconfigure it.
  • The other fixes in this area are more or less self-explanatory:
  • DBE-15973 [BigQuery]: The WINDOW clause is now supported.
  • DBE-9219 [Clickhouse]: Сase settings when completing exact-case names are now ignored.
  • DBE-14796 [MySQL]: Problems with LAG and LEAD functions have been fixed.
  • DBE-16311 [MySQL]: FOR UPDATE in nested queries is now supported.
  • DBE-12139 [MySQL]: The ENCRYPTION syntax is now supported.
  • DBE-13186 [Microsoft SQL Server]: Inspections no longer erroneously report extra code.
  • DBE-11946 [PostgreSQL]: An issue with Place constraints was fixed.
  • DBE-6276 [PostgreSQL]: DDL navigation to security policies now works as expected.
  • Database explorer:
  • DBE-17263: Data source content statistics is again displayed in the Quick Documentation popup.
  • DBE-10812 [PostgreSQL]: The Drop context menu command now works as expected.
  • Introspection:
  • DBE-12578 [Oracle]: Cross database triggers are now supported. You can create a trigger X in schema A to table E in schema B, and it will be shown in schema B under the host table E.
  • DBE-6986 [MySQL]: The ROW_FORMAT clause/syntax is now supported.
  • DBE-10603 [Microsoft SQL Server]: The Quick Definition now works as expected.
  • DBE-9087 [PostgreSQL]: When using the clause REFERENCING, the trigger’s DDL is generated correctly.
  • DBE-12404 [IBM Db2]: We fixed an issue with interrupting object introspection. If the user permissions did not allow retrieving a list of database users, the rest of the database objects were not loaded either. Now everything but the list of users will be loaded.
  • Connectivity:
  • DBE-16417 [Microsoft SQL Server]: Current schema detection now works for any database.
  • DBE-11012 [SQLite]: The SQLite native library is now unpacked to the system folder.
  • Object editor:
  • DBE-16393: We’ve added a source editor to the Modify view.
  • DBE-17329 [PostgreSQL]: Virtual view creation is now also available in read-only mode.
  • Data editor/viewer:
  • DBE-3572: We’ve added an Alternate row colors setting for results tables. When the checkbox is enabled, rows will have alternating colors.
  • DBE-16250: There are no more empty spaces in in-editor results, as the table now adjusts its height to match the height of the results.
  • Query console:
  • DBE-14074: Named parameters are detected correctly.
  • DBE-10555: Whenever you copy and paste something, the IDE now correctly analyzes the selection (instead of the cursor position).
  • DBE-12109 [Oracle]: Semicolons are no longer omitted in Oracle Aggregate Functions.
  • DBE-16871 [BigQuery]: The Unexpected value error no longer pops up when previewing a table.
  • SQL Resolve:
  • DBE-16831: A setting to specify the default resolve mode used in the console has been added to Preferences | Database | Query execution | Other.
  • DBE-5497 [Oracle]: We fixed a few problems with Oracle collection methods:
  • – Public synonyms are now correctly placed in the PUBLIC schema.
  • – Recursive references to nested routines are resolved correctly.
  • – Cursor parameter references qualified by a cursor name are resolved correctly.
  • – Incorrect usages of %TYPE are reported as warnings.
  • DBE-12772 [Oracle]: We fixed the resolution of standard attributes for collection types (for example, COUNT).
  • Explain plan:
  • DBE-17137: We fixed a bug where the IDE would show the Explain Plan diagram only for the first of several queries.
  • Navigation and search:
  • DBE-12015 [Oracle]: Go to Declaration (Ctrl/Cmd+B or Ctrl/Cmd+click) now navigates you to the routine implementation.

New in DataGrip 2022.3.3 Build 223.8617.3 (Jan 12, 2023)

  • DBE-11963: Auto-refresh is now available with adjustable intervals. It can be disabled manually or automatically (for example, if you start editing).
  • You can set up auto-refresh for sessions in Virtual views to monitor sessions in real time, which finally resolves this really old ticket, DBE-229! 
  • DBE-17059: A list of settings was added to the Object Migration dialog.
  • DBE-16936: The Custom color chooser for databases now works correctly.
  • DBE-17068: Execute to file now works correctly.
  • DBE-16902: [Redis] We fixed the problem with connecting when SSL is enabled. Important: Please update the Redis JDBC driver to v1.3.
  • [Oracle] We added more details related to obtaining stored object sources to the Diagnostic Refresh log. This will help us investigate problems when some object sources are not retrieved by the introspector properly.

New in DataGrip 2022.3.2 Build 223.8214.62 (Dec 22, 2022)

  • DBE-16825: The default name for created objects is selected so that it’s easy to replace it.
  • DBE-16899: Virtual views are correctly refreshed.
  • DBE-16824: Virtual views can be found via the Search dialog.
  • DBE-15968: [PostgreSQL] Database names with slashes are supported.
  • DBE-16862: [SQL Server] The correct parameter syntax is generated for stored procedures via the Generate menu.
  • DBE-16887: [Redshift] We fixed the problem with introspection for the latest database version 1.0.44126.
  • DBE-16829: [Firebird] Keep-alive query works.

New in DataGrip 2022.3.1 Build 223.8214.6 (Dec 9, 2022)

  • Improvements:
  • You can view and edit External Objects Files for virtual objects, such as foreign keys, views, and columns. 
  • Virtual views now can be added to schemas, data sources, and databases.
  • Virtual views with session lists are available for most dialects: Sybase ASE, ClickHouse, IBM Db2, Exasol, H2, HSQLDB, Microsoft SQL Server, Azure SQL Database, MySQL, MariaDB, Oracle, PostgreSQL, Amazon Redshift, Greenplum, Snowflake, and Vertica.
  • It is now possible to drop virtual objects.
  • The Current file submenu is enabled in the run configurations switcher.
  • Database and table settings can be synchronized via the Settings Sync plugin.
  • DBE-16456: We’ve added an SSH tunneling check, meaning you’ll be notified if your SSH configuration is incorrect.
  • Bug fixes:
  • DBE-16166: Right-clicking on a table column header no longer erroneously takes you to the selected cell.
  • DBE-16838 [BigQuery]: Struct columns are now displayed correctly.
  • DBE-16887 [Amazon Redshift:] The introspection of external tables now works correctly with the latest version of Redshift (v1.0.44126).

New in DataGrip 2022.3 Build 223.7255.83 EAP 2 (Nov 4, 2022)

  • Redis support
  • Connectivity:
  • Redis Single Instance (Redis Cluster is not yet supported)
  • Introspection:
  • Introspection of databases and keys
  • Ability to set a default key filter for the introspector
  • Database Explorer:
  • Separate folders for keys of different types for Redis v6.0+
  • One folder with all keys for older versions
  • Query Execution:
  • JDBC driver allows query execution in most cases
  • Coding assistance:
  • Code highlighting
  • Keyword completion
  • Resolve of databases and keys
  • Object Editor:
  • Renaming and deleting keys
  • Data Viewer:
  • Filtering
  • JSON highlighting

New in DataGrip 2022.3 Build 223.6646.21 EAP (Oct 13, 2022)

  • Database explorer:
  • Quick filter
  • Pattern-based schema filtering
  • Colors for global data sources
  • Drag and drop for script files
  • Data editor:
  • Formats for datetime fields
  • New extractor: WHERE clause
  • SQL filtering by multiple values
  • Text search field: populate with selection
  • [Big Query] Struct values are displayed correctly
  • Working with code:
  • Intention action preview
  • Single line copy-paste
  • Working with tables:
  • Multiple edit in the Modify window
  • [MySQL, PostgreSQL] Table size in quick documentation
  • Other:
  • New UI available via settings
  • Navigation in diagrams
  • [MongoDB] Authentication options
  • Important fixes:
  • DBE-16117: Edit as Table works correctly for CSv with values starting from a single quote.
  • DBE-15784: The data editor tabs no longer steal focus.
  • DBE-13987: The All related rows option has been returned to navigation.
  • IDEA-264269: Search Everywhere results don't jump when more options are found.
  • DBE-6156: [Oracle] SET ROW is now supported.
  • DBE-12766: [SQL Server] $PARTITION is now supported.
  • DBE-16203: [Big Query] Introspection works if the port is not specified in the URL.

New in DataGrip 2022.2.5 Build 222.4345.5 (Sep 29, 2022)

  • DBE-16324: Fixed the DataGrip freezing issue that occurred due to INSERT AS SELECT queries.
  • DBE-12680: Database renaming now works correctly.
  • DBE-16462 [PostgreSQL]: Fixed the bug with incorrect max values for BIGINT identity columns.
  • DBE-15560 [Microsoft SQL Server]: INCLUDE columns are now recognized correctly.
  • DBE-16377 [PostgreSQL]: Fixed the issue with extra grant/revoke permissions.
  • DBE-15604 [Snowflake, BigQuery]: QUALIFY clause is now supported.
  • DBE-16203 [BigQuery]: Database introspection now works correctly.
  • DBE-16376 [Amazon Aurora SQL]: Many users have encountered issues when using the MariaDB 3.X driver due to a known MariaDB Connector bug. If you are still facing this problem, downgrade the driver version manually by selecting MariaDB Connector J / 2.X in the Driver Files. You may also need to restart the IDE.

New in DataGrip 2022.2.4 Build 222.4167.25 (Sep 12, 2022)

  • This update fixes the issue preventing tables from being rendered when the Transpose view is enabled.

New in DataGrip 2022.2.3 Build 222.4167.22 (Sep 9, 2022)

  • DBE-6418 We’ve added the Smallest subquery or statement option in Preferences | Query Execution | When inside statement execute. It will run the nested subquery under the cursor or the entire statement if there is no subquery.
  • DBE-16264 Ignore modification of the identifier case in schema diff now works as expected.
  • DBE-16138 The autocompletion popup in the Data Editor filter field is now enabled right after restart.
  • DBE-16277 Modify object no longer generates extra grant/revoke statements.
  • Escape in the in-editor result set now moves the focus to the editor as expected.
  • DBE-15913 [Redshift] Routines are now introspected correctly.
  • [SQL Server] We’ve fixed the issue with high CPU usage and improved performance.

New in DataGrip 2022.2.2 Build 222.3739.67 (Aug 24, 2022)

  • This bug-fix update is focused on enhancing the new Modify Object UI.

New in DataGrip 2022.2.1 Build 222.3345.126 (Jul 29, 2022)

  • DBE-15994: Clicking Compare Data opens the table content diff tab as expected.

New in DataGrip 2022.1.5 Build 221.5787.39 (Jun 11, 2022)

  • Bug-fixes:
  • DBE-14378: TiDB is now detected, and DataGrip only uses statements that are supported by the database.
  • DBE-15553: [Exasol] The IMPERSONATE command is now supported.
  • DBE-15322: [ClickHouse] Fixed type deduction for map literals.
  • [Snowflake] Added the ability to skip the table stage property introspection if it’s taking too long to get the properties.
  • [PostgreSQL, Azure] Fixed the introspection problem that was occurring when several databases were selected in one data source (also fixed DBE-15360).
  • [Oracle]: Fixed Numeric Overflow in Oracle v.18 and later.

New in DataGrip 2022.2 Build 222.2889.12 EAP (Jun 3, 2022)

  • Option to import multiple CSV files:
  • You can now select several CSV files and import them at once!
  • New Modify UI:
  • The new Modify UI, a basic version of which was introduced in the 2022.1 release, has become the default option. Starting with version 2022.2, all of a table’s child objects can be added and edited using this new UI.
  • The old UI will remain available through this release cycle via the context menu.
  • Categories in keymap:
  • Previously, all of the actions related to database functionality were stored in four different places in the keymap:
  • Database | Database Explorer
  • Database | Query Result
  • Plugins | DataGrip customization
  • Plugins | Databases Tools and SQL
  • This structure, which admittedly has very little logic, was a historical consequence of the IDE’s development.
  • To help you see all the available actions, we’ve re-arranged the structure and placed all of the actions in groups under the Database parent group.
  • Scopes in DDL data sources:
  • You can now set file scopes as sources for DDL data sources. This will let you filter folders for the DDL data source easily. For example, you can exclude subfolders.
  • Merge All Project Windows action on macOS:
  • For macOS users, we’ve introduced the ability to merge all open project windows into one, turning them into tabs. This action is available from the Window menu.
  • [Oracle, Vertica] Password expiration warning:
  • Oracle and Vertica databases can provide warnings if the password is going to expire. DataGrip now retrieves this information and displays it after Test Connection is activated.
  • [SQL Server] Support for collations and charsets:
  • Collations and charsets are now generated with the table’s DDL.
  • Basic DB support:
  • We’ve added 3 new databases to the basic support list: DuckDB, Mimer SQL, Apache Ignite.
  • Quality improvements:
  • Data editor:
  • DBE-10971: The table order is now saved in the data editor.
  • DBE-7888: February is back in the date picker!
  • DBE-15454: Binary columns with mixed content types are now editable.
  • DBE-7804: CSV import no longer fails on the last line if the last value is empty and there is no new line.
  • DBE-15335: The SQL-Insert-Multirow extractor generates the correct query.
  • Query Console:
  • DBE-996: The search bar no longer hides the toolbar.
  • DBE-11616: [ClickHouse] MODIFY ORDER BY is supported for ALTER TABLE.
  • DBE-14643: [SQL Server] The condition is always false warning no longer appears during variable assignment.
  • DBE-12232: [SQL Server] CHANGETABLE is now supported.
  • DBE-13312: [SQL Server] END CONVERSATION is now supported.
  • DBE-12435: [SQLite] The PRAGMA_TABLE_INFO and PRAGMA_TABLE_XINFO tables are resolved.
  • DBE-14997: [PostgreSQL] Columns are now correctly resolved when using CTE with INSERT INTO.

New in DataGrip 2022.1.4 Build 221.5591.57 (May 13, 2022)

  • DBE-15552: We’ve fixed a bug that was causing the names and icons of DDL data sources to be missing from the Database Explorer.

New in DataGrip 2022.1.3 Build 221.5591.46 (May 9, 2022)

  • DBE-15456: [SQL Server] Windows authentication is operational again.
  • DBE-15179: Read-only icons are again available for data sources.
  • DBE-15494: Introspection no longer fails with an Unknown column ‘generation_expression’ in ‘field list’ error.
  • DBE-15354: Dates are now saved correctly after you edit them via the text field.
  • DBE-15330: [MySQL, MariaDB] There is now a way to ignore auto_increment values in the schema diff viewer.

New in DataGrip 2022.1.2 Build 221.5591.9 (Apr 28, 2022)

  • Features:
  • [Oracle] DBE-6034: We have added support for virtual columns (aka computed columns).
  • Important fixes:
  • DBE-14943: Fixed an error with incorrect qualification of language objects.
  • DBE-15080: Fixed bug with non-closing error pane when executing a query from SQL Injection.
  • DBE-10691: Added a duplicate button next to the SSH dropdown so you can easily modify a copied datasource.
  • DBE-13562: Removing a project from Recent Projects now works correctly.
  • DBE-15228: Go to related now works with virtual foreign keys.
  • DBE-14305: Made it possible to add JDBC drivers directly from zip archives.
  • DBE-15324: Import progress bar now shows the import status correctly.
  • DBE-15396: Fixed the incorrect appearance of diagram edges.
  • DBE-15161: Copy Column Name action now works for multiple columns.
  • DBE-11706: Enabled the UP and DOWN keys in numeric fields in the datetime picker.
  • DBE-15284: Fixed the problem with tree scrolling in Modify Table.
  • DBE-15093: Fixed the problem with saving large files.
  • DBE-9974: The Data tab will no longer be displayed for non-CSV files.
  • Fixed the problem preventing the dumping of files in the SQL Generator.
  • [Microsoft SQL Server] DBE-15198: Explain Analyze works correctly.
  • [BigQuery] DBE-15005: Support for creating and dropping columns.
  • [Snowflake] DBE-15310: Fixed the bug with introspection.
  • [MySQL] DBE-15251: Fixed invalid code for security invoker.

New in DataGrip 2022.1.1 Build 221.5080.224 (Apr 14, 2022)

  • IDEA-288804: we’ve fixed the problem with the Services tool window disappearing so users could not find Services when receiving query results or when explicitly activating this window through the menu or via Alt+8/Cmd+8.
  • No action is required – just reopen the IDE.
  • After the first activation of Services, the Stripe button which opens/closes the window will no longer be hidden as before.

New in DataGrip 2022.1 Build 221.5080.155 (Apr 14, 2022)

  • Import/Export:
  • Copy multiple objects
  • Data editor:
  • Default display format for binary cells
  • [MongoDB] Ability to edit fields in results
  • [SQL Server] Support for in-editor results in batch mode
  • Introspection:
  • Session templates for introspection
  • [Oracle] Fragmental introspection
  • [H2] Support for version 2.x
  • [YugabyteDB] Added to basic support
  • Code generation:
  • New version of Modify Table
  • Quality improvements for old Modify Table
  • Database diff viewer:
  • Swap source and target
  • Code editor:
  • Convert to subquery intention
  • Auto-indentation algorithms were improved
  • [PostgreSQL] Multirange types supported
  • Running queries:
  • Canceling running statements
  • Canceling connections
  • IDE General:
  • Reworked settings
  • Evenly split tabs
  • Export UML diagram to other formats

New in DataGrip 2021.3.4 Build 213.6777.22 (Jan 20, 2022)

  • DBE-14416 [PostgreSQL, Greenplum, Redshift]: The introspector is now more stable if errors occur.
  • DBE-10913: Synonym quick info now displays information about the target object.
  • DBE-14724: The console toolbar disappears automatically after session detach for non-SQL files.
  • DBE-11591 [PostgreSQL]: DataGrip will automatically re-run queries without CTID if it causes an error in Postgres Citus.
  • DBE-14728 [Azure]: Fixed Copy Table to… when the action is invoked from the context menu or from Find Action.
  • DBE-14697: After executing the migration script, DataGrip automatically refreshes the target schema.
  • DBE-14633: The Oracle debugger now works as expected.

New in DataGrip 2021.3.3 Build 213.6461.82 (Dec 29, 2021)

  • Fixes:
  • DBE-14771: Data sources no longer disappear from the database explorer when changing DBMS in Expert options.
  • DBE-14665 [PostgreSQL]: Identity columns are now compared correctly.

New in DataGrip 2021.3.2 Build 213.6461.19 (Dec 17, 2021)

  • Improvements:
  • DBE-12590: Data source colors are now displayed in the Run Configuration UI.
  • Fixes:
  • Advanced Settings work as expected again.
  • Fixed a bug with the Add to Bookmarks action.
  • [BigQuery] Support for TRUNCATE statements is available again.
  • [Db2] DBE-14582: Keep-alive queries work as expected.
  • [PostgreSQL] DBE-14517: Support for options in CREATE AGGREGATE is available again.
  • [Azure Synapse] DBE-14004: Support for USE statements is available again.

New in DataGrip 2021.2.3 Build 212.5457.16 (Oct 1, 2021)

  • Improvements:
  • DBE-14044: Test Connection shows a warning if the keep-alive query has one or more errors.
  • DBE-10341: We’ve added the Choose schema action as the default intention action for the Unresolved reference inspection.
  • Fixes:
  • DBE-4212: [PostgreSQL] The problem with processing plv8 scripts has been fixed.
  • DBE-13878: [PostgreSQL] The Column is invalid in the select list warning is no longer falsely triggered.
  • DBE-5229: [MySQL] The Ambiguous column reference warning in a HAVING clause is no longer falsely triggered.
  • DBE-12475: [MySQL] Aliases in INSERT statements are supported.
  • DBE-12430: [SQLite] UPDATE FROM is supported.
  • DBE-12404: [Db2] We’ve fixed the bug that prevented introspection while data was being retrieved for users.

New in DataGrip 2021.2.2 Build 212.5284.17 (Sep 2, 2021)

  • Improvements:
  • DBE-2216: Wildcards are now considered as column usages.
  • DBE-13773: Ctrl/Cmd+Click from the navigation bar correctly navigates to the desired element.
  • DBE-8885: [SQL Server] Line numbers are included in error messages.
  • DBE-13732: [ClickHouse] There is now a special node for distributed tables in the database explorer.
  • Fixes:
  • DBE-12656: Enable DBMS_OUTPUT works immediately after being turned on.
  • DBE-13862: The Update and Delete fields are no longer hidden in the Modify Table dialog.
  • DBE-13278: The inspection that reports unsafe queries has become smarter.
  • DBE-13945: Ctrl/Cmd+N works as before in the data editor.
  • DBE-13907: [PostgreSQL] It’s possible to modify sequences in version 10 and lower.
  • DBE-13566: [Snowflake] We’ve fixed a problem preventing the import of large CSV files.

New in DataGrip 2021.1.2 Build 211.7442.38 (Jun 1, 2021)

  • Features:
  • DBE-13048: Some run configurations require the data source to be disconnected first. Now it’s possible to disconnect from a data source before launch.
  • DBE-12906: We’ve introduced a Modify grants action.
  • Introspection:
  • DBE-6276: [PostgreSQL] Support for security policies.
  • DBE-13138 [Redshift] Support for sort keys for tables and views.
  • DBE-13024: [Redshift] Fixed the bug with the completely failed introspection.
  • DBE-12442: [Oracle] Source code is retrieved correctly for Oracle 9i.
  • DBE-13146: [Oracle] Type attributes are retrieved correctly for Oracle 11.
  • DBE-12954: [BigQuery] No more missing schemas.
  • DBE-12166: [BigQuery] Creating a temporary function doesn’t re-run the introspection.
  • Navigation and search:
  • DBE-12901: It’s possible to navigate to the data source from the Database tab of the search.
  • DBE-11738: The Context data source scope works again in search.
  • DBE-12968: Color settings are respected again in search.
  • DBE-13090: View DDL from data works again.
  • DBE-5341: Go to related symbol has been added to the context menu of the object in the code editor.
  • DBE-4960: [PostgreSQL] Go to related symbol works for navigating from triggers to the related procedure, and vice versa.
  • DBE-13033: Navigation by foreign keys supports references to one column.
  • DBE-13037: Scroll from editor works from the data editor.
  • DBE-12967: [SQlite] Full-Text Search uses LIKE to search within LONGVARCHAR fields.
  • Data viewer:
  • DBE-5435, DBE-11780, DBE-12827, DBE-11591: Fixed some bugs with missing ctid columns.
  • DBE-13150: The data diff viewer works again.
  • DBE-13126: Text search works when invoked a second time.
  • DBE-12985: [MySQL]: The default value for the date field is now correct.
  • DBE-12940: The Toggle Soft-Wrap and Toggle Formatting buttons don’t disappear anymore.
  • DBE-12594: Formatted mode for XML no longer removes all spaces.
  • Code generation:
  • DBE-8654: Run routine generated code contains qualified objects.
  • DBE-12934: Argument direction is taken into account when modifying the routine.
  • DBE-12873 [BigQuery] Int64 is the default type when creating a new column.
  • DBE-12892 [BigQuery] Dropping views now works.
  • Code highlighting:
  • DBE-9813: [Clickhouse] Support for CREATE DICTIONARY.
  • DBE-12996: [Clickhouse] Support for EXISTS (database | dictionary | view) statements.
  • DBE-12993: [Clickhouse] Correct syntax highlighting for CREATE OR REPLACE.
  • DBE-12994: [BigQuery] Support for EXPORT DATA, TABLESAMPLE SYSTEM, CREATE SCHEMA, ALTER SCHEMA, and DROP SCHEMA.

New in DataGrip 2021.1.1 Build 211.7142.37 (Apr 29, 2021)

  • Important fixes:
  • DBE-5341 [Oracle] It’s possible to navigate from a synonym to the table.
  • DBE-12985 [MySQL] The default date for the datetime cells is correct.
  • DBE-12994 [BigQuery] CREATE/ALTER/DROP SCHEMA, TABLESAMPLE and EXPORT DATA are supported.
  • DBE-11591, DBE-12827, DBE-11780 [PostgreSQL, Redshift, Greenplum] Fixed the introspection problem that affected tables with no CTID column.
  • DBE-11892 [Redshift] Batch mode is on for CSV import.

New in DataGrip 2020.3.2 Build 203.7148.68 (Jan 31, 2021)

  • Important fixes:
  • DBE-12398: The problem with freezes on Test Connection is fixed.
  • DBE-12367: Athena introspection works again.
  • DBE-12168: The Submit changes immediately option is back.
  • DBE-10828: The JDBC URL is not pasted in the data source name by default.

New in DataGrip 2020.3.1 Build 203.6682.134 (Dec 24, 2020)

  • Apple Silicon support:
  • Starting from this version we provide builds for Apple Silicon M1 processors. They can be found on the download page for macOS.
  • New features:
  • Forgotten comma
  • Inline CTE:
  • We’ve come up with a counterpart for the existing action ‘Extract CTE from the subquery’ – ‘Inline CTE’. Use it to create a subquery instead of using common table expressions.
  • MongoDB SSL modes:
  • With version 1.9 of the MongoDB JDBC driver and DataGrip 2020.3.1, all SSL modes are now available.
  • Important fixes:
  • DBE-9945: [PostgreSQL, Greenplum] WITH block is included in the DDL.
  • DBE-2489: [SQL Server] Allow unqualified calls of stored procedures from sys schema.
  • DBE-3893: [SQLite] JSON1 functions are supported.
  • DBE-12193: [SQLite] Virtual columns are highlighted properly.
  • DBE-10007: [Oracle] Simplified table functions are supported.
  • DBE-12051: [Oracle] The “Refresh could not take such arguments” warning isn’t falsely triggered anymore.

New in DataGrip 2020.3.0 (Dec 24, 2020)

  • SQL for MongoDB:
  • SELECT, FROM, JOIN, WHERE, HAVING, GROUP BY clauses
  • Functions and object builders are supported
  • JS query preview
  • Copy JS query to clipboard
  • Connectivity:
  • Couchbase support
  • Azure AD authentication
  • Working directory
  • Data editor:
  • Separate editor for cell values: Formatted value
  • Separate editor for cell values: Bottom position
  • Separate editor for cell values: Images
  • Opening transposed tables
  • Shrinking selection
  • Import/Export:
  • Introducing two new extractors: One-row and SQL-Insert-Multirow
  • Never quote values option
  • Introspection:
  • Collect introspection diagnostic information
  • Grants
  • Changes in the database tree
  • [PostgreSQL] More properties for tables
  • [Greenplum] New objects
  • [Oracle] Correct display of overloaded procedures
  • Coding assistance:
  • Formatter for Generic dialect
  • Rename options
  • Fixing typos
  • [Oracle] Inspection for a conflict call
  • Running queries:
  • Run configurations: Schema switching
  • Run configurations: Displaying the default schema
  • Run configurations: History targets
  • [SQL Server] Tab names
  • Console output in a separate tab
  • Hints for indexes in ‘Explain plan’
  • DDL editing:
  • Warning for outdated table structure
  • Warning if the object was deleted
  • Migration actions are available everywhere
  • IDE general:
  • The Welcome screen is back
  • Per-Project plugins
  • Syncing current theme with OS settings
  • macOS shortcuts as words
  • Preview tab
  • Simple calculator
  • File associations
  • Expand all in the database tree view

New in DataGrip 2020.2.3 Build 202.7319.56 (Sep 18, 2020)

  • Important fixes:
  • DBE-11340: The username and password fields no longer disappear.
  • DBE-11156: When updating the source code, if a new version contains errors and fails to be submitted, you’ll now see a prompt to restore the previous version.
  • DBE-11440: [SQL Server] Submit changes to database works again for procedures.

New in DataGrip 2020.2.2 Build 202.6948.53 (Aug 20, 2020)

  • DBE-11268: The annoying bug causing the parameters pop-up to appear instead of the context menu has been fixed.
  • DBE-10951: No more freezes when editing CSV files.
  • DBE-10749: Code completion inside OVER clauses works again.
  • DBE-11243: Filters are respected when migrating databases.
  • DBE-10590: No more high memory consumption during export to Excel.

New in DataGrip 2020.1.5 Build 201.8538.4 (Jun 26, 2020)

  • Most important:
  • The issue with SQL Server Authentication on Windows is fixed.
  • Other fixes:
  • DBE-9876: Forced execution in read-only mode now runs the correct query.
  • DBE-10727: Schemas comparator respects column order.
  • DBE-10715: [PostgreSQL]: DataGrip no longer throws a time zone error for versions of PostgreSQL before 10.
  • DBE-10724: [Snowflake]: The Modify Table dialog generates valid code.
  • New features:
  • A new quick-fix is available: Refresh schema. If your colleague adds a new object after you have already refreshed your database, this fix will make sure your query is properly highlighted.
  • We have also renamed the migration buttons in the schema comparator to make it clearer what they actually do.
  • If you create a DDL data source, the folder with the sources will automatically be attached to the project.
  • If you try to change the DDL of the target table during the data import process, DataGrip will double-check this with you with an alert box to confirm that you want to perform this action.
  • If an Oracle database wants you to change an expired password, you can do so from the DataGrip UI. This works for versions from Oracle 12.2 if you use the standard JDBC driver. If you use the OCI driver, it works for the older versions as well.

New in DataGrip 2020.1.4 Build 201.7846.70 (May 31, 2020)

  • DBE-10715: [PostgreSQL] Fixed a time zone error affecting PostgreSQL versions prior to 10.
  • DBE-7578: DataGrip no longer refreshes the database after running a query in read-only mode.
  • DBE-9417: Targets in the Run Configuration dialog are now filtered by dialect.

New in DataGrip 2020.1.3 Build 201.7223.85 (Apr 30, 2020)

  • Features:
  • DBE-1845: The data editor tab appears automatically for CSV files.
  • DBE-9993: Pasting to the data editor automatically creates new rows.
  • DBE-8019: The data editor allows for scrolling beyond the last row.
  • DBE-10484: The file name is pre-selected in the dump data dialog.
  • DBE-8121: The dedicated node for trigger functions has been added to the database tree view.
  • DBE-10483: [MongoDB]: Collection references specified as string literals are now resolved correctly.
  • DBE-10410: [Redshift] Support for the syntax of materialized views has been added.
  • Bug-fixes:
  • DBE-10408: No more UI freezes when editing large SQL strings.
  • DBE-9272: Save LOB works for the results of complex queries.

New in DataGrip 2020.1.2 Build 201.6668.164 (Apr 23, 2020)

  • Hello! This update fixes the problem that caused extremely high CPU usage.

New in DataGrip 2020.1.1 Build 201.6668.158 (Apr 21, 2020)

  • Important bug fixes:
  • DBE-10421: Using Cmd/Alt+1 to open the Database tree view also passes focus to it.
  • DBE-9957: Always Select Opened Element in the Services tool window can be disabled.
  • DBE-10383: Parts of cells from in-editor results can be copied.

New in DataGrip 2020.1 Build 201.6668.99 (Apr 17, 2020)

  • Run configurations:
  • Configuration for running script files
  • Configuration for running code
  • Support for utPLSQL and tSQLt
  • Data editor:
  • Results in the editor
  • Geo viewer
  • [MongoDB] Data filtering
  • Export options:
  • Export to Excel
  • Better usability
  • Text data viewer
  • Connectivity:
  • [PostgreSQL] pg_pass support
  • [SQL Server] Domain credentials support
  • Shared SSH configuration
  • Query console:
  • Update preview
  • Easy navigation to Execute settings
  • Datetime injection
  • [MongoDB] Better coding assistance
  • Navigation and search:
  • Context data sources scope
  • Structural Search
  • Working with files:
  • CSV file type
  • Attach directory
  • Mark as plain text
  • Database tree view:
  • UI for creating users and roles
  • UI for creating schemas and databases

New in DataGrip 2019.3.3 Build 193.6494.42 (Feb 13, 2020)

  • Important bug-fixes:
  • The right schema is used when adding a foreign key constraint to a table. DBE-9743
  • Auto sync is working after a DROP followed by a CREATE statement. DBE-9980
  • No more freezes in JOIN completion. DBE-9844
  • [Oracle] The OracleSqlPlus dialect is back. DBE-10030
  • [ClickHouse] Deleting rows works as expected.
  • [BigQuery] Identifiers are quoted using back quotes.
  • [BigQuery] LIMIT and OFFSET are generated when opening a table’s data.

New in DataGrip 2019.3.2 Build 193.6015.44 (Jan 22, 2020)

  • Virtual foreign keys:
  • We’ve introduced the concept of virtual foreign keys. You can use this concept in the event that you need to use a relationship that exists but is not located in your database.!
  • Doing so will help you:
  • Have the proper completion when writing JOIN clauses.
  • See the relations in diagrams.
  • Stored procedure runner for MySQL:
  • Finally, after adding the option to execute stored procedures in PostgreSQL, MS SQL and Oracle, we’ve now made it possible to do so in MySQL.
  • Important bug-fixes:
  • DBE-9829 Aliases are no longer used when completing table names in DDL.
  • DBE-9800 Only trigger functions are offered in the corresponding completion list.
  • DBE-9803 The wildcard is now resolved inside row constructors.

New in DataGrip 2019.3.1 Build 193.5662.58 (Dec 20, 2019)

  • Hello! This is the first bugfix update for DataGrip 2019.3. Here’s what it has inside:
  • DBE-9708: A new option lets you choose whether you want to use schema qualifications when using JOIN.
  • DBE-9736: The table filter is cleared when opening a table from the database explorer.
  • DBE-9743: The correct schema is used when adding a foreign key.
  • DBE-9728: Fixed the bug with queries seeping into column names.
  • DBE-9714: Right-clicking on a column header shows the menu again.
  • DBE-8196: A new registry option to remove the schema qualification when updating data.

New in DataGrip 2019.3 Build 193.5233.139 (Dec 4, 2019)

  • MongoDB support:
  • The day has finally come for us to start adding MongoDB support. Since the request received more than 400 votes, we decided that the time was ripe to begin including basic functionality for it.
  • Here’s a quick overview of the MongoDB features that work in this version:
  • Introspection: You can observe collections and fields in the database explorer.
  • Data viewer: Open any collection or observe the query result and you have the option to sort it by column or filter the values. Paging works, as well.
  • Tree view: It’s also possible to explore a tree view of the data. To turn it on, click the Gear icon | View as… | Tree.
  • Query console: To run a statement, put the caret on it and run the console by pressing Ctrl/Cmd+Enter, or use the Play button on the toolbar.
  • Oracle PL/SQL debugger:
  • In this first version of the long-awaited PL/SQL debugger, you can debug procedures, functions, triggers, and anonymous blocks, and observe variables.
  • Working with the source code:
  • Diff viewer for routines
  • 3-way merge
  • Code prettifier in PostgreSQL
  • Intentions now work inside the source codes
  • Running queries:
  • Inline query progress
  • Flame chart for explain plan
  • Coding assistance:
  • New inspections
  • New intention actions
  • An option to sort lines alphabetically
  • An option to search only in a selected area
  • Resolve respects filtering
  • New items in the Generate menu
  • Data editor:
  • There are no longer problems with ambiguous names in the result-set.
  • The Modify Table action is now available from the data editor context.

New in DataGrip 2019.2.6 Build 192.7142.42 (Nov 1, 2019)

  • Result tabs switch with the consoles again.
  • No more freezes on MacOS Catalina when exporting data. DBE-9334
  • Fixed the bugs with the external tables in Redshift not showing. DBE-9181
  • Various bugs with paging are fixed. DBE-9217
  • Column names are no longer collapsed when the data editor is transposed. DBE-8904
  • The “column specified more than once” error does not appear for data import anymore. DBE-9283
  • The table and column comments are not truncated anymore. DBE-8000
  • There are no longer false warnings about the number of values when selecting the identity column. DBE-8924

New in DataGrip 2019.3 Build 193.4099.20 EAP (Oct 4, 2019)

  • Basic MongoDB support
  • 3-way source code merge

New in DataGrip 2019.2.5 Build 192.6817.21 (Sep 27, 2019)

  • Improvements in H2 grammar support.
  • DBE-7893 [PostgreSQL] Procedure is back to the Generate menu.
  • DBE-9098 Fixed the bug with importing data from CSV files that include an IDENTITY column.
  • DBE-9105 Numbers at the beginning of table names are supported again.
  • DBE-9093 The Replace IN intention doesn’t corrupt code anymore.

New in DataGrip 2019.2.4 Build 192.6603.38 (Sep 12, 2019)

  • DBE-8977 Compare content action has been added to the context menu of two tables.
  • We’ve fixed some problems with the Help plugin’s compatibility.
  • DBE-9021 UUIDs are now quoted when navigating to referenced rows.
  • DBE-8897 Full-text search results are now sorted alphabetically.
  • DBE-1878 DataGrip offers to introspect the schema if it’s used in the console.

New in DataGrip 2019.2.2 Build 192.6262.49 (Aug 19, 2019)

  • Features:
  • DBE-4499 We’ve added JOIN completion based on column names.
  • DBE-2640 The markdown data extractor is bundled with DataGrip!
  • DBE-7315 Drag-and-drop of columns became smarter: now it adds commas!
  • DBE-8239 Breadcrumbs are now shown for SQL as well.
  • DBE-5661, DBE-7960 [PostgreSQL] Support for partition tables is improved. The key enhancement: partition tables are now displayed under the main one.
  • Bug fixes:
  • IDE general:
  • DBE-8380, DBE-8769, DBE-8778, DBE-7107 Performance improvements.
  • DBE-8633 The folder path became editable in SQL Dialects settings section.
  • Code generation:
  • DBE-8835, DBE-8376 Schema comparison: the same objects are not marked as different anymore.
  • DBE-8826 [Oracle] No more disappearing semicolon in the package code.
  • DBE-6261 [Oracle] Column names are not missed from view’s code anymore.
  • DBE-8344 [DB2] Editing procedures is available on DB2 for i (AS/400).
  • DBE-8889 [Sqlite] Check constraints do not disappear after the update.
  • Data editor:
  • DBE-5165, DBE-8732 Fixed bugs in file import.
  • DBE-8857 Fixed problem with the column width when using the Material Theme plugin.
  • DBE-8788 BLOB fields are displayed correctly.
  • DBE-8433 The Forward and Back buttons don’t run queries anymore.
  • DBE-6601 The Ctrl/Cmd+F12 shortcut in the filter field of the data editor opens the columns list.
  • DBE-8511 The Go To Related Data action enabled showing only required rows.
  • Database explorer:
  • DBE-8728 Adding a new schema doesn’t remove items from the database explorer.
  • DBE-8871 [Redshift] External tables are back!
  • Coding assistance:
  • DBE-8845, DBE-8767, DBE-6776 Fixed bugs in the SQL formatter.
  • DBE-8850 [Exasol] DROP INDEX support.
  • Navigation:
  • DBE-8895 Results in Find Usages are sorted by the line number.

New in DataGrip 2019.2.1 Build 192.5728.128 (Aug 1, 2019)

  • No more high memory usage, which led to total freezes.
  • This was actually connected with the new feature whereby system catalogs were stored inside DataGrip for better coding assistance. Now, if you have more than 10 databases inside one data source, automatic loading of system objects is switched off and a corresponding warning is displayed.
  • If you still need to have system objects in coding assistance without seeing them in the database explorer, select the lightning icon next to the schema name in the schema chooser.

New in DataGrip 2019.2 Build 192.5728.116 (Jul 31, 2019)

  • Services tool window:
  • Observe and manage all the connections
  • Manage Docker services
  • Query live timer
  • Full-text search:
  • Search for data everywhere
  • SQL preview
  • Search in columns that don’t support the LIKE operator
  • [PostgreSQL, MySQL, MariaDB] Search only in columns that are indexed
  • [Oracle] The following indices are used, if they exist: context, ctxrule, ctxcat
  • [SQL Server] Search is aware of full-text indexes
  • [Cassandra] Make several queries for one table
  • Data editor:
  • The page size is easy to change
  • The results tabs can be named
  • [Cassandra] Edit columns of type: set, list, map, tuple, udt, inet, uuid, and timeuuid
  • Database tree view:
  • Quick table backup
  • Quick group creation
  • Force Refresh action
  • Table comments are displayed
  • Indicator for live connections
  • Filtering in search and navigation:
  • GoTo popup: filter by data source or a group of them
  • Find in path: filter by data source or a group of them
  • Coding assistance:
  • Completion and resolution use objects from system catalogs
  • Quick-fixes are integrated into the inspection tooltip
  • New inspections, Unnecessary usage of CASE and Possible truncation of the string
  • An intention action to Convert GROUP BY to DISTINCT
  • Two new combined items, IS NULL and IS NOT NULL, are now included in code completion
  • An Introduce alias action was added to the Refactoring menu
  • Code editor:
  • New option to control the behavior of Move Caret to Next Word
  • Select current statement action
  • Folding of big numbers
  • The option Jump outside closing bracket/quote with Tab is enabled by default
  • Surround a selection with a quote or brace is enabled by default

New in DataGrip 2019.1.4 Build 191.8026.4 (Jul 3, 2019)

  • We hope that, finally, all the performance problems on startup are fixed! JBR-1393
  • The Filter History is preserved in the data editor after a restart DBE-8318
  • Boolean values can be edited when creating a new row DBE-7701
  • [Oracle] DataGrip doesn’t hang when working with big packages DBE-8499
  • [Apache Ignite] Data editor now works DBE-8453

New in DataGrip 2019.1.3 Build 191.7479.12 (May 22, 2019)

  • First, there are no more freezes after sleep!
  • Also, we’ve fixed the annoying indentation in SQL Server that was happening after starting a new line.
  • Other fixes:
  • IDEA-176926 The All Places scope now includes scratch files and consoles. This is more important for anyone using the database plugin in other IDEs, and not DataGrip itself. In DataGrip scratches and consoles were already part of the All Places scope.
  • DBE-7993 The Formatter keeps the line break before INTO.
  • DBE-8223 The Formatter doesn’t break the code by quoting local variables.
  • DBE-8248 The Sublime keymap is bundled.
  • DBE-8133 Export into INSERT statements works again for Cassandra.

New in DataGrip 2019.1.2 Build 191.7141.30 (May 1, 2019)

  • Formatter:
  • First and foremost, now the code style can be configured separately for different dialect
  • Please note, you can paste examples of your code to the preview panel on the right-hand side to check that the style you have configured formats the SQL correctly. More dialects come later.
  • Code insight:
  • DBE-1837: Columns from outer queries are now highlighted.
  • DBE-3778: Better support for aggregate functions. DataGrip will warn if you use them in the wrong place.
  • DBE-5368: Unnecessary keywords for ORDER BY are highlighted
  • Using the HAVING clause with no aggregates will also generate a warning
  • Snowflake:
  • We’re continuing to improve the Snowflake native introspection. Warehouses and stored procedures are now supported!
  • Important fixes:
  • DBE-8217 [Cassandra] Support for lightweight transactions
  • DBE-8037 [MySQL] Support for JSON_TABLE()
  • DBE-8180 No more freezes when pasting big chunks of text

New in DataGrip 2018.3.4 Build 183.6156.3 (Mar 13, 2019)

  • SQL formatter: we’re still improving it:
  • DBE-7362: Formatter works in SQL-injections.
  • DBE-7376: Better WITH formatting.
  • DBE-6937: Better arrays formatting in PostgreSQL.
  • DBE-4805: We keep the case of quoted identifiers in PostgreSQL.
  • DBE-7881: Support for ON CONFLICT clause in PostgreSQL.
  • DBE-7890: No more line break after PERFORM in PostgreSQL.
  • DBE-7605: INTO TEMP TABLE support in PostgreSQL.
  • DBE-7806: Better formatting for variables in SQL Server.
  • Other:
  • During data import errors are written into a file by default.
  • DBE-7838: Fixed bug with missed reference when creating a foreign key.
  • DBE-7840: Autoscroll from the editor works correctly.
  • DBE-7896: No more raw HTML in notifications.

New in DataGrip 2018.3.3 Build 183.5912.12 (Feb 20, 2019)

  • Here’s a list of important bug-fixes in 2018.3.3:
  • DBE-7745: No more false positives in Unreachable Code inspections in case of FOREACH statements.
  • DBE-4399: Fixed the problem with resolving objects in files.
  • DBE-7699: UTF-16 is always used in the data editor.
  • DBE-5850: No more -1 day changes to dates.
  • DBE-1465: Fixed a regression issue with synchronizing read-only data sources.
  • DBE-7795: Fixed problems with rename cancellation.
  • DBE-7694: The correct script is generated for changing table comments.
  • DBE-7712: All MySQL functions are correctly highlighted in the editor.

New in DataGrip 2018.3.2 Build 183.5429.24 (Feb 7, 2019)

  • Enum values can now be completed in the data editor. This works in both PostgreSQL and ClickHouse.
  • Other important fixes we’ve made:
  • DBE-7561: DataGrip doesn’t change the default value of a column in MySQL.
  • DBE-7572: CREATE OR REPLACE is supported for MariaDB events.
  • DBE-7604: Hidden schemas are not used in comparison now.
  • DBE-7417: Report mismatch between expected/actual column count in the SQL Server OUTPUT clause is fixed.
  • DBE-7457, DBE-7458: DataGrip doesn’t report columns as unused in some false positive cases.

New in DataGrip 2018.3.1 Build 183.4886.38 (Jan 10, 2019)

  • DataGrip had a usability problem where, every time you opened the source code, it showed you a version loaded during the indexing process. In fact, if someone had changed the source code from another place, DataGrip was unaware of it and thus displayed an outdated version of the DDL.
  • The thing is that DataGrip maintains a consistent database model at every moment to provide navigation and usage search. This means the IDE cannot update just one single DDL in the local storage as that would break the whole flow.
  • Now, if a source code object has been changed, you can get an alert. Go to the data source properties and turn on Notify when the outdated object is opened.
  • Then, when you open the source code, you’ll see a notification saying it’s been changed from elsewhere.
  • Another very important thing: we’ve finally fixed the problem with NULL instead of empty date in MySQL. Well, in fact, MySQL fixed it :) Now, if you work with new 8.0 JDBC driver, everything is OK.
  • Important! This new driver isn’t compatible with MySQL 5.1 and older. This means that the date problem will persist for those who use these old versions and will not be fixed until the database is updated.
  • Also:
  • Comma position can now be detected automatically.
  • We’ve fixed the issue with connecting to PostgreSQL: DBE-7447
  • The highlighting for ‘column aliases required‘ inspection works better: DBE-7314
  • The color in the database tree is exactly the same as set: DBE-6558
  • Select in works in Search Everywhere: IDEA-197872
  • Replace in pre-selected text works again: IDEA-200011
  • We’ve fixed the bug with connecting to Redshift: DBE-7459

New in DataGrip 2018.3 (Jan 10, 2019)

  • Database objects:
  • Cassandra database supported
  • Generate SQL files for the selected objects
  • Support for extensions in PostgreSQL
  • Support for stored procedures in PostgreSQL 11
  • Statistics in Quick Doc
  • Use drop cascade syntax option
  • Code completion:
  • Postfix completion:
  • New setting to automatically add aliases when completing table names
  • Not aggregated fields in GROUP BY
  • All columns list in SELECT, MERGE and INSERT INTO table variable
  • Named parameters of stored procedures
  • Numeric fields in SUM() and AVG()
  • FILTER (WHERE…) clause
  • Option to Invert order of operands in auto-generated ON clause
  • Window functions
  • Code generation:
  • Dialects for Live templates
  • Column names hint appears automatically when using INS live template
  • CREATE TABLE definition for SELECT
  • Refactoring:
  • Intention action to Introduce table alias
  • Many fixes in Extract subquery as CTE action
  • Code insight:
  • Warnings about unsafe DELETE and UPDATE
  • New inspection to detect unreachable code
  • Unused subquery item inspection
  • Connectivity:
  • Single connection mode
  • Auto-reconnect after timeouts
  • Search and navigation:
  • New Search Everywhere
  • Multiline TODO comments
  • Multiline search in Find/Replace in Path
  • User interface:
  • High-contrast color scheme
  • Better UI for page size setting
  • Color settings in the data source Properties dialog

New in DataGrip 2018.2.3 Build 182.4505.4 (Sep 5, 2018)

  • Some people complained that the new SQL log was not really very friendly: the output panel would become hard to read due to the number of internal queries. So, we removed the internal queries from this panel: now you will see only the queries which were run explicitly by the user, including those, which were run from the UI.
  • If you still need to inspect literally all the queries that DataGrip has run, check the SQL log file: Help → Show SQL log.
  • Other fixes:
  • DBE-6889: DataGrip executes procedures fine with old MySQL jdbc connectors.
  • DBE-6982: No more deadlock in read-only mode.
  • DBE-6810: We fixed the highlighting in DB2.
  • DBE-5459: Internal files are not shown in the Go to File list.
  • DBE-6939: No more lags in code formatter settings preview.
  • DBE-6823: Custom code style can be used as default.

New in DataGrip 2018.2.2 Build 182.4129.19 (Aug 16, 2018)

  • One of the highlights in this update is added support for ClickHouse (an open-source analytic DBMS for big data from Yandex). The update offers a dedicated driver, and allows you to browse the tables, views, table data, run queries, and pretty much everything (except exporting data and modifying tables).
  • Last but not least, the update also fixes a few performance issues related to VCS (file scanning).
  • Also, the update addresses the following issues:
  • The default row height in the Modify Table dialog is equal to the biggest row in the dialog (DBE-6443)
  • The Oracle Not-Equals operator “~=” causes a parse error (DBE-6817)
  • The SQL Server’s Filtered Index is not handled by the Modify Table action
  • Display schema names in the editor tabs if the Multiple Schemes checkbox is enabled (DBE-6693)
  • The Go to File action included non-project files (DBE-5459)
  • The formatter for Sql Server obscured spaces before and after the dot between the schema and table names (DBE-6874)
  • The new line concatenation not supported for PostgreSQL (DBE-6853)
  • Multiple JOINs with USING for MySQL sometimes were not resolved correctly in the editor (DBE-6844)

New in DataGrip 2018.2.1 Build 182.3911.26 (Aug 3, 2018)

  • New experimental Search Everywhere:
  • IntelliJ Platform 2018.3 will introduce some changes that you can already start playing with, namely a new Search Everywhere dialog. It is the result of merging Search Everywhere, Go to table/procedure/class, Go to file, Go to symbol, and Find action.
  • SearchEverywhere:
  • To turn it on, open the Maintenance dialog (Ctrl+Alt+Shift+/ on Windows and Linux or Cmd+Alt+Shift+/ on macOS), select Experimental features, and enable the new.search.everywhere check-box. Please keep in mind that this feature is still under heavy development.
  • Bug fixes:
  • DBE-6751: Default precision for common data types are now generated when executing a procedure.
  • DBE-6818: Working with Postgres 11 is possible now.
  • DBE-6753: Drag and drop works to move data source to a group.
  • DBE-6796: Data source group name can be used when navigation to an object.
  • DBE-6797: Slashes work as a path separator when renaming a data source.

New in DataGrip 2018.2 Build 182.3684.106 (Jul 26, 2018)

  • SQL LOG:
  • First, now you’ll see every query that DataGrip runs in the console output. Whether it’s your SQL or something DataGrip needs to run internally, check the Output tab to understand what’s going on.
  • Second, literally all queries from the IDE are now logged in a text file.
  • NEW SQL FORMATTER:
  • Thanks for sharing your ideas about SQL styles with us! We hope that now DataGrip will be able to accommodate many more different code styles.
  • The new SQL formatter is a feature we strongly need feedback on, so please try it out and if your specific cases are not covered, do let us know. We are still working on new clauses to add.
  • As you may already know, you can create custom Code Style schemes. Now any of them can be used specifically for each data source. To do this, go to the Options tab of the data source properties.
  • RUNNING STORED PROCEDURES:
  • This long-awaited feature has been implemented for Oracle and PostgreSQL! Support for SQL Server procedures is only available in DataGrip for now, but will soon appear in the 2018.2.1 updates of other JetBrains IDEs.
  • SOURCE CODE MIGRATIONS:
  • Now, to update the source code of any other objects, just double-click them and make the needed changes. The gutter (the vertical bar to the left of the text editor) will highlight the changes you’ve made. Note also the new Submit button on the toolbar.
  • QUERY PLAN DIAGRAM:
  • A diagram-based view is now available for the query plan. To view it, click the Show Visualization button on the toolbar after you invoke Explain Plan. As a reminder, it’s also available in the context menu for queries in the SQL console.
  • SQL EDITING:
  • Context info:
  • When editing a huge procedure in a package, it is sometimes useful to refresh your memory on its context, i.e. what particular procedure or package is now being edited.
  • Jump outside closing bracket/quote with Tab:
  • Starting with this version, you can navigate outside the closing brackets, or closing quotes, by pressing Tab. Note this works only when inputting parameters or values for the first time.
  • DATA EDITOR:
  • Number of selected rows:
  • Now DataGrip shows the number of rows selected in the data editor. Look for this in the status bar.
  • UI UPGRADES:
  • Touch Bar support:
  • We’ve added support for the MacBook Touch Bar. It only has an Execute button by default.
  • Assign a shortcut from Find Action:
  • Previously, it was impossible to assign a shortcut from the Find Action if using the Default keymap. We’ve fixed this bug and now it works in any keymap and any layout. A good reason to remind you that it’s possible!
  • Custom data source:
  • Now you can add custom data sources based on jdbc-driver. Click the + button on the toolbar and select the appropriate item from the drop-down.
  • Run SQL on a schema:
  • Before, the only way to run the script was by executing it from the context menu of the corresponding SQL file. Now you can use a more intuitive way: choose the datasource or the database you need and select Run SQL script from the context menu.
  • Dialect and console choosers:
  • Now you can choose the dialect of the SQL file and attach any console to it just from the toolbar.
  • Dark window headers:
  • Now you can make the Darcula theme even darker. If you are on a macOS, to darken the title bars, just go to Preferences → Appearance & Behavior → Appearance and select Use dark window headers.
  • IMPORTANT BUG FIXES:
  • DBE-6681: MySQL comments are being formatted properly.
  • DBE-5204: DDL for a table opens in a right place.
  • DBE-1858: Deleting the criteria from the Filter field shows all rows in the data editor.
  • DBE-6436: Backspace doesn’t break quick search in Structure View.
  • DBE-6362: Views with no schema binding in Redshift are shown in the database tree.
  • DBE-6469: Record count in data editor works if sorting applied.
  • IDEA-189650: IDE opens empty files after restart.

New in DataGrip 2018.2 Build 182.3684.15 EAP 3 (Jul 12, 2018)

  • New:
  • Running stored procedures
  • Code style per data source

New in DataGrip 2018.2 Build 182.3569.14 EAP 2 (Jul 6, 2018)

  • New:
  • Show context info action for SQL.
  • Number of selected rows in the data editor.
  • To learn more, read the blog post at:
  • https://blog.jetbrains.com/datagrip/2018/07/05/datagrip-2018-2-eap-2/

New in DataGrip 2018.2 Build 182.3341.22 EAP (Jun 22, 2018)

  • New:
  • New SQL formatter
  • SQL Log
  • Source code migrations
  • Query plan diagram
  • Run SQL on a schema
  • To learn more, read the blog post at:
  • https://blog.jetbrains.com/datagrip/2018/06/21/datagrip-2018-2-eap-is-open/

New in DataGrip 2018.1.5 Build 181.5281.40 (Jun 21, 2018)

  • Bug fixes:
  • DBE-6502: YAML plugin is included in DataGrip.
  • DBE-6537: Now you can drag-and-drop database elements to Favorites.
  • DBE-6551: Data source colors work fine after project re-opening.
  • DBE-6544: POJO-generator works for views as well.
  • IDEA-191807: Now you can paste file into Scratches folder.

New in DataGrip 2018.1.4 Build 181.5087.33 (May 24, 2018)

  • Fixes just one but an important bug: DBE-6451. User parameters work well again.

New in DataGrip 2018.1.3 Build 181.5087.19 (May 19, 2018)

  • Oracle:
  • DBE-3195 — Auto-completion for object types
  • DBE-5340 — Compiling PL/SQL code works OK
  • Support for:
  • DBE-2581 — Conditional compilation flags
  • DBE-6027 — SET statements with multiple clauses
  • DBE-6196 — INSERT ALL
  • DBE-6378 — JSON keyword
  • PostgreSQL:
  • DBE-6301 — The bug with creating foreign keys between tables is fixed
  • DBE-6391 — Fields are resolved in LOOP cycle
  • Redshift:
  • DBE-6336 — MAXFILESIZE support for UNLOAD
  • Sql Server:
  • DBE-6325, DBE-6370 — Columns for OUTPUT are resolved
  • DBE-6354 — Support for ORDER BY in subqueries
  • H2:
  • DBE-6367 — CTE support
  • DBE-6368 — DROP CASCADE support

New in DataGrip 2018.1.2 Build 181.4892.10 (Apr 29, 2018)

  • Enhancements:
  • Access methods support in PostgreSQL.
  • Run SQL script menu option for schema's context menu
  • In the Power Save mode> DataGrip shows icons.

New in DataGrip 2018.1.1 Build 181.4668.2 (Apr 13, 2018)

  • Crucial fix: the scrolling in 2018.1 became laggy. No more!
  • Other improvements:
  • A new action is introduced: Context menu of the object → Database tools → Modify Comment.
  • DBE-5479: Explain Plan works in Redshift.
  • DBE-5987: Now it’s possible to use N as null text in data import.
  • IDEA-186636: The keystrokes aren’t lost during freezing anymore.
  • IDEA-188229: Clicking the Replace all option from the Replace in path dialog doesn’t cause the IDE to freeze.

New in DataGrip 2018.1 Build 181.4203.585 (Apr 3, 2018)

  • Data editor:
  • SQL log
  • IDE general enhancements:
  • Rename everything
  • Schema switch mode
  • Enhancements in Navigation
  • Target is remembered when running scripts
  • Quick documentation for Files
  • Database view:
  • MariaDB support
  • External schemas in Redshift
  • Virtual schemas in Exasol
  • Events in MySQL
  • Partitioned tables in PostgreSQL 10
  • Datasource color affects associated files
  • SQL editing:
  • Navigate to the next/previous occurrence
  • Move element left or right
  • Completion for file references
  • CTEs in MySQL
  • Folded code highlighting
  • To learn more, read the blog post at:
  • https://blog.jetbrains.com/datagrip/2018/04/03/datagrip-2018-1/

New in DataGrip 2018.1 Build 181.4203.581 RC (Mar 30, 2018)

  • Bug fixes:
  • DBE-6115: Scroll from editor works if horizontal split is used.
  • DBE-3548: The sequence start number is correct in PostgreSQL.
  • DBE-6104: Drop multiple columns works in H2.
  • DBE-5081: The REST client plugin is now available.
  • DBE-3260: Default values are added in the SSH configuration for data sources.
  • For more details, read the blog post at:
  • https://blog.jetbrains.com/datagrip/2018/03/29/datagrip-2018-1-release-candidate/

New in DataGrip 2018.1 Build 181.4203.511 EAP 3 (Mar 23, 2018)

  • Enhancements:
  • Ability to rename any object
  • Enhancements in navigation
  • Read-only mode in MySQL works better
  • Support for partitioned tables in PostgreSQL
  • For more details, read the blog post at:
  • https://blog.jetbrains.com/datagrip/2018/03/22/datagrip-2018-1-eap-3/

New in DataGrip 2018.1 Build 181.4203.7 EAP 2 (Mar 15, 2018)

  • Enhancements:
  • Now when you run a file against a data source, your choice is remembered for further runs
  • Data source color affects console files in the Files pane
  • Bug fixes:
  • DBE-5960: Window functions are supported for MySQL
  • DBE-5969: No more error when inserting a row with all default values
  • DBE-5999: The ability to sort items in structure pane is added
  • DBE-2102: Several fixes are delivered connected with default constraints in SQL Server. Now it’s possible to alter and delete them
  • DBE-5968: Sybase shows correct length for nchar, nvarchar, unichar and univarchar types
  • DBE-4962: Cascade rules for foreign keys are now correctly displayed for SQL Server
  • DBE-6028: Code folding works with CTEs
  • For more details, read the blog post at:
  • https://blog.jetbrains.com/datagrip/2018/03/14/datagrip-2018-1-eap-2/

New in DataGrip 2017.3.7 Build 173.4674.7 (Mar 1, 2018)

  • Important bug fixes:
  • DBE-5904: The names of folders with console files don’t contain GUIDs anymore.
  • Fixed additional issues with scrolling diagrams.
  • Built-in SSH executable now supports strong cryptographic algorithms.
  • More Information in the blog post available at:
  • https://blog.jetbrains.com/datagrip/2017/07/27/datagrip-2017-2-released/

New in DataGrip 2017.3.6 Build 173.4652.3 (Feb 23, 2018)

  • DBE-5932: Deleting tables generates DROP CONSTRAINTS if needed.
  • DBE-5745: DataGrip now correctly qualifies objects while deleting them in SQL Server and Sybase.
  • New types added to the introspection: point, line, lseg, box, path, polygon, circle.
  • Scrolling in diagrams works again, thanks to Lewislg who reported it in our forum!

New in DataGrip 2018.1 Build 181.3870.22 EAP (Feb 22, 2018)

  • Enhancements:
  • Data editor SQL log
  • Options for switching schemas: Automatic, Manual, Disabled
  • MariaDB support
  • Navigate to the next or previous identifier occurrence action
  • Move element left or right action
  • Completion for file references now works for Oracle and Exasol
  • Support for:
  • External schemas in Redshift
  • Virtual schemas in Exasol
  • Events in MySQL
  • CTE in MySQL
  • For more details, read the blog post at:
  • https://blog.jetbrains.com/datagrip/2018/02/21/we-open-eap-for-datagrip-2018-1/

New in DataGrip 2017.3.5 Build 173.4652.2 (Feb 15, 2018)

  • New:
  • Object filter in the database tree view.
  • Important bug fixes:
  • Code completion respects number input DBE-4965
  • Paste from CSV format is now correctly detected
  • New types of fields are available for editing in PostgreSQL: point, polygon, line, lseg, box, path, circle, pg_lsn, tsquery, tsvector

New in DataGrip 2017.3.5 Build 173.4652.2 (Feb 15, 2018)

  • There is even a new feature in the release: object filter. Define which objects you want to see in the database tree.
  • The most important bug-fixes are:
  • Code completion respects number input: DBE-4965
  • Paste from CSV format is now correctly detected
  • New types of fields are available for editing in PostgreSQL: point, polygon, line, lseg, box, path, circle, pg_lsn, tsquery, tsvector

New in DataGrip 2017.3.4 Build 173.4301.31 (Jan 18, 2018)

  • Many issues have been fixed, the most important of which are:
  • Collations are now placed after schemas in the database tree. If you want to hide them, put collation:-.* into Data source properties → Options tab → Object filter.
  • DBE-5703: А correct DDL statement is now generated when a PostgreSQL function with defaults is dropped.
  • DBE-5608: Amazon Redshift data source synchronization works now.
  • DBE-5404: The editor now recognizes the WITH NO SCHEMA BINDING syntax in Redshift.
  • DBE-2465: FETCH ALL IN doesn’t return errors anymore.
  • DBE-5274: FOR EACH ROW WHEN in triggers shows the correct clause.
  • DBE-4983: SQL generator doesn’t add the ‘n’ character in new lines in Oracle anymore.
  • Fixed freezes:
  • DBE-2536: While introspecting schemas with many tables.
  • DBE-5532: After updating a function.

New in DataGrip 2017.3.3 Build 173.4127.18 (Dec 20, 2017)

  • This update brings an important fix of “Out of memory” problem.

New in DataGrip 2017.3.2 Build 173.3942.44 (Dec 16, 2017)

  • Bug fixes:
  • DBE-5031 – Enum fields are now available for editing. Completion is not yet implemented.
  • DBE-5512 – Fixed bug with saving LOBs.
  • DBE-4426 – DataGrip now can connect to FrontBase. There are still some known issues with transactions.

New in DataGrip 2017.3.1 Build 173.3942.40 (Dec 15, 2017)

  • New features:
  • IDE-level read-only mode
  • Go to class and Go to table are merged
  • Alignment options for Background images

New in DataGrip 2017.3 Build 173.3727.157 (Dec 6, 2017)

  • NEW FEATURES AND IMPROVEMENTS:
  • Database tree view:
  • Ability to group data sources
  • More convenient managing schemas
  • Users and roles are now displayed in PostgreSQL and AWS Redshift
  • Foreign data wrappers are now displayed in PostgreSQL
  • Drag-and-drop multiple objects to the editor
  • SQL coding:
  • SQL generator
  • Better JOIN statement completion
  • PostgreSQL 10 grammar support
  • Executing queries:
  • Ability to choose a schema when running an SQL file
  • The list of data sources/consoles is available when attaching the console to a file
  • Three independent Execute actions
  • Foreign data wrappers are now displayed in PostgreSQL
  • Set Current Schema action
  • Connectivity:
  • OpenSSH config files are supported (~/.ssh/config и /etc/ssh/ssh_config)
  • Dialog added for One Time Password
  • Ability to use SSH-agent and Pageant for authentication
  • Exasol support
  • Data editor:
  • Paste data in a DSV format (i.e. from Excel)
  • Numerical data are now right-aligned by default
  • Tabs are restored after re-opening DataGrip
  • Cells can be compared
  • Navigation:
  • Navigate references to DDL editor options
  • Jump to Console in the context menu of the data source
  • Replace the selected occurrences in the Replace In Path dialog
  • Scratches and Consoles are now placed in Files

New in DataGrip 2017.3 Build 173.3727.95 RC (Nov 24, 2017)

  • All the new features described in the previous EAP releases are available in the stable build. License required!

New in DataGrip 2017.3 Build 173.3727.37 EAP 4 (Nov 17, 2017)

  • Fixes:
  • IDE doesn't freeze while building database diagram.
  • Fixes in SSH support: DBE-5434, DBE-5409, IDEA-181525.

New in DataGrip 2017.2.3 Build 172.4574.13 (Nov 15, 2017)

  • Fixes:
  • IDE doesn't freeze while building database diagram.

New in DataGrip 2017.3 Build 173.3531.20 EAP 3 (Nov 3, 2017)

  • New:
  • SQL Generator
  • Paste multiple rows to the data editor from an external source
  • Enhancements in SSH tunneling
  • For more details, read the blog post at:
  • http://blog.jetbrains.com/datagrip/2017/11/02/datagrip-2017-3-eap-3/

New in DataGrip 2017.3 Build 173.3302.20 EAP 2 (Oct 21, 2017)

  • New:
  • Ability to group data sources
  • Navigate references to DDL editor option
  • Users and roles in Database View
  • Foreign Data Wrappers in Database View
  • Ability to compare cell values
  • PostgreSQL 10 grammar support
  • Automatic detection of Regexp, JSON, XML and XPath to many functions and operators in various databases
  • Synchronization of your settings across devices
  • Important fixes:
  • Better PIVOT support.
  • Expand column list deals well with table aliases

New in DataGrip 2017.3 Build 173.2696.33 EAP 1 (Oct 21, 2017)

  • New:
  • Ability to choose console by the datasource when attaching console to the file
  • Ability to jump to any console associated with the data source
  • Several Execute actions
  • Right-side alignment for numerical data
  • Schemas… node is moved to the context menu and opens by Alt+Enter
  • Ability to choose schema when running a file against the data source
  • Set Current Schema action
  • Smarter JOIN completion
  • Exasol support
  • Important fixes:
  • Generate DDL on tables node doesn’t include views anymore
  • DDL generation for tables is better
  • All attributes (expect obj_file and ink_symbol) are generated in function DDL for PostgreSQL
  • DDL generation in MySQL works with escaped quotation marks. But the fix can raise performance problems.

New in DataGrip 2017.2.2 Build 172.4155.28 (Sep 7, 2017)

  • Highlights:
  • Export options are enabled again, but some issues persist, so we don’t close this issue.
  • Custom dialect data sources are visible in the Run against list.
  • Many people complained about UI freezing, we investigated this and fixed bugs raising the problem.
  • Editing data in DB2 is back.
  • Stored procedures code is generated correctly in SQL Server.
  • Bug fixes:
  • DBE-1158 — Option "Hide file extension in editor tabs" has no effects
  • DBE-3520 — Database -> Table -> Contents is a mess
  • DBE-4340 — Can't Connect SQL File to Console
  • DBE-4362 — scroll from editor doesn't work properly
  • DBE-4483 — Can not associate Data Source with sql file based on file and Data Source SQL dialects
  • DBE-4876 — IntelliJ freezes when syncing with database
  • DBE-4886 — Autoscroll from Editor does not work for DDL opened in console
  • DBE-4968 — Color settings IN CONSOLE EDITORS AND GRIDS does not work for grids
  • DBE-4979 — Run sql file in console reads the file contents later
  • DBE-4996 — Can not execute begin ... end block if there are multiply such blocks
  • DBE-5005 — Version 2017.2 Does not let you update records in the datagrid using DB2 dialect
  • DBE-5015 — DataGrip generate faulty code for procedure
  • DBE-5020 — Impossible to specify path with space to pg_dump executable
  • DBE-5038 — Context menu to add a file to favorites has disappeared in 2017.2.1
  • DBE-5085 — Sudden IDEA freeze
  • DBE-5097 — when importing CSV file DG messes up the data making the table completely unreliable

New in DataGrip 2017.2.1 Build 172.3757.39 (Aug 10, 2017)

  • In this release cycle, we are focused on improving navigation. As we wrote in our release blog-post, we divided Data and DDL tabs in the table data editor. There was a problem (well, our fault) that Edit Source wasn’t very visible on the toolbar and it was the only way to see the DDL of the table.
  • We added several enhancements:
  • To see DDL of any database object go to Context menu → DDL and sources → Source editor.
  • Use Cmd/Ctrl+Alt+B to switch between table’s Data and table’s DDL. It works in both directions. Also, there is the DDL button in the data editor toolbar and the Data Editor button in the DDL editor.
  • A new action is introduced called Select in the database view. Now there is no UI shortcut, but you can invoke it by Ctrl+Shift+A or define your own shortcut. Remember, that the same can be done in a more general way: press Alt+F1 on any object and choose Database view.
  • Sidv:
  • We continue working on that. If we still don’t cover your use case, please describe it in the comments.
  • Other fixes:
  • Dump actions now work on files with attached console.
  • DBE-4505 No wrong rounding in Oracle during import.
  • DBE-4902 More… link now works in Quick Evaluate.
  • DBE-4953 Scrolling works in the database switcher for PostgreSQL.

New in DataGrip 2017.2 Build 172.3544.109 (Jul 28, 2017)

  • NEW FEATURES:
  • Amazon Redshift and Microsoft Azure support
  • Several databases in one PostgreSQL data source
  • Transaction Control
  • Evaluate expression
  • Table DDL
  • Integration with restore tools for PostgreSQL and MySQL
  • Executing queries
  • Coding assistance
  • OTHER:
  • New features:
  • Database objects can be added to Bookmarks.
  • You can now pause file indexing when you need to free the CPU for other tasks, and then resume it when appropriate.
  • We added per-monitor DPI support for Windows. Font settings are automatically adjusted based on the display resolution.
  • Lines with two identical results are merged in Find in Path.
  • Support for non-int-literal expressions in TABLESAMPLE and ALTER FOREIGN TABLE in Postgres.
  • Support for ‘json_table’ function in Oracle.
  • Important fixes:
  • DBE-4600 with renaming schemas.
  • DBE-1288 with renaming sequences in PostgreSQL.
  • DBE-4507 in composite primary key editing.
  • DBE-4637 about a wrong error message in queries with GROUP BY.
  • Faster data editor scrolling

New in DataGrip 2017.2 Build 172.3544.95 RC 2 (Jul 22, 2017)

  • Various bug fixes.

New in DataGrip 2017.2 Build 172.3317.79 RC (Jul 18, 2017)

  • New features:
  • Integration with restore tools for PostgreSQL and MySQL.
  • Automatic scrolling from a result-set.
  • Database objects in bookmarks.

New in DataGrip 2017.2 Build 172.2953.19 EAP 3 (Jun 27, 2017)

  • New features:
  • Notification when a large query is finished.
  • Incremental introspection for Amazon Redshift.
  • Better DDL generation in Amazon Redshift

New in DataGrip 2017.1.5 Build 171.4694.58 (Jun 27, 2017)

  • Most important fixes:
  • DBE-2771 — Important fix with “column reference is ambiguous” for Postgres EDB users.
  • DBE-4753 — “Invalidate Caches/Restart” is enabled in the Find action menu.
  • DBE-4733 — Empty rows are removed from the console output tab.

New in DataGrip 2017.2 Build 172.2465.11 EAP (May 26, 2017)

  • New features:
  • Support for Amazon Redshift and Microsoft Azure
  • Support for several databases in a single PostgreSQL data source
  • New evaluate expression functionality
  • Possibility to attach query console to a file
  • Result-sets now switch along with corresponding console
  • Objects are resolved by their OID values in PostgreSQL

New in DataGrip 2017.1.2 Build 171.4249.43 (Apr 26, 2017)

  • Most important fixes:
  • DBE-4211 – Row number in the data editor is properly aligned with the row.
  • DBE-4387 – The bug with enrcypt() values for INSERT in PostgreSQL is fixed.
  • DBE-4467 – Broken code generation for not officially supported databases is fixed.
  • DBE-4444 – Cursor loop statements in procedures are now supported.
  • Milliseconds don’t disappear from the copied TIMESTAMP value anymore.

New in DataGrip 2017.1.1 Build 171.4073.34 (Apr 7, 2017)

  • Database tree: New schema management, SQL resolution scopes; Create database/schema UI; Color settings affects editor and grid.
  • Import/export data: Column mappings and DDL preview; Drag-n-drop tables; Export result-set to a database.
  • Query Console: Respecting the default search path in PostgreSQL; Trigger generation pattern; Insert string concatenation on Enter option; Settings for Qualifying objects and more.
  • Database objects: Double-cliсk opening of column details in Modify table; Warning if object has been changed in another place.
  • Miscellaneous: Query time and column/row numbers in data editor status bar; Including/excluding text occurrences in Find Usages; Windows authentication for SQL Server in jTDS driver and more.

New in DataGrip 2017.1 Build 171.3780.102 (Mar 22, 2017)

  • Database tree:
  • New schema management
  • SQL resolution scopes
  • Create database/schema UI
  • Color settings affect editor and grid
  • SQLite introspection
  • Import/export data:
  • Column mappings
  • DDL preview
  • Drag-n-drop tables
  • Export result-set to a database
  • Query console:
  • Respecting the default search path in PostgreSQL
  • Trigger generation pattern
  • NEW/OLD and INSERTED/UPDATED support
  • Hints for column names in INSERT statement
  • Insert string concatenation on Enter option
  • Settings for Qualifying objects
  • Editable Aliases casing
  • Statement separators
  • Jump to colors and fonts action
  • Database objects:
  • Double-cliсk to open column details in Modify table
  • Warning if an object has been changed in another place
  • Correct source code for views in SQLite
  • Miscellaneous:
  • Query time and selected column/row numbers in data editor status bar
  • Include/exclude text occurrences in Find Usages
  • Windows authentication for SQL Server in jTDS driver
  • Commit triggers synchronization in PostgreSQL
  • Read-only preview available for large files

New in DataGrip 2017.1 Build 171.3780.53 RC (Mar 16, 2017)

  • New features:
  • UI for creating database/schema
  • Including/excluding text occurrences in Find Usages
  • Warnings about changing the database object
  • Further details on this release are available at:
  • http://blog.jetbrains.com/datagrip/2017/03/15/datagrip-2017-1-rc-is-out/

New in DataGrip 2017.1 Build 171.3691.11 EAP (Mar 1, 2017)

  • Features:
  • SQL resolution scopes per file
  • Respecting the default search path in PostgreSQL
  • Query time in the status bar
  • Datasource color settings affect console background
  • Column names hints in INSERT statements
  • Statement line separators
  • Navigation to color settings from the editor
  • Emoji support

New in DataGrip 2017.1 Build 171.2822.18 EAP (Feb 2, 2017)

  • NEW FEATURES:
  • File import:
  • Drag-n-drop csv files to the datasource
  • Import zipped CSV files
  • Faster import
  • Other:
  • New schema management UI
  • Colored result-set
  • Aliases casing

New in DataGrip 2016.3.3 Build 163.12455.1 (Jan 26, 2017)

  • New features:
  • The Drop action in the context menu for schemas
  • Fixed bugs:
  • The random switch-off of Auto-commit
  • Long lines on Oracle routines are truncated

New in DataGrip 2017.1 Build 171.2455.7 EAP (Jan 19, 2017)

  • New features:
  • Map columns in CSV import
  • Import/export tables to other databases
  • Manage string concatenation on Enter
  • Manage qualifying objects in completion
  • Support for NEW/OLD and INSERTED/UPDATED while modifying triggers
  • Completion of named parameters
  • Better SQLite introspection
  • Zero-latency typing enabled by default
  • Known issues:
  • Drag-n-dropping tables can break the database tree

New in DataGrip 2016.3.2 Build 163.11103.2 (Dec 30, 2016)

  • Fixed bugs:
  • Data import from files
  • Excessive use of threads when 'Use provided driver' is selected
  • Invalid DB name display in the function editor

New in DataGrip 2016.3 Build 163.7744.4 (Nov 25, 2016)

  • SOURCE CODE STORAGE:
  • Now DataGrip shows triggers, views, and materialized views source code. Also, IDE lets you find usages of tables/views inside other views, stored procedures, and functions.
  • How does that work? The IDE loads the source code of major types of objects and puts them into the local storage. This opens up many new possibilities, so let’s briefly go over them.
  • To make this storage work, please re-synchronize your data source. Select Forget Schemas, and then click the Synс/Refresh button.
  • You’re ready. Most importantly, now you can find usages of objects inside the source code of other objects. For instance, you can learn in which stored procedures, functions or views your table is used. As usual, press Alt+F7 on the table name or call it from the context menu. In the Usages window you can see the preview of objects, i.e. the source code of the objects where your table is used.
  • What else? We’ve fixed many bugs related to source code. Now DataGrip shows it for triggers in all popular management systems: MySQL, PostgreSQL, SQL Server, Oracle, and Sybase. We also added the Drop action to the context menu.
  • View source code is also shown correctly in all places. In addition to Copy DDL, there is a new action in the context menu now: Open DDL in Сonsole.
  • We didn’t forget about materialized views in PostgreSQL: their source code is now available, and materialized views can be refreshed from the UI.
  • When you edit the source code of any object, DataGrip tracks your changes and highlights edited rows in the left editor panel. If you click on a highlighted row, a small toolbar is displayed with a Show Diff link. Click it to see the difference between the row you’ve changed and the one from the source code.
  • If there are lots of changes in many places, you can see all of them in the Database Changes window. Please note that this window is available only in DataGrip, not other IntelliJ-based IDE’s.
  • Any individual change can be clicked to display the diff viewer as well.
  • Remember that you can manage which sources will be loaded (or none at all) using the Options tab of data source properties, or from the context menu for several data sources at once.
  • OTHER ENHANCEMENTS CONNECTED TO DATABASE OBJECTS SUPPORT ARE:
  • Views can be renamed using Ctrl+F6 (Cmd+F6 for OSX).
  • Operator’s signature in PostgreSQL is shown in the database view.
  • Comments in creating procedures/functions DDL are now saved to the database.
  • DATA EDITOR:
  • A lot of new features of this version are related to the data editor. The first and the most important: now all your changes are stored locally and can be submitted at once. Local changes are colored, so you can see which changes you are going to save, be it updating, inserting or deleting rows.
  • Submit changes by Ctrl+Enter (Cmd+Enter for OSX). As usual, Ctrl+Z (Cmd+Z for OSX) is for canceling, but works in a tricky way — only the selected changes are canceled. If you wish to cancel all of them, select all cells by Ctrl+A (Cmd+A for OSX) before reverting.
  • Several fields can be edited at once: just select them and begin to type. Of course, it works only if the columns you are editing are not unique and have the same type.
  • We added data conversion. Copy-paste your data even if the fields have different types of data, and moreover, even if the tables are in different databases from different vendors!
  • Since multiple cells edit is also available, this will work with the whole column of data as well. Date to string, bool to integer — not a problem.
  • The familiar editor’s action called Select next occurrence by Alt+J (Ctrl+G for OSX) works here now, even if several cells are selected.
  • Another familiar Expand selection action by Ctrl+W (Alt+Up for OSX) works in the data editor like this: first, a field is selected, then the column of the active field, then the row of the active field, and finally, the whole grid.
  • CODE INSIGHT:
  • The INSERT statement completion offers you not only the list of all fields but also the list of fields which have no default value.
  • The IDE will warn you about an unused variable or parameter in the function.
  • Another inspection will let you know if there is a different number of columns in queries used in set operators (UNION, INTERSECT and EXCEPT).
  • The new intention action offers you to introspect the schema or databases right from the editor if DataGrip has no metadata on them yet.
  • Some specific features for PostgreSQL users: when you use JOIN USING, DataGrip offers you only the field names common for both tables.
  • Find Usages now handles positional parameters references: $1 will be treated as the first parameter’s usage and so on.
  • Navigate to the next method, familiar to many of you from our other IDE’s, now works in DataGrip and is called Navigate to the next statement. Invoke it by Alt+Up and Alt+Down (Ctrl+Down and Ctrl+Up for OSX).
  • DATA DUMP:
  • We integrated DataGrip with mysqldump and pg_dump. To dump the objects, use the Dump with… option from the context menu.
  • This is what the dialogue window for MySQL looks like:
  • And here is the one for PostgreSQL. Note that in both cases you can use completion for the console parameters.
  • XML EXTRACTOR COMES BACK:
  • Back in 0xDBE times (remember those?) we had an XML-extractor. Some of you asked to bring it back, and we’ve obliged.
  • OTHER FEATURES:
  • When large script files are run from the context menu, now they are executed much faster.
  • Now DataGrip detects if an old driver is in use and offers you to update it.
  • You might have noticed the new icons! We hope you’ll like them.
  • OTHER FIXES AND ENHANCEMENTS:
  • SQL Server 2016 grammar support
  • PostgreSQL 9.6 grammar support
  • Many minor objects can now be dropped from the UI
  • Many minor objects are now resolved in the SQL code
  • Rules support in PostgreSQL
  • External tables parsing in Oracle
  • The FiraCode font is bundled
  • Auto-inc support in SQLite
  • Expression index support in SQLite

New in DataGrip 2016.3 Build 163.7744.4 RC (Nov 21, 2016)

  • New features:
  • Navigation by statements
  • Large scripts are executed faster

New in DataGrip 2016.3 Build 163.7743.34 EAP (Nov 14, 2016)

  • Data conversion
  • Materialized views support in PostgreSQL
  • Drop triggers from UI
  • Faster scripts execution
  • New icons

New in DataGrip 2016.3 Build 163.7342.16 EAP (Nov 3, 2016)

  • Showing source codes of triggers
  • Showing source codes of views
  • Find usages inside views, procedures and functions

New in DataGrip 2016.2.6 Build 162.2229.1 (Oct 17, 2016)

  • Fixed problem with sensitive scrolling on macOS Sierra.

New in DataGrip 2016.3 Build 163.5644.18 EAP (Oct 7, 2016)

  • Bulk submit
  • Improved drivers management
  • Renaming views
  • XML extractor comes back
  • Enhancements in SQLite support

New in DataGrip 2016.2.5 Build 162.2228.8 (Oct 4, 2016)

  • Fixed problem with incremental introspection in Oracle.

New in DataGrip 2016.2.4 Build 162.2159.2 (Sep 21, 2016)

  • Updated H2 driver up to 1.4.192.
  • Fixed issues with introspection context.
  • Fixed issues with encoding in tree view.
  • Enhanced MySQL code formatter.

New in DataGrip 2016.3 Build 163.4396.16 EAP (Sep 14, 2016)

  • This version features integration with dump tools, several new inspections, the possibility to edit several fields at the same time, new completions, and many other enhancements. Let’s take a closer look at them:
  • Drivers:
  • Now DataGrip detects if an old driver is in use and offers you to update it.
  • Table Editor:
  • Now you can edit several fields at once — just select them and begin to type. Of course, it works only if the columns you are editing are not unique and have the same type.
  • The familiar expand selection action by Ctrl+W (Alt+Up for OSX) now works in the data grid as well: first, a field is selected, then the column of the active field, then the row of the active field and finally, the whole grid.
  • External dump tools integration:
  • We integrated DataGrip with mysqldump and pg_dump. To dump the objects, use the Dump with… option from the context menu.
  • Code completion:
  • Now if you use JOIN USING, DataGrip offers you only the field names common for both tables.
  • The INSERT statement completion offers you not only the list of all fields but also the list of fields which have no default value.
  • Inspections:
  • The IDE will warn you about the unused variable or parameter in the function.
  • Another inspection will let you know if there is a different number of columns in queries used in set operators (UNION, INTERSECT and EXCEPT).
  • Introspect missing schemas and databases:
  • The new intention action offers you to introspect the schema or databases right from the editor if DataGrip has no metadata on them yet.
  • Find usages in PostgreSQL:
  • Find Usages now handles positional parameters references in PostgreSQL: $1 will be treated as the first parameter’s usage and so on.
  • FiraCode font:
  • All IntelliJ-based products bundle FiraCode font so you can use it to have ligatures in your code.
  • Other enhancements:
  • SQL Server 2016 grammar support
  • External tables parsing in Oracle
  • Better operators parsing in PostgreSQL
  • SELF resolving in Oracle

New in DataGrip 2016.2.3 Build 162.2032.7 (Sep 9, 2016)

  • Highlights:
  • Fixed problem with Redshift not showing database objects.
  • Now queries return the correct number of rows if the PageSize parameter is set to 0.
  • Exporting the result-set affects the whole set, not only one page.
  • Fixed bug in comparing schemas with different names.
  • The Flip intention action in functions has been fixed.

New in DataGrip 2016.2.2 Build 162.1889.11 (Aug 30, 2016)

  • Fixed bug with freezing during the introspection.
  • Schema comparing tool now understands if it needs to create the table or alter it.
  • Fixed error with incorrect results on the other pages of the result-set.
  • DataGrip doesn't retry failed command after detecting connection problems.
  • Fixed bug with Snowflake introspection.

New in DataGrip 2016.2 Build 162.1122.5 (Jul 20, 2016)

  • Brings UI for importing CSV files, JSON and XML support in literals, regular expressions checking, dynamic SQL support, completion in tables, keyboard layout aware completion and more.
  • Specific DB features: Recompile packages in Oracle, search path support and enhancements in fields editing for PostgreSQL.
  • Other improvements:
  • Fixed DBE-569: important bug with timed out connection on MySQL.
  • The Database tool window now provides the option Auto-scroll from Editor.
  • If you use auto-completion, in case of identical names DataGrip will qualify the name of the object automatically.
  • Added Tools → Create Command-line launcher/Create Desktop Entry actions in Linux.
  • Go to source works from the preview in Find in path.
  • Copying SSH and SSL settings copies the password as well.
  • *.sql files are associated with DataGrip on Windows and also can be opened from the "Open with" context menu.
  • CTE support has been improved — we parse it even not finished.
  • Inserting the selected keyword in completion by ";" and "," doesn't insert a space anymore.
  • Aggregate functions in ORDER BY are not highlighted as errors.
  • The same for PREVIOUS VALUE in DB2.
  • Test connection UI has been improved.

New in DataGrip 2016.1.2 Build 145.864.1 (Jul 9, 2016)

  • There was a problem with information about the perpetual fallback license. After just a minor update users could see "You have perpetual fallback license for this version" no more. We've fixed it.

New in DataGrip 2016.1.1 Build 145.864 (Jul 7, 2016)

  • This update contains fixes for two security issues inside IntelliJ Platform. The vulnerabilities, in various forms, are also present in DataGrip 1.0; therefore, patches for that version is also available.
  • Find more information about the issues, the affected versions and ways to update in this special blog post: http://blog.jetbrains.com/blog/2016/05/security-update-for-intellij-based-ides.

New in DataGrip 2016.2 Build 162.1120.25 EAP 3 (Jul 6, 2016)

  • Dedicated UI for importing CSV, TSV (well, DSV) files to the database:
  • Click the schema you want import data to, and choose Import From File… from the context menu. Then choose the CSV file where your data is.
  • You will see the Import dialog window. The left-hand panel is for format specification: choose the delimiter, whether the first row is a header (the separate format options are available for it), and specify if you have quoted values in the file.
  • On the right-hand side, you see a frame describing the table to be created and a result data preview. Press Delete to remove a column from the result. If you wish to import data to an existing table, just use the context menu of this particular table to choose Import From File…
  • OK, but what happens if there are errors in the file? Write error records to file option is available. The import process will not be interrupted, but all the wrong lines will be recorded to this file.
  • What else:
  • A couple of small things: select rows with Shift+Space like in Excel.
  • Also, a very annoying bug has been fixed: foreign keys previously pointed to nowhere once you had renamed the table it pointed to.

New in DataGrip 2016.2 Build 162.917.27 EAP (Jun 23, 2016)

  • LANGUAGE INJECTIONS:
  • Quite possibly the most important feature of this build, it lets you treat string literals as live code written in other languages (like XML, JSON, any SQL dialect or even regular expressions), including formatting, highlighting, usage search, completion, and even refactoring.
  • Let’s have a closer look at how this feature is useful when you’re working with DataGrip.
  • Language is auto-injected into a literal when DataGrip is 100% positive of the nature of its contents. For example, if you are working with values from JSON columns, they will be treated as such.
  • Language can also be injected when you’re specifying a column default value. In the following case it’s XML, which makes all the XML-related features available there: rename elements by Ctrl/Cmd+F6, find usages by Alt+F7, and enjoy completion for attribute names. For more information about XML support you can have, read this IntelliJ IDEA help page. DataGrip and IntelliJ IDEA share the common platform, everything described there will work in DataGrip just as well.
  • By default, there are only two predefined injection types: JSON and XML. However, it’s really simple to create your own injections: just press Alt+Enter and then select Inject By Type.
  • There are many languages you can inject.
  • You will be offered to create a custom type pattern that simplifies the use of injections, for instance, you can configure it to inject XML into any field ending with DATA. You can use regular expressions to define the injection patterns. There’s RegExp assistance, too: Alt+Enter invokes the Check RegExp feature.
  • Your pattern will be added to the list in Settings/Preferences → Editor → Language Injections.
  • Since it’s possible to inject languages into any string in the SQL code, we can use Check RegExp if we’re inserting a value for the MasterCard pattern.
  • Did you see this was temporarily injected tooltip? If you want to have the injection whenever you edit a particular piece of code, comment it with “language=” like on the following screenshot. In it is another important example — the use of DynamicSQL that provides coding assistance for the injected fragment.
  • DUMPING TABLES:
  • Now you can dump multiple tables and even the entire schema, which means that any data (not only result-sets), can be exported to CSV, JSON or a list of INSERT/UPDATE statements.
  • RECOMPILE OBJECTS IN ORACLE:
  • We’ve fixed some bugs in recompiling packages and added a way to recompile any DB object. Well, it has to be recompilable, of course, like procedures, views, types, triggers, etc. There is a possibility to recompile only invalid objects in the group, too.
  • LIGATURES:
  • Just as with any of IntelliJ platform-based IDE, DataGrip editor now officially supports fonts with programming ligatures. To enable ligatures, go to the Settings → Editor → Colors & Fonts → Font, specify a font that supports ligatures, e.g. FiraCode, Hasklig, Monoid or PragmataPro (the font has to be installed) and select the Enable font ligatures option.

New in DataGrip 2016.2 Build 162.686.8 EAP (Jun 3, 2016)

  • We’ve added completion for database names in the connection dialog. Make sure you’re logged in to the server, and then press Ctrl+Space (Cmd+Space for Mac).
  • Database view:
  • Some changes happened to the instrospector. We’ve replaced the way schemas are selected from the tab in Properties, so now you will find all schemas of the server by clicking “More Schemas…” in the database view. Choose the schemas you want to see here and hide any you don’t need from the context menu. Now you need to refresh your data source if you’ve updated from the previous version. This is what we are trying to improve, and your feedback is very important.
  • Auto-scroll to source: If this is turned on, you will automatically navigate to data source from the active console and to the table/view from table editor. If you turn it off, use locate (crosshairs) icon to scroll to source.
  • Query console:
  • DataGrip now supports search path in PostgreSQL, meaning you can add schemas one by one in the switcher of the console. The console has a list of schemas to look in. If there are two tables with the same name in different schemas, the first one will be used. Thus, the order is important: move schemas in the search path with the mouse or Alt+Arrows.
  • If you use auto-completion, in case of identical names DataGrip will qualify the name of the object automatically.
  • Auto-completion became a little bit better — we’ve removed some elements from the list according to the context. For instance, there are no functions now if we see that you mean table.
  • A small enhancement for those who use many languages, IntelliJ-based IDEs including DataGrip now understand what you mean, even if you forgot to switch the language of input.
  • Surround action doesn’t ruin multi-carets anymore. Also, we’ve added surround with function which means that the caret will be placed before the brackets, not after: put the name of the function here. Notice, you can just type “bion” to put get_AuthorByIdOrName function.
  • Table editor:
  • Completion for values in table is available by pressing Ctrl+Space (Cmd+Space for Mac). It looks through all the values in the column and offers you a list of possible matches.
  • Some improvements have been made in PostgreSQL: now you can modify different range types and types with time zones.
  • We’ve added actions for resizing columns: use Ctrl+Shift+Left/Right (Cmd+Shift+Left/Right for Mac). You can resize several columns at the same time. Ctrl+Shift+Up stands for the default size.
  • IDE:
  • A small new feature will help you make DataGrip look different: set any image as the background of your IDE. Add the folder with the picture to the Files panel, and then choose Set Background Image from the context menu.
  • Those were just the key changes. Others include:
  • Copying SSH and SSL settings copies the password as well.
  • Go to source works from the preview in Find in path.
  • Inserting the selected keyword in completion by “;” and “,” doesn’t insert a space anymore.
  • CTE support has been improved — we parse it even not finished.
  • Aggregate functions in ORDER BY are not highlighted as errors.
  • The same for PREVIOUS VALUE in DB2.
  • Test connection UI has been improved.

New in DataGrip 2016.1 Build 145.862 (Apr 20, 2016)

  • HIGHLIGHTS:
  • Connectivity enhancements
  • Better PostgreSQL and Oracle support
  • By-word difference highlighting
  • File scopes
  • CONNECTIVITY:
  • Password is copied with SSH settings:
  • SSH/SSL tab is now always accessible, and is a bit smarter—you can copy the password along with all other SSH settings between data sources. Just click “Copy from…”, and you’re all good.
  • Custom URLs support:
  • If you’re using a DBMS we don’t directly support, you’ll be prompted to create a custom JDBC URL template that we will then use to extract information (like login or address) from that URL.
  • Port number auto corrections:
  • New SQL Server connection inspections should help those who mistake the port numbers. From now on, DataGrip will inform you that you specified an incorrect port number and offer a quick-fix for that.
  • Completion for instance and databases:
  • In General tab for SQL Server data source now there is a completion for hosts, instances and databases. Thus, you can see the complete list of what you need by pressing ^⇧Space in the text field.
  • Better errors handling:
  • We improved the way MySQL tells you about connection errors, so you will get more details on what exactly went wrong, not just some generic "Could not create connection” message.
  • EDITOR:
  • Qualify and unqualify identifier:
  • A new pair of intention actions, Qualify and Unqualify identifier, are accessible from the ⌥Enter menu.
  • Generate definitions
  • Structure view enhancements:
  • Structure View will now be able to display the common table expressions, and will not shorten longer names them in an unpredictable way.
  • Right-to-left languages support:
  • Selection and caret now are fully supporting RTL languages like Arabic or Hebrew.
  • IDE FEATURES:
  • File scopes:
  • Starting with this version DataGrip supports file scopes that simplify various operations (like code analysis) by grouping files based on multiple flexible criteria such as path or name mask. To manage scopes, go to Preferences/Settings → Appearance and Behavior → Scopes. Scopes you create will appear in the Files panel (⌘2)
  • By-word difference highlighting:
  • We added by-word difference highlighting in the diff viewer—now it's easier to see the difference between the two files you’re comparing.
  • POSTGRESQL SUPPORT:
  • Better grammar support:
  • Some PostgreSQL features like WITHIN GROUP and window functions for custom aggregates are now properly highlighted and available for completion.
  • Completion for table functions:
  • We’ve improved the support for table functions: they’re now properly highlighted and available for completion. Finally, the automatic aliases can be used for qualification in the SQL editor.
  • Function in indexes support:
  • Also, we’ve added the support for functions in indexes: you can navigate to them from the database view or from an index DDL with the familiar ⌘ + Mouse Click action.
  • OTHER IMPROVEMENTS:
  • Oracle 12 grammar support.
  • Moving elements in XML left or right with Alt+Ctrl/Cmd+Shift+Arrow keys.
  • Objects that are not introspected now can be resolved to DDL statement is there is a match.
  • Ctrl/Cmd+F text search in Terminal plugin.
  • Fix for the issue of losing the formatting of Oracle functions and procedures.
  • Remote Hosts Access plugin is available for installation.
  • Perforce plugin is available for installation.

New in DataGrip 2016.1 Build 145.861.1 RC (Apr 8, 2016)

  • The most important changes in this build are optimizations of memory and indexing. Many of users got "Out of memory" error message: we've fixed it. Also we've fixed IDEA-153620, a very important bug about slow indexing.

New in DataGrip 2016.1 Build 145.735.3 EAP (Apr 1, 2016)

  • Enhancements in Structure View
  • Scopes (virtual file folders)
  • Informative error messages in MySQL connection

New in DataGrip 2016.1 Build 145.404.2 EAP (Mar 14, 2016)

  • Connectivity:
  • We improved the interface for using the SSH tunnel.
  • SSH/SSL tab is not hidden anymore depending on the driver — you can always see it. As you may know, you can copy SSH settings from some other data source. Now the password is copied as well, so you don’t need to do anything else except pressing “Copy from…”.
  • We added a new warning that will inform you if the URL can’t be parsed. It likely happens if you use some DBMS we don’t directly support.
  • This problem can be fixed by clicking “create template”. You will be offered to create your own template for JDBC URL.
  • We have new inspections for SQL Server connection. Some of our users had difficulties with it, often because they specified the wrong port number. Now DataGrip will inform you about this situation. Specify the correct port number by pressing Apply near the Instance field.
  • In General tab for SQL Server data source now there is a completion for hosts, instances and databases. Thus, you can see the complete list of what you need by pressing Ctrl+Space in the text field.
  • PostgreSQL support:
  • Some PostgreSQL features like WITHIN GROUP and window functions for custom aggregates are now properly highlighted and available for completion.
  • We improved the support for table functions: they’re highlighted and available for completion. Automatic aliases can be used for qualification, it is not the problem for the SQL editor anymore.
  • Also, we’ve added the support for functions in indexes: you can navigate to them in the database view just from the index DDL by clicking them while holding Ctrl/Cmd.
  • Editor:
  • We’ve added the support for Right-to-left languages (Arabic, Hebrew):
  • This is the issue we strongly need your feedback for. If you use these kinds of languages and notice problems, please don’t hesitate to write in our issue tracker.
  • There are new intentions Qualify identifier and Unqualify identifier.
  • We also fixed the very annoying bug with losing the formatting of Oracle functions and procedures while loading source code.
  • Also, in this version you will find:
  • Oracle 12 grammar support.
  • Moving elements in XML left or right by Alt+Ctrl/Cmd+Shift+Arrow keys.
  • Objects that are not introspected now can be resolved to DDL statement is there is any.

New in DataGrip 1.0.3 Build 143.2263 (Feb 19, 2016)

  • Highlights:
  • Parameterized query plan can now be explained in Oracle without providing parameter values.
  • CSV extractor now quotes values properly.
  • Numeric overflow on spatial indices error is fixed.

New in DataGrip 1.0.2 Build 143.1997 (Jan 27, 2016)

  • HIGHLIGHTS:
  • PostgreSQL 9.5 support
  • User-Defined types in SQL Server support
  • Table and column comments now can be modified and created from UI
  • Truncate multiple tables
  • RELEASE NOTES:
  • DB.Connectivity:
  • Feature: DBE-103: Interface to easily connect to localdb instances
  • Bug: DBE-1933: Cannot connect to DB, driver settings keep reverting to the Abstract Driver class on "Apply"
  • DB.Introspection:
  • Feature: DBE-1404: MSSQL Support User-Defined Data Types (non-CLR)
  • Bug: DBE-2136: Create data source dialog doesn't detect all schemas for MSSQL
  • Bug: DBE-2061: MS SQL and Sybase Data Source Configuration Window: wildcards in schema list don't work
  • DB.Refactoring:
  • Bug: DBE-1393: Postgres: Renaming quoted columns
  • Bug: DBE-2079: Oracle: impossible to edit "on delete actions" for foreign keys
  • Bug: DBE-408: Support comments for column/table
  • IDE.General:
  • Bug: DBE-2095: "Confirm application exit" setting not work
  • IDE.User Interface:
  • Bug: DBE-153: Add truncate for multiple tables
  • SQL.Highlighting:
  • Bug: DBE-2085: Sybase dialect doesn't recognize special variables (starting with @@)
  • Bug: DBE-1860: Statement ALTER TABLE table_name ADD CONSTRAINT FOREIGN KEY is not highlighted as erroneous
  • Bug: DBE-2165: Problem compiling oracle package containing "merge" statement
  • Bug: DBE-2168: Unknown database function 'Try_Convert'
  • Feature: DBE-2089: PostgreSQL 9.5 support
  • Bug: DBE-2171: PostgreSQL select with no fields parse error
  • SQL.Editing:
  • Bug: DBE-2133: Custom folding issue

New in DataGrip 1.0.1 Build 143.1411 (Dec 29, 2015)

  • DB.Connectivity:
  • Bug: DBE-1797: MSSQL: OxDBE can't connect to the named server instance over Microsoft JDBC driver
  • DB.Introspection:
  • Bug: DBE-2049: Oracle Triggers: trigger types and events are not introspected perfectly
  • Bug: DBE-2061: MS SQL and Sybase Data Source Configuration Window: wildcards in schema list don't work
  • DDL\PL.Editor:
  • Bug: DBE-1914: Editor marks empty Postgres enum as an error
  • IDE.General:
  • Feature: DBE-2064: TFS integration plugin
  • IDE.User Interface:
  • Usability: DBE-652: Support directories as DDL data source
  • SQL.CodeStyle:
  • Bug: DBE-1388: Huge indentation on reformat MySQL view
  • SQL.Completion:
  • Feature: DBE-2026: No suggestion in PLPGSQL for FOUND special variable.
  • Feature: DBE-1924: MS SQL: completion for routine parameters
  • SQL.Editing:
  • Feature: DBE-1309: Custom Code Folding
  • Bug: DBE-1762: Surround with in SQL: end of document/selection bugs
  • SQL.Highlighting:
  • Bug: DBE-1303: Postgresql: support ? operator
  • Bug: DBE-2052: Sybase dialect should recognize *= / =* (old-fashioned outer joins)
  • Bug: DBE-2020: 'level' not properly identified as keyword in 'connect by' line
  • Bug: DBE-1936: MySQL, format function can take 3rd optional parameter. FORMAT(X,D[,locale])
  • Bug: DBE-1695: "respect | ignore" clause for Oracle FIRST_VALUE and LAST_VALUE analytical functions is not pared corresctly