Databases: Workspace#

Database Workspace is the main interface for working with tables and records of a specific connection. It opens from the "Databases" section and provides a full set of tools for creating tables, managing fields, viewing and editing records, executing SQL queries, and exporting data.

Location: Access the window through the "Databases" section in the left navigation panel by clicking the open icon next to the connection name.

Available actions:

• View the list of connection tables in the left panel
• Create new tables with a custom field schema
• Edit the structure of existing tables
• Delete tables with confirmation
• View and edit records in a tabular grid
• Add new records through a modal window
• Delete selected rows
• Paste data from the clipboard using Ctrl+V
• Execute SQL queries through the query terminal
• Sort data by columns
• Search records by keyword
• Export the table in CSV format

Tables Panel#

The Tables Panel is the left sidebar of the workspace that displays all tables of the current connection. The panel header shows a counter in the format "Tables (N)", where N is the number of existing tables.

Clicking on a table name in the list makes it active: the right workspace switches to display records of that table. If there are no tables, the counter shows "Tables (0)", and the list remains empty.

Refresh Icon#

The Refresh Icon is located in the header of the Tables Panel and is used to forcibly update the list of tables and data of the current table. Use it after external changes in the database or when the grid data needs synchronization.

After clicking, the list of tables and the grid content are refreshed with the current connection data.

Create Table Button#

The Create Table Button — the "+" icon in the header of the Tables Panel — initiates the creation of a new table in the current database. Clicking opens the "Create Table" modal window, where the schema is defined: table name and list of fields with types.

After confirmation, the new table appears in the panel's table list and becomes available for work.

Query Terminal Icon#

The Query Terminal Icon is located in the header of the Tables Panel and opens the "Query Terminal" modal window for executing custom SQL queries to the current database.

Clicking the icon opens the terminal where you can enter an SQL expression and get the result directly in the window. A detailed description of the terminal is provided in the Query Terminal section below.

Data Grid#

The Data Grid is the right workspace of the window that displays records of the selected table in a table format with rows and columns. Column headers show the field name and its type in parentheses, for example, id (integer) or data1 (text). Each row has a selection checkbox on the left.

For tables with many columns, horizontal scrolling is available. If no table is selected, the grid shows the hint "Select a table to view data".

Add Record Icon#

The Add Record Icon is located in the row of each table in the Tables Panel and opens the "Create Record" modal window to add a new row to the selected table.

How to add a record:

1. In the Tables Panel, find the desired table.
2. Click the Add Record (plus) icon in the row of that table.
3. In the Create Record window, fill in the fields according to the table schema.
4. Click Add Record to save or Close to cancel.

After confirmation, a new row appears in the data grid of the selected table.

Edit Table Icon#

The Edit Table Icon (pencil) is located in the row of each table in the Tables Panel and opens the "Edit Table" modal window to change the schema of an existing table.

How to edit a table:

1. In the Tables Panel, click the Edit Table icon in the row of the desired table.
2. In the Edit Table window, change the Table Name or add new fields through Add Field.
3. For each field, specify the name in Field Name and select a type from the Select Type list.
4. To set additional field properties, click the Field Additional Actions Menu (three dots) and check the necessary checkboxes: Primary Key, Not NULL, Unique, Autoincrement.
5. To delete a field, click the Delete Field (trash can) icon in the row of that field.
6. Click Edit Table to apply the changes.

After saving, the updated table schema is displayed in the data grid.

Delete Table Icon#

The Delete Table Icon (trash can) is located in the row of each table in the Tables Panel and initiates the deletion of a table along with all its records.

How to delete a table:

1. In the Tables Panel, click the Delete Table icon in the row of the desired table.
2. In the confirmation window, click Confirm to delete or Cancel to undo the action.

After confirmation, the table disappears from the Tables Panel list, and all its records are permanently deleted.

Row Selection and Batch Actions#

