Database Management Habilidades de Claude

ORM & Database Schema Generator

Generates production-ready ORM models and database schemas for frameworks like TypeORM, Prisma, and SQLAlchemy using natural language.

Database Query Performance Optimizer

Optimizes database query execution by analyzing EXPLAIN plans and identifying performance bottlenecks.

SQL Query Optimizer

Analyzes and refines SQL queries to enhance database performance through index recommendations and structural rewrites.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers for major SQL databases to optimize performance and enforce business logic.

PostgreSQL Schema Design Expert

Architects high-performance PostgreSQL databases using industry-standard schema design, indexing strategies, and data integrity patterns.

Backend Queries

Writes efficient, secure database queries while preventing N+1 problems and SQL injection vulnerabilities.

Backend Models

Defines robust database models and schemas with precise ORM mappings, relationships, and data integrity constraints.

NestJS TypeORM Integration

Streamlines the setup, configuration, and refactoring of TypeORM within NestJS TypeScript projects for scalable database management.

Unified SQL Data Analyst

Queries and joins data across PostgreSQL, MySQL, and SQLite databases using a unified SQL engine for advanced data exploration.

Supabase Expert

Provides comprehensive guidance for building secure and scalable applications using Supabase database, auth, storage, and edge functions.

PostgreSQL Nanoid Identifiers

Implements a hybrid ID strategy using Nanoids for public-facing identifiers and UUIDs for internal PostgreSQL references.

Supabase Database & Security Manager

Manages Supabase database instances, enforces PostgreSQL security best practices, and streamlines migration workflows for the Dashboard project.

Drizzle ORM Expert

Provides comprehensive documentation and implementation patterns for Drizzle ORM, covering type-safe queries, schema management, and multi-database integrations.

Firebase Firestore Specialist

Implement and optimize Firebase Firestore databases with real-time synchronization, offline-first architecture, and robust security rules.

PostgreSQL Table Design

Designs optimized, production-grade PostgreSQL schemas following industry best practices and performance patterns.

JGI Lakehouse Query

Facilitates querying and exploring the Joint Genome Institute (JGI) Dremio Lakehouse, including GOLD and IMG genomics databases.

Supabase Database

Streamlines Supabase database management through optimized CRUD operations, Row Level Security (RLS) implementation, and PostgreSQL function support.

Data Quality Test Generator

Generates comprehensive dbt test suites using modern 1.10+ syntax to ensure data integrity and structural consistency across analytical models.

Postgres Hypothetical Index Helper

Generates Ruby and ActiveRecord commands to create and test PostgreSQL hypothetical indexes using the HypoPG extension.

dbt Model Builder

Constructs standardized dbt models following Kimball dimensional patterns and modern testing configurations.

Database Schema Conflict Resolver

Resolves database schema version conflicts by automatically selecting the most recent migration timestamp.

Supabase Next.js Integration

Streamlines the integration of Supabase backend services into React and Next.js applications using modern App Router patterns and SSR.

ClickHouse Analytics & Data Patterns

Optimizes ClickHouse database performance with expert patterns for schema design, high-volume data ingestion, and complex analytical queries.

Optimizing Performance

Identifies and resolves performance bottlenecks across databases, application logic, and infrastructure using proven optimization patterns.

Backend Queries

Implements structured database queries and repository patterns using Prisma ORM to maintain a robust layered architecture.

Objectstar Legacy Migration

Analyzes, refactors, and migrates TIBCO Objectstar legacy mainframe applications to modern architectures and programming languages.

PostgreSQL Table Design

Architects production-grade PostgreSQL schemas using expert-level best practices for data integrity, performance, and scalability.

Metadata Manager

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

SQL Optimization Patterns

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

Writing Queries

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