transactions
Manage PostgreSQL database transactions with actions including begin, commit, rollback, and savepoint operations for controlled data modifications.
Instructions
Transaction management: begin, commit, rollback, savepoints
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | Yes | Action: begin (start transaction), commit (commit transaction), rollback (rollback transaction), savepoint (create savepoint), rollback_to (rollback to savepoint), release (release savepoint), status (transaction status) | |
| isolationLevel | No | Transaction isolation level (for begin action) | |
| readOnly | No | Start read-only transaction (for begin action) | |
| savepointName | No | Savepoint name (required for savepoint, rollback_to, release) | |
| transactionId | No | Transaction ID (required for commit, rollback, and operations within transaction) |
Input Schema (JSON Schema)
{
"properties": {
"action": {
"description": "Action: begin (start transaction), commit (commit transaction), rollback (rollback transaction), savepoint (create savepoint), rollback_to (rollback to savepoint), release (release savepoint), status (transaction status)",
"enum": [
"begin",
"commit",
"rollback",
"savepoint",
"rollback_to",
"release",
"status"
],
"type": "string"
},
"isolationLevel": {
"description": "Transaction isolation level (for begin action)",
"enum": [
"READ UNCOMMITTED",
"READ COMMITTED",
"REPEATABLE READ",
"SERIALIZABLE"
],
"type": "string"
},
"readOnly": {
"default": false,
"description": "Start read-only transaction (for begin action)",
"type": "boolean"
},
"savepointName": {
"description": "Savepoint name (required for savepoint, rollback_to, release)",
"type": "string"
},
"transactionId": {
"description": "Transaction ID (required for commit, rollback, and operations within transaction)",
"type": "string"
}
},
"required": [
"action"
],
"type": "object"
}