Interact with databases: query, insert, update, or delete.

When to Use #

• Retrieve/store data in databases
• Update records
• Join data across tables
• Filter results

Settings #

Basic

• Description: Explain the DB operation
• Connection: Choose a database connection
• Operation: SELECT, INSERT, UPDATE, DELETE, stored procedure
• Table: Target table

SELECT

• Columns: Which to retrieve (* for all)
• WHERE: Add conditions (column, operator, value)
• JOIN: Join other tables (INNER, LEFT, RIGHT, FULL)
• ORDER BY: Sort
• LIMIT/OFFSET: Pagination

INSERT

• Map columns to values (static or {{$.variable}})

UPDATE

• SET: Which columns/values to update
• WHERE: Target records

DELETE

• WHERE: Target records to delete

Stored Procedure

• Procedure Name, Parameters

Tips #

• Use parameterized values for security
• Keep WHERE clauses specific
• Use LIMIT/OFFSET for large data sets
• Test queries in the database first
• Use ORDER BY for consistent results
• Handle NULLs as needed