# locksmith

> locksmith — cxk280-locksmith. Use this tool when you need to identify and mitigate locking risks in PostgreSQL statements to prevent database deadlocks and errors. It analyzes SQL migrations and provides safe rewrites to ensure secure database operations. Ideal for use cases involving complex database transactions, high-traffic databases, or critical data integrity requirements.

Canonical page: https://skillsregistry.net/skills/cxk280-locksmith  
JSON: https://api.skillsregistry.net/v1/skills/cxk280-locksmith

## Description

An MCP server that catches dangerous SQL migrations by analyzing PostgreSQL statements for locking risks and providing safe rewrites.

## Trust

- **Trust score (0–1):** 0.70
- **Verification tier:** verified
- **Last scanned:** 2026-09-03

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-03

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/rxfdm5157c)
- **Repository:** <https://github.com/cxk280/locksmith>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "cxk280-locksmith"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/cxk280-locksmith` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/cxk280-locksmith/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt