skills.rest
Tzeusy
TzeusyCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

butler-db-schema

Design PostgreSQL schemas and Alembic migrations for Butler framework modules.

Updated Feb 9, 2026
Search Tags:#schema design#database#postgresql#migrations#alembic#butler framework
One-click install
npx skills add https://github.com/Tzeusy/butlers --skill butler-db-schema
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: butler-db-schema
Source: https://github.com/Tzeusy/butlers/tree/main/.claude/skills/butler-db-schema
Command: npx skills add https://github.com/Tzeusy/butlers --skill butler-db-schema

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides comprehensive guidance on designing, managing, and evolving PostgreSQL database schemas for the Butler framework, ensuring data integrity and efficient operations.

Core Features & Use Cases

  • Schema Design Principles: Understand best practices for table creation, data types, and indexing.
  • Migration Management: Learn to use Alembic for robust, backward-compatible schema changes across core, module, and butler-specific databases.
  • Use Case: When developing a new Butler module, use this Skill to define its database tables, write the necessary Alembic migrations, and ensure proper schema isolation and access control.

Quick Start

Consult the schema design principles for creating new tables in a butler's schema.

Frequently Asked Questions about butler-db-schema

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

FAQPage Schema
How do I design PostgreSQL database schemas for the Butler framework?▼

Design PostgreSQL schemas for the Butler framework by applying best practices for table creation, data types, and indexing. Define core tables, module-specific schemas, and butler-specific data models to ensure data integrity.

How do I use Alembic migrations to manage database schema changes in Butler?▼

Use Alembic migrations for version-controlled, backward-compatible schema changes across core, module, and butler-specific databases. The multi-chain migration architecture ensures robust data management during schema evolution.

When do I need schema isolation for PostgreSQL databases in a multi-module environment?▼

Schema isolation is needed when developing new modules to enforce proper access control. Distinct schemas per butler prevent conflicts and maintain clear boundaries between core, module, and butler-specific data models.

What are the best practices for indexing strategies in PostgreSQL schema design?▼

Indexing strategies in PostgreSQL schema design involve defining optimal indexes during table creation to ensure efficient query operations. Apply these principles when creating new tables within a butler's schema.

Does the Butler framework enforce backward compatibility rules for database migrations?▼

Yes, the Butler framework enforces backward compatibility rules for database migrations. Alembic manages these version-controlled changes to ensure existing operations remain functional during schema evolution across distinct databases.

Related Skills

Explore More Software Engineering Skills→
thehivegroup-aithehivegroup-ai

postgres-standards

Manage PostgreSQL schema design, migrations, and query optimization with psycopg2.

Official
Intermediate
HeldinhowHeldinhow
4

database-migrations

Manage database schema changes through version-controlled migration scripts.

Community
Intermediate
NelkitNelkit
1

alembic-migration

Automate PostgreSQL schema changes with SQLAlchemy ORM and Alembic migrations.

Community
Intermediate
openmeterioopenmeterio
2.2k

db-migration

Generate SQL migrations for ent framework schema changes on PostgreSQL.

Official
Intermediate