Local Installation

1. Clone the Repository

Since Prodly is a commercial product, the source code is stored in a private GitHub repository. You should have received access to it after purchasing a license.

git clone https://github.com/your-organization/prodly.git
cd prodly

Replace the URL with the actual repository URL you were provided.

2. Install Dependencies

Install all required packages using npm (or bun):

npm install

This will read the package.json and install everything needed to run the application.

3. Set Up Environment Variables

Prodly uses a .env.local file to store configuration and secrets. You should have prepared this file while following the Environment Setup guide.

If you haven’t done so already, create a .env.local file in the root of the project and fill in all the required variables:

# Domain (use localhost for local development)
NEXT_PUBLIC_APP_URL=http://localhost:3000

# Supabase
NEXT_PUBLIC_SUPABASE_URL=your_supabase_project_url
NEXT_PUBLIC_SUPABASE_ANON_KEY=your_supabase_anon_key
SUPABASE_SERVICE_ROLE_KEY=your_supabase_service_role_key

# AI - Text generation (Groq)
GROQ_API_KEY=your_groq_api_key

# AI - Image analysis (Google Gemini)
GOOGLE_API_KEY=your_google_gemini_api_key

# Keyword suggestions (Serper)
SERPER_API_KEY=your_serper_api_key

# Rate limiting (Upstash Redis)
UPSTASH_REDIS_REST_URL=your_upstash_redis_url
UPSTASH_REDIS_REST_TOKEN=your_upstash_redis_token

# Stripe (if you use payments)
STRIPE_SECRET_KEY=sk_test_...
NEXT_PUBLIC_STRIPE_PUBLISHABLE_KEY=pk_test_...
STRIPE_WEBHOOK_SECRET=whsec_...   # optional for local testing

4. Set Up the Database

Prodly uses Supabase as its database. You need to apply the database schema to your Supabase project.

1. Log in to your Supabase Dashboard .

2. Open your project.

3. Go to the SQL Editor.

4. Copy the entire contents of supabase-schema.sql (provided in the project root) and paste it into a new query.

5. Run the query. This will create all the required tables and set up Row Level Security policies.

5. Start the Development Server

Now you’re ready to launch the application locally:

npm run dev

After a few seconds, you should see output like:

ready - started server on http://localhost:3000

Open http://localhost:3000  in your browser. You will see the Prodly landing page.

6. First User Becomes Admin Automatically

The database schema includes a special mechanism that grants administrator privileges to the very first user who registers. Here’s how it works:

• A trigger on the user_profiles table runs before a new row is inserted.

• It calls a function handle_first_user_admin() that checks if any user profile already exists in the table.

• If no profiles exist (i.e., this is the first user), the function sets is_admin = TRUE for the new profile.

• All subsequent users will have is_admin = FALSE by default.

What this means for you:

1. After applying the schema, register immediately – the account you create will become the administrator.

2. You can then access the admin panel at http://localhost:3000/admin with full privileges.

3. No manual SQL updates are required for the first user.

UPDATE user_profiles
SET is_admin = true
WHERE id = (SELECT id FROM auth.users WHERE email = 'user@example.com');

7. Verify Everything Works

• Register a new user account.

• Check that you can generate a description (trial generation).

• Verify that your credits are deducted correctly.

• If you’ve set up Stripe, test a payment using Stripe test cards.