Table and Schema Explorer

The Tables page in the Hydra dashboard offers an interactive interface for managing data. Tables lets you add, update, and delete records, filter data, modify columns, drop or truncate tables, as well as export data in both JSON and CSV formats.

​

Edit records

Edit individual entries directly within the table interface. Click on a cell to modify its contents. You don’t have to press Enter (though you can). Just move your cursor to the next cell you want to modify. Click Save x changes when you’re done.

​

Add records

Add new records to your tables using the Add record button.

A couple of things to note:

• You need to hit 

  Enter

   for your input to register. When editing existing fields, you don’t have to do this. But for new fields, if you tab to the next cell, you’ll lose your input.

• You can leave 

  DEFAULT

   fields untouched and the cell will inherit the right value based on your schema definition. For example, defaults for boolean fields are automatically applied when you click 

  Save changes

  .

​

Toggle columns

You can simplify your view by hiding (or showing) individual columns in the table. You’re not modifying content here; deselect a checked column to hide it, and re-select the column to show it again. Your selections are saved as a persistent filter.

​

Add filters

Filters let you store simplified views of your data that you can come back to later. You can use dropdown-filtering to select columns, conditions, and input text for the filter.

Each new filter is added as a view under your list of tables. These views are not persisted to your database, and are saved in your browser only.

​

Delete records

Use the checkboxes to mark any unwanted records for deletion, or use the select-all checkbox for bulk deletion. Click Delete x records to complete the process.

​

Export data

You can also use the checkboxes to mark records for export. Select the records you want to include in your export, then choose Export selected… from the export dropdown.

Or just choose Export all.. to download the entire contents of the table.

You can export to either JSON or CSV.

​

Schema Explorer

To open the Schema Explorer, navigate to the Table tab on the left sidebar. once in the Table Editor select the structure icon, shown in the red circle in the image below.

Once selected, you will see the following information

Select column name, data type, constraints, default, and generated sub fields to make modifications. The schema editor is an interactive way to view and modify tables, indexes, and constraints on the fly.

​

Drop Columns, constraints, indexes

Hover over the field you would like to delete, select it and you’ll find an orange check mark. Then select “Drop selected” shown as a red button the right side of the display box.