databaselisted

# Database Operations & Management This skill provides comprehensive database patterns and best practices for 2025, focusing on async operations, performance optimization, and production-ready configurations that work across different database systems. ## When to Use This Skill Use this skill when you need to: - Design database schemas with SQLModel/SQLAlchemy - Implement async database operations - Optimize database performance - Set up connection pooling - Create and manage database migrations - Handle complex relationships and queries - Set up production database configurations - Monitor and troubleshoot database issues ## Core Database Patterns ### 1. Async Connection Management ```python # Database connection setup with connection pooling import asyncio from sqlalchemy.ext.asyncio import AsyncSession, create_async_engine, async_sessionmaker from sqlalchemy.pool import NullPool from contextlib import asynccontextmanager import os # Environment-based configuration DATABASE_CONFIG = { "development": { "url": "sqlite+aiosqlite:///./app.db", "poolclass": NullPool, "echo": True }, "production": { "url": os.getenv("DATABASE_URL", "postgresql+asyncpg://user:pass@localhost/db"), "pool_size": 30, "max_overflow": 40, "pool_pre_ping": True, "pool_recycle": 3600, "echo": False } } class DatabaseManager: """Universal database manager for async operations""" def __init__(self, env: