Skip to content

ARCHITECTURE.md

Latest commit

 

History

History
83 lines (70 loc) · 2.37 KB

ARCHITECTURE.md

File metadata and controls

83 lines (70 loc) · 2.37 KB

Trewrap — Technical Architecture

System Architecture

graph TB
    subgraph Frontend["Next.js 16 Dashboard"]
        A[Wallet Input] --> B[Analysis Engine]
        C[Persona Card] --> D[Share Button]
        E[Leaderboard] --> F[Persona Stats]
    end

    subgraph Dune["Dune Analytics API"]
        B --> G[Timing Variance Query]
        B --> H[Token Diversity Query]
        B --> I[MEV Exposure Query]
        B --> J[Win Rate Query]
        B --> K[Hold Duration Query]
    end

    subgraph AI["Persona Engine"]
        G --> L[Signal Aggregator]
        H --> L
        I --> L
        J --> L
        K --> L
        L --> M[OpenAI — Persona Generator]
        M --> N[Persona Card Renderer]
    end
Loading

Tech Stack

Layer Technology
Frontend Next.js 16, React 19, Tailwind v4
Data Dune Analytics API (5 custom SQL queries)
AI OpenAI API (persona + roast generation)
Sharing html-to-image (card export)
Database Supabase (cached results, leaderboard)

Dune SQL Integration Map

Query Signal SQL Pattern
Timing Analysis When does the wallet trade? (insomniac?) GROUP BY HOUR(block_time)
Token Diversity How many unique tokens? (degen or blue-chip?) COUNT(DISTINCT token_address)
MEV Exposure How often sandwiched? JOIN mev_sandwiches ON tx_hash
Win Rate % of swaps that were profitable SUM(CASE WHEN pnl > 0 ...)
Hold Duration Average time between buy→sell AVG(sell_time - buy_time)

Database Schema

CREATE TABLE wallet_analyses (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    wallet_address TEXT NOT NULL,
    timing_score NUMERIC,
    diversity_score NUMERIC,
    mev_score NUMERIC,
    win_rate NUMERIC,
    hold_duration_avg INTERVAL,
    persona_title TEXT,
    persona_roast TEXT,
    card_image_url TEXT,
    created_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE persona_leaderboard (
    persona_title TEXT PRIMARY KEY,
    count INT DEFAULT 1,
    updated_at TIMESTAMPTZ DEFAULT NOW()
);

API Routes

Method Path Description
POST /api/analyze Submit wallet → run 5 Dune queries
GET /api/persona/:wallet Get cached persona result
GET /api/leaderboard Most common persona archetypes
POST /api/share Generate shareable card image