Edit PostgreSQL table data directly in VS Code and Cursor

[mmcfarland]

Some data corrections do not always need a hand-written UPDATE or INSERT statement. The PostgreSQL extension now includes Edit Data, an editable table grid for making and reviewing targeted row changes in Visual Studio Code and Cursor.

Try it

1. Open the Connections tree.
2. Expand a database, schema, and the Tables folder.
3. Right-click a table and select Edit Data.
4. Edit values in the grid, then review and save your changes.

The grid provides type-aware editing for text, numbers, booleans, enums, dates, times, and nullable values. You can also add rows, mark existing rows for deletion, revert an individual row, or open long text and JSON values in an expanded editor.

Review changes before they run

Edits remain pending until you choose what to do with them. Select Preview changes to review the generated INSERT, UPDATE, and DELETE statements before they reach the database.

From the review pane, you can:

• inspect the pending changes grouped by operation,
• copy the generated SQL, or
• open the SQL in a connected query editor for further changes.

When everything looks right, select Save to apply all pending changes in a single transaction. Select Discard to return the grid to its last saved state.

Built-in safeguards

Edit Data respects PostgreSQL table and column permissions. Actions that your role cannot perform remain disabled. A primary key is required for editing so each row can be identified safely; tables without a primary key open in read-only mode. Changes to primary-key values require confirmation before they are saved.

Edit Data is intended for small, focused updates. For bulk changes, complex filters, or repeatable operations, use the query editor instead.

Try it and let us know what would make table editing more useful in your PostgreSQL workflow.