Designing indexes and the queries that use them: what an index costs on write and in space, the access paths a planner can choose, composite column order, covering and partial indexes, selectivity and statistics, and partition pruning. It explains access paths and their costs; it never recommends a database product and never promises a latency. Use when asking "database index", "which columns to index", "composite index order", "covering index", "query plan", "why is this query slow", "full table scan", "index selectivity", "partition pruning", "explain plan". Not for schema shape and migrations (ac-database-changes), not for application-level caching (ac-caching-and-invalidation), not for end-to-end latency work and profiling (ac-performance).
cp -r cryptoskill/skills/exchanges/anoscranel-ac-query-and-index-design .claude/skills/clawhub install anoscranel-ac-query-and-index-designCapabilities below are detected automatically by an open-source scanner that reads the skill's text and scripts (see how this is computed). Not measured means the scanner couldn't make a confident call — it is NOT a green check, and you should treat it as a possible red flag until a human or a stronger scanner has measured it.
read_only Phase 1 single-mode classification — multi-mode breakdown deferred to Phase 2.
We did not find any well-known hosted services in this skill's text or scripts. This does NOT mean the skill is local-only — it might use services we don't yet recognize, or talk to them through code paths our scanner can't reach. A complete dependency list (every package, library, and binary, with integrity hashes) is on the roadmap; today we only show recognized hosts.
No one has audited this skill yet. That is different from “audited and clean” — it just means no professional reviewer (a security firm, the CryptoSkill team, or a verified independent researcher) has signed off on it. There are no audit reports to read. How reviewer levels work →
SKILL.md → SOURCE.md → TRUST.auto.yaml → Browse directory →
Auto-generated by cryptoskill/extract-capabilities/0.3.1 · hosted-service list version 2026-09-06 · how this is computed