Creator Knowledge Assistant
A public WordPress assistant that answers from a creator’s approved YouTube videos, with linked sources.

Public WordPress assistant · slide-in answer panel live October 28
Client project · JWALKER Marketing
Paid creator-knowledge assistant engagement. The September 29 public release uses approved YouTube material; paid membership and course content are excluded.
THE ENGINEERING
A public WordPress knowledge assistant grounded in approved YouTube material. FastAPI combines SQLite FTS5, local embeddings and rank fusion without a hosted vector database. Relevance checks and source citations constrain answers; paid membership and course material are excluded from the public release. Manifest checks, atomic knowledge updates, daily refresh and scheduled backups support operations. The September 29 go-live record includes a real grounded answer with five sources, a public homepage check and execution of the actual scheduled backup command. On October 21 the missing homepage loader was restored, both question boxes were republished and browser-checked, and the engine (26,634 indexed passages, 28 running services) was prepared for the client’s final domain. On October 28 answers moved into a right-hand slide-in panel (a bottom sheet on phones) shared by both question boxes and the follow-up box, checked live with zero page errors; the engine now holds 27,016 passages. The domain’s DNS records resolve, and attaching the domain and its certificate on the client’s hosting is the remaining client-side step. The earlier members-only brief is historical.
BEFORE → AFTER
Real problems from this build, what I changed and the verified result.
- CASE 01Before
A public assistant needs a clear boundary between public videos and paid creator material.
AfterThe September 29 release record includes a public homepage check and a grounded answer with five cited sources.
How I fixed itRestricted the public knowledge release to approved YouTube sources and kept paid connectors outside its active source set.
- CASE 02Before
A scheduled backup needs to work through the scheduler’s real invocation, not only a helper function.
AfterA successful scheduled backup and passing offline checks were retained with the release evidence.
How I fixed itVerified the module entry point used by the scheduled job and exercised the actual command.
Evidence reviewed: September 29 release records · October 10 public case study