Skip to main content

Prisma

还没翻译译自英文（supabase.com）本页 50 段都还没译

This guide shows how to connect your Prisma application to Supabase Postgres. If you encounter any problems, reference the Prisma troubleshooting docs.

Note

If you plan to solely use Prisma instead of the Supabase Data API (PostgREST), turn it off in the API Settings.

  1. Create a custom user for Prisma

    • In the SQL Editor, create a Prisma DB user with full privileges on the public schema.
    • This gives you better control over Prisma's access and makes it easier to monitor using Supabase tools like the Query Performance Dashboard and Logs.

    Password manager

    For security, consider using a password generator for the Prisma role.

    -- Create custom user
create user "prisma" with password 'custom_password' bypassrls createdb;

-- extend prisma's privileges to postgres (necessary to view changes in Dashboard)
grant "prisma" to "postgres";

-- Grant it necessary permissions over the relevant schemas (public)
grant usage on schema public to prisma;
grant create on schema public to prisma;
grant all on all tables in schema public to prisma;
grant all on all routines in schema public to prisma;
grant all on all sequences in schema public to prisma;
alter default privileges for role postgres in schema public grant all on tables to prisma;
alter default privileges for role postgres in schema public grant all on routines to prisma;
alter default privileges for role postgres in schema public grant all on sequences to prisma;
    -- alter prisma password if needed
alter user "prisma" with password 'new_password';

  2. Create a Prisma Project

    Create a new Prisma Project on your computer

    Create a new directory

    mkdir hello-prisma
cd hello-prisma

    Initiate a new Prisma project

    npmpnpmyarnbun

    npm init -y
npm install prisma tsx @types/pg --save-dev
npm install @prisma/client @prisma/adapter-pg dotenv pg

npx tsc --init

npx prisma init

  3. Add your connection information to your .env file

    • On your project dashboard, click Connect
    • Find your Supavisor Session pooler string. It should end with 5432. It will be used in your .env file.

    Note

    If you're in an IPv6 environment or have the IPv4 Add-On, you can use the direct connection string instead of Supavisor in Session mode.

    • If you plan on deploying Prisma to a serverless or auto-scaling environment, you'll also need your Supavisor transaction mode string.
    • The string is identical to the session mode string but uses port 6543 at the end.

    server-based deploymentsserverless deployments

    In your .env file, set the DATABASE_URL variable to your connection string

    # Used for Prisma Migrations and within your application
DATABASE_URL="postgres://[DB-USER].[PROJECT-REF]:[PRISMA-PASSWORD]@[DB-REGION].pooler.supabase.com:5432/postgres"

    Change your string's [DB-USER] to prisma and add the password you created in step 1

    postgres://prisma.[PROJECT-REF]...

  4. Configure prisma.config.ts

    Add import "dotenv/config" to the generated prisma.config.ts. If you are using a serverless environment, change the data source URL to DIRECT_URL.

    server-based deploymentsserverless deployments

    import "dotenv/config";
import { defineConfig, env } from "prisma/config";

export default defineConfig({
  schema: "prisma/schema",
  migrations: {
    path: "prisma/migrations",
  },
  datasource: {
    url: env("DATABASE_URL"),
  },
});

  5. Migrate and generate your Prisma client

    If you have already modified your Supabase database, synchronize it with your migration file. Otherwise create new tables for your database, then generate the Prisma client.

    New ProjectsPopulated Projects

    Create new tables in your prisma.schema file

    model Post {
  id        Int     @id @default(autoincrement())
  title     String
  content   String?
  published Boolean @default(false)
  author    User?   @relation(fields: [authorId], references: [id])
  authorId  Int?
}

model User {
  id    Int     @id @default(autoincrement())
  email String  @unique
  name  String?
  posts Post[]
}

    commit your migration

    npmpnpmyarnbun

    npx prisma migrate dev --name first_prisma_migration
npx prisma generate

  6. Test your API

    Create a index.ts file and run it to test your connection

    import "dotenv/config";
import { PrismaClient } from "./generated/prisma/client";
import { PrismaPg } from "@prisma/adapter-pg";

const adapter = new PrismaPg({ connectionString: process.env.DATABASE_URL });
export const prisma = new PrismaClient({ adapter });

async function main() {
  const val = await prisma.user.findMany({
    take: 10,
  });
  console.log(val);
}

main()
  .then(async () => {
    await prisma.$disconnect();
  })
  .catch(async (e) => {
    console.error(e);
    await prisma.$disconnect();
    process.exit(1);
});
Edit on GitHub
AI 翻译查看英文原文