Database Management Agent Skills

Postgres Query Optimization

Optimizes PostgreSQL database performance by analyzing execution plans, identifying bottlenecks, and implementing advanced indexing strategies.

Database Query Optimizer

Optimizes database performance by implementing EXPLAIN analysis, strategic indexing, and N+1 query prevention patterns.

SQL Optimization Patterns

Optimizes database performance through advanced indexing, query plan analysis, and efficient query architectural patterns.

Database Migration

Manage database schema and data migrations across ORMs with zero-downtime strategies and rollback procedures.

Supabase Database

Streamlines Supabase database management including complex queries, CRUD actions, and Row Level Security implementation.

Database Migrations for Claude

Manages database schema changes using Alembic patterns, ensuring safe upgrades, downgrades, and data integrity.

SQL Optimization Patterns

Optimizes SQL queries and database performance through advanced indexing strategies and execution plan analysis.

Database Performance & Optimization

Optimizes database schemas, queries, and caching strategies to improve application speed and resource efficiency.

Solomon Database Consultant

Performs expert-level database schema analysis, query optimization assessments, and architectural reviews to ensure data integrity and performance.

Database Design & Optimization

Designs high-performance database schemas and manages migrations for PostgreSQL, MySQL, and NoSQL systems.

SQLite & Drizzle Database Management

Implements type-safe SQLite database workflows using LibSQL and Drizzle ORM for local, Turso, and Cloudflare D1 environments.

InstantDB

Provides expert guidance and best practices for building, debugging, and querying with the InstantDB real-time database.

Spring Data JPA Best Practices

Implements high-performance Spring Data JPA repositories and entities using modern aggregate-centric patterns.

ClickHouse Analytics & I/O

Optimizes high-performance analytical workloads by implementing ClickHouse-specific database patterns and query best practices.

Database Operations

Streamlines database interactions by providing standardized patterns for CRUD operations, session management, and performance optimization.

Supabase Database & Security Manager

Manages Supabase database instances, enforces PostgreSQL security best practices, and streamlines migration workflows for the Dashboard project.

PostgreSQL Table Design Specialist

Designs optimized PostgreSQL database schemas using performance-first patterns and industry best practices.

Database Migration Master

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

Firebase Firestore Specialist

Implement and optimize Firebase Firestore databases with real-time synchronization, offline-first architecture, and robust security rules.

Laravel Eloquent Expert

Optimizes Laravel database interactions using Eloquent ORM patterns, advanced relationships, and query performance techniques.

Supabase Database Manager

Enables direct connection and SQL execution for Supabase PostgreSQL databases within the Claude Code environment.

Supabase Database Migrations

Manages Supabase schema migrations, RLS policies, and PostGIS integration with security-first patterns.

Database Archival & Retention

Automates the archival of historical database records to cold storage or archive tables to optimize performance and ensure regulatory compliance.

Database Audit Logging

Automates the implementation of database audit trails and change tracking to ensure data integrity and regulatory compliance.

Database Backup Automator

Automates secure database backups and restoration procedures for PostgreSQL, MySQL, MongoDB, and SQLite.

Database Caching Adapter

Implements multi-tier caching architectures to optimize database performance and reduce latency using Redis, in-memory layers, and CDNs.

Database Deadlock Detector

Detects, analyzes, and prevents database deadlocks by monitoring lock contention and identifying problematic transaction patterns.

Database Migration & Schema Diff Tool

Automates database schema comparisons and generates safe, production-grade migration scripts with built-in rollback procedures.

Database Documentation Generator

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

Database Index Advisor

Analyzes database query patterns and workloads to provide actionable recommendations for index optimization and performance tuning.