skills.rest
iukumarasiri-dev
iukumarasiri-devCOMMUNITY
Explore all skills by this author →
GitHub

prisma-database-setup

Configure Prisma ORM with PostgreSQL, MySQL, SQLite, MongoDB, and other database providers.

Updated Jul 30, 2026
Search Tags:#postgresql#ORM#Prisma#MySQL#MongoDB#database setup#driver adapter
One-click install
npx skills add https://github.com/iukumarasiri-dev/JobNest-AI --skill prisma-database-setup-iukumarasiri-dev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-database-setup
Source: https://github.com/iukumarasiri-dev/JobNest-AI/tree/main/job-assistant/.windsurf/skills/prisma-database-setup
Command: npx skills add https://github.com/iukumarasiri-dev/JobNest-AI --skill prisma-database-setup-iukumarasiri-dev

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Setting up Prisma ORM with the correct database provider, connection string, driver adapter, and client generation involves many version-specific details that are easy to get wrong, especially with the differences between Prisma 6 and Prisma 7 workflows. ## Core Features & Use Cases - Provider-Specific Guides: Step-by-step setup references for PostgreSQL, MySQL, SQLite, MongoDB, SQL Server, CockroachDB, and Prisma Postgres. - Driver Adapter Configuration: Maps each database to the correct @prisma/adapter-* package and JS driver, with ready-to-use PrismaClient instantiation code. - Version Guardrails: Clarifies that MongoDB projects should stay on Prisma 6.x with prisma-client-js, while SQL providers use the Prisma 7 prisma.config.ts workflow. - Use Case: When initializing a new project with PostgreSQL, follow the reference to set the datasource provider, configure DATABASE_URL in prisma.config.ts, install @prisma/adapter-pg, and generate the client with an explicit output path. ## Quick Start Ask the assistant to configure Prisma with your chosen database, for example: set up Prisma with PostgreSQL including the driver adapter and client generation.

Frequently Asked Questions about prisma-database-setup

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I configure Prisma with PostgreSQL?▼

Set provider to "postgresql" in prisma/schema.prisma, define the datasource URL via env('DATABASE_URL') in prisma.config.ts, then install @prisma/adapter-pg and pg. Instantiate PrismaClient with new PrismaPg({ connectionString: process.env.DATABASE_URL }).

Which Prisma driver adapter should I use for my database?▼

PostgreSQL, CockroachDB, and Prisma Postgres use @prisma/adapter-pg with pg; MySQL uses @prisma/adapter-mariadb; SQLite uses @prisma/adapter-better-sqlite3 or @prisma/adapter-libsql for Turso; SQL Server uses @prisma/adapter-mssql. MongoDB uses no SQL adapter.

Can I use MongoDB with Prisma 7?▼

MongoDB projects should stay on the latest Prisma 6.x release with the prisma-client-js generator and url = env("DATABASE_URL") in the schema. Prisma 7's SQL adapter workflow does not provide a supported MongoDB upgrade path.

Why does Prisma report too many connections on MySQL?▼

MySQL enforces a connection limit and each PrismaClient instance creates its own connection pool. Reuse a single PrismaClient instance per process and adjust the pool size with the connection_limit parameter in the DATABASE_URL.

What are the limitations of SQLite with Prisma?▼

SQLite does not support enums or scalar list types like String[] directly, and write operations lock the database file, limiting concurrency. For edge runtimes or Turso, use the @prisma/adapter-libsql driver adapter instead.

How do I set up Prisma with PlanetScale?▼

PlanetScale uses the mysql provider but does not support foreign key constraints, so set relationMode = "prisma" in the datasource block to emulate relations at the Prisma level. Then follow the standard MySQL adapter setup with @prisma/adapter-mariadb.

Related Skills

Explore More Software Engineering Skills→
CodenburgCodenburg

prisma-database-setup

Configure Prisma with PostgreSQL, MySQL, SQLite, MongoDB, SQL Server, and CockroachDB.

Community
Advanced
HollowvynHollowvyn

prisma-orm

Generate type-safe Prisma clients and manage schema migrations for TypeScript.

Official
Advanced
mcclowesmcclowes

railway

Automate Railway CLI workflows for deployments, PostgreSQL, and environment management.

Community
Advanced
johinsDevjohinsDev

drizzle-orm

Build type-safe SQL schemas and queries in TypeScript with Drizzle ORM.

Community
Intermediate