Search Skills
Search across 54932 indexed skills
food-database-query
技能名称: Food Database Query 技能类型: 数据查询与分析 创建日期: 2026-01-06 版本: v1.0 --- 需要查询食物营养成分、比较食物差异或做营养计算时使用。 任务涉及食物数据库检索、食物推荐、份量换算或分类筛选。 需要基于结构化食物数据生成分析结果而不是自由文本...
monitoring-database-transactions
Monitor active database transactions in real time to detect long-running queries, lock contention, uncommitted transactions, and transaction throughpu...
managing-database-recovery
Plan and execute database backup and recovery procedures for PostgreSQL and MySQL, including point-in-time recovery (PITR), logical and physical backu...
monitoring-database-health
Monitor database server health across PostgreSQL, MySQL, and MongoDB by tracking key performance indicators including connection utilization, query th...
implementing-database-audit-logging
Implement database audit logging to track all data modifications (INSERT, UPDATE, DELETE) with full before/after values, user identity, timestamps, an...
optimizing-database-connection-pooling
Configure and optimize database connection pooling using external poolers (PgBouncer, ProxySQL, Odyssey) and application-level pool settings to preven...
validating-database-integrity
Implement and enforce data integrity rules at the database level using CHECK constraints, triggers, foreign keys, and custom validation functions acro...
managing-database-replication
Configure and manage database replication topologies for PostgreSQL (streaming replication, logical replication), MySQL (source-replica, group replica...
generating-database-seed-data
Generate realistic database seed scripts that populate development and testing environments with representative data. This skill creates seed data tha...
managing-database-migrations
Create, validate, and execute database schema migrations with full rollback support across PostgreSQL, MySQL, and MongoDB. Database credentials with D...
designing-database-schemas
Design normalized relational database schemas from business requirements, entity-relationship diagrams, or existing application code. This skill produ...
archiving-databases
Implement automated data archival pipelines that move historical records from primary database tables to archive storage (archive tables, S3, Azure Bl...