Database Management Agent Skills

Database Design & Optimization

Architects production-ready database schemas, manages migrations, and optimizes complex SQL queries for maximum performance.

Convex Database Explorer & Visualizer

Visualizes Convex database schemas and provides interactive dashboards for real-time data exploration and relationship mapping.

Convex Schema Visualizer

Visualizes and explores Convex database schemas through interactive dashboards and ER diagrams.

Space-Based Architecture Paradigm

Implements high-scale, stateful system architectures using in-memory data grid patterns to eliminate database bottlenecks.

CQRS and Event Sourcing Architect

Implements robust Command Query Responsibility Segregation and Event Sourcing patterns for complex, scalable distributed systems.

NoSQL Database Standards

Implements battle-tested NoSQL standards, implementation patterns, and security guidelines for production-grade database environments.

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.

Clone Database

Automates the end-to-end process of cloning remote MySQL or PostgreSQL databases from servers to a local development environment.

Init PostgreSQL Mac

Automates the installation, configuration, and lifecycle management of PostgreSQL with the pgvector extension on macOS.

macOS MySQL Manager

Automates the installation, security configuration, and management of MySQL servers on macOS using Homebrew.

PGVector Hybrid Search

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

Glide Data Modeling

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

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.

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.

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.

Database Architect & Drizzle ORM Specialist

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

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.

Database Design Patterns

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

Domain Entity Modeling

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

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.