postgres-expert
Use when implementing postgres functionality with production-grade patterns and safeguards.
- License 许可
- MIT
- 最近更新
- 2026-04-11
- Stars
- ★ 3
- Forks
- 0
01 前言 Front Matter
- name
- postgres-expert
- metadata
- { "hermes": { "tags": [ "codex-agent", "general" ], "source": "codex-field-kit/general" } }
- description
- Use when implementing postgres functionality with production-grade patterns and safeguards.
03 SKILL.md 正文
Postgres Expert
Focus Areas
- Mastery of advanced SQL queries, including CTEs and window functions
- Proficient in designing and Normalizing database schemas
- Expertise in indexing strategies to optimize query performance
- Deep understanding of PostgreSQL architecture and configuration
- Skilled in backup and restore processes for data safety
- Familiarity with PostgreSQL extensions to enhance functionality
- Command over transaction isolation levels and locking mechanisms
- Conducting performance tuning and query optimization
- Implementation of replication and clustering for high availability
- Ensuring data integrity through constraints and referential integrity
Approach
- Analyze query execution plans to identify bottlenecks
- Normalize database schemas to minimize redundancy
- Apply indexing wisely by balancing read/write performance
- Configure PostgreSQL settings tailored to workload demands
- Utilize partitioning strategies for big data scenarios
- Leverage stored procedures and functions for repeated logic
- Conduct regular database health checks and maintenance
- Implement robust monitoring and alerting systems
- Utilize advanced backup strategies, such as PITR
- Stay updated with the latest PostgreSQL features and best practices
Quality Checklist
- Queries are optimized for minimal execution time
- Indexes are appropriately used and maintained
- Schemas are normalized without loss of performance
- All database operations are ACID compliant
- Appropriate partitioning is used for large datasets
- Data redundancy is minimized and integrity is enforced
- Backup and recovery plans are tested and documented
- Extensions are appropriately used without performance degradation
- Monitoring tools are effectively deployed for real-time insights
- System configurations are optimized based on query patterns
Output
- Performance-optimized SQL queries with detailed explanation
- Comprehensive schema design documentation
- Configuration files customized for specific workloads
- Detailed execution plan analyses with recommendations
- Backup and recovery strategy documentation
- Performance benchmarking results before and after optimizations
- Monitoring setup guidelines and alert configuration documentation
- Deployment strategies for high availability setups
- Documentation of custom functions and procedures
- Reports on periodic health checks and maintenance activities
04 同仓库更多 Skills
vercel-react-best-practices
React and Next.js performance optimization guidelines from Vercel Engineering. This skill should be used when writing, reviewing, or refactoring React/Next.js code to ensure optimal performance patterns. Triggers on tasks involving React components, Next.js pages, data fetching, bundle optimization, or performance improvements.
swarm-planner
[EXPLICIT INVOCATION ONLY] Creates dependency-aware implementation plans optimized for parallel multi-agent execution.
super-swarm-spark
Only to be triggered by explicit super-swarm-spark commands.
role-creator
Create and install Codex custom agent roles in ~/.codex/config.toml, generate role config files, enforce supported keys, and guide users through required role inputs (model, reasoning effort, developer_instructions).
read-github
Read and search GitHub repository documentation via gitmcp.io MCP service. **WHEN TO USE:** - User provides a GitHub URL - User mentions a specific repo in owner/repo format - User asks "what does this repo do?", "read the docs for X repo", or similar - User wants to search code or docs within a repo
planner
Create comprehensive, phased implementation plans with sprints and atomic tasks. Use when user says: "make a plan", "create a plan", "plan this out", "plan the implementation", "help me plan", "design a plan", "draft a plan", "write a plan", "outline the steps", "break this down into tasks", "what's the plan for", or any similar planning request. Also triggers on explicit "/planner" or "/plan" commands.