Database Management Agent Skills

Rails AI Solid Stack (Jobs & Cache)

Configures database-backed background jobs, caching, and WebSockets using the Rails 8 Solid Stack while strictly excluding Redis and Sidekiq.

SQL Patterns & Optimization

Provides advanced SQL design patterns and optimization techniques for efficient data engineering and complex query construction.

Litestream for Rails

Configures continuous SQLite backups for Rails 8+ applications using Litestream and S3-compatible storage.

Production ETL Patterns

Orchestrates production-grade Extract-Transform-Load (ETL) pipelines using reliability patterns and incremental load strategies.

Parquet Data Engineering

Optimizes columnar data storage using Parquet patterns for partitioning, predicate pushdown, and schema evolution.

dbt Coder

Standardizes dbt project architecture and SQL transformation patterns for scalable analytics engineering.

Database Schema Documentation

Generates comprehensive database schema documentation, ERD diagrams, and technical data dictionaries for clear data modeling.

Data Migration Script Generator

Generates robust, reversible, and production-grade database migration scripts for schema changes and data transformations.

Vector Database Management

Manages and optimizes vector databases like Pinecone, Weaviate, and Chroma for semantic search, RAG systems, and similarity-based AI applications.

Redis State Management

Implements high-performance Redis patterns for caching, session management, and distributed state coordination.

Neon Serverless Postgres

Streamlines database development by providing expert guidance on Neon's serverless architecture, branching features, and driver integrations.

PostgreSQL Database Engineering

Optimizes and manages professional PostgreSQL environments through advanced indexing strategies, query tuning, and high-availability architecture patterns.

Psycopg PostgreSQL Adapter

Simplifies PostgreSQL database operations in Python with specialized support for connection pooling, asynchronous I/O, and secure query execution.

Event Sourcing

Implements event sourcing and CQRS patterns to maintain a full history of state changes through immutable event streams.

Database Management Patterns

Optimizes data architecture and performance across SQL and NoSQL systems through comprehensive schema design, indexing strategies, and scaling patterns.

Database Architect & Management

Architects, queries, and optimizes complex data storage systems across SQL and NoSQL paradigms.

Alembic Database Migration

Manages complex database schema evolutions and data migrations using Alembic and SQLAlchemy with a focus on production stability.

Pre-Dev Data Modeling

Defines technology-agnostic data entities, relationships, and ownership to ensure robust system architecture before database selection.

PostgreSQL Database Administration

Manages and optimizes PostgreSQL databases for customer support environments, including schema design, performance tuning, and advanced query implementation.

SQL

Writes and optimizes SQLite queries, schemas, and migrations using standardized best practices and specific implementation patterns.

Ampi Vault Builder

Transforms document folders or SQLite tables into searchable, Ampi-compliant database vaults with keyword and semantic indexing.

SQLAlchemy ORM Expert

Implements professional-grade SQLAlchemy ORM patterns and database optimizations for modern Python applications.

Kafka Stream Processing

Architects and implements scalable event-driven systems using Apache Kafka for real-time data processing and high-throughput messaging.

dbt Data Transformation

Streamlines analytics engineering workflows by implementing modular SQL transformations, automated testing, and comprehensive data documentation using dbt.

SQLite Truncated Database Recovery

Recovers data from corrupted or truncated SQLite database files through manual binary analysis and custom parsing when standard tools fail.

Query Optimization

Optimizes SQL queries through systematic performance benchmarking, execution plan analysis, and iterative refinement across multiple database engines.

SPARQL University

Constructs and verifies complex SPARQL queries for RDF datasets with a focus on academic ontologies and graph pattern matching.

Database WAL Recovery

Provides technical procedures and systematic workflows for recovering data from corrupted, encrypted, or inaccessible SQLite Write-Ahead Log (WAL) files.

SQLite DB Truncation Recovery

Recovers data from corrupted or truncated SQLite databases by manually parsing binary structures when standard tools fail.

SQL Query Optimization

Optimizes SQL queries for maximum performance by identifying bottlenecks, rewriting inefficient subqueries, and implementing high-performance patterns like window functions and CTEs.