Browse and edit PostgreSQL data

Browse PostgreSQL schemas and tables, filter rows, inspect values and stage checked edits before committing.

Tablyne starts with the PostgreSQL hierarchy rather than a flat list of tables. You can move through databases, schemas and objects, then open a table in the data grid without losing the connection context.

Find the table

  1. Use the sidebar to open a database and schema.
  2. Select a table and wait for its first page of rows.
  3. Use the filter… control for a quick search, or add a structured condition when the filter needs a real WHERE expression.
  4. Open Columns when you need to change the visible column set.

The PostgreSQL grid supports sorting, pagination, multi-selection and an inspector with database-aware formats. Foreign-key navigation can take you from the selected value to the referenced table. The ERD and schema views keep the relationship context beside the rows.

Stage the edit

Edit a cell in place, then leave the row in a staged state. The grid does not immediately send the change to PostgreSQL. The review surface lists the changed columns and the SQL that would run. A row can be discarded before the commit, so a mistaken edit does not require a compensating write.

The write uses the row identity and the version captured when the row was read. For a normal PostgreSQL table that check is xmin; a stale version causes the operation to affect no row and the whole batch is rejected.

Keyboard flow

  • Ctrl+S saves pending changes.
  • Ctrl+Z undoes the last grid change.
  • Ctrl+Y redoes it.
  • Shift+Enter opens the selected cell value.
  • Ctrl+E opens data export.

The same flow applies when a table has a composite primary key. Tablyne keeps the key columns in the generated predicate instead of guessing from the displayed row order.