Database Management Agent Skills

Ecotone Business Interface Builder

Generates auto-implemented PHP interfaces for database queries, messaging gateways, and data converters using the Ecotone Framework.

Ecotone Event Sourcing

Implements robust event sourcing patterns, projections, and event versioning within the Ecotone framework.

Database Migration

Generates database migration files with automated schema changes and corresponding rollback logic.

PHP N+1 Query Detector

Identifies and fixes inefficient N+1 database query patterns in PHP applications to optimize performance.

PHP Event Store Generator

Generates robust Event Store infrastructure for PHP 8.4 applications using Event Sourcing and DDD patterns.

PHP Batch Processing Optimizer

Identifies and refactors inefficient PHP loops that perform repetitive database, API, and file operations into high-performance batch processes.

Backend Migrations

Manages database schema transitions and production migration workflows according to established backend engineering standards.

PHP Query Efficiency Analyzer

Analyzes PHP code and SQL queries to identify performance bottlenecks, missing indexes, and inefficient data retrieval patterns.

Backend Models

Standardizes the implementation and management of backend data models to ensure architectural consistency and best practices.

PHP Snapshot Pattern Generator

Generates Snapshot pattern infrastructure for PHP 8.4 to optimize event sourcing aggregate rebuild performance.

PHP Database Index Auditor

Identifies missing database indexes and optimizes query performance within PHP and Doctrine-based applications.

PHP Cache-Aside Generator

Generates robust Cache-Aside infrastructure for PHP 8.4 applications with stampede protection and tag-based invalidation.

PHP Lazy Loading Analyzer

Optimizes PHP performance by identifying inefficient database loading patterns, missing pagination, and memory-intensive queries.

Backend Queries

Standardizes backend query implementation by applying specialized coding patterns and optimization guidelines.

PostgreSQL Development Standards

Enforces strict transaction safety, type-safe schema designs, and robust PostgreSQL naming conventions for reliable database architecture.

Transactional Outbox Pattern Knowledge

Implements and audits the Transactional Outbox pattern in PHP applications to ensure reliable event delivery and data consistency.

Caching Strategies & Redis Patterns

Provides a comprehensive knowledge base for implementing efficient caching patterns, invalidation strategies, and Redis data structures.

Event Sourcing Architecture Expert

Implements and audits high-performance Event Sourcing architectures using PHP 8.4 patterns and Domain-Driven Design principles.

PHP DDD Repository Generator

Generates DDD-compliant Repository interfaces and PHP 8.4 infrastructure implementations for clean architecture.

PHP Connection Pool Analyzer

Identifies and resolves database connection leaks, pool exhaustion, and lifecycle issues in PHP applications.

PHP Unit of Work Generator

Generates robust Unit of Work infrastructure for PHP 8.4 to ensure transactional consistency across multiple domain aggregates.

JPA Entity Creator

Generates robust, production-ready JPA entities following Spring Boot best practices and Domain-Driven Design principles.

PostgreSQL Schema Dumper

Exports a clean, stripped-down PostgreSQL database schema to a local file and copies the file path to the clipboard.

Django ORM Patterns

Optimizes database interactions by implementing advanced Django ORM patterns for efficient queries, complex relationships, and performance tuning.

Ecto Schema Modeling

Models database entities in Elixir by defining Ecto schemas, complex associations, and embedded data structures.

Elixir Ecto Patterns

Implements robust database patterns for Elixir applications using Ecto schemas, changesets, and advanced query logic.

Bun SQLite Management

Optimizes SQLite database operations using Bun's native high-performance driver for efficient data storage and retrieval.

Ecto Changeset Mastery

Validates, casts, and transforms data for reliable database operations in Elixir applications using Ecto.

Rails Active Record Patterns

Implements robust Ruby on Rails models using optimized Active Record patterns for associations, validations, and complex queries.

Ecto Schema Patterns

Defines and implements robust Elixir data structures using Ecto schemas, associations, and advanced modeling patterns.