Database Management Habilidades de Claude

Database Management & Operations

Streamlines database schema design, query optimization, and administration for both MongoDB and PostgreSQL environments.

PG Gleam Postgres Guide

Optimizes Postgres performance and schema design for Gleam-based backend stacks using Squirrel, POG, and Cigogne.

ACSets Algebraic Databases

Manages complex data structures using category-theoretic formalism for in-memory relational databases and graphs.

dbt Transformation Patterns

Implements production-ready dbt patterns for analytics engineering, including model layering, automated testing, and incremental processing.

PostgreSQL Advanced Patterns

Optimizes PostgreSQL performance and database architecture using advanced indexing, complex query patterns, and efficient schema design.

AgentDB Advanced Vector Search & Sync

Manages advanced AgentDB features for distributed AI systems, including sub-millisecond QUIC synchronization, hybrid search, and multi-database orchestration.

Python Peewee ORM Assistant

Implements best practices for Peewee ORM using DatabaseProxy, scoped connections, and atomic transactions.

Koan Entity Relationships

Optimizes data entity navigation and prevents N+1 query issues through efficient batch loading and relationship patterns.

ClickHouse Architect

Designs high-performance schemas and optimizes query structures for ClickHouse v24.4+ environments.

PostgreSQL Table Design

Designs optimized, high-performance PostgreSQL schemas using industry-standard best practices for data integrity and scalability.

Database Migration Guide

Provides expert guidance and automated workflows for migrating databases across engines, versions, and cloud platforms with minimal downtime.

Treasure Data CLI (tdx-basic)

Manages Treasure Data resources and executes SQL queries using the tdx CLI directly within Claude.

Lisp-ACSet Serialization

Bridges Lisp-style S-expressions with Algebraic Databases (ACSets) for seamless serialization and data manipulation in Julia.

SQLite Data Analysis & Management

Streamlines SQLite database operations for data analysis through expert guidance on schema exploration, efficient querying, and data importing.

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, query plan analysis, and efficient SQL pattern implementation.

Event Store Design & Implementation

Designs and implements robust event stores for event-sourced systems using various database technologies and patterns.

Data Warehousing & Modeling

Architects and optimizes production-grade cloud data warehouses using dimensional modeling and modern performance patterns.

Database Migration Helper

Generates safe, reversible database migrations and schema transformations for multiple ORMs and raw SQL.

Bitwarden Dapper & MSSQL Implementation

Streamlines the creation of Dapper repository methods and idempotent MSSQL stored procedures following Bitwarden's architectural patterns.

Astro DB Patterns

Streamlines Astro DB development with standardized patterns for schema design, Drizzle ORM queries, and API endpoint implementation.

ClickHouse Analytics & Data Engineering

Provides high-performance ClickHouse database patterns, query optimizations, and data engineering best practices for OLAP workloads.

PostgreSQL Patterns & Optimization

Optimizes PostgreSQL databases through expert schema design, indexing strategies, and security best practices based on Supabase standards.

Projection Patterns for Event Sourcing

Builds high-performance read models and materialized views from event streams using standardized architectural patterns.

SQL Query Optimizer

Analyzes and optimizes database queries to improve performance, reduce latency, and minimize resource consumption across SQL and NoSQL systems.

Database Migration Manager

Manages database schema evolution by generating and executing version-controlled migrations for PostgreSQL, MySQL, SQLite, and MongoDB.

Flyway Database Migrations

Manages database schema changes and versioning through standardized Flyway migration patterns and PostgreSQL best practices.

jOOQ Database Patterns

Implements type-safe SQL queries and repository patterns using jOOQ for robust Kotlin and Java database interactions.

PostgreSQL Streaming Replication Manager

Automates the configuration, monitoring, and failover management of PostgreSQL streaming replication clusters.

Database Connection Pooler

Optimizes database connection pooling to enhance application performance and resource management efficiency.

PostgreSQL PL/pgSQL Development

Develops robust PostgreSQL procedural logic including functions, triggers, and procedures with production-ready patterns.