joao-aires/agent-skills-public
Skill Claude Code
Investigate database workload performance and compare improvements while preserving correctness and operating budgets. Use for latency, throughput, contention, connection or resource bottlenecks before choosing engine-specific tuning.
joao-aires/agent-skills-public
Skill Claude Code
Develop or review PostgreSQL schemas, transactions, migrations and access policies. Use for SQL, data integrity, concurrency and engine-specific persistence behavior with the actual application roles and server version.
joao-aires/agent-skills-public
Skill Claude Code
Plan or perform scoped PostgreSQL backup/recovery, maintenance, replication and upgrades. Use for operating procedures and readiness with the actual hosting model, recovery objectives and authorized target.
joao-aires/agent-skills-public
Skill Claude Code
Diagnose and improve PostgreSQL query, locking, connection and maintenance performance using representative workload evidence. Use for slow queries, pool pressure, plan regressions and resource bottlenecks.
joao-aires/agent-skills-public
Skill Claude CodeCodex
Security hardening reviewer for GitHub Actions workflow files (.github/workflows/.yml). Reasons about the Actions threat model that pattern matchers and general code linters miss — untrusted-input script injection, privileged triggers running fork code, mutable action references, and over-scoped tokens. Use this skill…
joao-aires/agent-skills-public
Skill Claude Code
Automate browser interactions, test web pages and work with Playwright tests.
joao-aires/agent-skills-public
Skill Claude CodeCodex
Audits a project's dependencies for supply-chain risk: version-matched advisories for direct dependencies and the full lockfile tree, abandoned or archived upstreams, npm publisher concentration, and install-time script execution. Use when asked to audit dependencies, assess supply-chain or third-party package risk…
joao-aires/agent-skills-public
Skill Claude CodeCodex
Creates and maintains concise AGENTS.md and CLAUDE.md project instruction files. Use when asked to create AGENTS.md, update AGENTS.md, maintain agent docs, set up CLAUDE.md, document repository agent conventions, or keep coding-agent instructions minimal and reference-backed.
joao-aires/agent-skills-public
Skill Codex
Review the changes since a fixed point (commit, branch, tag, or merge-base) along two axes: Standards (does the code follow this repo's documented coding standards?) and Spec (does the code match what the originating issue/spec asked for?). Runs both reviews in parallel sub-agents and reports them side by side. Use…
joao-aires/agent-skills-public
Skill Codex
Shared vocabulary for designing deep modules. Use when the user wants to design or improve a module's interface, find deepening opportunities, decide where a seam goes, make code more testable or AI-navigable, or when another skill needs the deep-module vocabulary.
joao-aires/agent-skills-public
Skill Codex
Diagnosis loop for hard bugs and performance regressions. Use when the user says "diagnose"/"debug this", or reports something broken/throwing/failing/slow.
joao-aires/agent-skills-public
Skill Claude CodeCodex
Performs security-focused differential review of code changes. Adapts analysis depth to codebase size, uses git blame for context, calculates blast radius by counting callers, checks test coverage of modified code, and generates a markdown report. Use when reviewing a PR, commit, or diff for security vulnerabilities…
joao-aires/agent-skills-public
Skill Codex
Build and sharpen a project's domain model. Use when discussing codebase terminology, writing or editing a GLOSSARY.md, or recording or editing an ADR.
joao-aires/agent-skills-public
Skill Claude CodeCodex
A relentless interview to sharpen a plan or design.
joao-aires/agent-skills-public
Skill Claude CodeCodex
A relentless interview to sharpen a plan or design, which also creates docs (ADR's and glossary) as we go.
joao-aires/agent-skills-public
Skill Codex
Grill the user relentlessly about a plan, decision, or idea. Use when the user wants to stress-test their thinking, or uses any 'grill' trigger phrases.
joao-aires/agent-skills-public
Skill Claude CodeCodex
Compact the current conversation into a handoff document for another agent to pick up.
joao-aires/agent-skills-public
Skill Claude CodeCodex
Implement the result of /to-spec and /to-tickets in code.
joao-aires/agent-skills-public
Skill Claude CodeCodex
Implement a piece of work based on a spec or set of tickets.
joao-aires/agent-skills-public
Skill Claude CodeCodex
Scan a codebase for deepening opportunities, present them as a visual HTML report, then grill through whichever one you pick.
joao-aires/agent-skills-public
Skill Claude CodeCodex
Writes, reviews, and debugs property-based tests — Hypothesis, fast-check, proptest, jqwik, rapid, and Echidna or Medusa for Solidity invariants. Use whenever tests should cover a whole input domain instead of a hand-picked list of examples: encode/decode and serialize/deserialize pairs, parsers, canonicalizers and…
joao-aires/agent-skills-public
Skill Codex
Build a throwaway prototype to answer a design question. Use when the user wants to sanity-check whether a state model or logic feels right, or explore what a UI should look like.
joao-aires/agent-skills-public
Skill Codex
Investigate a question against high-trust primary sources and capture the findings as a Markdown file in the repo. Use when the user wants a topic researched, docs or API facts gathered, or reading legwork delegated to a background agent.
joao-aires/agent-skills-public
Skill Claude CodeCodex
Conduct a retrospective on a coding session.
At most 3 mods per repository are shown here, and a mod shipped inside a plugin is left to that plugin's page — the rest are on their repository pages: