SEARCH · EDIT · EXPORT / 04

Search, edit and export records

Find the records you need, review and edit values, then save them in a suitable format. Follow the Cuvel SQL interface while keeping the target and export scope clear.

Windows / Based on the Cuvel SQL 1.0.2 interface

Check the table and record list

Select a database/schema and table on the left, then open Browse. Confirm the connection and table name before acting. Choose a sort column and ASC or DESC; clicking a column name also changes the order. Column headers stay at the top while scrolling vertically, and horizontal scrolling is available without going to the bottom of the list.

Edit a cell, review and save

Double-click an editable cell in Browse or search results, enter a value and choose Save. You can cancel before saving. Saving writes to the database, so check the row and change first. Editing is restricted when a row cannot be identified safely, such as without a primary key, or when the type or column is not editable. Read error details for permission or constraint failures.

Editing a cell with Save and Cancel controls
Editing a cell with Save and Cancel controlsScreenshot: English / Version 1.0.0Open full-size image in a new tab ↗

Check only the rows you need

Row checkboxes show a selected count with Export and Delete buttons. The header checkbox selects rows on the current page, not every search result. Use Clear selection to remove checks. Deletion requires confirmation of the target and count. If deletion stops partway through, rows already deleted are not restored.

Two selected rows with Export and Delete actions
Two selected rows with Export and Delete actionsScreenshot: English / Version 1.0.0Open full-size image in a new tab ↗

Choose the export rows and columns

Use Export beside the selected count or in the top menu. Choose all records, current search results or checked records, and verify the displayed count. All records means the entire table, not just the visible page. Run a search before choosing search results; check rows before choosing checked records. You can exclude unwanted columns.

Choosing the export scope and columns
Choosing the export scope and columnsScreenshot: English / Version 1.0.0Open full-size image in a new tab ↗

Pick a format for your purpose

Use CSV, TSV or Excel (XLSX) for spreadsheets; JSON or PHP for code; PDF for reading or printing. SQL supports moving structure and data, with options for structure and data, structure only or data only. Excluding columns may omit required values during restoration, so normally keep all columns for migration. Creating an SQL file does not itself verify that restoration will succeed.

File formats and advanced SQL export settings
File formats and advanced SQL export settingsScreenshot: English / Version 1.0.0Open full-size image in a new tab ↗

Check the saved file

Choose a destination, export, and check the completion message and file. Export reads data without changing the source records. Review row counts, columns and included information before sharing. If it fails, check the connection, SELECT permission, disk space and write permission. For connection setup, see Your first connection.

Your first connection →
← Back to guides