Database Management Claude 技能

PostgreSQL Patterns & Optimization

Optimizes PostgreSQL databases with best-practice schema designs, indexing strategies, and performance tuning patterns.

HydraDB Workspace Reindex

Syncs local workspace context into HydraDB to enable long-term memory and retrieval for Claude Code.

HydraDB Status Checker

Monitors and verifies the configuration and synchronization state of the HydraDB plugin for Claude Code.

HydraDB Knowledge Search

Queries your HydraDB workspace memory to retrieve and summarize relevant context and stored implementation details.

Data Structure Analyst

Performs comprehensive database reverse engineering and metadata analysis to document data lineage and relationships.

DBT Model Optimizer

Optimizes and refactors DBT models to improve query performance, SQL efficiency, and materialization strategies.

dbt Model Developer

Streamlines dbt data modeling through automated architecture design, schema synchronization, and best-practice implementation.

Salesforce Data Analyzer

Analyzes Salesforce data models and executes SOQL queries to generate comprehensive data reports and exports.

DBT Project Manager

Automates the initialization, configuration, and health monitoring of dbt projects to ensure seamless data transformation workflows.

NestJS TypeORM Integration

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

Rockets SDK CRUD Generator

Generates production-grade CRUD modules including TypeORM entities, NestJS controllers, and ACL wiring for the Rockets SDK.

SAP ABAP CDS Development

Develops robust data models and semantic enrichments using SAP ABAP Core Data Services (CDS) for modern enterprise applications.

SAP HANA CLI

Manages SAP HANA database development and administration through the powerful hana-cli tool.

SQL Server Patterns

Implements industry-standard T-SQL best practices and performance optimization patterns for SQL Server and Azure SQL Database.

BigQuery CLI Integration

Facilitates seamless interaction with Google BigQuery via the bq command-line tool for data exploration and analysis.

Database Archival & Retention

Automates the archival of historical database records to cold storage or archive tables to optimize performance and ensure regulatory compliance.

Database Audit Logging

Automates the implementation of database audit trails and change tracking to ensure data integrity and regulatory compliance.

Database Backup Automator

Automates secure database backups and restoration procedures for PostgreSQL, MySQL, MongoDB, and SQLite.

Database Caching Adapter

Implements multi-tier caching architectures to optimize database performance and reduce latency using Redis, in-memory layers, and CDNs.

Database Deadlock Detector

Detects, analyzes, and prevents database deadlocks by monitoring lock contention and identifying problematic transaction patterns.

Database Migration & Schema Diff Tool

Automates database schema comparisons and generates safe, production-grade migration scripts with built-in rollback procedures.

Database Documentation Generator

Automates the generation of comprehensive database documentation, ERD diagrams, and data dictionaries from existing schemas.

Database Index Advisor

Analyzes database query patterns and workloads to provide actionable recommendations for index optimization and performance tuning.

Database Migration Manager

Automates the creation, application, and rollback of database schema migrations across multiple SQL and NoSQL engines.

Database Partitioning Manager

Automates the design, implementation, and management of database partitioning strategies to optimize query performance and data archival.

Database Recovery & Backup Manager

Automates database disaster recovery, point-in-time recovery (PITR), and failover strategies to ensure production system resilience.

Database Replication Manager

Automates the setup and management of database replication, failover, and high availability configurations for PostgreSQL and MySQL.

Database Schema Designer

Designs, normalizes, and visualizes relational database schemas with automated ERD and SQL generation.

Database Sharding Manager

Architects and implements horizontal database sharding strategies to scale data storage and performance across multiple servers.

Database Transaction Monitor

Monitors database transactions in real-time to detect long-running queries, lock contention, and transaction anomalies.