execute
Run INSERT, UPDATE, or DELETE queries on the PostgreSQL server with parameterized SQL for secure data modification.
Instructions
Execute an INSERT, UPDATE, or DELETE query
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | No | Query parameters (optional) | |
| sql | Yes | SQL query (INSERT, UPDATE, DELETE) (use $1, $2, etc. for parameters) |
Input Schema (JSON Schema)
{
"properties": {
"params": {
"description": "Query parameters (optional)",
"items": {
"type": [
"string",
"number",
"boolean",
"null"
]
},
"type": "array"
},
"sql": {
"description": "SQL query (INSERT, UPDATE, DELETE) (use $1, $2, etc. for parameters)",
"type": "string"
}
},
"required": [
"sql"
],
"type": "object"
}