Awardopedia - Federal Contracts

Awardopedia

Free, searchable interface for U.S. federal contract award data sourced from USASpending.gov.

Tech Stack

• Frontend: React 18 + Vite 5, react-router-dom v6, Chart.js, lucide-react
• Backend: Node.js 20 + Express 4, PostgreSQL 15
• AI: Anthropic Claude API for contract analysis (paid credits)
• Payments: Stripe Checkout for credit packs
• Auth: Magic link email via SendGrid + JWT
• Hosting: DigitalOcean App Platform
• DNS/CDN: Cloudflare

Local Development

Prerequisites

• Node.js 20+
• PostgreSQL 15+
• Python 3.10+ (for data sync scripts)

Setup

# Clone
git clone https://github.com/openclaw/awardopedia.git
cd awardopedia

# Database
psql -d your_db -f scripts/schema.sql

# API
cd api
cp ../.env.example .env   # Edit with your values
npm install
npm run dev               # Starts on :3001

# Frontend (separate terminal)
cd web
npm install
npm run dev               # Starts on :3000, proxies /api to :3001

Environment Variables

See .env.example for all required variables. At minimum for local dev:

DATABASE_URL=postgresql://localhost:5432/awardopedia
JWT_SECRET=any-dev-secret
PORT=3001

Project Structure

awardopedia/
├── api/                  # Express API server
│   ├── src/
│   │   ├── db/           # Database connection + queries
│   │   ├── middleware/    # Auth, credits, rate limiting
│   │   ├── routes/       # API route handlers
│   │   └── services/     # Claude AI, Stripe, SendGrid
│   └── Dockerfile
├── web/                  # React + Vite frontend
│   ├── src/
│   │   ├── components/   # Reusable UI components
│   │   ├── pages/        # Route pages
│   │   ├── styles/       # CSS tokens, global, components
│   │   └── utils/        # API client, formatters, SEO
│   └── public/
├── scripts/
│   ├── schema.sql        # PostgreSQL schema
│   ├── ingest.py         # Bulk CSV ingestion
│   └── sync.py           # Weekly USASpending API sync
├── docs/
│   ├── api.md            # API endpoint reference
│   ├── data-model.md     # Database schema docs
│   └── deployment.md     # Deployment guide
└── assets/               # Brand logos

Data

All contract data is sourced from USASpending.gov, the official open data source of federal spending information maintained by the U.S. Department of the Treasury as mandated by FFATA.

• Bulk import: python3 scripts/ingest.py --file contracts.csv
• Weekly sync: python3 scripts/sync.py (fetches last 7 days from USASpending API)

Business Model

• Core data access (search, filter, browse): Free
• AI analysis (contract insights, summaries): Paid credits
  • Starter: 100 credits / $9
  • Pro: 500 credits / $29
  • Power: 2,000 credits / $79

License

Proprietary. Data sourced from USASpending.gov (public domain).