Database Management Agent Skills

Prisma ORM Development

Streamlines database development using Prisma 5+ with type-safe schema design, migration workflows, and optimized query patterns.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers for PostgreSQL, MySQL, and SQL Server to optimize database logic.

Data Quality Test Generator

Generates comprehensive dbt test suites using modern 1.10+ syntax to ensure data integrity and structural consistency across analytical models.

Database Deadlock Detector

Detects, analyzes, and resolves database deadlocks by monitoring transaction patterns and lock contention in real-time.

Database Deadlock Detector

Detects, analyzes, and prevents database deadlocks by monitoring transaction patterns and lock contention in real-time.

Event Stream Projection Patterns

Implements high-performance read models and CQRS projections from event streams for optimized data retrieval.

Event Store Design

Designs and implements robust event stores for event-sourced architectures and distributed systems.

SQL Optimization Patterns

Optimizes database performance through systematic query tuning, advanced indexing strategies, and execution plan analysis.

Supabase Storage Manager

Manages file storage, bucket configurations, and secure access policies within the Supabase ecosystem.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through advanced indexing, quantization, and high-efficiency caching strategies.

AgentDB Performance Optimizer

Optimizes AgentDB vector databases using quantization, HNSW indexing, and caching to significantly improve search speed and memory efficiency.

dbt Model Builder

Constructs standardized dbt models following Kimball dimensional patterns and modern testing configurations.

MongoDB Transactions

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

Backend Queries

Implements structured database queries and repository patterns using Prisma ORM to maintain a robust layered architecture.

Convex Data Migrations

Guides developers through safe, idempotent data migrations within the Convex backend ecosystem using best-practice workflows.

Ghost CMS Database Migration

Automates the creation, implementation, and testing of database schema migrations for Ghost CMS.

SQLModel Task & User Schemas

Generates robust, type-safe SQLModel database schemas optimized for PostgreSQL performance and Better Auth integration.

Codebase & Schema Explorer

Accelerates codebase onboarding by automating the discovery of database schemas, API endpoints, and architectural patterns.

Database Implementation

Streamlines database schema design, automated Flyway migrations, and SQL query optimization within the Claude Code environment.

ORM Code Generator

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

Firebase Firestore Specialist

Architects high-performance NoSQL databases and manages real-time synchronization for mobile-first Firestore applications.

Database Administrator

Manages database operations, performance tuning, backup/recovery, and security through structured guidance and implementation patterns.

Firebase Firestore Specialist

Architects and implements scalable NoSQL database solutions using Firebase Firestore with real-time sync and offline-first capabilities.

Firebase Firestore Specialist

Optimizes Firebase Firestore implementations with expert guidance on NoSQL patterns, real-time synchronization, and robust security rules.

Objectstar Legacy Migration

Analyzes, refactors, and migrates TIBCO Objectstar legacy mainframe applications to modern architectures and programming languages.

Cloudflare R2 & D1 Storage Mastery

Optimizes development with Cloudflare's edge storage products including R2 object storage, D1 SQL databases, and KV namespaces through battle-tested patterns.

PostgreSQL Table Design

Architects optimized, production-grade PostgreSQL schemas using industry-standard best practices and performance patterns.

Data Quality Frameworks

Implements production-grade data validation and observability using Great Expectations, dbt tests, and formal data contracts.

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, query plan analysis, and efficient SQL implementation patterns.

Database Migration & Schema Management

Executes seamless database migrations, schema transformations, and zero-downtime deployment strategies across multiple ORMs and platforms.