Skip to main content
skill CX Codex

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.

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add woocommerce/woocommerce --skill woocommerce-performance -a claude-code
Open on GitHub

What 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 postmeta joins 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-code

2Manually: put the files in place

~/.claude/skills/woocommerce-performance/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/woocommerce-performance/

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.

Similar skills

Everything for Code review and refactoring →

From the same set3

Project sponsors

Companies that keep this analytics open
Gold sponsor

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor