Database Management Agent Skills

Koan Entity Relationships

Optimizes data entity navigation and prevents N+1 query issues through efficient batch loading and relationship patterns.

Trino to Hive Migration

Guides the conversion of memory-intensive Trino queries to Hive syntax and execution patterns to resolve resource constraints and performance issues.

Koan Entity-First Data Access

Simplifies data persistence by replacing traditional repository patterns with self-aware, self-persisting entities.

DuckDB TimeTravel & ACSet Schema

Manages temporal versioning and generates relational schemas from category-theoretic ACSet definitions within DuckDB.

AgentDB Performance Optimization

Optimizes AgentDB vector databases through quantization, HNSW indexing, and advanced caching to maximize search speed and minimize memory overhead.

Systematic Data Import

Standardizes the CSV import process through automated discovery, schema design, and data normalization for relational databases.

Data Engineering & Analytics Assistant

Architects, optimizes, and manages end-to-end data pipelines, warehouse schemas, and analytics workflows using industry-standard frameworks.

Analytical SQL Writing

Guides systematic SQL query development for data analysis, ensuring accuracy and reproducibility through a structured five-phase process.

Data Profiler & Explorer

Automates systematic data profiling and exploration across multiple SQL database dialects.

Database Migration Helper

Generates safe, reversible database migrations and schema transformations for multiple ORMs and raw SQL.

Derangement CRDT & Topological State

Enforces no-fixed-point permutations and GF(3) color conservation within distributed CRDT state transitions.

ACSets Algebraic Databases

Manages complex data structures using category-theoretic formalism for in-memory relational databases and graphs.

Database Design & Optimization

Architects robust PostgreSQL schemas using expert normalization, indexing strategies, and zero-downtime migration patterns.

ClickHouse DBeaver Config Generator

Generates DBeaver database client configurations from Pydantic models using mise as a single source of truth.

ACSets Hatchery

Implements category-theoretic data structures and algebraic databases using attributed C-sets for advanced technical computing.

OpenSaaS Stack Migration

Facilitates seamless migrations from Prisma, KeystoneJS, and Next.js projects to the OpenSaaS Stack with expert guidance.

Drizzle Migration Manager

Automates and guides the Drizzle Kit database migration workflow for the Hyper Forge platform.

Lisp-ACSet Serialization

Bridges Lisp-style S-expressions with Algebraic Databases (ACSets) for seamless serialization and data manipulation in Julia.

Database Design

Designs efficient database schemas, plans safe migrations, and optimizes queries for relational and document databases using industry-best practices.

Architecture Reviewer

Evaluates and optimizes system architectures for file-based queuing, data persistence, and messaging reliability.

Django Model Helper

Generates production-ready Django database models with optimized field types, relationships, and migration workflows.

Conceptual Data Modeling

Defines core system entities and relationships using a minimal, plain-language conceptual approach.

Hyperbolic Bulk Entropy Manager

Manages on-chain GF(3) entropy storage and state mediation on Aptos using the bulk-boundary correspondence principle.

CRDT State Management

Manages local-first data synchronization and state persistence using Loro CRDTs and draft-style mutations.

Duck Agent

Streamlines the discovery, access, and querying of local DuckDB databases and associated Python utility libraries.

TanStack DB Local-First Development

Builds reactive, local-first applications with sub-millisecond live queries and seamless background data synchronization.

Frappe Data Migration Generator

Generates production-ready Python scripts for migrating, transforming, and importing large datasets into Frappe Framework applications.

Frappe Fixture Creator

Generates structured JSON fixtures and Python import logic for Frappe Framework test data and master site configurations.

Database Migration Guide

Provides expert guidance and automated workflows for migrating databases across engines, versions, and cloud platforms with minimal downtime.

Unified Reafference

Synchronizes session data across multiple AI agents using a topological B3 Poset database structure.