Database Management Agent Skills

Database WAL Recovery

Provides technical procedures and systematic workflows for recovering data from corrupted, encrypted, or inaccessible SQLite Write-Ahead Log (WAL) files.

Neon Serverless PostgreSQL Specialist

Optimizes and manages Neon serverless PostgreSQL databases with specialized support for branching, auto-scaling, and edge-compatible connection pooling.

Schema Auto-Tagger for Treasure Data

Automates metadata classification and policy tagging for Treasure Data schemas to ensure governance and compliance with minimal manual effort.

SQL Query Optimization

Optimizes SQL queries for maximum performance by identifying bottlenecks, rewriting inefficient subqueries, and implementing high-performance patterns like window functions and CTEs.

Database WAL Recovery

Recovers data from SQLite Write-Ahead Log (WAL) files by identifying, analyzing, and decrypting corrupted or inaccessible database components.

Firebase Firestore Specialist

Optimizes Firebase Firestore implementation with expert NoSQL modeling, real-time synchronization, and advanced Security Rules configuration.

SPARQL University Querying

Provides specialized guidance for constructing and verifying SPARQL queries against RDF and Turtle datasets, specifically tailored for academic and university data structures.

Grey Haven Multi-Tenant Data Modeling

Standardize and automate multi-tenant database schema design using SQLModel and Drizzle ORM.

Firebase Firestore Specialist

Architects production-ready Firebase Firestore implementations with expert-level NoSQL modeling, real-time synchronization, and robust security rules.

Data Validation & Schema Quality

Implements robust data validation and schema alignment using Pydantic v2 for PlanetScale and API services.

Database Design & Schema Standards

Enforces standardized database conventions, multi-tenant isolation, and schema best practices for Drizzle ORM and SQLModel.

PostgreSQL Code Review

Reviews PostgreSQL code for optimal indexing, JSONB performance, connection pooling, and transaction safety.

SQLAlchemy Code Review

Reviews SQLAlchemy code to optimize session management, eliminate N+1 queries, and ensure database migration safety.

SQLite Vector Search (sqlite-vec)

Implements high-performance vector similarity search and embedding storage directly within SQLite databases.

Kafka CLI Tools & Operations

Manages Apache Kafka clusters and data streams using modern CLI tools like kcat, kaf, and kafkactl.

dbt Semantic Layer Architect

Simplifies the creation and management of dbt Semantic Layer components including semantic models, metrics, and dimensions.

dbt Fusion Migration

Migrates dbt Core projects to the dbt Fusion engine by resolving compatibility errors, deprecations, and unsupported configurations.

Kafka MCP Integration

Simplifies the integration and configuration of Model Context Protocol (MCP) servers for managing Kafka operations directly within AI coding environments.

Confluent ksqlDB Stream Processing

Master real-time event streaming and data processing using ksqlDB's SQL-like syntax on Kafka topics.

dbt Analytics Engineering

Streamlines data transformation and analytics engineering workflows by applying software engineering best practices to dbt projects.

Confluent Kafka Connect

Configures and optimizes Kafka Connect pipelines for seamless data movement between databases, cloud storage, and search indexes.

Database Administrator

Manages database operations, performance tuning, and high availability configurations across multiple DBMS platforms through a structured workflow.

Data Modeling & Schema Design

Designs optimized database schemas and guides architectural decisions for operational and analytical systems.

Vector Database Systems Design

Architects high-performance vector search systems by providing guidance on database selection, ANN algorithms, and scaling strategies.

Event Sourcing Design

Architects and implements robust event-sourced systems using standardized patterns for event stores, aggregates, and projections.

ETL & ELT Design Patterns

Provides architectural guidance and implementation patterns for designing modern data pipelines and transformation workflows.

Event Sourcing Patterns for HZL

Enforces event-driven architecture and immutable state patterns within the HZL task ledger system.

Data Architecture & Modern Platforms

Designs modern data platforms and implements scalable data architecture patterns like data lakes, lakehouses, and data mesh.

Data Modeling & Database Design

Designs and documents robust data structures using Entity-Relationship Diagrams, data dictionaries, and multi-level schema models.

SurrealDB Query Assistant

Generates production-ready SurrealQL queries and schemas for multi-model database applications including document, graph, and relational patterns.