๐งช Data Alchemist โ Smart Data Validator & Rule Engine
๐ Built with Next.js 15 + AG Grid + Zod + Tailwind
๐ง Role: AI/ML Product Engineer | ๐ง Bonus: Natural-Language Rule Builder (No API Key Needed)
๐ Overview
Data Alchemist is a no-code web app to clean, validate, and rule-check CSV/XLSX datasets.
It lets users:
- Upload datasets
- Highlight and remove invalid rows
- Define rules (manually or with text input)
- Prioritize rules
- Export clean data + rule logic as
.csv,.json, or.zip
๐ก Designed as a technical showcase for SDE, Data, or AI/ML engineering roles.
๐ฏ Features
โ
Upload .csv / .xlsx files
โ
Schema-based row validation using Zod
โ
Visual data grid using AG Grid v34
โ
Manual rule builder with:
- Rule types:
no-collab,must-follow,skill-match - Weight slider (1โ10)
โ Natural Language Rule Generator
- Example:
John must follow Alice with priority 8 - Generates structured JSON rule without OpenAI
โ Exports:
- ๐งผ
clean.csvโ valid rows only - ๐
rules.jsonโ all rules with priorities - ๐ฆ
bundle.zipโ includes both above
โ
Legacy AG Grid theming (no Quartz conflict)
โ
Fully offline โ no .env or API key needed
๐ง NLP Rule Generator Example
Input:
Alice must follow Bob with priority 9
src/
โโโ app/ # Main page.tsx + layout
โโโ components/
โ โโโ FileUploader.tsx # Upload + parse + validate
โ โโโ GridView.tsx # AG Grid setup
โ โโโ RuleBuilder.tsx # Manual + NLP rule UI
โโโ lib/
โ โโโ schema.ts # Zod schema for row validation
โ โโโ download.ts # CSV, JSON, and ZIP exporters
โโโ pages/api/
โโโ nl-rule.ts # Fake NLP parser (no OpenAI needed)
# 1. Clone
git clone https://github.com/<your-username>/data-alchemist.git
cd data-alchemist
# 2. Install dependencies
npm install
# 3. Start dev server
npm run dev
# Open http://localhost:3000
---
### โ
What To Do Now:
1. Replace `README.md` in your project root with the file above
2. Commit changes:
```bash
git add README.md
git commit -m "๐ Updated README with full feature list + role info"
git push
Log in or sign up for Devpost to join the conversation.