Row Selection and Batch Actions allow performing operations simultaneously on multiple grid records. Each row has a selection checkbox on the left; after selecting one or more rows, an indicator "Selected: ..." and the Clear Selection (cross) icon appear at the bottom of the grid.

In the bottom right corner, batch action icons become active: Save (floppy disk), Cancel (cross), and Delete (trash can). Batch deletion applies only to selected rows.

Column Sorting#

Column Sorting allows changing the order of rows in the grid based on the values of the selected field. An ascending or descending sorting indicator (arrow) may appear in the column header, and the Column Additional Actions Menu (three dots) icon opens options to "Sort Ascending" and "Sort Descending".

After selecting the sorting direction, the rows in the grid are rearranged according to the selected column and order.

Search Icon#

The Search Icon is located in the top right corner of the data grid workspace and opens a field for filtering records by a keyword.

How to find records:

1. Click the Search icon in the top right corner of the grid.
2. Enter the keyword in the "Search" field.
3. The grid automatically filters rows that match the query.
4. To show all records again, clear the search field.

After clearing the field, the grid returns to displaying all table records.

Download Icon#

The Download Icon is located in the top right corner of the data grid workspace and opens the export menu for the current table.

How to export the table:

1. Click the Download icon in the top right corner of the grid.
2. In the menu, select Export CSV.

After selection, a system save window opens where you can specify the path and save the table in CSV format.

Pagination#

Pagination is located at the bottom of the data grid and controls the number of records displayed per page. In the "Records" field, you can select or enter the desired value, and the navigation buttons allow moving between pages.

Changing the number of records per page takes effect immediately after selecting a new value.

Query Terminal#

Query Terminal is the "Query Terminal" modal window opened through the terminal icon in the "Tables Panel" header. It is designed for executing custom SQL queries directly to the current database.

How to execute an SQL query:

1. Click the Query Terminal icon in the "Tables Panel" header.
2. Enter an SQL expression in the multiline input field of the "Query Terminal" window.
3. Click Execute Query.
4. Review the result in the lower part of the window.
5. Click Close to close the terminal.

After executing the query, the result is displayed in the terminal window output area.

Create Table Window#

Create Table Window is a modal window opened through the "+" icon in the "Tables Panel" header. It is used to define the schema of a new table: table name and a list of fields with types and properties.

How to create a table:

1. Click the + icon in the "Tables Panel" header.
2. In the Create Table Window, enter the table name in the "Table Name" field.
3. Click Add Field to add the first column.
4. Enter the field name in "Field Name" and select a type from "Select Type" list.
5. Open the Field Additional Actions Menu (three dots) if needed and set properties: Primary Key, Not NULL, Unique, Autoincrement.
6. Repeat steps 3–5 for each subsequent field.
7. To delete a field from the schema, click the Delete Field (trash can) icon in the row of that field.
8. Click Create Table to confirm or Close to cancel.

After confirmation, the new table appears in the Tables Panel list and is ready for data population.

Edit Table Window#

Edit Table Window is a modal window opened through the edit icon (pencil) in the row of a table in the "Tables Panel". It allows changing the table name and composition of its fields without losing existing data.

How to edit the table schema:

1. Click the Edit Table icon in the row of the table.
2. In the Edit Table window, modify the Table Name as needed.
3. To add a new field, click Add Field and fill in Field Name and Select Type.
4. To delete a field, click the Delete Field (trash can) icon in the row of that field.
5. Click Edit Table to save the changes.

After saving, the updated table schema is displayed in the data grid, and the Refresh icon allows forcing data update.

Create Record Window#

Create Record Window is a modal window opened through the "Add Record" (plus) icon in the row of a table in the "Tables Panel". It displays a set of fields according to the current table schema and allows entering data for a new row.

How to create a record:

1. Click the Add Record (plus) icon in the row of the desired table.
2. In the Create Record window, fill in the fields according to the table schema.
3. Click Add Record to save the record, or Close to cancel.

After confirmation, a new row appears in the data grid of the table.

Workflow Scenario#