Database Management Agent Skills

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, query plan analysis, and efficient data access patterns.

WordPress SQL Manager

Executes SQL queries against WordPress Docker environments to inspect data, debug issues, and manage database tables.

Medusa Database Migration Generator

Generates database migration files for specific Medusa modules to synchronize data schemas with your application code.

Medusa Database Migrations

Executes and monitors database migrations for Medusa projects to ensure schema synchronization.

Data Impact & Downstream Lineage

Analyzes data dependencies to determine the impact and blast radius of proposed schema or pipeline changes.

Profiling Tables

Generates comprehensive data profiles and quality assessments for database tables to help engineers and analysts understand dataset structure and health.

Data Warehouse Schema Discovery

Automates data warehouse schema discovery and generates comprehensive documentation enriched with codebase context for AI-assisted data engineering.

Data Freshness Checker

Verifies the currency and reliability of database tables by analyzing update timestamps and pipeline health.

Ecto Thinking

Applies domain-driven design principles and Ecto best practices to architect robust Elixir database layers.

Ecto Database Essentials

Enforces best practices for Elixir Ecto database schemas, changesets, queries, and migrations.

Bun SQLite

Manages high-performance SQLite database operations using Bun's native driver for seamless data persistence and optimized queries.

Ecto Query Patterns

Streamlines Elixir database interactions using Ecto's Query DSL for composable, type-safe, and efficient data retrieval.

Elixir Ecto Patterns

Implements professional database patterns using Elixir's Ecto for robust schema design, data validation, and complex query generation.

Python Data Modeling & Classes

Master Python data structures using dataclasses, attrs, and Pydantic for clean, type-safe modeling and automated validation.

Ecto Schema Patterns

Models robust Elixir data structures using Ecto schemas, complex associations, and embedded data patterns.

Rails Active Record Patterns

Streamlines Ruby on Rails model development by implementing standardized Active Record patterns, associations, and query optimizations.

Upstash Vector TypeScript SDK

Streamlines the integration of Upstash Vector database features for high-performance similarity search and AI applications.

SQLAlchemy 2.0 Async Patterns

Implements high-performance asynchronous database operations using SQLAlchemy 2.0 and FastAPI best practices.

Alembic Migration Patterns

Manages database schema changes using Alembic for SQLAlchemy 2.0 async applications.

SQLAlchemy 2.0 Async Patterns

Implements high-performance asynchronous database patterns using SQLAlchemy 2.0 and FastAPI integration.

Alembic Database Migrations

Manages SQLAlchemy 2.0 async database migrations and zero-downtime schema changes with production-ready patterns.

Database Versioning Patterns

Manages database schema history and coordinates changes across environments using standardized version control and change management patterns.

Zero-Downtime Database Migrations

Implements safe database schema changes using the expand-contract pattern and online tools to ensure continuous service availability.

Event Sourcing & CQRS Architecture

Implements robust event-driven architectures by storing application state as a sequence of immutable domain events for complete auditability and temporal queries.

PGVector Hybrid Search

Implements production-grade hybrid search using PostgreSQL PGVector and BM25 with Reciprocal Rank Fusion for high-accuracy retrieval.

Database Versioning Patterns

Manages database schema history and change management patterns across environments using industry-standard versioning strategies.

Database Schema Designer

Designs robust SQL and NoSQL database schemas with a focus on normalization, performance optimization, and safe migration patterns.

Database Schema Designer

Designs and optimizes SQL and NoSQL database schemas with professional-grade normalization, indexing, and migration patterns.

Event Sourcing Patterns

Implements immutable event logs and CQRS patterns for high-integrity, auditable application state management.

Reliable Outbox Pattern Implementation

Implements the transactional outbox pattern to ensure atomic database writes and reliable event delivery in microservices.