Database Management Agent Skills

Database Schema Designer

Designs and optimizes scalable SQL and NoSQL database schemas with a focus on normalization, performance, and robust migration patterns.

Nette Database & Explorer

Optimizes Claude's ability to write Nette Database queries, design typed entities, and manage schemas using MySQL 8.4+.

Database Migration Generator

Automates the creation of safe database migrations with automatic framework detection and built-in rollback logic.

Identity Resolution & Account Matching

Normalizes and matches accounts, contacts, and opportunities across disparate data sources to maintain a unified source of truth.

PGVector Hybrid Search

Implements production-grade hybrid search by combining PGVector HNSW semantic retrieval with BM25 keyword matching using Reciprocal Rank Fusion.

Data Contract Framework

Establishes structured operating models for defining, enforcing, and auditing business intelligence data contracts.

Vertica to dbt Snowflake Migration

Automates the conversion of Vertica DDL into production-ready dbt models optimized for Snowflake Data Cloud.

DB2 to Snowflake dbt Migrator

Converts IBM DB2 DDL and stored procedures into production-ready dbt models and schema configurations optimized for Snowflake.

EF Core DDD Persistence Layer

Implements a robust data persistence layer using Entity Framework Core within Hexagonal Architecture and Domain-Driven Design patterns.

Snowflake CLI

Manages Snowflake objects, executes SQL scripts, and deploys applications using the command-line interface for data orchestration and automation.

Snowflake Connections

Configures and manages Snowflake authentication for CLI tools, Streamlit applications, dbt projects, and Snowpark scripts.

dbt Commands & Operations

Executes dbt command-line operations, manages model selection syntax, and implements Jinja templating for data transformation workflows.

Snowflake Schema Management

Deploys and manages Snowflake database objects using a version-controlled, migration-based approach for seamless CI/CD integration.

dbt Architecture

Guides the implementation of medallion architecture and production-grade project organization within dbt.

dbt Core Development

Manages the local installation, configuration, and optimization of dbt-core environments for Snowflake data engineering.

dbt Performance Optimization

Optimizes dbt and Snowflake performance through expert guidance on materialization strategies, warehouse sizing, and advanced query patterns.

dbt Modeling

Implements production-quality dbt models using standardized CTE patterns, medallion architecture layers, and SQL best practices.

dbt Projects Snowflake Setup

Configures native dbt Projects on Snowflake with comprehensive guides for integrations, workspace management, and automated monitoring.

dbt Materializations

Provides expert guidance on selecting and implementing optimal data transformation strategies within dbt, including incremental models, snapshots, and Python-based ML workflows.

dbt Projects on Snowflake

Deploys, manages, and monitors dbt projects natively within Snowflake using PROJECT objects and OpenTelemetry-based event tables.

Bun Redis Integration

Implements high-performance Redis patterns for Bun environments including caching, session management, and real-time data structures.

SQL Query Optimization

Optimizes SQL queries for PostgreSQL and MySQL using indexing, execution plan analysis, and performance-driven pattern rewriting.

Database Schema Design

Designs and optimizes production-ready PostgreSQL and MySQL database schemas using normalization and performance best practices.

Doctrine Performance & Fetch Modes

Optimizes Symfony Doctrine queries using fetch modes, lazy loading strategies, and advanced query hints to eliminate N+1 issues.

Vercel KV Storage & Caching

Implements production-ready Vercel KV (Redis) storage patterns for caching, session management, and rate limiting in serverless applications.

Database Sharding

Implement horizontal scaling and high-performance sharding strategies for PostgreSQL and MySQL databases.

Bun SQLite

Integrates high-performance local data storage and management using Bun's native SQLite driver.

Doctrine Migrations for Symfony

Manages database schema versioning and migrations within Symfony applications using Doctrine.

Cloudflare Vectorize for RAG & AI

Implements high-performance semantic search and RAG workflows using Cloudflare's globally distributed vector database.

Bun Drizzle Integration

Integrates Drizzle ORM with Bun's SQLite driver to provide type-safe database schemas and streamlined migration workflows.