skills.rest
ProfPowell
ProfPowellCOMMUNITY
Explore all skills by this author →
GitHub

database

Manage PostgreSQL schemas with SQL migrations, seeding, and documentation.

4|Updated Jan 13, 2026
Search Tags:#schema design#database#postgresql#migrations#sql#seeding
One-click install
npx skills add https://github.com/ProfPowell/vanilla-breeze --skill database-profpowell
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/ProfPowell/vanilla-breeze/tree/main/.claude/skills/database
Command: npx skills add https://github.com/ProfPowell/vanilla-breeze --skill database-profpowell

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the process of designing, implementing, and documenting PostgreSQL databases, ensuring a structured and maintainable data foundation for applications.

Core Features & Use Cases

  • Schema Design: Define tables, columns, data types, constraints, and relationships.
  • Migrations: Create and manage database schema changes with reversible up/down scripts.
  • Seeding: Populate databases with initial or test data using JavaScript and faker.js.
  • Documentation: Maintain a clear schema.sql file for an up-to-date overview of the database structure.
  • Use Case: When starting a new project, use this Skill to define the initial user and product tables, create the first migration, and seed the database with a few sample users.

Quick Start

Use the database skill to create a new migration file for a 'products' table.

Frequently Asked Questions about database

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

FAQPage Schema
How do I manage PostgreSQL schema changes with reversible migrations?▼

PostgreSQL schema changes are managed through reversible up/down SQL migration scripts, allowing you to apply structural updates like creating tables and foreign keys or rollback schema evolution when needed.

What is the best way to seed a PostgreSQL database with test data?▼

Seeding a PostgreSQL database with test data is handled by populating initial records using JavaScript and faker.js, specifically supporting development and testing environments with sample data generation.

How do I design and document PostgreSQL tables, indexes, and constraints?▼

Designing PostgreSQL schemas involves defining tables, columns, data types, and constraints, while maintaining a clear schema.sql file provides an up-to-date documentation overview of the entire database structure.

Can I use this database skill for a new project's initial schema setup?▼

Yes, this database skill suits new project setup by defining initial user and product tables, creating the first migration file, and seeding the database with a few sample users for immediate development.

Does this database skill support rollback capabilities for schema evolution?▼

Rollback capabilities for schema evolution are supported through down scripts, enabling developers to cleanly reverse applied SQL migrations and revert database structures to previous states.

What are the limitations of using SQL migrations for schema seeding?▼

Using SQL migrations for schema seeding means relying on JavaScript and faker.js for test data population, which limits seeding logic to JavaScript-based scripts rather than pure SQL data insertion scripts.

Related Skills

Explore More Software Engineering Skills→
windyskywindysky

moai-lang-csharp

Automate C# 12 and .NET 8 development patterns for ASP.NET Core apps.

Community
Advanced
willdadywilldady
63

database-schema-changes

Manage database schema modifications and synchronization for Platypus backend using Drizzle ORM and CLI toolsets.

Community
Intermediate
takutakahashitakutakahashi

build-test-auto

Detect project types and execute build and test commands with failure diagnostics.

Community
Advanced
rodmena-limitedrodmena-limited
3

moai-domain-database

Provide database schema design, query optimization, and indexing strategies.

Official
Advanced