How LucidAgent Works
From 160+ public data sources through Bronze/Silver/Gold medallion architecture to AI-powered intelligence
Data Sources
Public APIs
160+
Bronze
Raw Ingestion
JSONB
Silver
48 Models
Enriched
Gold
18 Tables
Analytics
Intelligence
AI + API
Products
Data Volume
138,302
Bronze Records
94
Active Sources
48
Silver Models
0
AI Analyses
Connector Categories
Economic
25
Financial
20
Healthcare
15
Infrastructure
12
Legal & Regulatory
15
Global & Trade
18
Environmental
10
Safety & Security
12
Geopolitical
8
Real Estate
10
Energy
8
Innovation
7
Tech Stack
Next.js 14
App Router + Server Components
Vercel Pro
Edge deployment + Cron jobs
Neon PostgreSQL
Serverless database
Claude Haiku
AI analysis generation
Recharts
Data visualization
Tailwind CSS
Utility-first styling
Stripe
Payment processing
Resend
Transactional email
Medallion Architecture Detail
Bronze Layer
Raw data exactly as fetched from APIs. Stored in bronze_raw table with source_key, record_key, raw_data JSONB. Rolling retention: 90 days to unlimited depending on source.
Silver Layer
Normalized, enriched intelligence models. 48 silver_*_intelligence tables covering companies, geography, conflict, seismic, forex, crypto, health, air quality, trade, displacement, and more.
Gold Layer
Dimensional model + precomputed analytics. Dimension tables (date, geography, sector, commodity). Fact tables (economic, market, conflict, disaster, health, trade). Analytics tables (correlations, forecasts, anomalies, rankings, composite indices, time series).