- Home
- Skills
- Agents & Orchestration
- Repair Postgres Advisory Lock Leakage
More screenshots
Works with the AI Agents you already use
Repair Postgres Advisory Lock Leakage
Find advisory-lock ownership leaks that block background jobs after pooled database connections are reused.
$1
About this skill
Find advisory-lock ownership leaks that block background jobs after pooled database connections are reused.
What it checks:
- map session versus transaction lock scope
- identify leaked pool borrowers
- constrain acquisition release paths
- add cancellation and crash simulation tests
Deliverables:
- lock lifetime diagram
- scoped SQL patch
- concurrency regression cases
Typical case: A job succeeds once and every later job waits behind an advisory lock held by an idle pooled connection.
Runtime: ChatGPT Skill
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Agents & Orchestration.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 1 month ago
Permissions
No special permissions declared or detected