Database Management Agent Skills

SQL Optimization Patterns

Optimizes database performance by implementing efficient indexing, query refactoring, and execution plan analysis.

SQL Optimization Patterns

Optimizes SQL database performance through query plan analysis, advanced indexing strategies, and systematic query refactoring.

SQL Optimization Patterns

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

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, query plan analysis, and efficient data retrieval patterns.

PostgreSQL Syntax & Grammar Reference

Consults PostgreSQL's internal parser and grammar rules to provide precise guidance on SQL syntax and DDL structure.

PostgreSQL Query Assistant

Executes SQL queries and translates natural language into database commands for local PostgreSQL instances.

Rails Migrations

Streamlines database schema management and ActiveRecord migration workflows for Ruby on Rails applications.

Supabase CRUD Operations

Generates production-ready CRUD operations for Supabase tables with built-in error handling, type safety, and RLS awareness.

Bulk Static Data Sync

Optimizes high-volume data synchronization from external APIs to databases using multi-row insert patterns and foreign key pre-filtering.

Event Store Design Patterns

Designs and implements robust event storage solutions for event-sourced architectures and high-performance distributed systems.

SQLiteData Swift Diagnostics

Troubleshoots and resolves SQLiteData issues in Swift, including build errors, runtime crashes, and sync failures.

SQLiteData Swift Core

Streamlines Swift database development using SQLiteData patterns for type-safe modeling, reactive queries, and robust migrations.

SQLiteData Swift Router

Routes SQLiteData development questions to specialized skills for core implementation, troubleshooting, or CloudKit synchronization.

Database Migration & ORM Tools

Executes and manages database schema migrations, data transformations, and rollback procedures across multiple ORMs and platforms.

Persistence Layer Auditor

Audits and optimizes SQLite persistence layers by identifying unused tables, broken method calls, and schema inconsistencies.

SQL Optimization Patterns

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

WordPress Database SQL Manager

Executes SQL queries against WordPress development databases via Docker containers to inspect data and debug issues.

E-Report Database Management

Simplifies querying and managing the v3_e-report database for data analysis alert configurations and tenant statistics.

OpenAPI & Connector Database Manager

Queries and manages integrated connector configurations and API metadata within the v3_openapi database.

Blacklake OpenAPI Database Query

Queries and manages integrated connectors and API configurations within the v3_openapi database using structured SQL templates.

Database Tenant & Org Manager

Queries and manages tenant, organization, and factory information within the v3_user database using structured SQL execution.

Data Lake Architect

Designs scalable data lake and lakehouse architectures using optimized partitioning, storage tiers, and high-performance formats like Iceberg and Parquet.

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.

Warehouse Optimization

Optimizes data warehouse performance through efficient partitioning, query tuning, and cost-effective resource management.

Data Quality Frameworks

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

Database Migration & Schema Management

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

dbt Transformation Patterns

Implements production-ready dbt patterns for scalable data modeling and analytics engineering.

Laravel Migrations Expert

Streamlines database schema design and migration management for Laravel applications using industry-standard patterns.

ClickHouse Data Engineering

Facilitates complex ClickHouse querying, data ingestion, and analytics pipeline management through deterministic OpenClaw workflows.

Database Design Patterns

Implements industry-standard database design patterns, indexing strategies, and migration best practices for optimized data persistence.