Embedding models turn text into coordinates, and that is what vector search is really matching on. This covers tokenization, chunking, cosine similarity and fine-tuning a model so it fits your own catalog rather than the general web.
AI tools guess at your store because they cannot see it. MCP gives them real context: your files, your data, your WP-CLI. We talk it through at WooCommerce office hours on April 15, 2026, on Slack.
Pinecone and Chroma are a lot of machinery for a few hundred Markdown notes. The Google Memory Agent Pattern keeps structured memories in SQLite, consolidates them in the background, and loads them straight into a large context window.
Most people run one Claude Code agent and then wait for it. Git worktrees let you keep several going in separate folders on the same repo. How I lay that out in Warp or Tmux, plus the shared local database problem nobody warns you about.
The AI Client and Connectors API change how plugins talk to an LLM in WordPress 7.0. Notes from the Dev Chat agenda, plus the PHP refactor from a hardcoded wp_remote_post call to a registered ability.
MCP lets an AI pull data out of Google Drive, read old repos and load BigQuery instead of just suggesting Python. Includes the 150GB log file one unattended loop produced, and why domain knowledge still decides the answer.
A security report built on 127 million data points, and what it took: raw SQL instead of WP_Query, a resumable WP-CLI batch script, and segmentation that finally gave the numbers some contrast.
AI writes the query now and I check it. That includes the time an elegant LLM-generated join pushed a production database to 98% CPU, plus the utility I use to export sanitized WooCommerce data for analysis.
The Bits-over-Random Metric compares your retrieval against random chance, which is how you catch the context pollution a high Success@K hides. Notes on staged tool routing and where the collapse regime starts.
The six-month version of this career change is a sales pitch. Coming from a software background it took closer to two years, and the money goes to people who can ship a RAG system that does not leak data, not to people who can write prompts.