skills.rest
hopeoverture
hopeovertureCOMMUNITY
Explore all skills by this author →
GitHub

supabase-prisma-database-management

Manage Prisma schema, migrations, and seed data for Supabase PostgreSQL.

6|Updated Nov 11, 2025
Search Tags:#database#migrations#supabase#prisma#ci#seeds#shadow-database
One-click install
npx skills add https://github.com/hopeoverture/worldbuilding-app-skills --skill supabase-prisma-database-management
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: supabase-prisma-database-management
Source: https://github.com/hopeoverture/worldbuilding-app-skills/tree/main/skills/development/supabase-prisma-database-management
Command: npx skills add https://github.com/hopeoverture/worldbuilding-app-skills --skill supabase-prisma-database-management

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes assets (resource) and references (resource) components.

What problem does it solve?

This Skill guides managing Prisma schemas, migrations, and seed data for Supabase PostgreSQL, including shadow database configuration, CI checks, and cross-environment management.

Core Features & Use Cases

  • Schema & migrations: design Prisma schemas and generate migrations for Supabase.
  • Shadow database: configure shadow database for safe migrations during previews.
  • Seeding: create seed scripts and seed data for development and testing.
  • CI integration: run schema checks and migrations in CI to ensure reliability across environments.

Quick Start

Define schema.prisma, set up Prisma and Supabase URLs, run migrations (npx prisma migrate dev), then seed data and configure CI checks.

Frequently Asked Questions about supabase-prisma-database-management

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I set up Prisma migrations with Supabase?▼

Prisma migrations on Supabase require configuring DATABASE_URL for schema changes and DIRECT_URL for application queries. Define your schema.prisma, run npx prisma migrate dev to generate migrations, and push changes to your Supabase PostgreSQL instance.

What is a shadow database and why do I need it for Prisma?▼

A shadow database is a temporary copy of your schema that Prisma uses to preview migrations safely without affecting production. Configure shadowDatabaseUrl in your Prisma connection settings to validate schema changes before applying them.

How do I seed data in Prisma for development and testing?▼

Create idempotent seed scripts in prisma/seed.ts that populate your database with test data. Run npx prisma db seed after migrations to ensure consistent data across development and CI environments.

Can I automate Prisma schema validation in CI/CD?▼

Yes. Integrate Prisma migration checks into CI pipelines to validate schema changes before deployment. Run npx prisma migrate deploy and schema validation commands automatically across environments to catch breaking changes early.

Does Prisma work with Supabase PostgreSQL for cross-environment management?▼

Prisma fully supports Supabase PostgreSQL with dual-connection setup for schema migrations and application queries. Manage schema changes across development, staging, and production environments using migrations and CI-driven validation.

Why do I need separate DATABASE_URL and DIRECT_URL connections?▼

DATABASE_URL routes through Supabase's connection pooler for migrations, while DIRECT_URL connects directly to PostgreSQL for application queries. This separation prevents pooler conflicts and ensures reliable schema management.

Related Skills

Explore More Software Engineering Skills→
rostiSerostiSe
1

prisma-database-setup

Configure Prisma across PostgreSQL, MySQL, SQLite, and MongoDB providers.

Community
Intermediate
blazefluzblazefluz

Database Administrator (PostgreSQL)

Optimize slow PostgreSQL queries using pg_stat_statements for the Rentable application.

Community
Advanced
yonatangrossyonatangross
217

commit

Create Git commits following the Conventional Commits specification with local validation.

Community
Intermediate
as4584as4584
2

database-migration

Manage database schema and data migrations across Sequelize, TypeORM, and Prisma.

Community
Advanced