database-schema

Manage PostgreSQL schemas and migrations with Prisma ORM.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/TheKeithStewart/claude-workflows --skill database-schema
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-schema
Source: https://github.com/TheKeithStewart/claude-workflows/tree/main/example-orchestrator-workflow/.claude/skills/database-schema
Command: npx skills add https://github.com/TheKeithStewart/claude-workflows --skill database-schema

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill simplifies database schema management, migrations, and querying for PostgreSQL projects using Prisma ORM. It ensures correct configuration and adherence to project-specific patterns, preventing common errors and accelerating development.

Core Features & Use Cases

  • Schema Modification & Migrations: Safely add, modify, or remove database tables and fields with guided Prisma migrations, using helper scripts for correct schema paths.
  • Prisma ORM Operations: Write efficient and type-safe database queries using project-specific Prisma client imports and patterns like upserts and transactions.
  • Database Maintenance: Easily generate the Prisma client, open Prisma Studio for GUI management, or reset the database with dedicated helper scripts.
  • Use Case: Add a new user_preferences table to the database, create a migration, and generate the updated Prisma client, ensuring all operations follow the project's non-standard schema path and best practices.

Quick Start

Create a new Prisma migration named 'add_user_preferences_table' to add a new table to the database schema.