发现database management类别的 Claude 技能。浏览 25 个技能,找到适合您 AI 工作流程的完美功能。
Manages database schema changes through automated, version-controlled migration files for SQL and NoSQL databases.
Automates database schema evolution by generating and managing version-controlled migrations for SQL and NoSQL databases.
Automates the design, implementation, and management of table partitioning strategies to optimize database performance for large-scale datasets.
Detects, analyzes, and prevents database deadlocks by monitoring lock contention and transaction patterns.
Generates production-ready stored procedures, functions, and triggers across multiple database systems to streamline complex backend logic.
Architects and implements horizontal database sharding strategies to scale data infrastructure beyond single-server limitations.
Optimizes database query execution by analyzing EXPLAIN plans and identifying performance bottlenecks like missing indexes or inefficient joins.
Automates PostgreSQL backup, restoration, and monitoring workflows using pgBackRest and Wasabi S3 storage.
Manages database replication, high availability, and failover configurations for PostgreSQL and MySQL.
Orchestrates comprehensive database disaster recovery, point-in-time recovery, and automated failover strategies for production systems.
Optimizes database performance and resource management by implementing and fine-tuning connection pooling configurations across multiple programming languages.
Manages and automates PostgreSQL backup and recovery operations using pgBackRest and Wasabi S3 storage.
Optimizes database performance by analyzing query workloads to recommend missing indexes and identify redundant ones.
Automates the creation of comprehensive database documentation, ERD diagrams, and data dictionaries from existing schemas.
Generates realistic, schema-aware test data and database seed scripts to populate development and testing environments efficiently.
Generates production-ready stored procedures, database functions, and triggers for PostgreSQL, MySQL, and SQL Server to optimize performance and data integrity.
Automates the creation of comprehensive database schema documentation and architecture guides for SQL and NoSQL systems.
Optimizes application performance by implementing multi-tier caching strategies including Redis, in-memory L1 layers, and CDN integration.
Implements high-performance multi-tier caching architectures to optimize database query latency and reduce server load.
Automates the design and implementation of table partitioning strategies to optimize performance and manage large-scale datasets.
Designs, normalizes, and visualizes relational database schemas with automated ERD and SQL generation.
Designs, visualizes, and normalizes robust database schemas while generating SQL and Mermaid ERD diagrams.
Generates production-ready ORM models and database schemas across multiple programming languages and frameworks.
Manages version-controlled database schema changes by generating, applying, and rolling back migrations for multiple database engines.
Compares and synchronizes database schemas across different environments using automated guidance and structured validation workflows.
Implements multi-tier database caching solutions using Redis, in-memory layers, and CDNs to optimize query performance and reduce backend load.
Designs and optimizes non-relational database structures through structured architectural guidance and automated implementation workflows.
Optimizes database resource management by implementing and configuring efficient connection pooling strategies across various programming environments.
Optimizes database query performance through structured analysis, automated implementation, and comprehensive validation across multiple database systems.
Optimizes application caching strategies by analyzing hit rates, TTL configurations, and invalidation logic to enhance performance.
Scroll for more results...