Actions62
- SQL Actions
- Client Access Actions
- User Access Actions
- Tools Actions
- HTML to PDF
- Markdown to PDF
- Text to PDF
- Merge PDFs
- Split PDF
- Extract PDF Text
- Resize Image
- Convert Image
- Compress Image
- Add Image Watermark
- Create Thumbnail
- Generate Barcode
- Read Barcode
- Validate CPF/CNPJ
- Format CPF/CNPJ
- Generate UUID
- Transform JSON
- CSV to JSON
- JSON to CSV
- Normalize Text
- Extract Regex Fields
- Validate JSON Schema
- Generate Hash
- HMAC Sign
- Base64 Encode/Decode
- JWT Decode
- Encrypt Text
- Decrypt Text
- Format Date
- Parse Date
- Add Business Days
- Format Currency
- Number to Words
- Build Socket Event Payload
- Validate Client Token
- Validate Agent Context
- Build SQL Request
- Parse SQL Rows
- Generate Access Request Summary
- Publish Socket Event
- Wait for Socket Event
Tools → Build SQL Request
AI-generatedSummary
Builds a SQL request command for a specified Plug Database agent, incorporating a SQL query with parameters, and stores the result in a JSON property for use later in the workflow.
Inputs
- Tool Category — Select the group of related tools to display (e.g., Documents, Image, Data), defaulting to 'documents' but does not affect this operation's execution.
- Agent ID (required) — Specify the unique identifier of the Plug Database agent for which to build the SQL request.
- SQL (required) — Enter the SQL query string to be used in the SQL request.
- Params JSON (required) — Provide an array of parameters in JSON format to safely parameterize the SQL query.
- Output JSON Property — Define the JSON property name where the built SQL request command will be stored; defaults to 'sqlRequest'.
Output shape
a single JSON object representing the built SQL request command
The built command includes the agent ID, SQL string, and associated parameters, structured for execution by other Plug Database operations or nodes. The output is placed under the JSON property specified by 'Output JSON Property'.
Examples
Example 1: Build a parameterized SQL query command for agent 'agent123' selecting from a users table
Set Tool Category as desired (optional), specify 'agent123' as Agent ID, input a SQL query like 'SELECT * FROM users WHERE status = ?', provide corresponding parameters JSON array ['active'], and set Output JSON Property to 'sqlRequest'. The node outputs a JSON object under 'sqlRequest' containing the prepared SQL command and parameters ready for execution.