pg_execute_query
Execute SELECT queries, count rows, or check data existence in PostgreSQL databases. Pass parameters, set query limits, or define timeout for efficient data retrieval.
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) | |
| limit | No | Maximum number of rows to return (safety limit) | |
| operation | Yes | Query operation: select (fetch rows), count (count rows), exists (check existence) | |
| parameters | No | Parameter values for prepared statement placeholders ($1, $2, etc.) | |
| query | Yes | SQL SELECT query to execute | |
| timeout | No | Query timeout in milliseconds |