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.
NetCDF climate data is not a REST API. Here is how I process CMIP6 and ERA5 tensors with Python and Xarray, set local heat thresholds, and end up with numbers a city planner can actually use.
WordPress site search punishes users for not guessing your exact wording. Here is how I fix it: a synonym map through the posts_search filter, a controlled vocabulary for metadata, and a four-step audit of zero-result queries.
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.
Waiting on a full JSON payload from an LLM leaves users on a spinner for 15 seconds. Streaming with server-sent events, the ReadableStream code that consumes it, and when validation means you should not stream at all.
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.
A client ran her entire business through WhatsApp until the account was blocked on a Tuesday. What owned digital assets mean in practice, and why Brazil’s first Automattic partner writes WordPress.com into its contracts.
A colleague shipped a custom assistant in a couple of hours by wiring Google Calendar, Microsoft To Do and Notion together. Execution stopped being the bottleneck, and here is a Gemini API scheduler you can start from inside WordPress.