MCP PostgreSQL Operations

[Tool Purpose]: Analyze query conflicts in standby/replica database environments

[Exact Functionality]:

• Show conflict statistics for standby servers (only relevant on replicas)

• Display conflicts by type (tablespace, lock, snapshot, bufferpin, deadlock)

• Help diagnose replication-related performance issues

• Provide conflict resolution statistics

[Required Use Cases]:

• When user requests "replication conflicts", "standby conflicts", etc.

• When analyzing replica server performance issues

• When troubleshooting replication lag or conflicts

• When monitoring standby server health

[Strictly Prohibited Use Cases]:

• Requests for conflict resolution actions

• Requests for replication configuration changes

• Requests for statistics reset

Args: database_name: Database name to analyze (uses default database if omitted)

Returns: Database conflict statistics (meaningful only on standby servers)