Database Management Agent Skills

Solid Queue Coder

Configures and optimizes Solid Queue background job processing for Rails 8 applications using database-backed infrastructure.

Rails Event Sourcing & Inbox Handler

Implements pragmatic event-driven architectures in Rails monoliths using domain event recording and the inbox pattern.

Solid Cache Coder

Configures and optimizes Rails 8 Solid Cache for high-performance, database-backed application caching.

Rails StoreModel Coder

Wraps JSON-backed database columns in ActiveModel-like classes for type safety, validations, and structured data management in Ruby on Rails.

SQLite & Drizzle Database Manager

Implements type-safe SQLite database solutions using LibSQL and Drizzle ORM for Next.js, Turso, and Cloudflare D1 environments.

Salesforce Metadata & Schema Architect

Generates production-ready Salesforce metadata XML and performs advanced org querying with automated best-practice scoring.

Salesforce Data Operations Expert

Manages Salesforce data operations including complex SOQL queries, bulk imports, and automated test data generation via sf CLI.

Data Schema & Knowledge Modeling

Standardizes the design of rigorous database schemas, domain models, and knowledge graphs to ensure data integrity and system scalability.

PGVector Hybrid Search

Implements production-grade hybrid search combining semantic vector similarity with keyword matching using PostgreSQL and PGVector.

Glide Computed Columns

Configures logic-driven data transformations in Glide using math, conditional, and relational columns.

Glide API Operations

Integrates programmatic data operations with Glide Big Tables using REST API v2 and the official TypeScript SDK.

Glide Data Modeling

Design and implement high-performance Glide data architectures, including relational schemas, computed columns, and AI-powered data processing.

Convex Actions and General Development

Streamlines the development of robust Convex backends through advanced action implementation, HTTP routing, schema validation, and task scheduling.

PostgreSQL Pro

Optimizes PostgreSQL performance, manages complex database administration tasks, and implements advanced indexing and replication strategies.

Database Optimizer

Optimizes database performance through query tuning, strategic indexing, and execution plan analysis for PostgreSQL and MySQL.

Advanced T-SQL Patterns

Implements complex SQL Server techniques including recursive CTEs, temporal tables, and memory-optimized operations.

SQL Server 2025 & SqlPackage Support

Enables advanced SQL Server 2025 capabilities including native vector database support, AI model integration, and modernized deployment workflows.

Convex Queries

Provides specialized guidance for defining, optimizing, and implementing efficient data retrieval functions within the Convex backend-as-a-service platform.

SQL Pro

Optimizes complex database queries and designs scalable schemas across multiple SQL dialects for high-performance applications.

Convex Mutations

Implements and manages Convex mutation functions with best practices for database operations, validation, and task scheduling.

CQRS and Event Sourcing

Implements scalable architectural patterns for separated read/write models and immutable event logs to ensure system auditability.

CQRS & Event Sourcing Architect

Implements scalable, auditable system architectures using Command Query Responsibility Segregation and Event Sourcing patterns.

Database Architect & Drizzle ORM Specialist

Architects normalized PostgreSQL schemas and implements type-safe Drizzle ORM models with industry-standard best practices.

T-SQL Functions Master

Provides a comprehensive reference and implementation patterns for T-SQL functions across SQL Server and Azure SQL Database versions.

T-SQL Query Optimization

Optimizes SQL Server and Azure SQL Database performance through advanced T-SQL query tuning and execution plan analysis.

Azure SQL Optimization

Optimizes Azure SQL Database performance through platform-specific configurations, monitoring scripts, and scaling strategies.

Windows Git Bash Path Manager

Resolves path conversion conflicts between Windows and Git Bash for SSDT, SqlPackage, and DACPAC workflows.

T-SQL Index Strategies

Optimizes SQL Server database performance through expert index design, selection, and maintenance strategies.

Domain Entity Modeling

Models domain entities from requirements using Domain-Driven Design (DDD) principles to define attributes, relationships, and state machines.

Database Design Patterns

Architects scalable database schemas and optimizes query performance across relational and NoSQL systems.