SQL Query Executor Tool
The SQL Query Executor Tool enables your agent to run SQL queries against a configured relational database and return the results. This tool supports read and write operations and can be used to retrieve data, insert records, or perform updates as part of an agent's workflow, facilitating data-driven automation and decision-making. It also provides feedback on query execution.
| Field | Description |
| *Indicates mandatory field | |
| Name* | A unique, user-defined name for this instance of the SQL Query Executor Tool. This name is used by the agent to invoke the tool during runtime. |
| Description* | Describes the purpose of this tool instance. Helps users understand its role in the agent’s workflow. Example: Use this tool to fetch customer data from the PostgreSQL database. |
| Database Type* | The type of relational database the tool will connect to. Supported values typically include PostgreSQL, SQLite. Select the correct type to ensure proper query execution. |
| URL* |
The JDBC or database connection string required to access the database. This should include the protocol, host, port, and database name. Example: jdbc:postgresql://db.example.com:5432/analytics |
| Credentials to connect with (appears when you select Postgres in the Database Type field) | Select the database credential that provides authenticated
access. The credential must include valid username, password, and
optionally SSL configuration, depending on your environment. Note: Refer to the Adding a Credential section for steps to configure
this. |