Database Management Habilidades de Claude

Litestream for Rails

Configures continuous SQLite backups for Rails 8+ applications using Litestream and S3-compatible storage.

Alembic Database Migration

Manages complex database schema evolutions and data migrations using Alembic and SQLAlchemy with a focus on production stability.

Database Architect & Management

Architects, queries, and optimizes complex data storage systems across SQL and NoSQL paradigms.

Database Management Patterns

Optimizes data architecture and performance across SQL and NoSQL systems through comprehensive schema design, indexing strategies, and scaling patterns.

SQLAlchemy ORM Expert

Implements professional-grade SQLAlchemy ORM patterns and database optimizations for modern Python applications.

Pre-Dev Data Modeling

Defines technology-agnostic data entities, relationships, and ownership to ensure robust system architecture before database selection.

Ampi Vault Builder

Transforms document folders or SQLite tables into searchable, Ampi-compliant database vaults with keyword and semantic indexing.

PostgreSQL Database Administration

Manages and optimizes PostgreSQL databases for customer support environments, including schema design, performance tuning, and advanced query implementation.

SQL

Writes and optimizes SQLite queries, schemas, and migrations using standardized best practices and specific implementation patterns.

Kafka Stream Processing

Architects and implements scalable event-driven systems using Apache Kafka for real-time data processing and high-throughput messaging.

dbt Data Transformation

Streamlines analytics engineering workflows by implementing modular SQL transformations, automated testing, and comprehensive data documentation using dbt.

Psycopg PostgreSQL Adapter

Simplifies PostgreSQL database operations in Python with specialized support for connection pooling, asynchronous I/O, and secure query execution.

Redis State Management

Implements high-performance Redis patterns for caching, session management, and distributed state coordination.

Vector Database Management

Manages and optimizes vector databases like Pinecone, Weaviate, and Chroma for semantic search, RAG systems, and similarity-based AI applications.

PostgreSQL Database Engineering

Optimizes and manages professional PostgreSQL environments through advanced indexing strategies, query tuning, and high-availability architecture patterns.

Neon Serverless Postgres

Streamlines database development by providing expert guidance on Neon's serverless architecture, branching features, and driver integrations.

Event Sourcing

Implements event sourcing and CQRS patterns to maintain a full history of state changes through immutable event streams.

Query Optimization

Optimizes SQL queries through systematic performance benchmarking, execution plan analysis, and iterative refinement across multiple database engines.

SQLite Truncated Database Recovery

Recovers data from corrupted or truncated SQLite database files through manual binary analysis and custom parsing when standard tools fail.

Database WAL Recovery

Provides technical procedures and systematic workflows for recovering data from corrupted, encrypted, or inaccessible SQLite Write-Ahead Log (WAL) files.

SQLite DB Truncation Recovery

Recovers data from corrupted or truncated SQLite databases by manually parsing binary structures when standard tools fail.

SPARQL University

Constructs and verifies complex SPARQL queries for RDF datasets with a focus on academic ontologies and graph pattern matching.

Firebase Firestore Specialist

Optimizes Firebase Firestore implementation with expert NoSQL modeling, real-time synchronization, and advanced Security Rules configuration.

SQL Query Optimization

Optimizes SQL queries for maximum performance by identifying bottlenecks, rewriting inefficient subqueries, and implementing high-performance patterns like window functions and CTEs.

Database WAL Recovery

Recovers data from SQLite Write-Ahead Log (WAL) files by identifying, analyzing, and decrypting corrupted or inaccessible database components.

Schema Auto-Tagger for Treasure Data

Automates metadata classification and policy tagging for Treasure Data schemas to ensure governance and compliance with minimal manual effort.

Modern Database Architecture Specialist

Optimizes database architectures across PostgreSQL, MongoDB, and Redis to ensure high-performance data management and scalable system design.

Treasure Data Dictionary Helper

Automates the generation and maintenance of Treasure Data column descriptions using AI-powered schema analysis and human-in-the-loop review.

SPARQL University Querying

Provides specialized guidance for constructing and verifying SPARQL queries against RDF and Turtle datasets, specifically tailored for academic and university data structures.

Neon Serverless PostgreSQL Specialist

Optimizes and manages Neon serverless PostgreSQL databases with specialized support for branching, auto-scaling, and edge-compatible connection pooling.