Ask: an MCP connection to our research corpus, callable through a cloud desktop connection — Claude Desktop / claude.ai.
Shippable now, near-zero build for Phase 0. We already speak MCP and the corpus already lives in Supabase with a similarity-search RPC. The gap is not capability — our one MCP (viska-vault) is local stdio, not cloud-reachable, and the valuable corpus (Supabase pgvector) has no MCP surface at all. Both close by adopting Supabase's hosted remote MCP; grounded semantic retrieval is a small follow-on build.
Two distinct forms — this distinction drives everything.
| Corpus | Where | Exposed today | Cloud-reachable? |
|---|---|---|---|
A — Obsidian wikiViska-Wiki-Engineering |
Local Dropbox path, operator box | viska-vault MCP = local stdionpx @mauricio.wolff/mcp-obsidian · .mcp.json:3 |
✕ No — single machine, single user |
| B — Supabase pgvector DB | Supabase project (live, RLS-on) | Nothing — service-role writes + match_* RPC read, no MCP |
DB is cloud-hosted, but no MCP |
Corpus B is the real research corpus — embedded, grounded-retrieval-ready, with a citation gate (corpus_status='verified') already enforced at the RPC. Live contents (hades #70-73):
video_sources — deep-analysis records (stance / signal / theme, key_points, cited)transcript_chunks — vector(1536) embeddings, text-embedding-3-smallmatch_transcript_chunks(query_embedding, match_count, filter_theme, min_published) — cosine similarity RPC, verified-chunks-only filter baked inembeddings_main (existing 1536 corpus) · research_findings (conviction newsfeed)Claude Desktop + claude.ai support custom connectors via remote MCP servers (Settings → Connectors → Add custom connector). Verified against vendor docs:
viska-vault MCP cannot be a cloud desktop connector — local stdio only works on the machine that runs it. Cloud-from-anywhere ⇒ remote MCP over HTTPS. Corpus A is out of scope for "cloud" unless separately bridged.| Option | What | Build | Fit |
|---|---|---|---|
0 · Supabase hosted remote MCPmcp.supabase.com |
Official, OAuth 2.1, read-only via ?read_only=true, add as custom connector today |
Zero | Broad — exposes SQL/table query over the whole project. Powerful, but the LLM writes SQL, not semantic vector search. Needs scoping. |
| 1 · Thin custom MCP on Supabase Edge Functions | One tool search_research_corpus(query, theme?, since?) → embed query → call match_transcript_chunks → return cited chunks + ?t= jump links |
Small | Best — grounded semantic retrieval, verified-only, native to our stack, reuses the C4 schema + RPC already live. The InsightsLM / retrieve() pattern already specced (07-02 chat-stack, T4). |
| 2 · Bridge Obsidian wiki to cloud | Mirror wiki → queryable store, or remote-MCP Obsidian bridge | Medium | Skip for now — most research value already flows into Supabase B; wiki is a working local surface. |
Add mcp.supabase.com in read-only mode as a custom connector in Claude Desktop / claude.ai. Ship behind a scoped read-only DB role + RLS so the connector sees only corpus tables — not the whole project. Proves the capability today.
Deploy an MCP Edge Function exposing search_research_corpus over the verified-only RPC. Grounded, cited, semantic retrieval (not raw SQL) with ?t= YouTube jump links. Everything downstream already exists — wiring, not new architecture.
corpus_status='verified' filter (excludes draft / PII / off-thesis chunks — already enforced at the RPC). No service-role key in any connector config; OAuth only.| Phase | Owner | Effort |
|---|---|---|
| 0 — hosted remote MCP + scoped read-only role | ViskaDB (role/RLS) + operator (add connector, OAuth) | ~hours |
| 1 — thin Edge-Function semantic MCP | ViskaN8N/ViskaDB (deploy) + ViskaRes (tool schema + prompt semantics) | ~1 build arc |
This is the gap the landscape flagged 🟡 — "no MCP/agent-callable exposure of own corpus" — and it's the direction the whole institutional tier is moving (FactSet / Kensho / Quartr MCP exposure).
Build custom connectors via remote MCP servers — Claude Help
Get started with custom connectors using remote MCP — Claude Help
Announcing the Supabase Remote MCP Server
Deploy MCP servers (BYO-MCP / Edge Functions) — Supabase Docs
Supabase MCP Server — Docs
Repo: .mcp.json · research/youtube-deep-analysis/c4-pgvector-schema.md · research/ai-fund-intel-landscape-2026-07-06/REPORT.md