Data extractors

Last modified: 25 October 2023

Data extractors set rules of how to copy or view your data in the editor (in the Text editor view mode). You can select a default extractor from the Data Extractors list near the Export Data icon (The Export Data icon), configure the existing extractor, or create a custom extractor by using Groovy or JavaScript.

Data extractors list on the data editor toolbar

The last selected extractor becomes the default one for newly opened editor tabs. For MongoDB, the default extractor is always JSON.

In the following video, the data is copied using the CSV data extractor, and viewed in the Text editor view mode using the SQL Updates and Pipe-separated data extractors.

Using data extractors, you can export database data as SQL statements and in various formats. When you export to a file, a separate file is created for each individual table or view. For more information about exporting, refer to the Export section.

The list of available data extractors is as follows:

  • Built-in data extractors. Use them to export data as a set of INSERT or UPDATE statements, TSV and CSV files, Excel XLSX files, Markdown, HTML tables and JSON format.

    Built-in data extractor

    Export file format

    SQL Inserts

    .sql

    SQL Updates

    Where Clause

    One-row

    SQL-Insert-Multirow

    SQL-Insert-Statements

    Excel (xlsx)

    .xlsx

    CSV

    .csv

    TSV

    .tsv

    Pipe-separated

    .txt

    Pretty

    HTML (groovy)

    .html

    HTML (js)

    JSON

    .json

    Markdown

    .md

    XML

    .xml

  • Custom data extractors. Create them using Groovy or Javascript and the provided API.

  • Extractors for delimiter-separated values. Use them to create your own format that is based on CSV or any DSV format.