Database Management Agent Skills

PostgreSQL Patterns

Optimizes PostgreSQL database design and performance using industry-standard best practices and patterns.

JPA Patterns for Spring Boot

Optimizes Spring Boot data access layers with high-performance JPA and Hibernate design patterns.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database schemas, queries, and data pipelines for high-performance analytical workloads.

PostgreSQL Design & Performance Patterns

Implements high-performance PostgreSQL database schemas, optimized queries, and robust security policies based on industry best practices.

SwiftData to SQLiteData Migration

Guides the migration of xOS data layers from SwiftData to SQLiteData to achieve better performance and advanced CloudKit sharing capabilities.

SwiftData Migration

Implements complex SwiftData schema migrations using versioned schemas, two-stage transformation patterns, and relationship preservation strategies for iOS applications.

Neon Serverless Database Connector

Integrates the Neon Serverless Driver into applications to enable low-latency PostgreSQL access in edge and serverless environments.

Neon Drizzle Database Setup

Automates the configuration of Drizzle ORM with Neon databases, including schema generation and migration workflows.

Neon JS SDK Integration

Configures the full Neon JS SDK for unified authentication and PostgREST-style database queries in modern web applications.

Neon Toolkit

Automates the lifecycle of ephemeral Neon databases for automated testing, CI/CD pipelines, and isolated development environments.

Data Pipeline & ETL Discovery

Automatically activates specialized data engineering skills for ETL, batch processing, and real-time stream orchestration.

Database Skills Discovery

Automatically identifies and loads specialized skills for SQL, NoSQL, schema design, and query optimization within the Claude Code environment.

Snowflake SQL Optimizer

Optimizes Snowflake SQL queries for peak performance by identifying anti-patterns and rewriting logic while preserving exact results.

Ecotone Event Sourcing

Implements robust event sourcing patterns, projections, and event versioning within the Ecotone framework.

Ecotone Business Interface Builder

Generates auto-implemented PHP interfaces for database queries, messaging gateways, and data converters using the Ecotone Framework.

Database Designer

Architects, optimizes, and migrates professional database schemas for SQL and NoSQL systems using expert-level design patterns.

Migration Architect

Designs and executes zero-downtime system migrations with automated rollback strategies and compatibility validation.

Database Scaling Analyzer

Analyzes PHP applications for database access patterns that hinder horizontal scaling and primary database performance.

PHP Database Read-Write Proxy Generator

Generates robust database connection proxies for PHP 8.4 to implement seamless read/write splitting and replica routing.

Database Replication & Sharding Knowledge

Implements scalable database architectures in PHP through application-level read/write splitting and replica lag management.

Database Migration

Generates database migration files with automated schema changes and corresponding rollback logic.

Consistency Patterns Knowledge

Provides expert guidance on consistency models, locking strategies, and distributed systems patterns for robust PHP applications.

PHP Connection Pool Analyzer

Identifies and resolves database connection leaks, pool exhaustion, and lifecycle issues in PHP applications.

PHP Batch Processing Optimizer

Identifies and refactors inefficient PHP loops that perform repetitive database, API, and file operations into high-performance batch processes.

PHP DDD Repository Generator

Generates DDD-compliant Repository interfaces and PHP 8.4 infrastructure implementations for clean architecture.

PHP Unit of Work Generator

Generates robust Unit of Work infrastructure for PHP 8.4 to ensure transactional consistency across multiple domain aggregates.

Caching Strategies & Redis Patterns

Provides a comprehensive knowledge base for implementing efficient caching patterns, invalidation strategies, and Redis data structures.

PostgreSQL Development Standards

Enforces strict transaction safety, type-safe schema designs, and robust PostgreSQL naming conventions for reliable database architecture.

PHP Query Efficiency Analyzer

Analyzes PHP code and SQL queries to identify performance bottlenecks, missing indexes, and inefficient data retrieval patterns.

Backend Queries

Standardizes backend query implementation by applying specialized coding patterns and optimization guidelines.