SQL to MongoDB Converter

Overview

A powerful client-side tool that converts SQL database dumps into MongoDB-ready JSON format. Features intelligent field mapping, automatic type detection, custom field injection, smart mock data generators, and strict static overrides. All processing happens locally in the browser — no data ever leaves your device. Successfully tested with large datasets up to 1.5GB SQL dumps, including a real-world migration of a 1.47GB production database.

My Role

Full-stack Developer — architecture, UI/UX, and client-side processing logic

Key Contributions

• →Built intelligent SQL parser with automatic data type detection and MongoDB field mapping suggestions
• →Implemented custom field injection allowing users to add new fields directly during export without manual JSON edits
• →Developed smart mock data generators for handling missing/inconsistent data: random strings, dates, incrementing sequences, and MongoDB ObjectIds
• →Created strict static overrides for enforcing consistent values across all records (booleans, numbers, strings, nulls)
• →Designed privacy-first architecture with 100% client-side processing — zero server uploads, no data leaves the browser
• →Optimized for large datasets with streaming processing and memory-efficient parsing
• →Built responsive drag-and-drop interface with granular export control (tables, columns, data types)
• →Generated mongoimport-ready JSON files for seamless MongoDB integration