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.

    In the Data Editor, you can edit XML/JSON data right in the table cells, however, a big amount of data may require a larger editor, you may want to save XML/JSON scripts to a local file or upload this type of data from a local file.

    To open the full-size XML/JSON editor click the cell containing data in XML/JSON format and press Shift+Enter.

    By default the editor opens on JSON tab, open XML tab to modify XML data.

    Working with XML and JSON - 图1

    To auto-format XML/JSON script press Ctrl+Shift+F keyboard buttons.

    Working with XML and JSON - 图2

    Use Ctrl+S keyboard shortcut to save the changes made.

    You can also edit XML/JSON content, save it locally and upload it from a local file with the help of Value panel toolbar.

    Working with XML and JSON - 图3

    To upload data from a local file, press the Load from file… button Working with XML and JSON - 图4.

    To save the content to a local file, press the Save to file… button Working with XML and JSON - 图5.

    To switch between the formats, press the Content viewer settings button Working with XML and JSON - 图6 and select the format.

    Working with XML and JSON - 图7

    Use Word Wrap feature that wraps the text within a screen.

    Working with XML and JSON - 图8

    Use Auto Format feature to automatically change the appearance of XML/JSON script (fix spaces around operators / commas, fix indentation, etc) and make it more readable.

    Working with XML and JSON - 图9

    To learn more about Value panel, see Panels.