All authors
Claude Skills by adnanmokhtar
github.com/adnanmokhtar258 skills0 installs0 views
- Contract DiffTables others read: unenforced contracts, unversioned breaks, SELECT *, migrations under readers, timestamp mixing.Votes: 0GitHub stars: 2
- Data Test Scandbt, GX and Soda data tests that cannot fail or never run: grain, warn-only, empty slices, freshness.Votes: 0GitHub stars: 2
- Derived Data ScanRollups, materialized views and trigger-kept tables vs their sources; bucket SQL zones and DST.Votes: 0GitHub stars: 2
- Extract ScanExports and dumps as faithful copies; OFFSET paging of mutating tables, no snapshot, silent caps, lossy values.Votes: 0GitHub stars: 2
- Grain ProbeProve a model's grain by probe: offline duckdb build first; dry-run cost guard before any warehouse count(distinct).Votes: 0GitHub stars: 2
- Incremental Load ScanBatch and incremental loads: lookback, merge key, deletes, dedup, schema drift, overwrite scope, backfill, CDC.Votes: 0GitHub stars: 2
- Lineage TraceModel graph without dbt: hard-coded relations, layer breaks, undeclared readers, orphans; up/downstream trace of a node.Votes: 0GitHub stars: 2
- Orchestration ScanAirflow, Dagster, Prefect DAGs: wall-clock windows, parse-time I/O, overlap, trigger rules, retries, Airflow 3.Votes: 0GitHub stars: 2
- Pii Copy ScanPersonal data copied into models, rollups, snapshots and exports; classification, erasure reach, masking.Votes: 0GitHub stars: 2
- Warehouse Scan AuditPipeline SQL that scans more than it reads: unpruned partitions, unbounded merges, full rebuilds, view chains; offline first.Votes: 0GitHub stars: 2
- Connection Config ScanAudit how the app connects to its database — a client per request, pool size × processes × replicas against max_connections or the pooler, transaction-pooler incompatibilities, serverless storms, missing statement, idle-in-transaction, lock and acquire timeouts, reads-after-write on a replica, leaked connections, and session settings that weaken integrity.Votes: 0GitHub stars: 2
- Index Coverage ScanIndex-coverage detector — FK columns with no usable index (engine- and ORM-aware), filter and sort paths no index serves, wrong composite order, duplicate prefixes, unused indexes, missing expression or partial indexes, write-amplifying indexes. Static lane always; live lane read-only.Votes: 0GitHub stars: 2
- Migration RehearsalRun a pending migration against a restored prod-sized copy. Measure duration, the lock profile, the algorithm the engine actually chose, and rollback behaviour. Postgres and MySQL lanes. Do this BEFORE prod.Votes: 0GitHub stars: 2
- Migration SafetyMigration safety detector — blocking index builds, table rewrites, NOT NULL and constraints validated under the table lock, same-deploy drops and renames the running release still reads, missing lock timeouts, data inside DDL, irreversible steps, edited applied migrations. Linter lanes plus a safe / safe-with-pattern / unsafe op-class per engine and version.Votes: 0GitHub stars: 2
- N Plus One ScanFind per-element database round trips — a relation or query touched inside a loop, parallel single-row reads, a resolver per parent with no batch loader, row-by-row writes, per-row counts, joins that multiply rows — across the ORM lanes, each proved by a query-count scaling test.Votes: 0GitHub stars: 2
- Query Shape ScanFind reads whose cost grows with the table — no LIMIT on a growing table, deep OFFSET, over-fetch, predicates no index can serve, filtering or paging in application code, counts used as existence checks, unbounded IN lists, unstable page order — each proved by a plan or a seeded-cap test.Votes: 0GitHub stars: 2
- Schema Consistency AuditSchema + migration consistency audit. Detects drift in nullability, type choice, timezone handling, charset/collation, timestamp and audit-field coverage, soft-delete coverage, migration patterns, and object naming. Findings are ranked by data-integrity risk, not by detector order. Emits closure verbs that ship as reversible migrations. Used by /polish on data-* stacks and /db-audit.Votes: 0GitHub stars: 2
- Schema DiffDiff the ORM entities against the actual DB schema — catch drift between code and reality. Run before generating a new migration (drift corrupts autogenerate output), after an out-of-band hotfix, and weekly in CI against a restored backup. Detects drift only — `migration-rehearsal` is what proves the corrective migration is safe to apply.Votes: 0GitHub stars: 2
- Schema Integrity ScanSchema-integrity detector — relations with no database FK, FKs with no explicit ON DELETE, natural keys with no unique constraint, money as float, instants without a time zone, missing NOT NULL or CHECK, int32 keys, auto schema sync in production, soft-delete bypasses, PII storage, gapless numbers from a sequence.Votes: 0GitHub stars: 2
- Transaction ScanFind transactions that hurt the database — external I/O held inside one, multi-step writes without one or on the wrong handle, inconsistent lock order, SERIALIZABLE or optimistic locks with no retry, queue claims without SKIP LOCKED, long transactions, write skew, lost updates on non-abuse fields, hot rows and savepoints in loops.Votes: 0GitHub stars: 2
- Lane BackendBackend build lane of a delivery run — sibling-mirror premise, prior-art and new-dependency gates, signal→binding-constraint tables, generate rules, lens dispatch by touch and domain, spec conformance. Read by @architect, @implementer and /add-feature; not run on its own.Votes: 0GitHub stars: 2
- Lane FrontendFrontend build lane of a delivery run — sibling/wrapper-mirror premise, intent, prior-art and data-sensitivity gates, the UI design slice, generate rules, lens set by tier, nav-speed/SEO/a11y/i18n validation, spec conformance. Read by @architect, @implementer and /add-feature; not run on its own.Votes: 0GitHub stars: 2
- Lane MobileMobile build lane of a delivery run — sibling-mirror premise (navigation, state, offline, permissions, native config, i18n), the mobile design slice, generate rules, lens set, device/offline/deep-link validation, spec conformance. Read by @architect, @implementer and /add-feature; not run on its own.Votes: 0GitHub stars: 2
- Compose ScanCompose stacks that start wrong: depends_on, healthchecks, overrides.Votes: 0GitHub stars: 2
- Container Build ScanDockerfiles that build green and fail later: PID 1, stage-chain user, cache order, lockfile, healthcheck, size.Votes: 0GitHub stars: 2
- Deploy Safety ScanDeploys that race, half-apply or drop work: migration topology, deploy locks, gates, shutdown, env drift.Votes: 0GitHub stars: 2
- Gitops AuditGit-to-cluster reconciliation: kubectl/helm/argocd/flux bypassing a GitOps-managed namespace, live drift, unseen drift.Votes: 0GitHub stars: 2
- Monitor DeployWatch a just-shipped deploy until it proves healthy (or rolls back). Polls health/readiness, error rate, and latency against a baseline for an observation window; on threshold breach it surfaces evidence and triggers /rollback-deploy. The executor behind /deploy-stage's --watch / --no-monitor and the recovery confirmation in /rollback-deploy.Votes: 0GitHub stars: 2
- Pipeline Cache ScanCI caches serving stale deps: keys, restore-keys, buildx scopes.Votes: 0GitHub stars: 2
- Pipeline Integrity ScanCI lets a red build merge or deploy: masked gates, lost exits, skip-satisfied checks, ungated deploys.Votes: 0GitHub stars: 2
- Progressive DeliveryCanary gates that cannot fail and flags that cannot be flipped: dead, stale, unsafe default, build-time.Votes: 0GitHub stars: 2
- Release Integrity ScanReleases you cannot trust or undo: movable tags, split versions, rebuilt-after-scan images, verify-anything, pruned N-1.Votes: 0GitHub stars: 2
- Release SecurityImage gate runner: scan the built digest, SBOM, sign and attest, verify by exact identity; cosign ≥ 3.1.3.Votes: 0GitHub stars: 2
- Chaos TestInject failures (network, latency, crashes) against a running service to verify resilience. Run after adding an external dependency (cache, queue, third-party API), before promoting a service to a higher SLO tier, or before a high-traffic event. Requires a running service — this is not a static resilience review.Votes: 0GitHub stars: 2
- Coordination ScanLocks, leases, leaders, clocks: release, TTL, renewal, advisory locks, wall-clock time, DST — read-only.Votes: 0GitHub stars: 2
- Dlq ReplayReplay a dead-letter queue or failed set after its cause is fixed: dry-run list, sample one, native redrive, rate-limited, verified.Votes: 0GitHub stars: 2
- Dual Write ScanDual write: commit/publish order, outbox use, relay, inbox atomicity, CDC, gap-blind cursors — read-only.Votes: 0GitHub stars: 2
- Event Contract ScanEvent contracts: schema compatibility, tolerant readers, naming, event-store appends, projections — read-only.Votes: 0GitHub stars: 2
- Messaging ScanQueue semantics: ack order, consumer idempotency, poison/DLQ, ordering, rebalance, lock vs run — read-only.Votes: 0GitHub stars: 2
- Retry Deadline ScanRetries and deadlines: eligibility, caps, backoff, nested layers, non-idempotent retries, propagation — read-only.Votes: 0GitHub stars: 2
- Workflow ScanDurable workflows and sagas: determinism, versioning, activity config, compensation — read-only.Votes: 0GitHub stars: 2
- Changelog GenerateGenerate release notes from commit / PR history: breaking first with migration notes, computed semver bump; handles a repo with no tags.Votes: 0GitHub stars: 2
- Diagram SyncArchitecture diagrams vs the real module graph: boxes naming deleted modules (DF-3), missing nodes, wrong C4 level; regenerates mermaid / C4.Votes: 0GitHub stars: 2
- Doc Drift ScanHuman docs vs code and config: dead paths, symbols, scripts, flags, env, endpoints, pins, breaking notes, runbooks.Votes: 0GitHub stars: 2
- Doc Sample ScanDoc samples that must run: fences compile, doctests print what they say, embeds in sync, harness in CI, spec examples.Votes: 0GitHub stars: 2
- Doc Structure ScanHuman docs vs docs: links, anchors, the docs gate, ADR graph, changelog grammar, translations, placeholders, nav.Votes: 0GitHub stars: 2
- Docstring CoveragePublic API reference: undocumented exports (ratchet), docstrings that contradict the signature, broken doc-comment links. Read-only.Votes: 0GitHub stars: 2
- Quickstart VerifyRun a doc's setup steps in a disposable, offline container pinned to the repo's versions, never on the host; static pre-pass otherwise.Votes: 0GitHub stars: 2
- Allocation ScanAllocation tags and labels: IaC keys and values, pod-template labels, runbook-created resources (TG-1…4).Votes: 0GitHub stars: 2
- Candidate PricingPrices other detectors' quantity rows from a bill line or a dated page; flat-rate gate; price provenance.Votes: 0GitHub stars: 2