johnqtcg/awesome-skills

A curated system of production-ready Claude Code skills with quantitative evaluation reports, golden test fixtures, and engineering workflow integration.

This repository also configures its own agents. See what awesome-skills tells them →

30Stars on the repository
67Mods indexed here, across every type
yesterdayLast push, which is what freshness is scored on
MITLicence, which decides whether bodies are shown

johnqtcg/awesome-skills

Skill Claude CodeCodex

Kafka event-driven architecture designer and reviewer, at the application/client layer. ALWAYS use when designing, reviewing, or troubleshooting how a service produces or consumes Kafka events — topic and partition-key design, producer and consumer client configuration, consumer group topology, event schema definition…

not rated 30 yesterday A SkillSpector: warn 191 tokens original MIT

load-test

26

johnqtcg/awesome-skills

Skill Claude Code

Performance load testing specialist for writing k6/vegeta/wrk scripts, defining SLOs, modeling scenarios (spike/soak/stress/breakpoint), analyzing results, and identifying bottlenecks. ALWAYS use when writing load test scripts, reviewing test results, designing test scenarios, setting performance SLOs, or diagnosing…

not rated 30 yesterday A SkillSpector: warn 121 tokens original MIT

local-transcript

27

johnqtcg/awesome-skills

Skill Claude Code

Transcribe a specified local video or audio file into cleaned final .txt, .pdf, or .docx transcripts using speech recognition with Apple Silicon GPU acceleration and optional LLM-based proofreading. Use when the user wants text extracted from a local media file path such as .mp4, .mov, .mkv, .webm, .mp3, .m4a, or…

not rated 30 yesterday A SkillSpector: pass 139 tokens original MIT

log-analyzer

28

johnqtcg/awesome-skills

Skill Claude Code

Senior-SRE log analysis specialist. Use when investigating incidents from logs, triaging error spikes, extracting timelines, correlating distributed traces, or separating signal from noise across plain-text, JSON (slog/zap), syslog, journald, container, and Kubernetes logs. ALWAYS use when the user asks to "analyze…

not rated 30 yesterday A SkillSpector: warn 138 tokens original MIT

mongo-migration

29

johnqtcg/awesome-skills

Skill Claude CodeCodex

MongoDB schema migration safety reviewer and migration script generator. ALWAYS use when writing, reviewing, or planning MongoDB schema changes — field additions/removals, index builds, schema validator changes, document type migrations, shard key modifications, or any bulk update touching production collections.…

not rated 30 yesterday A SkillSpector: warn 140 tokens original MIT

monitoring-alerting

30

johnqtcg/awesome-skills

Skill Claude Code

Monitoring and alerting design reviewer for production backend services. ALWAYS use when writing Prometheus alerting rules, designing Grafana dashboards, defining SLI/SLO, configuring alert routing (PagerDuty/OpsGenie/Slack), or reviewing existing monitoring setups. Covers SLI/SLO definition, alert rule quality…

not rated 30 yesterday A SkillSpector: pass 137 tokens original MIT

mysql-migration

31

johnqtcg/awesome-skills

Skill Claude CodeCodex

MySQL schema migration safety reviewer and DDL generator. ALWAYS use when writing, reviewing, or planning MySQL schema changes — ALTER TABLE, CREATE/DROP INDEX, column type changes, charset conversions, data backfills, or any DDL touching production tables. Covers online DDL algorithm selection (INSTANT/INPLACE/COPY)…

not rated 30 yesterday A SkillSpector: pass 132 tokens original MIT

johnqtcg/awesome-skills

Skill Claude CodeCodex

OceanBase distributed table design and modeling expert. Use this skill when the user: asks to design tables, schema, or DDL in OceanBase describes a workload and wants optimal schema design asks about partitioning, indexing, table groups, columnstore, or avoiding distributed transactions in OceanBase wants to review…

not rated 30 changed 4d ago C 111 tokens original MIT

oracle-migration

33

johnqtcg/awesome-skills

Skill Claude CodeCodex

Oracle Database schema migration safety reviewer and DDL generator. ALWAYS use when writing, reviewing, or planning Oracle schema changes — ALTER TABLE, CREATE/DROP INDEX, column type changes, constraint additions, partition DDL, or any DDL touching production tables. Covers DDL auto-commit implications…

not rated 30 yesterday A SkillSpector: pass 141 tokens original MIT

pg-migration

34

johnqtcg/awesome-skills

Skill Claude CodeCodex

PostgreSQL schema migration safety reviewer and DDL generator. ALWAYS use when writing, reviewing, or planning PostgreSQL schema changes — ALTER TABLE, CREATE/DROP INDEX, column type changes, constraint additions, RLS policy changes, or any DDL touching production tables. Covers lock-level analysis, CREATE INDEX…

not rated 30 yesterday A SkillSpector: warn 135 tokens original MIT

readme-generator

35

johnqtcg/awesome-skills

Skill Claude Code

Generate or refactor project README.md files using repository evidence. Use when the user asks to create/rewrite/standardize README, improve documentation structure, or produce maintainable README templates for different project types (service/library/CLI/monorepo).

