Work with Database in TaruviBase Console

TaruviBase Console provides a visual workspace for Database tables and records. Use it to understand a table's shape, add and inspect data, build filters, and make one-off record changes without writing application code.

Open the Database editor

1. Sign in to TaruviBase Console.
2. Select the organization and site that own your application.
3. Open the app.
4. Select Datatables in the app navigation.

The table list stays on the left. Selecting a table opens two views:

• Data contains the record grid, filters, sorting, and record actions.
• Definition shows fields, types, required values, constraints, primary keys, and foreign keys.

Inspect and find tables

• Use the Search tables... field to filter the app's table list by name.
• Open Data to browse records with server-side pagination.
• Open Definition to inspect columns, types, nullable state, constraints, primary-key metadata, and foreign keys.
• Open a table's options menu to copy its name, schema JSON, or generated SQL.
• Use the refresh control after another client changes the records.

Add a record

1. Select the table and open Data.
2. Select Insert.
3. Complete the fields in Add Record to table name.
4. Select Add Record.
5. Verify the new row and retain its generated primary key.

TaruviBase generates the UUID primary key for new single-key tables. Existing integer-key tables continue to use the identifier defined by their schema. Console row actions address records through a field named id; use an SDK or REST for a reviewed table whose single primary key uses another name.

Edit or delete a record

1. Find the row in Data.
2. Open its action menu and select Edit. Change the fields, then select Update Record.
3. To remove the row, open the action menu and select Delete.
4. Review Confirm Delete Record, then select Delete Record.
5. Use the refresh control when you need to reload the current page.

System tables and schemas marked read-only show their data without record mutation controls.

Filter and sort records

1. Select Filters above the data grid.
2. Select Add first condition, then choose a field, operator, and value.
3. Select Add Expression for another condition in the same group, or Add Group for a nested group. Use And or Or to choose how each group's children are combined.
4. Switch to Sort and select Add sort field for each field. Up to five sort fields are supported; their displayed order sets sort precedence.
5. Select Apply. The data grid returns to its first page with the selected filters and ordering.
6. Use the copy-query control when you need the current DatatableFilter structure for debugging or a code handoff.
7. Select Clear all to restore the table's default primary-key ordering.

The filter editor chooses operators by field type, including comparisons, string matching, set membership, null checks, array operations, between ranges, and PostgreSQL range operators.

Inspect and share a schema

Open a table's options menu to copy:

• the table name;
• the stored JSON schema; or
• the generated SQL representation.

Use the JSON schema when reviewing a change or comparing environments. Follow Schema changes before altering a production table and Import and export when records must move with the schema.

Creating, importing, changing, and deleting tables requires an organization owner or admin, or another cloud user with access to the site. Your application's own credentials only need access to records.

Choose the right interface

Use Console for inspecting data and making one-off changes. Use an SDK or REST when the same operation belongs in application code, a repeatable job, or an automated workflow.

Task	Console	Code interface
Inspect a table and its schema	Yes	—
Create, import, or delete a table	Yes (organization owner or admin)	REST API for schema changes
Create, browse, edit, or delete one record	Yes	JavaScript, Python, or REST
Nested AND and OR filters and multi-field sorting	Yes	JavaScript, Python, Refine reads, or REST
Aggregations, allowed-action hints, and search	—	Use the dedicated Database guide

Continue with the Database quickstart or the Database interface reference.