Database Management Agent Skills

Snowflake CLI

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

dbt Performance Optimization

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

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.

Snowflake Connections

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

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.

dbt Commands & Operations

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

Bun Drizzle Integration

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

Database Sharding

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

Cloudflare Vectorize for RAG & AI

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

Vercel KV Storage & Caching

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

Bun SQLite

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

Doctrine Transaction Manager

Manages database transactions and concurrency in Symfony applications using Doctrine ORM 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.

Doctrine Migrations for Symfony

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

Doctrine Entity Relations for Symfony

Configures and optimizes Doctrine ORM entity relationships, fetch modes, and cascade operations for Symfony applications.

Symfony Cache

Implement and optimize high-performance caching strategies using the Symfony Cache component.

SQL Development & Optimization

Optimizes SQL development through expert query tuning, strategic indexing, and robust data modeling for high-performance analytics and pipelines.

Doctrine Batch Processing

Optimizes large-scale Symfony data operations through memory-efficient Doctrine ORM patterns and bulk database strategies.

ETL Pipeline Architect

Builds robust, idempotent data pipelines with a focus on data quality, error handling, and operational reliability.

Neon & Vercel Serverless Postgres

Configures and manages Neon and Vercel Serverless Postgres databases optimized for edge and serverless environments.

Cloudflare Hyperdrive Integration

Connects Cloudflare Workers to PostgreSQL and MySQL databases with high-performance connection pooling and query caching.

Zod Schema Designer

Designs and implements robust Zod schemas and TypeScript types using a Zod-first development approach for safe data modeling.

Cloudflare Workers KV

Integrates Cloudflare Workers KV storage into Claude Code for high-performance global key-value management and edge caching.

Cloudflare D1 Database Manager

Manages Cloudflare D1 serverless SQLite databases with best practices for migrations, query optimization, and global read replication.

Drizzle ORM for Cloudflare D1

Streamlines Cloudflare D1 database management using Drizzle ORM with type-safe schemas, automated migrations, and optimized query patterns.