Can I use this for production migrations?

Yes, the module is designed to work seamlessly with Alembic, allowing you to manage version-controlled database migrations safely in production.

Is auto-table creation safe for production?

No, the skill includes a safety check that raises an error if auto_create_tables is enabled while the environment is set to production.

Does it support connection pooling?

Yes, it includes built-in support for connection pooling with configurable pool size, max overflow, and recycle times to optimize database performance.

How are database sessions managed?

Sessions are REQUEST-scoped by default, meaning a new session is automatically created for each HTTP request and properly closed once the request is finished.

What databases are supported by the DataModule?

It supports major SQL databases compatible with SQLAlchemy's async drivers, including PostgreSQL via asyncpg, MySQL via aiomysql, and SQLite via aiosqlite.

Myfy Database Module

Name: Myfy Database Module
Author: psincraian

bypsincraian

•

Database Management

Integrates asynchronous SQLAlchemy database access with connection pooling and request-scoped sessions into Myfy applications.

The DataModule skill streamlines database management for Myfy applications by providing a robust wrapper for asynchronous SQLAlchemy. It simplifies complex tasks like connection pooling, transaction management, and session injection, ensuring that database operations are efficient and thread-safe within a request-scoped architecture. Whether you are defining declarative models, managing migrations via Alembic, or handling automated table creation in development, this module provides the patterns and configuration hooks necessary to build high-performance, data-driven backend services.

Key Features

01Request-scoped session management with automatic injection and cleanup

02Support for multiple database engines including PostgreSQL, MySQL, and SQLite

03Environment-aware table creation and integrated Alembic migration workflows

04Asynchronous SQLAlchemy integration for non-blocking database operations

05Advanced connection pooling with health checks and pre-ping functionality

0683 GitHub stars

Use Cases

01Managing complex database schema definitions and version-controlled migrations

02Building scalable REST APIs that require automatic database session handling per request

03Implementing transactional logic across multiple database operations in a single API call

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add psincraian/myfy data-module

For use in Claude.ai and ChatGPT

Download Skill