Harness-engineering db-pessimistic-locking

name: db-pessimistic-locking

install
source · Clone the upstream repo
git clone https://github.com/Intense-Visions/harness-engineering
manifest: agents/skills/claude-code/db-pessimistic-locking/skill.yaml
source content

name: db-pessimistic-locking version: '1.0.0' description: SELECT FOR UPDATE, lock granularity, lock duration, and row-level locking strategies stability: static cognitive_mode: advisory-guide type: knowledge tier: 3 triggers:

  • manual platforms:
  • claude-code
  • gemini-cli
  • cursor
  • codex tools: [] paths: [] related_skills:
  • db-optimistic-locking
  • db-deadlock-prevention
  • db-isolation-levels
  • db-mvcc
  • db-acid-properties
  • prisma-transactions
  • drizzle-transactions stack_signals:
  • postgresql
  • mysql
  • database keywords:
  • pessimistic-locking
  • select-for-update
  • row-lock
  • lock-granularity
  • lock-duration
  • exclusive-lock
  • shared-lock
  • FOR-NO-KEY-UPDATE metadata: author: community upstream: postgresql.org/docs/current/explicit-locking.html state: persistent: false files: [] depends_on: []