Create SQL Action with Artificial Intelligence Assistant in UI Design Module

You can create custom actions in Kuikada via UI Design or Datasources modules.

Steps:

1. Open the UI Design module.
2. Open the Custom Actions panel and select SQL Action.
3. Specify the action name and write your query in SQL Editor.

Creating SQL Queries

Kuika allows you to quickly add basic SQL queries:

• Add Select Query: List records in a table.
• Add Select By Id Query: Pull data based on a specific ID.
• Add Save Query: Insert or update data.
• Add Delete Query: Delete a specific record.
• Add Search By Keyword Query: Search data by keyword.
• Add Search With Pagination Query: Search data with pagination.

SQL Query Generation with Artificial Intelligence Assistant

1. Click on the Generate with AI button.
2. Select the table and enter the query description.
3. Add the generated query to the SQL Editor.

Example Command: “Create a query that lists only active departments.”

Testing and Saving SQL Queries

1. Run the query with the TEST button in the upper right corner.
2. Save the action by pressing the CREATE button.