AI-Powered Questionnaire App with Supabase to MySQL Migration

I rebuilt and debugged a full-stack web application originally created with Lovable.dev, transforming it into a production-ready, scalable platform with MySQL and modern React tooling.

The app is designed for businesses or consultants to manage customizable questionnaires, user assessments, and generate AI-based PDF reports using ChatGPT.

Key achievements:

Migrated the database from Supabase (PostgreSQL) to MySQL for compatibility with cPanel hosting.

Fixed critical bugs in authentication, registration, and user dashboard using JWT and a custom backend.

Rebuilt a form builder with advanced logic, image upload, conditional visibility, and drag-and-drop UI (inspired by Jotform and SurveyJS).

Integrated OpenAI’s ChatGPT API to generate real-time analytical reports based on questionnaire answers.

Developed a full admin dashboard to manage plans, questionnaires, users, and AI prompts.

Ensured data persistence for plans, prompts, reports, and user responses.

Added email and OAuth authentication (Google, Facebook), and secure password reset.

Made the UI fully responsive using Tailwind CSS and enhanced UX with Shadcn components.

Created a dynamic report builder similar to WordPress Gutenberg for rich-text and shortcode layouts.

The final application was deployed on a cPanel environment, with optimized database relations and responsive, modern design.