About

A federal hiring data platform with a durable production stack.

This project starts with a clean deployment path: Next.js 16 on Railway, Prisma on Railway PostgreSQL, health checks at /api/health, and GitHub-driven deploys on every push to main.

Database ready

Latest import finished Jul 8, 2026, 6:08 AM after finding 11,657 records.

Mission

Federal hiring deserves first-class data infrastructure.

Federal Hiring Data is designed to consolidate USAJOBS imports into a normalized schema that can support public search, internal dashboards, and long-term reporting.

The core rule is simple: production data belongs in Railway PostgreSQL via Prisma models, not in JSON exports, CSV snapshots, SQLite files, or ad hoc local storage.

Stack

Production baseline

Next.js 16 with the App Router and TypeScript
Tailwind CSS for the UI layer
Prisma ORM on top of Railway PostgreSQL
Dockerfile-based Railway deployments with health checks
GitHub Actions that lint and build on every push and pull request

Data models

Designed for growth

The initial schema includes Job, Agency, Occupation, Location, ImportRun, DailySnapshot, and Article models so operational data and editorial data can live together with clean relations.

Deployment flow

Push to main, deploy to Railway

Railway can connect directly to the private GitHub repository, build from the Dockerfile, run `npm run prisma:deploy` as a pre-deploy command, and only mark the service healthy after `/api/health` returns HTTP 200.