Back to Genai Toolbox

postgres-execute-sql

docs/en/integrations/postgres/tools/postgres-execute-sql.md

1.1.01.5 KB
Original Source

About

A postgres-execute-sql tool executes a SQL statement against a Postgres database.

postgres-execute-sql takes one input parameter sql and run the sql statement against the source.

Note: This tool is intended for developer assistant workflows with human-in-the-loop and shouldn't be used for production agents.

Compatible Sources

{{< compatible-sources others="integrations/alloydb, integrations/cloud-sql-pg">}}

Example

yaml
kind: tool
name: execute_sql_tool
type: postgres-execute-sql
source: my-pg-instance
description: Use this tool to execute sql statement.

Reference

fieldtyperequireddescription
typestringtrueMust be "postgres-execute-sql".
sourcestringtrueName of the source the SQL should execute on.
descriptionstringtrueDescription of the tool that is passed to the LLM.