Database Management Agent Skills

Database Index Advisor

Analyzes query workloads and provides actionable recommendations to optimize database indexing strategies for improved performance.

Query Performance Analyzer

Analyzes database EXPLAIN plans to identify performance bottlenecks and provide actionable SQL optimization recommendations.

Drizzle Cube Definition

Defines type-safe semantic layer cubes using Drizzle ORM for multi-tenant analytics and business logic abstraction.

Database Designer

Infers and generates database schemas, migrations, and ORM models directly from natural language feature descriptions.

Supabase Migration Toolkit

Manages Supabase database migrations using standardized naming conventions, automated linting, and security-first SQL templates.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers across major SQL databases using natural language.

Database Operations

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

Next.js Firestore Integration

Streamlines Next.js development with Firebase Firestore by providing type-safe patterns for data operations, real-time synchronization, and authentication.

Backend Models

Architects robust database models following Eloquent best practices, including relationship definitions, data typing, and multi-layer validation.

ER Diagram and Data Modeling

Generates entity-relationship diagrams and provides expert data modeling guidance for robust database schema design.

Database Deadlock Detector

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

Database Migration Expert

Executes seamless database schema transitions and data transformations across multiple ORMs with zero-downtime and rollback strategies.

Honeydew Semantic Relation Modeling

Defines and manages complex semantic relationships between Honeydew entities to enable multi-entity data modeling and cross-filtering.

Honeydew Entity Modeler

Guides the creation and management of Honeydew semantic entities from data warehouse sources with automated mapping and validation.

SQLDelight KMP Database Integration

Generates type-safe Kotlin APIs from SQL schemas for robust cross-platform data persistence in Kotlin Multiplatform projects.

PostgreSQL Table Design

Architects optimized PostgreSQL database schemas following production-grade best practices for performance, scalability, and data integrity.

Data Warehousing with dbt

Builds and maintains scalable, well-documented data warehouses using dimensional modeling principles and dbt best practices.

Honeydew Domain Governance

Configures and manages Honeydew domains to govern data visibility, apply mandatory filters, and establish focused business contexts for deep analysis.

Honeydew Semantic Model Exploration

Explores semantic layers, discovers data entities, and executes complex data queries within Honeydew workspaces.

Honeydew Attribute Creation

Defines and manages calculated dimensions and virtual columns in Honeydew semantic models using SQL and YAML.

SQL Development

Generates, optimizes, and manages production-grade SQL queries and database schemas with a focus on performance and readability.

Semantic Data Validation

Validates Honeydew semantic objects to ensure data integrity, logical consistency, and correct execution of metrics and entities.

Database Deadlock Detector

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

Stored Procedure Generator

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

SQL Query Optimizer

Analyzes and optimizes SQL queries to enhance database performance through index recommendations and structural rewrites.

JPA & Hibernate Patterns

Standardizes database entity design and query optimization using proven JPA and Hibernate best practices.

Database Connection Pooler

Optimizes database connection pooling and lifecycle management to enhance application performance and resource efficiency.

EF Core Async Patterns

Optimizes Entity Framework Core performance by implementing asynchronous best practices and efficient query patterns.

Database Connection Optimizer

Enhances application performance by configuring and optimizing database connection pools across various programming languages.

Database Audit Logger

Implements comprehensive database audit logging to track data changes, maintain compliance, and enhance system observability.