pg_execute_query
Execute PostgreSQL SELECT queries, count rows, or check data existence with optional parameters and safety limits. Designed for efficient PostgreSQL database management and 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 |