Database Management Habilidades de Claude

Codebase & Schema Explorer

Accelerates codebase onboarding by automating the discovery of database schemas, API endpoints, and architectural patterns.

JUDO Custom RDBMS Queries

Extends the JUDO DAO RDBMS query translation layer with custom mappers, translators, and join strategies.

Metadata Manager

Streamlines the creation and management of BigQuery table schemas, metadata configurations, and Airflow DAG schedules following Mozilla ETL conventions.

JUDO Entity Mapping

Maps complex domain entities to transfer objects while handling unit conversion and instance graph relationships.

JUDO Custom Expression Translators

Extends the JUDO Expression module by implementing custom translators for domain-specific logic and specialized calculations.

Supabase Storage Manager

Manages file storage, bucket configurations, and secure access policies within the Supabase ecosystem.

Prisma ORM Development

Streamlines database development using Prisma 5+ with type-safe schema design, migration workflows, and optimized query patterns.

Prisma ORM Setup & Patterns

Configures and optimizes Prisma ORM for type-safe database access and streamlined schema management in Node.js applications.

SQL Optimization Patterns

Optimizes SQL query performance through systematic execution plan analysis, advanced indexing strategies, and proven query restructuring patterns.

Postgres Query Optimization

Optimizes PostgreSQL database performance by analyzing execution plans, identifying bottlenecks, and implementing advanced indexing strategies.

Spring Data JPA Best Practices

Implements high-performance Spring Data JPA repositories and entities using modern aggregate-centric patterns.

ClickHouse Analytics & I/O

Optimizes high-performance analytical workloads by implementing ClickHouse-specific database patterns and query best practices.

Writing Queries

Guides the systematic development, verification, and documentation of SQL queries for analytical data processing.

Ghost Database Migration Tool

Automates the process of creating, testing, and verifying database migrations within the Ghost CMS ecosystem.

Go Database Migration Manager

Generates standardized golang-migrate SQL files with timestamp-based naming and strict schema conventions.

PostgreSQL Table Design

Architects high-performance, production-ready PostgreSQL schemas using industry-standard best practices and data modeling patterns.

Backend Models

Defines and structures database schemas with robust naming conventions, data integrity constraints, and optimized relationship mappings.

Database Migration & ORM Tools

Executes and manages database schema migrations, data transformations, and rollback procedures across multiple ORMs and platforms.

Database Architect & Schema Designer

Guides architectural decisions for database selection, schema modeling, and performance optimization.

NoSQL Expert Patterns

Guides the architecture and optimization of high-scale distributed databases like Cassandra and DynamoDB using query-first modeling.

Database Design & Optimization

Architects scalable database schemas and optimizes query performance through intelligent decision-making and best practices.

Database Design & Architecture

Architects scalable, performant database schemas and selects optimal data persistence tools based on specific project requirements.

NoSQL Design Expert

Architects high-scale distributed database systems using query-first modeling and single-table design patterns for Cassandra and DynamoDB.

NoSQL Expert & Distributed Systems Architect

Provides expert guidance and architectural patterns for high-scale distributed NoSQL databases like Cassandra and DynamoDB.

Neon Postgres Patterns

Implements expert patterns for Neon serverless Postgres, including database branching, connection pooling, and ORM integrations.

Neon Postgres

Implements expert patterns for Neon serverless Postgres, including database branching, connection pooling, and Prisma or Drizzle ORM integrations.

Prisma ORM Expert

Streamlines database development by providing expert guidance on Prisma schema design, migration management, and query performance optimization.

Prisma ORM Expert

Streamlines database workflows by optimizing Prisma schema design, resolving migration conflicts, and implementing high-performance query patterns.

Neon Serverless Postgres

Facilitates professional-grade database management using Neon serverless Postgres with optimal connection patterns for Prisma and Drizzle ORMs.

ClickHouse Analytics Patterns

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