pg_query
Run parameterized SQL queries with placeholder parameters. Returns query results as JSON rows. Supports safe parameter injection using $1, $2, etc.
Instructions
Execute a parameterized SQL query. Returns rows as JSON. Use $1, $2, ... for parameters.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | SQL query with $1, $2, ... placeholders | |
| params | No | JSON array of parameter values for placeholders | |
| target | Yes | Target name from ~/.dbx/targets/ |