skills.rest
Sahil-Showket
Sahil-ShowketCOMMUNITY
Explore all skills by this author →
GitHub

prisma-database-setup

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

Updated Aug 17, 2026
Search Tags:#postgresql#orm#mongodb#prisma#database setup#driver adapter#connection string
One-click install
npx skills add https://github.com/Sahil-Showket/ShopSphere --skill prisma-database-setup-sahil-showket
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-database-setup
Source: https://github.com/Sahil-Showket/ShopSphere/tree/main/services/product-service/.windsurf/skills/prisma-database-setup
Command: npx skills add https://github.com/Sahil-Showket/ShopSphere --skill prisma-database-setup-sahil-showket

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 configuration for PostgreSQL, MySQL, SQLite, MongoDB, SQL Server, CockroachDB, and Prisma Postgres, including schema blocks, prisma.config.ts, and .env connection strings. - Driver Adapter Setup: 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 must stay on Prisma 6.x with prisma-client-js and must not follow the Prisma 7 SQL adapter workflow. - Use Case: When bootstrapping a new microservice, ask the AI to configure Prisma with PostgreSQL, and it will produce the schema, config, environment variable, adapter installation, and client instantiation code in one pass. ## Quick Start Ask the AI to configure Prisma with PostgreSQL for a new project, including the connection string, driver adapter, and client generation steps.

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 in prisma.config.ts, and set DATABASE_URL in .env. Install @prisma/adapter-pg and pg, then pass a PrismaPg adapter instance to PrismaClient.

How to set up Prisma with MongoDB?▼

Stay on the latest Prisma 6.x release with the prisma-client-js generator and keep the connection URL in schema.prisma. MongoDB models require an id field mapped to _id with @db.ObjectId, and a replica set is required for transactions.

Which Prisma driver adapter should I use for MySQL?▼

Use @prisma/adapter-mariadb with the mariadb driver for MySQL or MariaDB. Instantiate PrismaMariaDb with host, port, user, password, and database options, then pass it to PrismaClient.

Can I use Prisma 7 with MongoDB?▼

No. Prisma 7's SQL adapter workflow does not provide a supported MongoDB upgrade path. MongoDB projects should remain on the latest Prisma 6.x release using prisma-client-js and prisma db push.

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 connection URL.

What are the limitations of SQLite with Prisma?▼

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

Related Skills

Explore More Software Engineering Skills→
wichopswichops

database

Provision and connect PostgreSQL, Redis, MySQL, and MongoDB databases on Railway.

Community
Intermediate
gil00pitagil00pita

prisma

Generate a type-safe Prisma Client from declarative schemas for Node.js and TypeScript.

Community
Advanced
k97k97
4

prisma-connection-pool-exhaustion

Configure Prisma connection pooling to fix P2024 timeout errors in serverless environments.

Community
Intermediate
porcupine-mdporcupine-md
11

migration

Detect ORMs, update schemas, generate migrations, and validate changes.

Official
Advanced