Database Management Agent Skills

ClickHouse Analytics & Patterns

Implements high-performance ClickHouse database schemas, optimized analytical queries, and efficient data engineering patterns for OLAP workloads.

Bknd Database Provisioning

Configures and automates production database setup for Bknd applications across various cloud and self-hosted providers.

Bknd Schema Modification

Manages schema changes in Bknd apps including entity renaming, field type updates, and safe data migration workflows.

Bknd Advanced Query Filtering

Enables advanced data retrieval in Bknd.io projects using complex filter conditions and logical operators.

Logseq Datalog Expert

Builds and optimizes complex Datalog queries for Logseq's database-driven graphs.

Logseq Database Schema Expert

Explains Logseq's Datascript database architecture, including entity relationships, built-in classes, and property type systems.

Bknd Entity Creator

Creates and configures database entities for Bknd applications using either a code-first approach or the visual admin interface.

Wasp Dev Server Manager

Orchestrates the Wasp development environment by managing local servers, database containers, and schema migrations.

Bknd Bulk Operations

Streamlines high-volume data operations in Bknd.io using optimized batch processing, chunking, and error handling strategies.

Bknd Relationship Designer

Defines and manages complex data relationships, foreign keys, and associations within the Bknd.io ecosystem.

Enterprise ERP Consultant

Architects and implements complex business logic for enterprise resource planning systems including finance, inventory, and supply chain modules.

dbt Transformation Patterns

Implements production-ready dbt patterns for scalable data modeling and analytics engineering workflows.

PostgreSQL Scaling & Performance

Implements advanced PostgreSQL scaling strategies including partitioning, connection pooling, and high-availability replication.

Database Performance & Anti-Patterns

Identifies and remediates common database performance bottlenecks like N+1 queries, unbounded fetches, and connection pool issues.

Data Design & Architecture

Designs efficient, scalable, and maintainable data structures and schemas using industry-best practices for SQL and NoSQL databases.

PostgreSQL Schema Design

Guides the creation of performant, scalable, and normalized PostgreSQL database schemas using industry best practices.

Redis Modules Master

Extends Redis capabilities with advanced modules including RedisJSON, RediSearch, RedisTimeSeries, and RedisBloom for complex data modeling.

Supabase Typed Query

Builds type-safe, functional Supabase queries using chainable APIs and entity-based CRUD patterns for robust database interactions.

Database Migration & Schema Evolution

Manages complex database migrations across multiple ORMs with zero-downtime strategies and automated rollback procedures.

Drizzle ORM Patterns

Implements type-safe PostgreSQL database schemas and query patterns using Drizzle ORM.

Upstash Redis Patterns

Implements efficient caching, rate limiting, and session management patterns using Upstash Redis.

PostGIS Geospatial Architecture

Implements advanced geospatial features including geofencing, spatial indexing, and real-time fleet tracking using PostGIS and PGRouting.

Laneweaver Database Design

Designs robust PostgreSQL 17 schemas and Supabase migrations tailored for the LaneweaverTMS logistics ecosystem.

Flyway Database Migrations

Manages database schema changes and versioning through standardized Flyway migration patterns and PostgreSQL best practices.

jOOQ Database Patterns

Implements type-safe SQL queries and repository patterns using jOOQ for robust Kotlin and Java database interactions.

SQL Performance Optimization Patterns

Optimizes database performance through advanced SQL query patterns, strategic indexing, and detailed execution plan analysis.

Database Design Architect

Architects production-grade SQL and NoSQL databases with automated schema validation and performance optimization patterns.

ClickHouse Query & Schema Optimizer

Optimizes ClickHouse database performance through expert schema design, primary key ordering, and query tuning.

Data Engineering & Analytics

Architects robust data pipelines, optimizes SQL queries, and manages large-scale ETL/ELT workflows across modern data warehouses.

AgentDB Advanced Features

Powers distributed AI systems with low-latency QUIC synchronization, hybrid vector search, and multi-database management.