database

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

4|Updated Jan 13, 2026

Search Tags:#schema design #database #postgresql #migrations #sql #seeding

Ready to run

npx skills add https://github.com/ProfPowell/vanilla-breeze --skill database-profpowell

💬 Prompt for ChatGPT / Claude Chat▼

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.