Skills prisma-database-setup
📦
prisma-database-setup
v7.6.0 Content revision r2 Safe 📁 Filesystem access🔑 Env variables⚙️ External commands
Configure Prisma for Your Database
Prisma setup varies by database provider and major version. This skill provides provider-specific schemas, connection guidance, adapters, client generation, and troubleshooting steps.
Supports: Claude Codex Code(CC)
Install with my Agent
Copy this request to your Agent. It includes the canonical Skill page and manifest.
Agent request
Review the Skillstore skill "prisma-database-setup" from https://skillstore.io/skills/prisma-prisma-database-setup.md and its manifest at https://skillstore.io/api/skills/prisma-prisma-database-setup/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.Your Agent should still show its plan and request any confirmation required by the security policy.
Agent-readable resources
Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.
Test it
Using "prisma-database-setup". Set up Prisma 7 with PostgreSQL in a Node.js project.
Expected outcome:
- Install Prisma Client, Prisma CLI, the PostgreSQL adapter, and the pg driver.
- Configure the PostgreSQL provider and datasource environment variable.
- Generate the client and create one reusable adapter-backed client instance.
Using "prisma-database-setup". Configure Prisma for an existing MongoDB application.
Expected outcome:
- Keep the project on the latest supported Prisma 6 release.
- Use the MongoDB provider and the classic Prisma Client generator.
- Confirm replica-set support and ObjectID mappings before synchronizing the schema.
Using "prisma-database-setup". My Prisma MySQL application reports too many connections.
Expected outcome:
- Reuse one Prisma Client instance for each application process.
- Review the MySQL connection limit and adapter pool settings.
- Set an appropriate connection limit for the deployment environment.
Security Audit
Safev6 • 7/23/2026 Open versioned report
The skill contains documentation and examples for Prisma configuration. The flagged paths, environment variables, credentials, and backticks are fixed examples with no prompt injection, secret exfiltration, or executable audit payload.
9
Files scanned
975
Lines analyzed
0
Review items
0
False positives ignored
Risk Factors
📁 Filesystem access (23)
references/cockroachdb.md:20 references/cockroachdb.md:61 references/mysql.md:21 references/mysql.md:72 references/mysql.md:92 references/postgresql.md:21 references/postgresql.md:73 references/prisma-client-setup.md:19 references/prisma-client-setup.md:36 references/prisma-postgres.md:43 references/prisma-postgres.md:76 references/prisma-postgres.md:110 references/sqlite.md:20 references/sqlite.md:66 references/sqlite.md:87 references/sqlserver.md:21 references/sqlserver.md:69 SKILL.md:82 SKILL.md:103 SKILL.md:114 SKILL.md:133 SKILL.md:145 SKILL.md:157
🔑 Env variables (50)
references/cockroachdb.md:64 references/cockroachdb.md:64 references/cockroachdb.md:60 references/cockroachdb.md:34 references/cockroachdb.md:44 references/cockroachdb.md:64 references/mongodb.md:22 references/mongodb.md:63 references/mysql.md:79 references/mysql.md:80 references/mysql.md:81 references/mysql.md:95 references/mysql.md:79 references/mysql.md:80 references/mysql.md:81 references/mysql.md:95 references/mysql.md:71 references/mysql.md:35 references/mysql.md:45 references/mysql.md:95 references/mysql.md:122 references/postgresql.md:76 references/postgresql.md:76 references/postgresql.md:72 references/postgresql.md:35 references/postgresql.md:45 references/postgresql.md:76 references/prisma-client-setup.md:39 references/prisma-client-setup.md:39 references/prisma-client-setup.md:39 references/prisma-postgres.md:79 references/prisma-postgres.md:86 references/prisma-postgres.md:95 references/prisma-postgres.md:115 references/prisma-postgres.md:79 references/prisma-postgres.md:86 references/prisma-postgres.md:95 references/prisma-postgres.md:115 references/prisma-postgres.md:75 references/prisma-postgres.md:29 references/prisma-postgres.md:57 references/prisma-postgres.md:79 references/prisma-postgres.md:86 references/prisma-postgres.md:95 references/sqlite.md:70 references/sqlite.md:91 references/sqlite.md:92 references/sqlite.md:70 references/sqlite.md:91 references/sqlite.md:92
⚙️ External commands (48)
references/prisma-postgres.md:97-99 SKILL.md:29 SKILL.md:30 SKILL.md:39 SKILL.md:45 SKILL.md:46 SKILL.md:47 SKILL.md:48 SKILL.md:49 SKILL.md:50 SKILL.md:51 SKILL.md:57 SKILL.md:58 SKILL.md:59 SKILL.md:63 SKILL.md:67 SKILL.md:68 SKILL.md:69 SKILL.md:70 SKILL.md:71 SKILL.md:72 SKILL.md:73 SKILL.md:74 SKILL.md:76 SKILL.md:80-87 SKILL.md:87-94 SKILL.md:94-97 SKILL.md:97-99 SKILL.md:99-100 SKILL.md:100-105 SKILL.md:105-108 SKILL.md:108-110 SKILL.md:110-113 SKILL.md:113-119 SKILL.md:119-121 SKILL.md:121-126 SKILL.md:126-135 SKILL.md:135-138 SKILL.md:138-147 SKILL.md:147-150 SKILL.md:150-159 SKILL.md:159-162 SKILL.md:162-171 SKILL.md:171-173 SKILL.md:173 SKILL.md:179-188 SKILL.md:188-192 SKILL.md:192
No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.
Audited by: codex View Audit History →
Share & cite this report
Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.
Copy report link
https://skillstore.io/skills/prisma-prisma-database-setup/audits/6?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_reportMarkdown badge
[](https://skillstore.io/skills/prisma-prisma-database-setup?utm_source=security_passport_badge)HTML badge
<a href="https://skillstore.io/skills/prisma-prisma-database-setup?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/prisma-prisma-database-setup/security.svg" alt="Skillstore security assessment" loading="lazy"></a>Embed card
<iframe src="https://skillstore.io/embed/skills/prisma-prisma-database-setup.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>Academic citations (APA · BibTeX · CFF)
APA citation
prisma. (2026). prisma-database-setup security audit report (audit version 6) [Author version 7.6.0]. Skillstore. https://skillstore.io/skills/prisma-prisma-database-setup/audits/6BibTeX citation
@techreport{prisma-prisma-prisma-database-setup-2026,
author = {prisma},
title = {prisma-database-setup security audit report (audit version 6)},
institution = {Skillstore},
year = {2026},
number = {6},
url = {https://skillstore.io/skills/prisma-prisma-database-setup/audits/6},
note = {Author version 7.6.0}
}CITATION.cff
cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "prisma-database-setup security audit report (audit version 6)"
version: "7.6.0"
type: report
authors:
- name: "prisma"
date-released: "2026-07-23"
url: "https://skillstore.io/skills/prisma-prisma-database-setup/audits/6"
identifiers:
- type: other
value: "skillstore:prisma-prisma-database-setup:audit:6"
description: "Skillstore immutable audit report identifier"
Skillstore Score
Why this score Evidence Confidence: High 45
Architecture
100
Maintainability
87
Content
65
Community
91
Spec Compliance
What You Can Build
Start a SQL project
Configure a new Prisma project with the correct provider, adapter, connection variables, and generated client.
Build with local SQLite
Create a lightweight local database setup and understand SQLite paths, adapters, and feature limits.
Standardize database configuration
Compare provider requirements before changing databases or deploying Prisma across runtime environments.
Try These Prompts
Initialize Prisma
Configure Prisma for {database} in my {runtime} project. Show required packages, schema settings, environment variables, client generation, and a basic client instance.Add the correct adapter
Review my Prisma {database} setup for {runtime}. Identify the required driver adapter, packages, generated client import, and connection settings.Switch database providers
Move this Prisma project from {current_database} to {target_database}. Review the schema and configuration, then list required changes and compatibility concerns.Diagnose deployment connections
Diagnose this Prisma connection issue for {database} on {runtime}: {error_message}. Check URL format, adapter choice, pooling, environment values, and provider settings.Best Practices
- Keep real database credentials outside source control and use separate values for each environment.
- Confirm the Prisma major version and database provider before applying adapter guidance.
- Regenerate Prisma Client after every schema change and reuse one client instance per process.
Avoid
- Do not copy SQL driver adapter instructions into a MongoDB project.
- Do not commit environment files or real connection strings.
- Do not run production migrations without backups, review, and an approved deployment plan.
Frequently Asked Questions
Which databases are covered?
The guides cover PostgreSQL, MySQL, MariaDB, SQLite, MongoDB, SQL Server, CockroachDB, and Prisma Postgres.
Does this skill support MongoDB?
Yes. It uses the Prisma 6 MongoDB workflow because the Prisma 7 SQL adapter workflow does not apply.
Does this skill create a database?
Most guides expect an existing database. The Prisma Postgres guide also documents its authenticated provisioning command.
Does this skill store my credentials?
No. Examples use placeholders and named environment variables, while your project controls the real values.
Can I use Bun?
Yes. Run Prisma CLI commands through the documented Bun invocation so Prisma uses the Bun runtime.
Does this skill manage production migrations?
No. It covers provider and client setup, but production migration planning, backups, and recovery remain your responsibility.
Developer Details
Author
prismaLicense
MIT
Author version
v7.6.0
Skillstore revision
r2
Repository
https://github.com/prisma/skills/tree/1a9f427e9fe2137298abbcc1a6f372db92e8c40d/prisma-database-setupRef
ebdfe608f5de2b66ff37ab4af12af8ac4f5e8006
Maintenance freshness
7/25/2026
Usage
1 downloads · 0 views
File structure