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:
Open the UI Design module.
Open the Custom Actions panel and select SQL Action.
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
Click on the Generate with AI button.
Select the table and enter the query description.
Add the generated query to the SQL Editor.
Example Command: “Create a query that lists only active departments.”
Testing and Saving SQL Queries
Run the query with the TEST button in the upper right corner.
Save the action by pressing the CREATE button.
SQL Editor Developer Tools
Kuika SQL Editor supports the following developer tools to streamline the query writing process and improve code quality:
SQL Diagnostics: Syntax errors and potential issues in the written query are detected in real time; the user is alerted by highlighting the problematic areas.
SQL Completion: While writing queries, auto-completion suggestions are provided for table names, column names, and SQL keywords; this reduces typos and speeds up the development process.
SQL Formatter: It does not automatically format the query; when the TIDY UP button at the top of the SQL Editor is clicked, the query is formatted into a readable format by Kuika. Indentation, line spacing, and keyword consistency are adjusted during this process.
