Skip to content

XML and JSON data

DBeaver supports XML and JSON column types (in relational databases) by using standard JDBC interfaces. This feature was added in JDBC4 so you will need JDBC4 compliant driver for your database.

You can view and edit XML and JSON data in different ways:

From the XML and JSON tabs in the Data Editor

In document-oriented databases such as MongoDB, and in some relational databases, you can edit XML and JSON data using a dedicated XML and JSON tabs in the Data Editor left sidebar.

This editor supports advanced navigation features, including code folding, and is intended for working with structured and large values.

To edit data:

  1. Open the Data Editor.
  2. Switch to the XML or JSON tab on the left sidebar.

You can edit the content directly in this tab.

Note

Availability of the XML and JSON tabs depends on the database type and driver capabilities.

From the Data Editor cell

You can edit XML and JSON values directly from a Data Editor cell.

For small values, edit the content directly in the cell.

For large or complex values, open the full-size editor:

  1. Click a cell containing data.
  2. Press Shift+Enter to open the full-size editor in a new tab.

Tip

Use Auto Format to adjust spacing and indentation for better readability. Shortcut: Ctrl+Shift+F.

From the Value panel

You can interact with XML and JSON data using the Value panel, which provides tools for formatting, uploading, saving, and switching formats.

Note

The Value panel isn't available when working in the Data Editor left sidebar.

Formatting options

Through the context menu (right-click within the Value panel), you can access the following features to improve readability and manage text display:

Action Description Shortcut
Auto Format Adjust spacing and indentation for better readability. Ctrl+Shift+F (⌃⇧F for macOS)
Toggle Word Wrap Enable or disable word wrapping within the editor.