postgres_query
Run custom SQL queries on PostgreSQL, supporting complex joins, aggregations, and parameterized inputs to prevent SQL injection. Handles operations beyond standard tools.
Instructions
Execute a custom SQL query against the PostgreSQL database. Use this for complex queries, joins, aggregations, and any SQL operation not covered by other tools.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | SQL query to execute. Use $1, $2, etc. for parameters to prevent SQL injection. | |
| parameters | No | Optional array of parameters for parameterized queries |