skills.rest
ayia
ayiaCOMMUNITY
Explore all skills by this author →
GitHub

database-manager

Manage NutriProfile's PostgreSQL database with async SQLAlchemy and Alembic migrations.

Updated Dec 22, 2025
Search Tags:#database#production#postgresql#migrations#async#sqlalchemy#alembic
One-click install
npx skills add https://github.com/ayia/NutriProfile --skill database-manager-ayia
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-manager
Source: https://github.com/ayia/NutriProfile/tree/main/.claude/skills/database-manager
Command: npx skills add https://github.com/ayia/NutriProfile --skill database-manager-ayia

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

NutriProfile's database management is complex, requiring reliable async access, migrations, and production deployment handling. This skill provides a cohesive pattern to work with PostgreSQL using SQLAlchemy (async), Alembic, and Fly Postgres, reducing boilerplate and mitigating schema drift.

Core Features & Use Cases

  • Async SQLAlchemy integration with PostgreSQL for non-blocking operations in FastAPI-like backends.
  • Alembic migrations workflow for schema changes and version control, including upgrade/downgrade guidance.
  • Fly Postgres production guidance for safe deployments and backups.

Quick Start

Connect to NutriProfile's database and apply pending migrations to bring the schema up to date.

Frequently Asked Questions about database-manager

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

FAQPage Schema
How do I run async SQLAlchemy migrations with Alembic for a PostgreSQL database?▼

To apply pending migrations to a PostgreSQL database, run Alembic upgrade commands using environment-based configuration and async connection handling, ensuring the schema changes are version-controlled and applied safely without blocking operations.

What is the best way to manage PostgreSQL schema changes in a FastAPI-like backend?▼

Managing PostgreSQL schema changes in a FastAPI-like backend requires async SQLAlchemy integration for non-blocking operations and Alembic workflows for version control, enforcing migration-driven changes to mitigate schema drift between environments.

Does Alembic work with async SQLAlchemy for Fly Postgres production deployments?▼

Alembic works with async SQLAlchemy for Fly Postgres production deployments by enforcing safe connection handling through environment-based configuration, enabling reliable migration workflows and schema version control.

How do I deploy PostgreSQL migrations safely to production with Fly Postgres?▼

Deploying PostgreSQL migrations safely to Fly Postgres production requires migration-driven schema changes, async-first connection handling, and environment-based configuration to ensure safe deployments and reliable backups.

When do I need environment-based configuration for async PostgreSQL connections?▼

Environment-based configuration for async PostgreSQL connections is needed when managing production deployments with Fly Postgres, enforcing safe connection handling and preventing schema drift across different deployment environments.

Related Skills

Explore More Software Engineering Skills→
agusmdevagusmdev
3

fastapi-database-setup

Configure async SQLAlchemy 2.0 engine, session factory, and get_db dependency for FastAPI with PostgreSQL.

Community
Intermediate
ricardorochericardoroche
2

database-migrations

Automate Alembic database migrations with reversible upgrade and downgrade scripts.

Community
Intermediate
FEMADOXFEMADOX
4

sqlalchemy-alembic-expert-best-practices-code-review

Review SQLAlchemy models and Alembic migrations for safe production practices.

Community
Advanced
RepairYourTechRepairYourTech
6

database-migration-management

Manage PostgreSQL and MySQL schema changes with SQL migration scripts.

Community
Advanced