woocommerce-performance — Claude Code skill: what it does
Flags database and caching bottlenecks in WooCommerce PHP code. Useful when writing custom SQL queries or rendering catalog lists.
npx skills add woocommerce/woocommerce --skill woocommerce-performance -a claude-codeWhat woocommerce-performance does
The skill inspects WooCommerce PHP code to catch database bottlenecks and missing cache warmups. It validates data retrieval logic. The guidelines assist during code reviews and while writing new routines for the product catalog.
The instructions focus on two areas. Cache priming covers post objects via _prime_post_caches() alongside non-autoloaded options using wp_prime_option_caches(). Query analysis flags repetitive database lookups, steering queries toward lookup tables like wc_product_meta_lookup.
The rule set targets WordPress database architecture directly. Skipping these checks causes MySQL to execute heavy table scans across unindexed postmeta records.
What it helps with
- prevent redundant SQL queries when loading products
- prime post caches using
_prime_post_caches() - batch load non-autoloaded options with
wp_prime_option_caches() - replace expensive
postmetajoins with WooCommerce lookup tables
Example prompts for the agent
- Review this WooCommerce order query method for missing cache priming
- Optimize this custom SQL query to use wc_product_meta_lookup instead of postmeta
- Check this options loop and add wp_prime_option_caches
How to install woocommerce-performance
1Skills CLI (Vercel)
npx skills add woocommerce/woocommerce --skill woocommerce-performance -a claude-code2Manually: put the files in place
~/.claude/skills/woocommerce-performance/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/woocommerce-performance/
1Skills CLI (Vercel)
npx skills add woocommerce/woocommerce --skill woocommerce-performance -a codex2Manually: put the files in place
.agents/skills/woocommerce-performance/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add woocommerce/woocommerce --skill woocommerce-performance -a cursor2Manually: put the files in place
.cursor/skills/woocommerce-performance/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install woocommerce/woocommerce woocommerce-performance2Manually: put the files in place
.github/skills/woocommerce-performance/SKILL.md1Skills CLI (Vercel)
npx skills add woocommerce/woocommerce --skill woocommerce-performance -a gemini-cli2Platform CLI
gemini skills install https://github.com/woocommerce/woocommerce --path .ai/skills/woocommerce-performanceManually: put the files in place
.devin/skills/woocommerce-performance/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add woocommerce/woocommerce --skill woocommerce-performance -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about woocommerce-performance
How do I install woocommerce-performance in Claude Code?
Run npx skills add woocommerce/woocommerce --skill woocommerce-performance -a claude-code in your terminal.
What does woocommerce-performance do?
It reviews WooCommerce PHP code to identify missing cache warming, N-query loops, and unoptimized SQL joins across database tables.
Which options does wp_prime_option_caches target?
It targets non-autoloaded options requested inside loops or methods. Autoloaded options are already in memory, so priming them is unnecessary.