Database Management Agent Skills

PostgreSQL Query Assistant

Executes SQL queries and translates natural language into database commands for local PostgreSQL instances.

Rails ActiveRecord Optimization Patterns

Optimizes Ruby on Rails database interactions with production-grade ActiveRecord patterns and performance best practices.

Database Migration & ORM Master

Streamlines database schema evolution, data transformations, and zero-downtime deployments across major ORMs and SQL platforms.

DuckDB ETL Pipeline

Automates the ingestion of CSV and Excel files into DuckDB with integrated data validation and markdown reporting.

Data Engineering Expert

Architects robust data pipelines, ETL/ELT workflows, and scalable data warehouse solutions using modern stack patterns.

ORM Code Generator

Generates production-ready ORM models and database schemas from natural language descriptions or existing database structures.

AGI Memory System

Manages persistent AI memory through semantic, episodic, and working storage to enhance long-term context and knowledge recall.

Airtable Connector

Integrates Claude Code with Airtable to manage bases, tables, and records through a streamlined Python interface.

MongoDB Transactions

Implements robust ACID transactions and multi-document operations for MongoDB data consistency.

PostgreSQL Table Design

Designs high-performance, production-grade PostgreSQL schemas using domain-specific best practices and advanced indexing strategies.

Database Backup Automator

Automates scheduled backups, encryption, and restoration procedures for PostgreSQL, MySQL, MongoDB, and SQLite databases.

Database Migration Manager

Automates database schema and data migrations across multiple ORMs with robust rollback and zero-downtime strategies.

Data Quality Frameworks

Implements robust data validation and quality assurance using Great Expectations, dbt tests, and formal data contracts.

dbt Transformation Patterns

Implements production-ready dbt patterns for scalable data modeling and analytics engineering.

SQL Optimization Patterns

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

Query Performance Analyzer

Analyzes and optimizes database query performance by interpreting EXPLAIN plans and identifying execution bottlenecks.

Database Documentation Generator

Automates the creation of comprehensive database documentation, ERD diagrams, and data dictionaries from existing schemas.

Supabase Platform Specialist

Architects and implements full-stack Supabase applications using PostgreSQL 16, real-time subscriptions, and AI-powered vector search.

Advanced AgentDB Management

Powers distributed AI systems with advanced vector search, QUIC synchronization, and multi-database management.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance using quantization, HNSW indexing, and advanced caching strategies.

Database Domain Specialist

Architects and optimizes robust database solutions across PostgreSQL, MongoDB, and Redis to support scalable application development.

Database Diff Tool

Automates database schema comparisons and generates transaction-safe migration scripts with rollback procedures for PostgreSQL and MySQL.

Neon Database Specialist

Optimizes serverless PostgreSQL workflows using Neon's auto-scaling, database branching, and connection pooling capabilities.

Database Caching Layer

Implements multi-tier caching architectures to optimize database performance, reduce latency, and scale backend services.

Database Index Advisor

Analyzes database query workloads to identify missing indexes and recommend optimizations for peak performance.

Database Partition Manager

Automates the design and implementation of database partitioning strategies to optimize query performance and manage large-scale data sets.

Go Model Field Usage

Manages thread-safe model field access and instantiation using standardized Go patterns.

Backend Model Conventions

Enforces standardized Go model definitions and database mapping conventions for robust backend development.

Database Column Creator

Streamlines the creation and update of database columns using standardized Go struct tags and naming conventions.

Hasura Docker CLI

Manages Hasura GraphQL engine operations within self-hosted Docker environments using containerized CLI commands.