Database Management Habilidades de Claude

Snowflake CLI

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

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 Performance Optimization

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

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 SQLite

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

Vercel KV Storage & Caching

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

Bun Drizzle Integration

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

Cloudflare Vectorize for RAG & AI

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

Database Sharding

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

Cloudflare D1 Database Manager

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

ETL Pipeline Architect

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

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.

Cloudflare Hyperdrive Integration

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

Cloudflare Workers KV

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

SQL Query Optimization

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

Bun Redis Integration

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

Database Schema Design

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

Drizzle ORM for Cloudflare D1

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

Neon & Vercel Serverless Postgres

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

Zod Schema Designer

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

Symfony Cache

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

Doctrine Entity Relations for Symfony

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