joao-aires/agent-skills-public/postgresql-development

Claude Code and agent skill by joao-aires/agent-skills-public

Trust tier 2
  • community
LLM review pending
Source check pending

Checking that the SKILL.md file is still in the repository.

Develop or review PostgreSQL schemas, transactions, migrations and access

Install

npx vskill@latest install joao-aires/agent-skills-public/postgresql-development

SKILL.md

The same SKILL.md was published earlier as joao-aires/agent-skills-public/postgresql-development.

Implement the PostgreSQL data contract

Identify the actual PostgreSQL version, hosting model, extensions, application roles, driver and migration tooling. Preserve accepted project choices. Establish the affected invariants and workload; if broader design is unresolved, use available data/service-design expertise or project evidence without requiring another plugin. Read source selection for provenance and version-matched primary references.

Represent facts and authority

Choose types, constraints and keys from meaning and access patterns:

  • Use appropriate numeric/time semantics; distinguish null, empty and absent values.
  • Enforce durable uniqueness and relationships where they express the contract.
  • Consider JSONB, arrays, generated columns, partitioning and extensions with their update, validation, indexing and operational consequences.

Use parameterized values through the actual driver; dynamic identifiers need separate validation/quoting. Derive tenant/resource authority from verified context. Application authorization remains necessary for allowed operations.

When using row-level security

Row-level security evaluates access under the database role and policy context of the statement. Establish how trusted application identity reaches that context and which code can change it. A custom session variable alone does not establish a trusted identity; an untrusted caller must not be able to choose the tenant that the policy trusts.

Check both which existing rows an operation can reach and which proposed row values it may create or retain. Exercise the policy through the application's actual role and connection-pool behavior, because a privileged migration or table-owner session may bypass the restriction being tested. Verify:

BoundaryCheck
Execution roleOwnership and BYPASSRLS/superuser behavior
Policy behaviorUSING and WITH CHECK semantics, including relevant functions/views
Connection contextWho can set it and how pools scope/reset it
EvidenceCross-tenant reads and writes through the actual application role

Handle concurrent operations deliberately

Start from the concurrent operations that could violate the rule. Prefer a database constraint or atomic statement when it expresses the rule directly. When an operation reads and then decides what to write, establish which concurrent changes the selected isolation and locking behavior permits before assuming the earlier read remains valid.

Treat a retryable transaction failure as a request to repeat the complete logical transaction with fresh reads. Keep attempts bounded and account separately for external effects, which the database cannot roll back. Choose transaction/isolation and locking behavior for the invariant.

  • Keep transactions bounded and avoid waiting on remote work while holding locks.
  • Use constraints and atomic statements where they settle races.
  • For serializable/deadlock retries, repeat the complete logical transaction safely, with bounded attempts and durable side-effect handling.
  • Give advisory locks a stable ownership/lifecycle convention; they do not replace constraints or authorization.

Change schemas with operational evidence

Examine lock modes, table size, existing values, write traffic, replicas and concurrent application versions before migration.

  • Where appropriate, separate compatible structure, bounded backfill, constraint validation and cleanup.
  • Choose index creation for the deployment. Concurrent creation has transaction, failure and invalid-index consequences; it is not required for every index.
  • Set bounded lock/statement behavior through the accepted tooling and plan retry/forward recovery.
  • Verify before removing old representations.

Verify the affected contract

  • Exercise SQL and migrations on representative PostgreSQL data with actual roles, not an engine substitute.
  • Inspect persisted state after failures, duplicate/conflicting requests and version transitions.
  • Report proposed versus executed work. Keep live mutation inside the user's named target and authorization.

Security

  • Security scanPassed, 100 of 100Pattern checks on the skill's files.
  • Model reviewNot runA model review is scheduled for the next rescan.

Quality evaluation

  • Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

Source

Popularity

Repository stars
2
Repository forks
1
7-day trend score
0

Stars and forks are for the whole GitHub repository, not this skill alone. Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

  • Claude Code
  • Cursor
  • GitHub Copilot
  • Windsurf
  • Codex
  • Gemini CLI
  • Cline
  • Amp
  • Roo Code
  • Goose
  • Continue
  • Kilo Code
  • Junie
  • Trae
  • OpenHands
  • Qwen Code
  • AI Agent
  • Tabnine Chat
  • Sourcegraph Cody
  • Amazon Q
  • Firebase Genkit
  • Sweep
  • Devin
  • Phind
  • Mentat
  • Claude Desktop
  • Aider
  • GPT Pilot
  • Plandex
  • bolt.new
  • v0
  • Replit Agent
  • Anse
  • TypingMind
  • BetterChatGPT
  • LibreChat
  • Warp AI
  • Pieces
  • Fig AI
Embed badge
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/joao-aires/agent-skills-public/postgresql-development/badge)](https://verified-skill.com/skills/joao-aires/agent-skills-public/postgresql-development)

Something wrong with this skill or its page? Tell us.