Database Management Agent Skills

Data Freshness Checker

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

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 Impact & Downstream Lineage

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

Medusa Database Migrations

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

Medusa Database Migration Generator

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

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.

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.

Ecto Query Patterns

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

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.

Database Versioning Patterns

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

Alembic Migration Patterns

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

Alembic Database Migrations

Manages SQLAlchemy 2.0 async database migrations and zero-downtime schema changes with production-ready 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 Schema Designer

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

PGVector Hybrid Search

Implements high-performance hybrid retrieval by combining semantic vector search with BM25 keyword matching using Reciprocal Rank Fusion.

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.

Backend Caching Strategies

Implements production-ready Redis caching patterns and invalidation strategies to optimize backend performance and reduce database load.

Memory Fabric

Orchestrates graph-based and semantic memory systems to provide unified, high-context information retrieval for AI development.

Zero-Downtime Database Migrations

Implements safe, non-blocking database schema changes using the expand-contract pattern and online migration tools.

Database Schema Designer

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