What feeds viska.gg — live data-source map

Every data type currently flowing to the Viska front-end, grouped by origin. Source → ingestion → Supabase relation → front-end surface. Status reflects the live database, queried 2026-06-30.

Author: ViskaDB · As of: 2026-06-30
Verified: live $VISKA_DB_URL · Acct: U22131377

LIVE — fresh, flowing STALE — feeding but old WIRED, NOT PRODUCING Freshness = max date on the relation's primary date column.

live data sources feeding the FE

IBKR positions · NAV as-of 06-29

15,768

news/research items (sentiment-scored)

06-30

conviction engine last run (daily)

📈

Interactive Brokers — Flex Web Service

Portfolio source-of-truth · account U22131377 (Viska macro slhf.)

LIVE · as-of 2026-06-29 (settles T+1)

IBKR Flex API→ n8n pull (13:30 UTC, Mon–Sat)→ flex-apply-svc (Railway)→ trading.* (raw)→ public.* projections→ FE

Data types pulled

Positions / holdings (29) NAV — cash · stock · total Cost basis · market value MTD / YTD per position Trades (423) Dividends (81) Cash flows · fees / interest FX balances (135) Closed round-trips (75) Interest / dividend accruals Period TWR

Relations

raw:

trading.statements · nav_snapshots · positions_snapshots · trades · dividends · cash_flows · fees_interest · fx_balances · v_round_trips

FE-facing: public.positions_current · nav_latest · nav_history · cash_current · trades · monthly_pnl · pnl_split

Front-end surfaces

Stöður (positions table) · Forsíða / Hero (NAV, headline) · Yfirlit · Félög · returns & recent-trades panels

🧭

Broker research → Conviction engine

Broker documents, scored into theme conviction

LIVE · 2026-06-30

Broker docs→ embeddings / snippets→ n8n conviction (LLM scoring)→ dashboard views

Data types

Broker theme calls (177) Theme net-signal / coverage (69) Corroboration · contested Off-radar clusters (67) Snippet scores (782) Blind-spot clusters (507)

Relations

conviction_dashboard_theme_intel · _broker_calls · _off_radar · _corroboration (views over broker_theme_calls · theme_intelligence · off_radar · snippet_theme_scores)

Surfaces

Greining / Conviction — theme & broker detail, off-radar, history

📰

News & research feed

Curated market news + daily research synthesis

LIVE · 2026-06-30

News / research sources→ n8n ingestion + sentiment→ feed_items / artifacts

Data types

News items (15,768) Sentiment score + reason Ticker / theme tags Importance · price context Daily big-picture (17) 48h-ahead · headlines

Relations

feed_items (15,768) · research_artifacts (17) · research_feed (view, 155)

Surfaces

Forsíða research feed. Note: FE surfaces the 155-row digest; the full 15.7k sentiment feed is available but not yet displayed.

💱

FX rates — Central Bank of Iceland

USD / ISK reference rate

LIVE · 2026-06-29

CBI (source config)→ n8n FX fetch (pg_cron)→ fund.fx_rates

Data types

USD/ISK rateCaptured day / source

Relations

fund.fx_rates · fund.fx_usd_isk_latest · fund.fx_source_config

Surfaces

Currency toggle & ISK conversion across Hero / NAV money formatting

📊

Benchmark / returns (multi-basis)

FRED + CBI + ANAV — computed return bases

LIVE · basis 2026-06-26

FRED · CBI · ANAV→ benchmark compute→ basis / metrics / series

Data types

MTD / QTD / YTD / inception 3 bases (isk_anav · fx_clean · usd_book) Alpha vs benchmark

Relations

benchmark_basis (3) · benchmark_metrics (12) · benchmark_series (4)

Surfaces

Hero returns table + basis toggle

🧩

Allocation & themes

Derived from IBKR positions + theme registry

LIVE · 2026-06-29

positions + theme map→ allocation rollup→ history / registry

Data types

Theme allocation over time (26) Theme · sub-group per holding Fine-theme (29/29 in DB) Theme registry (8, tier)

Relations

allocation_history (26) · fund_themes (8) · positions_current.theme/sub_group/fine_theme

Surfaces

Þemu (allocation chart + breakdown). fine_theme populated in DB but not yet selected by FE.

🏦

ISK fund accounting (ANAV)

Operator / treasurer — manual ANAV & share ledger

STALE · as-of 2026-05-29

Operator / treasurer→ manual ANAV entry→ fund_isk_nav / ledger

Data types

NAV per share (ISK) AUM ISK · shares Share ledger / cap table (12) ISK NAV history (15)

Relations

fund.fund_isk_nav · public.fund_isk_nav_history · fund_share_ledger

Surfaces

Hlutabréf (cap table + ISK NAV trend) · ISK headline on Forsíða. Manual feed — last updated 05-29.

🌊

Sector flows & sentiment

ETF/sector momentum + sentiment scoring

MIXED · sentiment stale 04-10

Data types

Sector flow / momentum Quadrant · streaks Sector sentiment (16) Theme sentiment (8)

Relations

sector_flows · sector_sentiment_scores (stale) · theme_sentiment_scores (stale)

Surfaces

Intel sector-flow monitor

🩺

Pipeline & data health

Sync status + component health for data-source banner

LIVE · 2026-06-30

Data types

Flex sync status / next-run Component health (7) Daily pipeline health (77)

Relations

flex_sync_status · component_health · viska_daily_health_computed

Surfaces

FlexSyncPanel · DataSourceBanner (freshness/health indicators)

💬

Mímir chat (Face agent)

HTTP Worker — not a Supabase feed

FE placeholder (Phase 3)

FE→ face-agent.viska.gg (shield Worker)→ n8n agent

Data types

Chat Q&A (live via Worker)Chat history tables (empty)

/mimir route is a "coming soon" placeholder; the chat history tables exist but are unused.

Wired, but not yet producing — completeness (no gaps)

Market quotes (live intraday prices) — market_quotes in both public and fund schemas exist but are empty; no producer running (Alpaca/Twelve Data vendor wiring outstanding — "gap D").
Signals / Face-agent backtests — signals.* (9 relations) provisioned, all empty; Face-agent not yet emitting.
Ops event stream — ops.health_events · heartbeats empty (post-incident wiring not populated).
Strategic intensity (VISKA MACRO grid) — strategic_intensity built on a branch but not applied to prod; FE Heatmap that reads it is unrouted.
Anon fund.* mirror — positions/holdings/ISK-NAV mirror is stale (May 2026); the live values are served from the authenticated public.*/trading.* surface above.

Full per-relation coverage matrix (167 read-surface relations × every column) → Viska-Wiki audits/2026-06-30-fe-db-pool-coverage-audit.md. All counts & freshness live-queried 2026-06-30.