Database Management Agent Skills

Knack API Pagination Manager

Automates full dataset retrieval from the Knack API by managing page limits, rate limiting, and record streaming.

Knack Data Reader

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

Windows Git Bash Path Manager

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

Knack Filter & Sort Manager

Optimizes Knack database queries through dynamic filtering, multi-level sorting, and payload reduction for high-performance dashboards.

Database Architect & Drizzle ORM Specialist

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

Azure SQL Optimization

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

Knowledge Graph Expert

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

ACSets Relational Thinking

Models complex data structures and transformations using Attributed C-Sets (ACSets) and category-theoretic database design.

Kan Extensions Schema Migrator

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

CatColab Ologs

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

Knack Data Cleaner

Cleans and validates Knack database records to ensure data integrity and regulatory compliance for reporting dashboards.

Flix-Datalog Reasoning

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

DuckDB Temporal Versioning

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

Lisp S-Expression & ACSet Bridge

Converts between Lisp S-expressions and Algebraic Data Sets (ACSets) using OCaml-inspired bidirectional serialization patterns.

Knack Database Expert

Automates HTI Knack database operations including complex filtering, pagination management, and automated compliance reporting.

Keboola Configuration Manager

Simplifies the management of Keboola project structures, JSON configurations, and data pipeline transformations.

Keboola CLI & Project Reviewer

Manages Keboola project configurations and executes comprehensive multi-agent reviews for SQL, data architecture, and financial logic.

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.

DuckDB Spatial & H3 Analysis

Executes PostGIS-compatible spatial SQL queries and H3 hexagonal indexing for advanced geographic data analysis within DuckDB.

Prisma Schema Design

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

TypeORM Entity Modeling

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

Database Migration Strategy

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

Database Schema Designer

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

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.

Supabase Project Creator

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

Qlerify Domain Sync

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

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.