configuring-connection-pools
Configure connection pool sizing for optimal performance. Use when configuring DATABASE_URL or deploying to production.
Configure connection pool sizing for optimal performance. Use when configuring DATABASE_URL or deploying to production.
Create or modify Doctrine entities. Use for database models.
Explain how this repo (and others) reason about defining migrations directly on models, keeping the commands aligned after changes.
Set up and configure DuckDB databases. Use when user needs to create databases, configure settings, or initialize DuckDB projects.
Manage checkpoints for rollback capability. Use when creating save points, rolling back changes, managing recovery points, or restoring previous states.
Advanced Database Reliability Engineering, Performance, and Safe Migrations
Chuẩn hoá cách đọc/viết DB model Supabase (migrations + TS types + services) trong repo này.
Supabase 프로젝트 초기 설정. 테이블 생성, RLS 정책, 환경변수 설정, 타입 생성. "Supabase 설정", "DB 셋업" 요청 시 사용.
Run mjr.wtf locally using Docker Compose (SQLite), including migrations, logs, and teardown.
Sequelize migration patterns and best practices for PostgreSQL schema changes. Use when creating migrations, modifying tables, managing indexes, or handling data migrations safely.
Apply the Agent OS standard for backend migrations.
This skill should be used when working with database migrations in SQLModel-based projects. Trigger when user asks to create migrations for new/modified models, generate database schema changes, or apply migrations. Enforces SQLModel as single source of truth and automatic migration generation only.
Write secure, optimized database queries using parameterized statements, eager loading, and proper indexing to prevent SQL injection and N+1 query problems. Use this skill when writing database queries, using ORM query methods, implementing data fetching logic, or optimizing database performance. When working with SQL queries, ORM query builders, repository patterns, or data access layers. When implementing joins, eager loading, query optimization, transactions, or query caching. When selecting data, filtering records, or fetching related associations in service files, repository files, or controller methods.
A skill for managing database migrations with Alembic. Use this for tasks involving Alembic initialization, configuration, creating new migration scripts (both autogenerated and manual), defining upgrade and downgrade logic, handling data migrations, testing migrations, performing rollbacks, and following production deployment best practices for database changes.
USE IMMEDIATELY when user reports TODO accessibility issues or session migration detected. Restores TODO context using policy-guided recovery.
Instructions for managing Entity Framework Core migrations using project scripts. Use when adding, removing, applying, or listing database migrations.
Create and manage Supabase database migrations using MCP tools. Use when creating tables, modifying schemas, adding RLS policies, or working with database structure.
Safe database migration creation and management for Supabase PostgreSQL
Create, apply, and rollback goose migrations for SQLite using the embedded migrate tool.
Workflow chuẩn khi làm việc với Supabase (DDL/migrations, query/debug, RLS policies) cho repo này.
Add, remove, or query task dependencies in the local tasks database
Create Laravel database migrations with proper columns, indexes, and foreign keys
Resets local development database by deleting all data and restarting API container to trigger auto-seeding. SINGLE SOURCE OF TRUTH for dev database reset automation.
Manages Entity Framework Core migrations using project scripts. Use when creating, applying, listing, or removing database migrations.