How LucidAgent Works
From government and public data sources through Bronze/Silver/Gold medallion architecture to AI-powered intelligence
Data Sources
Public APIs
Government
Bronze
Raw Ingestion
JSONB
Silver
Domain Models
Enriched
Gold
Dimensional Facts
Analytics
Intelligence
AI + API
Products
Data Volume
446,878
Bronze Records
120
Active Sources
170
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 16
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).