🔮 Data Alchemist

An AI-enhanced data processing and task optimization platform
Transform your raw data into actionable insights with intelligent validation, natural language search, and AI-powered business rules.

Screenshots

✨ Features

🎯 Core Data Management

Multi-format Import: Support for CSV, Excel (.xlsx, .xls) with intelligent column mapping
Real-time Validation: Advanced data validation with error detection and suggestions
Inline Editing: Spreadsheet-like editing experience with change tracking
Export Options: Multiple export formats including JSON, CSV, and Excel

🤖 AI-Powered Intelligence

Natural Language Search: Query your data using plain English
Smart Column Mapping: AI-assisted column mapping with confidence scoring
Business Rule Generation: AI-powered rule creation and optimization
Data Insights: Automated analysis and recommendations

🎛️ Advanced Features

Dynamic Business Rules: Create, edit, and manage complex business logic
Priority Scoring: Configurable priority profiles with weight-based calculations
Interactive Dashboards: Real-time data visualization and monitoring
Change Tracking: Complete audit trail with save/discard functionality

🎨 User Experience

Modern UI: Clean, responsive design with dark/light theme support
Intuitive Navigation: Step-by-step workflow with progress tracking
Real-time Feedback: Instant validation and visual indicators
Accessibility: Full keyboard navigation and screen reader support

🚀 Quick Start

Prerequisites

Node.js 18.0 or higher
npm, yarn, pnpm, or bun
Gemini API Key (optional, for AI features)

Installation

Clone the repository

git clone <repository-url>
cd data-alchemist

Install dependencies

npm install
# or
yarn install
# or
pnpm install
# or
bun install

Set up environment variables

cp .env.example .env.local

Edit .env.local and add your Gemini API key:

GEMINI_API_KEY=your_gemini_api_key_here
NEXT_PUBLIC_GEMINI_API_KEY=your_gemini_api_key_here

Start the development server

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

Open your browser Navigate to http://localhost:3000

🎯 Usage Guide

1. Data Upload

Navigate to the Upload page
Upload your CSV or Excel files for Clients, Workers, and Tasks
Use AI-assisted column mapping for mismatched headers
Review validation results and fix any errors

2. Data Validation & Editing

View comprehensive validation reports
Edit data inline with spreadsheet-like functionality
Add/remove rows with full validation
Track changes with save/discard options

3. Natural Language Search

Use plain English queries: "Show high priority clients"
Filter data dynamically with AI-powered search
Export filtered results in multiple formats

4. Business Rules

Create custom business logic with the rule builder
Use AI assistance for rule generation from natural language
Test rules with preview functionality
Manage rule priority and activation status

5. Priority Configuration

Choose from pre-built priority profiles:
- Maximize Fulfillment: Optimize for completion rates
- Fair Distribution: Balance workload across workers
- Revenue Focused: Prioritize high-value tasks
- Custom: Create your own weighting system

6. Export & Integration

Export processed data in multiple formats
Download generated business rules
API-ready JSON output for system integration

🔧 Configuration

Environment Variables

Variable	Description	Required
`GEMINI_API_KEY`	Gemini 2.0 Flash API key for AI features	Yes
`NEXT_PUBLIC_GEMINI_API_KEY`	Public Gemini API key (fallback)	Yes
`DATABASE_URL`	Database connection string (future use)	No

AI Integration Setup

Get Gemini API Key:
- Visit Google AI Studio
- Create a new API key
- Add it to your .env.local file
AI Features Available:
- ✅ Natural language search
- ✅ Smart column mapping
- ✅ Business rule generation
- ✅ Data validation assistance
Fallback Mode:
- App works without API key using mock responses
- Full functionality available with limited AI features

🏗️ Project Structure

data-alchemist/
├── 📁 src/
│   ├── 📁 app/                 # Next.js App Router pages
│   │   ├── 📁 upload/          # Data upload interface
│   │   ├── 📁 rules/           # Business rules management
│   │   ├── 📁 export/          # Data export functionality
│   │   └── 📁 api/             # API routes (AI integration)
│   ├── 📁 components/          # React components
│   │   ├── 📁 ui/              # Reusable UI components (shadcn/ui)
│   │   ├── NaturalLanguageSearch.tsx
│   │   ├── EditableDataGrid.tsx
│   │   ├── BusinessRuleBuilder.tsx
│   │   └── ...
│   ├── 📁 lib/                 # Utilities and configurations
│   │   ├── stores.ts           # Zustand state management
│   │   ├── ai.ts              # AI service integration
│   │   ├── validation.ts       # Data validation logic
│   │   └── schemas.ts          # Data type definitions
│   ├── 📁 utils/              # Helper functions
│   └── 📁 types/              # TypeScript type definitions
├── 📄 package.json
├── 📄 tailwind.config.ts
├── 📄 next.config.js
└── 📄 README.md

🛠️ Built With

Core Technologies

Next.js 15.4.6 - React framework with App Router
React 19.1.0 - UI library with latest features
TypeScript 5.x - Type-safe development
Tailwind CSS 4.x - Utility-first styling

UI Components

shadcn/ui - Modern component library
Radix UI - Headless UI primitives
Lucide React - Beautiful icons
Sonner - Toast notifications

Data Processing

PapaParse - CSV parsing
XLSX - Excel file processing
Zod - Runtime type validation
TanStack Table - Data grid functionality

State Management

Zustand - Lightweight state management
Local Storage Persistence - Data persistence across sessions

AI Integration

Gemini 2.0 Flash - Google's latest AI model
LangChain - AI application framework
Natural Language Processing - Query understanding and processing

🎨 Design System

Color Scheme

Primary: Modern blue gradient (from-blue-500 to-purple-600)
Secondary: Clean grays with excellent contrast
Accent: Purple highlights for interactive elements
Status Colors: Semantic colors for validation states

Typography

Font Family: Geist Sans - Optimized for readability
Font Sizes: Carefully scaled type system
Font Weights: Strategic emphasis hierarchy

Interactive Elements

✅ Consistent cursor-pointer on all clickable elements
✅ Hover states with smooth transitions
✅ Focus management for accessibility
✅ Loading states and progress indicators

📊 Performance Features

⚡ Turbopack: Lightning-fast development builds
🎯 Code Splitting: Automatic route-based splitting
🗜️ Bundle Optimization: Tree-shaking and compression
📱 Responsive Design: Mobile-first approach
♿ Accessibility: WCAG 2.1 AA compliance

🔐 Data Security

🛡️ Client-Side Processing: Sensitive data never leaves your browser
🔒 Secure API Calls: Encrypted communication with AI services
💾 Local Storage: Data persisted locally with encryption options
🗂️ No Data Collection: Your data stays private

Environment Setup for Production

# Production environment variables
GEMINI_API_KEY=your_production_api_key
NEXT_PUBLIC_GEMINI_API_KEY=your_production_api_key
NODE_ENV=production

📝 License

This project is licensed under the MIT License - see the LICENSE file for details.

Built with ❤️ using cutting-edge web technologies

Transform your data processing workflow with AI-powered intelligence

Name		Name	Last commit message	Last commit date
Latest commit History 23 Commits
public		public
samples		samples
src		src
.eslintrc.json		.eslintrc.json
.gitignore		.gitignore
README.md		README.md
components.json		components.json
eslint.config.mjs		eslint.config.mjs
next.config.js		next.config.js
next.config.ts		next.config.ts
package-lock.json		package-lock.json
package.json		package.json
postcss.config.mjs		postcss.config.mjs
tsconfig.json		tsconfig.json

AKASH-PRASAD7/Data-Alchemist

Folders and files

Latest commit

History

Repository files navigation