Data editor

Modify data

Modify data in your table without leaving the window. It works for any query result received from a table. Completion for values in the table is available via Ctrl+Space. It looks through all the values in the column and offers you a list of possible matches. Submit changes using Ctrl+Enter.

Bulk submit

All your changes in the data editor are stored locally and can be submitted all 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 with Ctrl+Enter. Ctrl+Alt+Z 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 the cells with Ctrl+A before reverting.

Multiple edit

Several fields can be edited at the same time — just select them and begin to type. Of course, it only works if the columns you are editing are not unique and have the same type.

Paste from CSV

Paste data from Excel tables. Generally to do this, you need the ability to paste data in a DSV format. In DataGrip you can define any format you want, or you can let the IDE detect the format automatically: Gear icon → Paste format and it’s done:

Filter data

Use the filter text field to only see the data you need, without writing any WHERE clauses. Just put the condition in this field in the appropriate SQL dialect.

Text search

Find data inside a table quickly without writing a statement thanks to text search, available in the Table Editor via Ctrl+F. It’s especially helpful if you don’t know which exact column contains the data you’re looking for. You can easily hide irrelevant rows, and regular expressions are available as well.

Transaction control

Define what kind of transaction control you want to use when working with data. The data editor in the Auto mode works like it's described in the Bulk Submit section.

In Manual mode there are also:
Commit button or Shift+Ctrl+Alt+Enter: commits the transaction. If you have unsubmitted local changes (again, they are highlighted) they will be automatically submitted before the commit.
Rollback button: rolls back a transaction if it’s uncommitted.

Transpose view

If the table contains too many columns to place on the screen, use the Transposed view to see the data from a particular row in a friendlier way.

Search for a column

Open Structure view by Ctrl+F12 and start typing! Speed search can help save you again by filtering the columns. Press Enter to navigate to a particular column.

Rich text edit

If you have, for instance, a lot of text inside the field, you can maximize the cell view by pressing Ctrl+Alt+Shift+M. Choose Active Editor: Use Soft Wraps from the Find Action menu if you'd like to have word wraps for viewing the text.

In case oj JSON it'll be automatically formatted and highlighted.

Navigation by foreign keys

If a column contains a foreign key, you can navigate to the related data for a particular value or view it in the pop-up. In many situations this saves you from having to write a query.

On the opposite side, you can find usages of foreign keys in other tables. You will be navigated to the data referencing your row and column. If the cursor is on a column that is not referenced, then you can choose what data you want to navigate to.

Compare cells

The last enhancement in this section: values of two or three cells can be compared in the Diff Viewer. Select them and press Shift+Ctrl+D.

Export data

Any table or result-set can be exported in a variety of formats including CSV, JSON, XML, and HTML. You can even create your own format to export to.

Learn more about export data.