prisma-postgres-workflows

📁 yigit433/nextjs-skills 📅 7 days ago

总安装量

周安装量

#77712

全站排名

安装命令

npx skills add https://github.com/yigit433/nextjs-skills --skill prisma-postgres-workflows

Agent 安装分布

amp 1

opencode 1

kimi-cli 1

codex 1

github-copilot 1

claude-code 1

Prisma ORM ve PostgreSQL ile Ã§alÄ±ÅÄ±rken migration, seed, reset ve ortam ayrÄ±mÄ± (dev/prod) iÃ§in standart workflow’lar ve script’ler saÄlar.

Prisma + PostgreSQL kullanan bir projede veritabanÄ± yÃ¶netim sÃ¼reÃ§leri standartlaÅtÄ±rÄ±lacaksa.
Dev ortamÄ±nda hÄ±zlÄ± reset/seed, prod ortamÄ±nda gÃ¼venli migration politikasÄ± gerekiyorsa.
Docker Compose ile tekrarlanabilir DB ortamÄ± isteniyorsa.

Dosya	AÃ§Ä±klama
`templates/docker-compose.yml`	PostgreSQL 16 container (healthcheck, named volume)
`templates/.env.example`	Ortam deÄiÅkenleri (DATABASE_URL dahil)
`templates/prisma/schema.prisma`	Base Prisma schema (datasource + generator + Ã¶rnek model)
`templates/prisma/seed.ts`	Ãrnek seed dosyasÄ± (upsert pattern)
`scripts/init.sh`	Projeyi sÄ±fÄ±rdan ayaÄa kaldÄ±rÄ±r
`scripts/db-migrate.sh`	Ortama gÃ¶re migrate dev / migrate deploy
`scripts/db-reset.sh`	Dev-only DB reset (prod’da reddeder)
`scripts/db-seed.sh`	Prisma seed Ã§alÄ±ÅtÄ±rÄ±r

PostgreSQL baÅlat: docker compose up -d veya bash scripts/init.sh
Ortam deÄiÅkenlerini ayarla: .env.example dosyasÄ±nÄ± .env olarak kopyala, deÄerleri gÃ¼ncelle.
Schema tanÄ±mla: prisma/schema.prisma dosyasÄ±nÄ± projeye gÃ¶re dÃ¼zenle.
Dev migration: bash scripts/db-migrate.sh --name init
Seed: bash scripts/db-seed.sh
Prod deploy: NODE_ENV=production bash scripts/db-migrate.sh