prisma-database-setup

Set provider to "postgresql" in prisma/schema.prisma, define the datasource URL in prisma.config.ts using env('DATABASE_URL'), and add the connection string to .env. Then install @prisma/adapter-pg and pg, and instantiate PrismaClient with the PrismaPg adapter.

Install prisma and @prisma/client, add a generator block with provider "prisma-client" and an explicit output path, then run npx prisma generate. Instantiate PrismaClient by passing the database-specific adapter, such as PrismaPg for PostgreSQL.

MongoDB projects should stay on the latest Prisma 6.x release with the prisma-client-js generator and the connection URL in schema.prisma. The Prisma 7 SQL driver adapter workflow does not apply to MongoDB, and no supported MongoDB upgrade path exists yet.

For MySQL or MariaDB, install @prisma/adapter-mariadb with the mariadb driver. For SQLite, use @prisma/adapter-better-sqlite3 with better-sqlite3, or @prisma/adapter-libsql with @libsql/client for Turso and edge environments.

Common causes include wrong host or port, firewall rules, unencoded special characters in the password, or a missing schema parameter like ?schema=public in the PostgreSQL URL. Verify the database is running and the connection string format matches your provider.

SQLite does not support enums or scalar list types like String[] directly, and write operations lock the database file, limiting concurrency. It suits local development and file-based apps but not high-concurrency production workloads.