skills.rest
soumeningit
soumeningitCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

prisma-database-setup

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

Updated Aug 21, 2026
Search Tags:#postgresql#orm#mongodb#prisma#database setup#driver adapter#connection string
One-click install
npx skills add https://github.com/soumeningit/FlowBoard --skill prisma-database-setup-soumeningit
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-database-setup
Source: https://github.com/soumeningit/FlowBoard/tree/main/packages/database/.windsurf/skills/prisma-database-setup
Command: npx skills add https://github.com/soumeningit/FlowBoard --skill prisma-database-setup-soumeningit

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Setting up Prisma ORM with different database providers involves provider-specific schema syntax, connection string formats, driver adapters, and version constraints 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: Correct adapter and driver pairings for each database, including edge/serverless options like Turso and Prisma Postgres serverless. - Version Guardrails: Clear guidance that MongoDB projects must stay on Prisma 6.x with prisma-client-js, avoiding unsupported Prisma 7 SQL adapter migrations. - Use Case: You are switching a Node.js app from SQLite to PostgreSQL. Use this Skill to update the datasource provider, configure prisma.config.ts, install @prisma/adapter-pg, and instantiate Prisma Client correctly. ## Quick Start Ask the assistant to configure Prisma with PostgreSQL in your project, including the schema datasource, environment variable, and driver adapter setup.

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 the datasource provider to "postgresql" in prisma/schema.prisma, define the DATABASE_URL in prisma.config.ts, and install @prisma/adapter-pg with the pg driver. Then instantiate PrismaClient with the PrismaPg adapter using your connection string.

How do I set up Prisma with MongoDB?▼

Stay on the latest Prisma 6.x release and use provider "mongodb" with prisma-client-js, keeping the URL in schema.prisma. Do not apply the Prisma 7 SQL adapter workflow, and ensure your instance is a replica set for transaction support.

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

Use @prisma/adapter-pg for PostgreSQL and CockroachDB, @prisma/adapter-mariadb for MySQL, @prisma/adapter-better-sqlite3 for SQLite, @prisma/adapter-libsql for Turso, and @prisma/adapter-mssql for SQL Server. MongoDB uses no SQL adapter.

Does Prisma 7 support MongoDB?▼

Prisma 7 does not provide a supported MongoDB upgrade path. MongoDB projects should remain on the latest Prisma 6.x release with prisma-client-js and the classic connection URL in the schema.

Why does Prisma report too many connections on MySQL?▼

MySQL enforces a connection limit that Prisma's connection pool can exceed. Reduce the pool size by adding a connection_limit parameter to your DATABASE_URL, and reuse a single PrismaClient instance per process.

What are the limitations of using SQLite with Prisma?▼

SQLite does not support enums or scalar list types like String[], and write operations lock the database file, limiting concurrency. For edge deployments, consider the LibSQL/Turso adapter instead of better-sqlite3.

Related Skills

Explore More Software Engineering Skills→
wichopswichops

database

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

Community
Intermediate
HollowvynHollowvyn

prisma-orm

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

Official
Advanced
alissonmds00alissonmds00

prisma-database-setup

Configure Prisma ORM schemas, environment variables, and client instantiation for SQL and NoSQL databases.

Community
Intermediate
alinaqialinaqi
705

database-schema

Enforces reading database schema files before writing queries to prevent column and type errors.

Community
Intermediate