not rated 30 yesterday A SkillSpector: warn 54 tokens original MIT

johnqtcg/awesome-skills

Skill Claude CodeCodex

Redis caching strategy designer and reviewer. ALWAYS use when designing, reviewing, or troubleshooting Redis caching layers — cache pattern selection (cache-aside, write-through, write-behind), TTL strategy, cache stampede/penetration/avalanche prevention, hot key handling, cache-DB consistency, distributed locking…

not rated 30 yesterday A SkillSpector: warn 113 tokens original MIT

security-review

37

johnqtcg/awesome-skills

Skill Claude Code

A code-security review guide that checks code changes, pull requests, or services for risks an attacker could exploit.

not rated 30 changed yesterday A SkillSpector: warn 164 tokens original MIT

stock-analysis-lead

38

johnqtcg/awesome-skills

Skill Claude Code

Orchestrate a US-stock investment analysis — classify sector archetype, fetch SEC filings, dispatch a tiered fan-out of six vertical equity-research agents (business model, earnings quality, balance sheet, management, industry, peer comparison) over a validated JSON findings contract, then synthesize a buy/hold/sell…

not rated 30 yesterday A SkillSpector: warn 229 tokens original MIT

johnqtcg/awesome-skills

Skill Claude Code

Review a US-listed company's balance sheet health for an equity-research workup. Covers net-debt/EBITDA leverage, current ratio, cash runway, goodwill concentration and impairment history, DSO trend, inventory days, off-balance-sheet items (operating leases, contingent liabilities), and pension underfunding. Trigger…

not rated 30 yesterday A SkillSpector: pass 107 tokens original MIT

johnqtcg/awesome-skills

Skill Claude Code

Review a US-listed company's business model and revenue structure for an equity-research workup. Covers product/service mix, customer concentration, geographic exposure, industry position, revenue-growth decomposition (organic vs acquired vs price vs volume), and information-tier discipline (which numbers are facts vs…

not rated 30 yesterday A SkillSpector: pass 121 tokens original MIT

johnqtcg/awesome-skills

Skill Claude Code

Review a US-listed company's earnings quality, cash-flow integrity, and operating leverage for an equity-research workup. Covers operating cash flow vs net income drift, free cash flow trajectory, capex character (maintenance vs expansion), equity issuance / shareholder-return yield, revenue-quality signals…

not rated 30 yesterday A SkillSpector: pass 147 tokens original MIT

johnqtcg/awesome-skills

Skill Claude Code

Review a US-listed company's industry position and competitive moat for an equity-research workup. Covers Porter Five Forces scan, market-share trend (absolute and relative to industry growth), TAM size and trajectory, unit economics where disclosed (LTV/CAC, unit gross margin), moat classification (network / brand /…

not rated 30 yesterday A SkillSpector: pass 147 tokens original MIT

johnqtcg/awesome-skills

Skill Claude Code

Review a US-listed company's management quality and capital-allocation track record for an equity-research workup. Covers 5-year capital-allocation history (buybacks vs dividends vs M&A vs capex vs debt), buyback timing, M&A return-on-investment, guidance-vs-actuals track record, comp-structure alignment, insider…

not rated 30 yesterday A SkillSpector: pass 126 tokens original MIT

johnqtcg/awesome-skills

Skill Claude Code

Independently benchmark a US-listed target equity against 2-4 closest peers on a fixed 12-item ratio panel — growth rates, profitability, capital intensity, balance sheet leverage, capital returns, and valuation multiples. Provides cross-validation for moat and market-share claims made by the business and industry…

not rated 30 yesterday A SkillSpector: pass 127 tokens original MIT

johnqtcg/awesome-skills

Skill Claude Code

Use when debugging, diagnosing, or investigating any bug, test failure, flaky test, race condition, unexpected behavior, build failure, production incident, third-party breakage, root cause analysis, or performance regression before proposing fixes.

not rated 30 yesterday A SkillSpector: warn 49 tokens original MIT

tdd-workflow

46

johnqtcg/awesome-skills

Skill Claude Code

Enforce practical Test-Driven Development for code changes in Go services. Use for new features, bug fixes, refactors, API changes, and new modules. Requires Red-Green-Refactor evidence, defect-hypothesis-driven tests, killer cases, and coverage gates (line + risk-path).

not rated 30 yesterday A SkillSpector: pass 65 tokens original MIT

tech-doc-writer

47

johnqtcg/awesome-skills

Skill Claude Code

A guide for writing, reviewing, and improving technical documents such as API documentation, design documents, runbooks, and incident reports.

not rated 30 yesterday A SkillSpector: warn 133 tokens original MIT

johnqtcg/awesome-skills

Skill Claude Code

Create and run gated Go integration tests for third-party APIs with real external calls, strict configuration gates, bounded timeouts, and safe runtime controls. Use for vendor/client contract verification and failure triage.

not rated 30 yesterday A SkillSpector: pass 47 tokens original MIT

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: