transactions

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
`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"
}

Postgres MCP Server

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Postgres MCP Server

Related Tools

MCP directory API