Examining the Datasources Module

Follow these steps to create a data source connection with artificial intelligence in the Datasources module:

1. Log in to the Kuika platform and open the project you will work with from the Apps screen.

2. The screen will display Managed DB, a default local database created by Kuika.

• Thanks to Managed DB, you can develop and publish your application without the need for an additional database server.
• The relationships between database tables are also shown on this screen.

3. In the left menu, you can view the data sources, actions and tables in your application and add a new datasource, action or table.

• The Datasource panel has Actions and Tables sub-tabs by default.

Creating a SQL Action

1. Click the + icon next to the Actions heading in the left panel.
2. Select New SQL Action from the drop-down menu.

3. Write your SQL query via SQL Editor and click the CREATE button on the top right.
4. To create a SQL query with artificial intelligence, you can get suggestions by activating the Generate with AI option.
5. The generated action can be viewed in the left panel, then edited, renamed or deleted.

• For editing: Hover over the action and use Edit.
• To update: Edit the SQL query and click the Update button.
• To delete: Use the Delete option in the drop-down menu.

Creating a Select Action

1. Click the + icon next to the Actions heading in the left panel.

2. Select New Select Action from the drop-down menu.
3. In the window that opens, give the action a name.
4. Click the + icon to select the data source.
5. Define Fields, Filter and Sort Order fields according to your needs.

Table Creation

With Kuika you can quickly add a new table to the data source.

1. Click the + icon next to the Tables heading in the left panel.

2. Select New Table from the drop-down menu.
3. In the Create a New Table screen, name the table and click Next.

4. Enter the column information:
   
   • Column Name
   • Type: Data Type
   • Required: Whether it is a mandatory field
   • Unique: Whether it is unique
5. Click the ADD button.
6. Click the CREATE button to complete the table insertion process.

You can activate the Kuika AI button to use artificial intelligence suggestions.

Editing and Deleting a Table

• To edit the table: Select the table in the left panel and click the ellipsis. You can update the existing table using the Edit option.‍
• To delete a table: Click Delete.

Viewing and Editing Table Data with “Browse Data”

At design time, you can view and edit a table’s data directly through the platform interface. This allows you to create test data, edit existing records, or import/export data without needing a separate database client.

Access: DataSource → ManagedDB → when you hover over any table, the Browse Data (table icon) and ellipsis menu icons appear.

System Tables: System tables such as KApplication and KUser open in read-only mode: "System table — view only. You can read rows here, but edits, imports, and exports are disabled.“ message appears, and the SAVE/DISCARD buttons become disabled.

Hiding Sensitive Columns: In tables containing sensitive data, such as KUser, columns like passwords are automatically hidden, and the ”X sensitive columns hidden" warning is displayed.

Adding and Editing Data

• + Insert row can be used to add a new row.
• For GUID fields, the New GUID button can be used to generate an automatic value.
• Cells can be edited by clicking directly on them.

Save / Discard: Changes made activate the SAVE button; changes can be undone with DISCARD.

Undo / Redo: Changes can be undone or redone using the Cmd+Z (Undo) and Cmd+Shift+Z (Redo) shortcuts.

Generating Data with AI: Generate with AI Sample data rows can be generated using this button. The generated records first appear as draft inserts; they can be reviewed before saving and then saved to the database.

Show/Hide Columns: Using the Show / hide columns feature on the toolbar, you can hide or show specific columns; Show all and Reset widths options are available.

Column-Based Filtering: You can narrow down the data list by applying a filter to any column; the filter can be cleared using Clear filter.

Right-Click (Context Menu) Actions: Right-clicking a row displays the following options: Set [field] to null, Export selection, Clone row, Fill column from this row, Duplicate selected, Delete selected, Clear selection.

Export: Data can be exported in CSV, Excel (XLSX), SQL INSERT, SQL UPDATE, and SQL UPSERT (MERGE) formats.

Import: Data can be imported from CSV or Excel (.xlsx) files; Insert, Update existing, and Dry run modes are supported.

Preview SQL: Before saving, the SQL query corresponding to the changes made can be viewed as a preview (Preview SQL).