prisma-database-setup

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

Updated Feb 27, 2026
One-click install
npx skills add https://github.com/firstaxel/neon --skill prisma-database-setup-firstaxel
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-database-setup
Source: https://github.com/firstaxel/neon/tree/main/.agents/skills/prisma-database-setup
Command: npx skills add https://github.com/firstaxel/neon --skill prisma-database-setup-firstaxel

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Setting up Prisma with the correct database provider, connection string format, driver adapter, and client generation workflow is error-prone, especially with the differences between Prisma 6 and Prisma 7 and between SQL and MongoDB providers. This Skill provides verified, provider-specific configuration guidance so you avoid misconfigured schemas, wrong adapters, and connection failures. ## Core Features & Use Cases - Provider-Specific Guides: Step-by-step setup for PostgreSQL, MySQL, SQLite, MongoDB, SQL Server, CockroachDB, and Prisma Postgres, including schema blocks, prisma.config.ts, and .env connection strings. - Driver Adapter Selection: Maps each database to the correct @prisma/adapter-* package and underlying JS driver, with instantiation examples for Prisma Client. - 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: You are switching a project from SQLite to PostgreSQL. Use this Skill to update the datasource provider, install @prisma/adapter-pg, set the DATABASE_URL format, and regenerate Prisma Client correctly. ## Quick Start Ask the assistant to configure Prisma for your chosen database, for example: set up Prisma with PostgreSQL including the driver adapter and connection string.

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 the format postgresql://user:password@host:5432/db?schema=public. Then install @prisma/adapter-pg and pg, and pass a PrismaPg adapter instance to PrismaClient.

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 Prisma 7 with MongoDB?▼

No, MongoDB projects should stay on the latest Prisma 6.x release with the prisma-client-js generator and the connection URL kept in schema.prisma. The Prisma 7 SQL adapter workflow does not provide a supported MongoDB upgrade path.

Why does Prisma fail to connect to my database?▼

Common causes include wrong host or port, firewall rules, unencoded special characters in passwords, or a missing schema parameter in the URL. Verify the connection string format for your provider and confirm the database server is running and reachable.

What are the limitations of Prisma with SQLite?▼

SQLite does not support enums or scalar list types like String[], and write operations lock the database file, limiting concurrency. Connection strings use the file:./dev.db format relative to where Prisma runs.