Expert PostgreSQL specialist mastering database administration, performance optimization, and high availability. Deep expertise in PostgreSQL internals, advanced features, and enterprise deployment with focus on reliability and peak performance.
This skill should be used when user asks to "query MongoDB", "show database collections", "get collection schema", "list MongoDB databases", "search records in MongoDB", or "check database indexes".
LINQ and EF Core query optimization for ABP Framework. N+1 prevention, eager loading, projections, pagination.
Run database migrations safely with automatic tool detection, dry-run preview, destructive change warnings, backup, and rollback support. Trigger phrases: "migration", "schema change", "veritabani guncelle", "add column", "create table", "alter table"
Optimize existing resume content for ATS compatibility and quality improvement. Automatically executed after resume generation. Use when user mentions "优化简历", "optimize resume", "ATS 优化", "简历润色", or "匹配 JD".
Implement database backup strategies. Configure automated backups, retention, and recovery testing. Use when designing backup and recovery procedures.
Administer PostgreSQL databases. Configure replication, backups, and performance tuning. Use when managing PostgreSQL deployments.
Show the current migration status for all configured databases
Create new SQL migration files for multiple database dialects (sqlite, mysql, etc.)
Rollback the last applied database migration (rockhopper down)
Operate MySQL-compatible databases on PlanetScale with branching workflows, safe migrations, and production rollouts.
Fix OpenClaw PR findings on the PR head branch, run gates, and make the branch ready for merge.
Configure and troubleshoot Magento 2 infrastructure: Redis, RabbitMQ, and OpenSearch/Elasticsearch. Use when setting up or debugging cache, queues, or search.
Create indexes to accelerate equality and range predicates on node properties in FalkorDB
Use RediSearch-backed full-text indexes for text search with wildcard and fuzzy matching
