Database Management Habilidades de Claude

Trino to Hive Migration

Guides the conversion of memory-intensive Trino queries to Hive syntax and execution patterns to resolve resource constraints and performance issues.

Railway Qdrant Manager

Manages Qdrant vector database deployments on Railway for high-performance AI applications and semantic search systems.

Railway Postgres Manager

Manages PostgreSQL databases on Railway with support for ORM migrations, connection pooling, and automated backups.

Trino CLI for Treasure Data

Provides expert guidance on using the Trino command-line interface to interactively query and explore Treasure Data environments.

AgentDB Advanced Vector Search & Sync

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

dbt Analytics Engineering

Simplifies data transformation and analytics engineering by providing standardized dbt patterns, model structures, and testing frameworks.

Frappe Performance Optimizer

Optimizes Frappe Framework applications by generating efficient database queries, implementing caching strategies, and managing database indexes.

Vector Similarity Search Patterns

Implements high-performance similarity search and vector retrieval patterns for AI-driven applications.

Database Query Optimizer

Analyzes and optimizes database queries for PostgreSQL, MySQL, and MongoDB using EXPLAIN plans and automated index recommendations.

FHIR Data Migration & Integration

Migrates patient and practitioner data to HAPI FHIR storage using a hybrid architecture for healthcare applications.

Query Optimization & Database Performance

Optimizes SQL database performance through advanced indexing strategies, execution plan analysis, and query refactoring.

Drizzle Migration Manager

Automates and guides the Drizzle Kit database migration workflow for the Hyper Forge platform.

Database Migration Helper

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

Koan Entity-First Data Access

Simplifies data persistence by replacing traditional repository patterns with self-aware, self-persisting entities.

Koan Entity Relationships

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

PostgreSQL Table Design

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

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, query plan analysis, and efficient SQL design patterns.

Dataverse Schema Design

Designs robust Microsoft Dataverse table schemas and data models following enterprise best practices.

Dataverse Queries

Simplifies retrieving and filtering data from Microsoft Dataverse using optimized OData and SQL syntax.

SQLMesh Data Transformation

Implements advanced data transformation patterns using SQLMesh for efficient incremental processing and column-level lineage.

Dataverse Python SDK

Simplifies interaction with the Microsoft PowerPlatform Dataverse Client SDK for building robust Python integrations.

CakePHP Database Designer

Designs optimized database schemas, Phinx-based migrations, and multi-tenant architectures specifically for PHP CakePHP applications.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through quantization, HNSW indexing, and efficient batch operations.

AgentDB Vector Search

Implements high-performance semantic vector search for intelligent document retrieval and context-aware RAG systems.

Database Design & Optimization

Architects scalable database schemas, optimizes SQL queries, and manages complex data migrations using industry best practices.

SAP HANA Developer CLI

Streamlines SAP HANA database development and administration by leveraging the hana-cli tool for object inspection, HDI management, and metadata conversion.

SAP ABAP Development

Streamlines SAP ABAP development with production-ready patterns for ABAP SQL, internal tables, RAP, and ABAP Cloud.

PostgreSQL Row Level Security (RLS)

Enforces robust multi-tenant data isolation by auditing PostgreSQL Row Level Security policies and preventing common bypass vulnerabilities.

SAP SQLScript Development

Streamlines SAP HANA database programming with expert SQLScript syntax patterns, performance optimization, and AMDP integration.

SAP Datasphere Expert

Accelerates SAP Datasphere development by providing expert guidance on data modeling, ETL orchestration, and BTP integration.