Ok holy shit using supabase MCP with agentic search via Claude Agent SDK discord bots is the best way to search the discord chat archive.
I just copied @steipete discrawl schema and made it way better for my use case.
episodic memory and custom instructions per channel stay in md files and the full discord server archive goes to supabase with MCP.
So much better than semantic search.