Data browser and editor

DbGate has very powerful data browser and editor. It allows you to quickly find or modify, what you need, even when using complicated relations.

Filtering data

Quick filter - filter rows by typing value in the filter box.

Complex filters - use AND, OR for combining your filter conditions.

Dictionary lookup - choose filtered values from list.

Filter by multiple values - simply copy list of values into filter box, multiple-value filter is applied.

Filter by related column - filter by column from related table.

Easy navigation - Use the arrow keys to navigate around the table.

Excel-like feeling - Edit cells as in Excel. Copy multiple rows in one branch between tables.

Stage changes - Review changes before saving to database.

Macros - Apply predefined macros ion selected cells - eg. change text case, remove diacritics, generate UUID.

Relation hints - see text value from related table in addition to numeric key valuye

Foreign key column expansion - expand foreign key column and view referenced data directly

Master-detail views - explore related rows with master/detail views

Open detail - open detail for foreign key reference

“Transposed view” - view one row with large number of columns

Expand foreign keys - form view works as tree view, with expandable foreign key columns

Grouping - apply GROUP BY master detail view

Advanced copy data - copy selected cells as CSV, YAML, SQL inserts, MongoDB inserts

Column manager - find by column name, hide some columns