skills.rest
jpmartirez
jpmartirezCOMMUNITY
Explore all skills by this author →
GitHub

prisma-database-setup

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

Updated Aug 1, 2026
Search Tags:#database#postgresql#configuration#orm#mysql#mongodb#prisma
One-click install
npx skills add https://github.com/jpmartirez/kilatis --skill prisma-database-setup-jpmartirez
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-database-setup
Source: https://github.com/jpmartirez/kilatis/tree/main/frontend/.windsurf/skills/prisma-database-setup
Command: npx skills add https://github.com/jpmartirez/kilatis --skill prisma-database-setup-jpmartirez

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 format, driver adapter, and client generation workflow is error-prone, especially with the differences between Prisma 6 and Prisma 7 and the special handling MongoDB requires. ## 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: Enforces the Prisma 7 SQL adapter workflow while keeping MongoDB projects on Prisma 6.x with prisma-client-js. - Use Case: When migrating a Next.js app from SQLite to PostgreSQL, follow the postgresql reference to update the datasource provider, install @prisma/adapter-pg, set DATABASE_URL, and regenerate the client. ## Quick Start Ask the AI to configure Prisma to connect to your PostgreSQL database using the correct 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 .env. Install @prisma/adapter-pg and pg, then instantiate PrismaClient with the PrismaPg adapter.

How do I set up Prisma Client with a driver 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 with the adapter matching your database, such as PrismaPg for PostgreSQL.

Can I use Prisma 7 with MongoDB?▼

No. MongoDB projects should stay on the latest Prisma 6.x release using prisma-client-js and keep the connection URL in schema.prisma. The Prisma 7 SQL driver adapter workflow does not support MongoDB.

Which Prisma driver adapter should I use for MySQL?▼

Use @prisma/adapter-mariadb with the mariadb JS driver for MySQL or MariaDB. Pass connection options like host, port, user, password, and database to PrismaMariaDb, then provide the adapter to PrismaClient.

Why does Prisma fail to connect to my database?▼

Common causes include wrong host or port, firewall rules, unencoded special characters in the password, or a missing schema parameter in the URL. Verify the DATABASE_URL format matches your provider's connection string specification.

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. Use @prisma/adapter-better-sqlite3 locally or @prisma/adapter-libsql for Turso and edge deployments.

Related Skills

Explore More Software Engineering Skills→
wichopswichops

database

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

Community
Intermediate
doanchienthangdevdoanchienthangdev
4

Developing with Prisma

Implement Prisma ORM for type-safe database access and migrations.

Community
Intermediate
abzhawabzhaw

environment-config

Manage environment variables and secret keys across development, staging, and production.

Community
Intermediate
alinaqialinaqi
705

database-schema

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

Community
Intermediate