pg_execute_sql
Execute any valid SQL statement on PostgreSQL, including complex queries, with optional parameters, transactional support, and query timeouts for efficient database management.
Instructions
Execute arbitrary SQL statements - sql="ANY_VALID_SQL" with optional parameters and transaction support. Examples: sql="CREATE INDEX ...", sql="WITH complex_cte AS (...) SELECT ...", transactional=true
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionString | No | PostgreSQL connection string (optional) | |
| expectRows | No | Whether to expect rows back (false for statements like CREATE, DROP, etc.) | |
| parameters | No | Parameter values for prepared statement placeholders ($1, $2, etc.) | |
| sql | Yes | SQL statement to execute (can be any valid PostgreSQL SQL) | |
| timeout | No | Query timeout in milliseconds | |
| transactional | No | Whether to wrap in a transaction |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"connectionString": {
"description": "PostgreSQL connection string (optional)",
"type": "string"
},
"expectRows": {
"default": true,
"description": "Whether to expect rows back (false for statements like CREATE, DROP, etc.)",
"type": "boolean"
},
"parameters": {
"default": [],
"description": "Parameter values for prepared statement placeholders ($1, $2, etc.)",
"items": {},
"type": "array"
},
"sql": {
"description": "SQL statement to execute (can be any valid PostgreSQL SQL)",
"type": "string"
},
"timeout": {
"description": "Query timeout in milliseconds",
"type": "number"
},
"transactional": {
"default": false,
"description": "Whether to wrap in a transaction",
"type": "boolean"
}
},
"required": [
"sql"
],
"type": "object"
}