postgres-execute-sql Tool

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

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

This tool can be used with the following database sources:

Source Name
PostgreSQL Source
⚠️ Source not found at path: integrations/alloydb-pg
Cloud SQL for PostgreSQL Source

Example

kind: tools
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.