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