Lovable Prompt Creator - AI Prompt Generator

## APPLICATION OVERVIEW
This project is a web application designed to facilitate the migration of data from an inaccessible Supabase database to a new database that the user has access to. The application will allow users to seamlessly transfer data while maintaining integrity and ensuring accessibility to the new database.

## CORE FEATURES
1. **Database Connection Management**: Users can input their new database credentials and connect to it securely.
2. **Data Migration Tool**: A feature that enables the extraction of data from the existing database and imports it into the new database.
3. **Progress Tracking**: Users can monitor the migration process in real-time, receiving updates on completed tasks and any encountered issues.
4. **Error Handling**: The application will provide error messages and troubleshooting tips when data migration fails or when there are connectivity issues.
5. **User Authentication**: Secure login and authentication to protect sensitive database information.
6. **Responsive Design**: The application will be fully responsive, ensuring usability across various devices.

## DESIGN SPECIFICATIONS
- **Visual Style**: minimalist - Clean, simple design with plenty of white space, minimal color palette, and focus on typography.
- **Color Mode**: Light theme with dark text on light backgrounds.
- **Primary Color**: #1978E5 (accent for buttons, links, highlights).
- **Typography**: Use Inter from Google Fonts for headings, Inter for body text and UI elements.
- **Border Radius**: 8px (moderately rounded) for buttons, cards, and inputs.
- **Layout**: The main layout will consist of a top navigation bar, a central content area for features and forms, and a footer with contact information and links.

## TECHNICAL REQUIREMENTS
- **Framework**: React with TypeScript.
- **Styling**: Tailwind CSS.
- **UI Components**: shadcn/ui.
- **State Management**: useContext and useReducer for managing application state.

## IMPLEMENTATION STEPS
1. **Setup Development Environment**:
   - Initialize a new React TypeScript project using Create React App.
   - Install Tailwind CSS and configure it according to the documentation.

2. **Create Core Components**:
   - Develop the main components: Header, MigrationForm, ProgressTracker, and ErrorDisplay.

3. **Implement Database Connection Logic**:
   - Use Supabase client to connect to both the current and new databases.
   - Create services to handle data fetching and migration.

4. **Build the User Interface**:
   - Apply Tailwind CSS styling based on the design specifications.
   - Ensure responsive design using Tailwind's utility classes.

5. **Implement Authentication**:
   - Set up user authentication using Supabase Auth features.

6. **Test Functionality**:
   - Perform unit tests and integration tests to ensure all features work as intended.

7. **Deploy the Application**:
   - Use a service like Vercel or Netlify to deploy the application for public access.

## USER EXPERIENCE
The user will start by logging into the application. Once authenticated, they will be guided through the process of entering their new database credentials. After initiating the migration, users will see a progress bar indicating the status of the data transfer. If any errors occur during this process, informative messages will help guide them through troubleshooting. The application will ensure a smooth experience with a focus on simplicity and efficiency, allowing users to complete the migration with minimal hassle.