Browse and Edit Table Data
Double click a table in the left sidebar to open an Excel-like interface for viewing and editing the data. We call this the Table View
This view allows you to:
- Interact with your table like it is a spreadsheet
- Filter the view to see specific records
- Easily edit data
- Copy/Paste data from elsewhere
- Export the whole or partial table to a range of formats
Interaction
The table view provides a spreadsheet-like experience for selecting, copying, and pasting data. Beekeeper supports many spreadsheet-like interaction primitives.
- Select arbitrary ranges of cells using click & drag, ctrl-click, and shift-click.
- Hide columns by right clicking the header and choosing
hide column - Resize columns, either one at a time, or together
- Copy and paste ranges of cells from Excel or Google Sheets with native keyboard shortcuts
Filtering The Table View
At the top of the table are data filters. You can use these to search your table for the specific data you want.
There are two types of filter you can use - the filter GUI, and the raw SQL filter
Filter GUI
The filter GUI lets you check any column on the table for a variety of conditions:
- Equality
- Greater than / less than
- Like
- IN
Warning
When using LIKE in your filters, don't forget to use %. For example to find all titles that contain foo you would write: %foo%, not foo
Raw SQL filters
Click the little <> icon to the left of the filters to enter a sql filter. You can type anything in here that would appear in the WHERE clause of a sql statement.
Editing Data
In the table view you can easily edit any cell you like. Simply double click the cell to edit.
Note
Beekeeper only supports editing tables with primary keys.
Editing JSON & Other Large Values
Editing a JSON document in a tiny table cell isn't a great experience. Instead you can right click the cell and select Edit in Modal. This will provide a pop-out modal with syntax highlighting and checking.
Applying Changes
Beekeeper has a unique design that 'stages' changes before applying them, so you can make multiple changes to be applied inside of a single transaction.
Staged change types are indicated by color:
- Green - new data to be added
- Red - data to be deleted
- Orange - data to be updated
To commit a change, click the Apply in the bottom right of the screen. To discard the change, click Reset. You can also click Copy To Sql if you'd like to make manual changes to the operations.
Warning
Sorting or filtering the table during editing will discard your staged changes.
Editing entire rows
You can clone, delete, and create new rows of data pretty easily.
Right click a row (or multiple rows) to delete or clone.
Click the + button at the bottom right to add a new row. New rows will be added to the end of the table, even though they appear at the top of the UI for convenience.
Copying Data
The table view allows you to copy
- An individual cell
- An entire row
- An arbitrary set of selected cells.
If you press the copy keyboard shortcut (ctrl+c or cmd+c), you will copy the data in a spreadsheet-friendly format (it will paste beautifully into Google Sheets or Excel)
Alternatively, right-click any cell to copy that row (or all selected cells) in a range of formats like CSV, JSON, and Markdown.
Exporting the whole table
Click the ⚙ icon in the bottom right and select export to export a whole table, or the filtered table view.
From here you can get a full snapshot of the table, ready to share with others.