Database Management Agent Skills

PostgreSQL Read-Only Explorer

Executes safe, read-only SQL queries and explores schemas across multiple PostgreSQL databases.

Database Documentation Generator

Automatically generates comprehensive database schema documentation, architecture guides, and operational runbooks using SQL and NoSQL CLI tools.

Database Design Architect

Architects production-grade SQL and NoSQL databases with automated schema validation and performance optimization patterns.

PostgreSQL Fundamentals

Master production-ready SQL foundations and schema design for PostgreSQL 16+ environments.

Vanilla Rails Models

Enforces production-grade Rails model patterns including state-as-records, namespaced concerns, and invocation-based method ordering.

Database Schema

Enforces strict database schema conventions for Drizzle ORM and PostgreSQL to ensure consistent table structures, constraints, and indexing patterns.

Laneweaver Database Design

Designs robust PostgreSQL 17 schemas and Supabase migrations tailored for the LaneweaverTMS logistics ecosystem.

NestJS TypeORM Integration

Integrates TypeORM into NestJS projects by configuring data sources, defining entities, managing migrations, and implementing scalable repository patterns.

Database Data Seeder Generator

Generates realistic, relationally consistent test data and database seed scripts for development and testing environments.

ClickHouse Query & Schema Optimizer

Optimizes ClickHouse database performance through expert schema design, primary key ordering, and query tuning.

Hono D1 Integration

Integrates Cloudflare D1 database functionality into Hono and TypeScript applications running on Cloudflare Workers or Pages.

Database Management & Optimization

Simplifies database schema design, query optimization, and administration for MongoDB and PostgreSQL environments.

Drizzle ORM Development

Enforces database query conventions, type safety, and permission filtering using standardized Drizzle ORM patterns.

Supabase RLS Policy Expert

Generates production-ready, optimized PostgreSQL row-level security (RLS) policies for Supabase databases following security best practices.

PostGIS Geospatial Architecture

Implements advanced geospatial features including geofencing, spatial indexing, and real-time fleet tracking using PostGIS and PGRouting.

Data Engineering & Analytics

Architects robust data pipelines, optimizes SQL queries, and manages large-scale ETL/ELT workflows across modern data warehouses.

Database Migration & Schema Evolution

Manages complex database migrations across multiple ORMs with zero-downtime strategies and automated rollback procedures.

Lutece 8 DAO & Home Patterns

Implements standardized DAO and Home layer patterns for Lutece 8 development using best practices for data persistence.

Unified Database Management

Manages both MongoDB and PostgreSQL environments, from schema design and query optimization to production administration and migrations.

TimescaleDB Expert

Optimizes time-series data management and PostgreSQL analytics through advanced hypertables, compression, and performance tuning.

SQLite Best Practices

Optimizes SQLite database performance and reliability through expert-level configuration and high-performance implementation patterns.

Shopify Database Best Practices

Optimizes Shopify app database operations using Prisma ORM with a focus on multi-tenant data isolation and high-performance query patterns.

Database Migration Manager

Manages database schema evolution by generating and executing version-controlled migrations for PostgreSQL, MySQL, SQLite, and MongoDB.

Architecture Performance Optimizer

Analyzes and resolves performance bottlenecks across database queries, API endpoints, and frontend rendering frameworks.

Redis Hashes and Sorted Sets

Optimizes Redis data management with advanced patterns for Hashes and Sorted Sets, including leaderboards, object storage, and ranking systems.

Redis Cluster Manager

Manages production-grade Redis Cluster operations including horizontal scaling, hash slot distribution, and automated failover procedures.

Caching Conventions

Enforces standardized caching patterns across React, Next.js, Redis, and Cloudinary layers to ensure consistent data performance and invalidation logic.

Vanilla Rails Data Modeling

Enforces high-performance, multi-tenant database schema patterns and migrations for Ruby on Rails applications based on 37signals conventions.

Redis Transaction Pro

Implements production-grade Redis transaction patterns using MULTI/EXEC, optimistic locking with WATCH, and atomic Lua scripting.

Redis Lists & Sets Master

Implements high-performance Redis data structures including reliable queues, unique collections, and complex set operations for distributed applications.