Database Management Agent Skills

Knack Data Reader

Accesses and transforms data from Knack objects and views via REST API for operational reporting and data analysis.

Kan Extensions Schema Migrator

Automates universal schema migrations and data transformations using advanced category theory principles.

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.

DuckDB Temporal Versioning

Implements in-process SQL databases with time-travel semantics, causality tracking, and deterministic replay capabilities.

Flix-Datalog Reasoning

Implements Flix-based Datalog reasoning with lattice semantics and GF(3) coloring for declarative routing and skill composition.

Advanced T-SQL Patterns

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

CatColab Ologs

Constructs category-theoretic knowledge representations to define rigorous database schemas and conceptual models.

Knowledge Graph Expert

Builds and manages semantic memory systems using knowledge graphs and GraphRAG patterns for enhanced AI reasoning.

Kan Extensions Schema Migrator

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

Database Schema Design

Architects optimized database schemas using industry-standard normalization patterns, complex relationship modeling, and performance-driven data types.

Prisma Schema Design

Architects optimized Prisma database schemas using industry-standard patterns for models, relationships, and performance indexing.

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.

TypeORM Entity Modeling

Defines and optimizes TypeORM database entities using standardized patterns for relations, indexes, and lifecycle hooks.

Qlerify Domain Sync

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

Prisma Migration Patterns

Manages database schema evolutions and migration workflows using Prisma ORM best practices.

Prisma Relations Patterns

Provides standardized implementation patterns for modeling and querying complex database relationships using Prisma ORM.

Mirrord DB Branching

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

PostgreSQL Query Patterns

Provides optimized PostgreSQL query patterns and best practices for robust database operations.

TypeORM Query Patterns

Provides standardized TypeORM query patterns and best practices for efficient database interaction.

Database Query Optimization

Optimizes database performance through efficient query patterns, advanced indexing strategies, and comprehensive performance analysis.

TypeORM Migrations

Manages database schema changes and data transformations using standardized TypeORM migration patterns.

Postgres Performance Optimizer

Optimizes PostgreSQL database performance through deep query analysis, indexing strategies, and expert server configuration tuning.

Logseq DB Knowledge

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

Prisma Query Patterns

Provides standardized patterns and best practices for querying databases using Prisma Client.

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.