Dev vs Prod Compare UI (MVP)

Small Next.js app to compare DEV vs PROD Redshift results locally via StrongDM.

Setup

1. Ensure StrongDM is connected and you have two resources:

   • one for DEV (localhost port)
   • one for PROD (localhost port)

2. Create .env.local from .env.example and fill in:

   • REDSHIFT_DEV_URL
   • REDSHIFT_PROD_URL

You told me database name is dev for both environments.

Run

cd compare-ui
npm run dev

Then open the local URL printed by Next.js.

Notes

• Queries run server-side (API route POST /api/compare).
• For MVP we only allow a small table allowlist (Retail + Digital primary tables). Add more in app/api/compare/route.ts and app/page.tsx.

This is a Next.js project bootstrapped with create-next-app.

Getting Started

First, run the development server:

npm run dev
# or
yarn dev
# or
pnpm dev
# or
bun dev

Open http://localhost:3000 with your browser to see the result.

You can start editing the page by modifying app/page.tsx. The page auto-updates as you edit the file.

This project uses next/font to automatically optimize and load Geist, a new font family for Vercel.

Learn More

To learn more about Next.js, take a look at the following resources:

• Next.js Documentation - learn about Next.js features and API.
• Learn Next.js - an interactive Next.js tutorial.

You can check out the Next.js GitHub repository - your feedback and contributions are welcome!

Deploy on Vercel

The easiest way to deploy your Next.js app is to use the Vercel Platform from the creators of Next.js.

Check out our Next.js deployment documentation for more details.