pg_execute_query
Execute PostgreSQL SELECT queries to retrieve data, count rows, or check record existence using parameterized queries with optional safety limits.
Instructions
Execute SELECT queries and data retrieval operations - operation="select/count/exists" with query and optional parameters. Examples: operation="select", query="SELECT * FROM users WHERE created_at > $1", parameters=["2024-01-01"]
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionString | No | PostgreSQL connection string (optional) | |
| operation | Yes | Query operation: select (fetch rows), count (count rows), exists (check existence) | |
| query | Yes | SQL SELECT query to execute | |
| parameters | No | Parameter values for prepared statement placeholders ($1, $2, etc.) | |
| limit | No | Maximum number of rows to return (safety limit) | |
| timeout | No | Query timeout in milliseconds |