skills.rest
drhayf
drhayfCOMMUNITY
Explore all skills by this author →
GitHub

database-patterns

Standardize JSONB database patterns across SQLAlchemy 2.0 models, migrations, and queries.

Updated Aug 23, 2026
Search Tags:#postgresql#migrations#orm#sqlalchemy#alembic#jsonb#database-patterns
One-click install
npx skills add https://github.com/drhayf/GUTTERS --skill database-patterns-drhayf
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-patterns
Source: https://github.com/drhayf/GUTTERS/tree/main/.agent/skills/database-patterns
Command: npx skills add https://github.com/drhayf/GUTTERS --skill database-patterns-drhayf

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Database patterns for GUTTERS emphasize JSONB-enabled flexibility, consistent indexing, and a robust Alembic-driven migration workflow to keep models aligned with evolving requirements.

Core Features & Use Cases

  • JSONB-centric patterns for models and configurations
  • Automated migration workflows using Alembic with strict versioning
  • Guidance for indexing, JSONB usage, and type hints across modules

Quick Start

Create a module using the database-patterns templates to ensure JSONB configs and proper migrations.

Frequently Asked Questions about database-patterns

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

FAQPage Schema
How do I structure SQLAlchemy 2.0 models to use PostgreSQL JSONB fields?▼

To structure SQLAlchemy 2.0 models with PostgreSQL JSONB fields, apply standardized database patterns that ensure flexible configurations and consistent indexing across your schema. This approach maintains model alignment during complex data access operations.

What is the best way to automate Alembic migrations for evolving database schemas?▼

Automating Alembic migrations requires a strict versioning workflow to keep models aligned with evolving requirements. Using standardized database patterns ensures repeatable migrations and consistency across PostgreSQL schemas during deployment.

Do I need PostgreSQL to use JSONB-centric database patterns?▼

Yes, JSONB-centric database patterns require PostgreSQL or a compatible database with JSONB support. Proper indexing of these JSONB fields is necessary to ensure query performance and maintain consistent data access workflows.

How does indexing JSONB columns work in SQLAlchemy and Alembic workflows?▼

Indexing JSONB columns in SQLAlchemy involves applying specific database patterns to maintain query performance. Combined with an Alembic-driven migration workflow, these indexes ensure consistent data access as models evolve.

When should I use JSONB fields instead of standard relational columns in PostgreSQL?▼

Use JSONB fields in PostgreSQL when your application requires schema flexibility for complex configurations. Standardized database patterns provide guidance on when to leverage JSONB usage over rigid columns while maintaining proper indexing.

Related Skills

Explore More Software Engineering Skills→
NelkitNelkit
1

alembic-migration

Automate PostgreSQL schema changes with SQLAlchemy ORM and Alembic migrations.

Community
Intermediate
CJHarmathCJHarmath

postgres-patterns

Review PostgreSQL migrations and optimize query performance with SQL patterns.

Community
Advanced
amaozhaoamaozhao

fastapi-database-async

Configure an asynchronous SQLAlchemy 2.0 database layer for FastAPI projects.

Community
Intermediate
albertdobmeyeralbertdobmeyer
2

sql-toolkit

Manage SQL database tasks across SQLite, PostgreSQL, and MySQL.

Community
Intermediate