# Provision Prisma Postgres for Local Projects

Manual database provisioning and Prisma 7 configuration require several coordinated API, dependency, and migration steps. This skill guides the complete setup and verification workflow.

## Install

```bash
npx skillstore add prisma/prisma-postgres-setup
```

## Metadata

- Status: approved
- Slug: prisma-prisma-postgres-setup
- Version: 1.1.0
- Author version: 1.1.0
- Skillstore revision: r2
- Version status: valid
- Tree hash: 6c80091cae61d79e2af7fc084b4b2b8c5e23ce99b2a00a8f8be424e2a467c492
- Author: prisma
- GitHub username: prisma
- License: MIT
- Repository: https://github.com/prisma/skills/tree/1a9f427e9fe2137298abbcc1a6f372db92e8c40d/prisma-postgres-setup
- Ref: ebdfe608f5de2b66ff37ab4af12af8ac4f5e8006
- Supported tools: Claude, Codex, Claude Code
- Audit status: complete
- Agent install advisory: confirmation\_required
- Manual install advisory: allowed
- Artifact signature: available
- Audit attestation: unavailable
- Human verification: not\_verified
- Risk factors: network, env\_access, external\_commands
- Quality score: 38
- Quality tier: warning
- Public page: https://skillstore.pages.dev/skills/prisma-prisma-postgres-setup
- Manifest: https://skillstore.pages.dev/api/skills/prisma-prisma-postgres-setup/manifest

## Capabilities

- Lists available Prisma Postgres regions and helps users select an available location.
- Creates a Prisma project and default database through the Management API.
- Creates optional named database connections for developers or environments.
- Configures Prisma 7 dependencies, environment loading, schema files, and the PostgreSQL adapter.
- Creates an initial migration or uses schema push only for explicit prototypes.
- Runs a temporary connection check and provides Prisma Studio and Console access paths.

## Use Cases

- Start a New Prisma Application: Provision a development database, configure Prisma 7, create a starter schema, and verify connectivity.
- Standardize Team Setup: Apply one repeatable database and client configuration process across local Node.js projects.
- Prepare a Migration Baseline: Connect existing models to a new database and create reviewed migration history for later deployment.

## Prompt Templates

### Set Up a New Project

```
Set up Prisma Postgres for this Node.js project. Ask before creating cloud resources, changing files, installing packages, or running migrations.
```

### Create a Starter Database

```
Provision a Prisma Postgres database in my chosen available region. Configure Prisma 7, add a starter blog schema, then verify the connection.
```

### Preserve Existing Models

```
Connect this existing Prisma 7 codebase to a new Prisma Postgres database. Preserve existing models and create an initial migration after my confirmation.
```

### Run a Controlled Provisioning Audit

```
Audit this repository for Prisma 7 readiness, propose required changes, provision a development connection, migrate safely, and report every local and remote modification.
```

## Limitations

- Requires Node.js 18 or newer, a Prisma workspace, and a workspace service token.
- Targets new Prisma Postgres databases and local Prisma 7 projects.
- Does not manage CI/CD preview databases or embedded multi-tenant provisioning.
- Cloud creation, deletion, migrations, and package installation can modify remote and local resources.

## Best Practices

- Use a short-lived service token and rotate it after setup.
- Review region, project name, schema, and destructive actions before confirmation.
- Keep environment files ignored and inspect migrations before applying them.

## Anti Patterns

- Do not paste production credentials into source files or commit environment files.
- Do not delete projects automatically when a workspace limit is reached.
- Do not use schema push when migration history is required.

## Security Audit

- Audited at: 2026-07-23T17:58:14.33\+00:00
- Summary: Ten static findings are confirmed: eight executable command spans and two operations involving secret-bearing environment files. Most alerts are Markdown, official Prisma URLs, placeholders, or standard local configuration. Contextual review found unsafe token handling and permanent project deletion, but no prompt injection or unrelated exfiltration.

## Stats

- Views: 0
- Downloads: 3
- Favorites: 0
- Popularity score: 0