Table of contents

• From the Data Editor cell
• From the Value panel
  • Formatting options

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 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.