1. Sign up and create a new project on Supabase

• Head over to supabase.com and sign up for a new account.
• Create a new project, pick a name for it, and choose your database region.

1. Get the API keys and Database URL

• Go to your Supabase project dashboard.
• Click on the "Settings" tab, then "API". Jot down the API URL and anon key.
• Find the Database URL under the "Settings" tab in "Database".

1. Initialize a new Node.js project (if not already done)
   ```sh
   mkdir my-prisma-project
   cd my-prisma-project
   npm init -y
   ```

2. Install Prisma and initialize
   ```sh
   npm install prisma --save-dev
   npx prisma init
   ```

3. Install the necessary Prisma client

```sh
npm install @prisma/client
```

1. Configure the .env file

• Open the .env file in your project directory.
• Add the Supabase database connection string:
  ```env
  DATABASE_URL="your_supabase_database_url"
  ```

1. Update schema.prisma file

   • Open the prisma/schema.prisma file.

   • Define your data models. For example:
     ```prisma
     datasource db {
     provider = "postgresql"
     url = env("DATABASE_URL")
     }

     generator client {
     provider = "prisma-client-js"
     }

     model User {
     id Int @id @default(autoincrement())
     email String @unique
     name String?
     }
     ```

1. Run the migration

• Save your schema and then run:
  ```sh
  npx prisma migrate dev --name init
  ```

1. Generate the Prisma client
   ```sh
   npx prisma generate
   ```

1. Create a file to use the Prisma client (e.g., index.js)

• For example, to create a new user in your database:
  ```js
  const { PrismaClient } = require('@prisma/client');
  const prisma = new PrismaClient();

  async function main() {
  const newUser = await prisma.user.create({
  data: {
  email: 'test@example.com',
  name: 'John Doe',
  },
  });
  console.log(newUser);
  }

  main()
  .catch(e => console.error(e))
  .finally(async () => {
  await prisma.$disconnect();
  });
  ```

1. Run the file to test
   ```sh
   node index.js
   ```

1. Add additional queries to index.js for retrieving data:

   • Example:
     ```js
     async function main() {
     // Create a new user
     const newUser = await prisma.user.create({
     data: {
     email: 'test@example.com',
     name: 'John Doe',
     },
     });

     // Fetch all users
     const allUsers = await prisma.user.findMany();
     console.log(allUsers);
     }

     main()
     .catch(e => console.error(e))
     .finally(async () => {
     await prisma.$disconnect();
     });
     ```

2. Run your application again to see the changes:
   ```sh
   node index.js
   ```