Skip to content
PUBLIC KNOWLEDGE RAG · CLIENT JWALKER Marketing

Creator Knowledge Assistant

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

Illustration of Creator Knowledge Assistant: a WordPress question box with an answer linked to public video sources
ILLUSTRATION
CURRENT SCOPE

Public WordPress assistant · slide-in answer panel live October 28

WHO IT'S FOR

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.

FastAPISQLite FTS5WordPress

BEFORE → AFTER

Real problems from this build, what I changed and the verified result.

  1. CASE 01
    Before

    A public assistant needs a clear boundary between public videos and paid creator material.

    After

    The September 29 release record includes a public homepage check and a grounded answer with five cited sources.

    How I fixed it

    Restricted the public knowledge release to approved YouTube sources and kept paid connectors outside its active source set.

  2. CASE 02
    Before

    A scheduled backup needs to work through the scheduler’s real invocation, not only a helper function.

    After

    A successful scheduled backup and passing offline checks were retained with the release evidence.

    How I fixed it

    Verified 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