Database Management Agent Skills

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 Index Strategies

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

Windows Git Bash Path Manager

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

Domain Entity Modeling

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

Algebraic Database Schema Comparison

Analyzes and compares DuckDB and LanceDB architectures using category theory and algebraic data structures (ACSets).

SQL Server 2025 & SqlPackage Support

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

Advanced T-SQL Patterns

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

BMorphism Video Interleave

Interleaves video transcripts with technical skill corpora using algebraic database schemas and GF(3) conservation principles.

Database Optimizer

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

Database Architect & Drizzle ORM Specialist

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

CatColab Database Schemas

Models rigorous database schemas by distinguishing entities from attributes to enable category-theoretic data structures and ACSets.

Compositional ACSet Comparison

Compares complex data structures like DuckDB and LanceDB using algebraic databases and category-theoretic analysis.

SQL Pro

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

ACSets Algebraic Databases

Implements category-theoretic algebraic databases to provide flexible, composable in-memory data structures generalizing graphs and data frames.

PostgreSQL Pro

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

Algebraic Databases (ACSets)

Implements Attributed C-Sets (ACSets) as in-memory algebraic databases for category-theoretic data modeling and graph manipulation.

Compositional ACSet Comparison

Compare database schemas and data structures using algebraic databases and persistent homology coverage analysis.

Kan Extensions Schema Migrator

Performs universal schema migrations and data transport using category theory principles of Kan extensions.

Drizzle ORM for TypeScript

Simplifies type-safe database management using Drizzle ORM across PostgreSQL, MySQL, SQLite, and Cloudflare environments.

Project Schema & Terminology Designer

Establishes a unified project language and robust data structures to ensure consistency across AI-native development workflows.

Database Schema Designer

Architects robust data models for SQL and NoSQL databases using industry-standard normalization, indexing strategies, and migration patterns.

Database Migration Strategy

Executes complex database migrations and schema transformations using zero-downtime strategies and cross-ORM best practices.

Supabase Project Creator

Automates the creation and configuration of Supabase projects with comprehensive authentication and security setups.

TypeScript DynamoDB Toolbox

Simplifies DynamoDB single-table design using dynamodb-toolbox v2 for type-safe, high-performance TypeScript data layers.

Mirrord DB Branching

Configures isolated database branches for safe, production-like development and testing without affecting live data.

Logseq DB Knowledge

Provides comprehensive guidance on working with Logseq's database-based data model, covering nodes, typed properties, classes, and advanced Datalog queries.

Backend Models

Defines and optimizes database models with appropriate data types, relationships, and integrity constraints across various ORM frameworks.

Backend Queries

Writes secure, performant database queries and data access logic using optimization techniques and security best practices.

Backend Migrations

Manages database schema changes through version-controlled migration files while ensuring rollback safety and zero-downtime compatibility.

Qlerify Domain Sync

Synchronizes local codebase domain models, entities, and API schemas with Qlerify to maintain architectural alignment.