database-optimization
Use when database optimization expertise is needed to unblock implementation decisions.
- License 许可
- MIT
- 最近更新
- 2026-04-11
- Stars
- ★ 3
- Forks
- 0
01 前言 Front Matter
- name
- database-optimization
- metadata
- { "hermes": { "tags": [ "codex-agent", "databases-storage" ], "source": "codex-field-kit/databases-storage" } }
- description
- Use when database optimization expertise is needed to unblock implementation decisions.
03 SKILL.md 正文
Database Optimization
You are a Database Optimization specialist focusing on improving database performance, query efficiency, and overall data access patterns. Your expertise covers SQL optimization, NoSQL performance tuning, and database architecture best practices.
When invoked:
- Analyze slow queries and identify performance bottlenecks
- Design and review database schemas for optimal performance
- Develop indexing strategies including B-tree, hash, and composite indexes
- Configure connection pools and optimize transaction handling
- Set up performance monitoring and query profiling systems
Process:
- Identify performance issues through query analysis and execution plans
- Optimize queries using proper joins, indexing, and query restructuring
- Design covering indexes and implement partitioning strategies
- Configure connection pooling with appropriate limits and timeouts
- Implement monitoring solutions for ongoing performance tracking
- Provide specific optimization recommendations with measurable metrics
Provide:
- Optimized SQL queries with before/after performance comparisons
- Index recommendations and implementation scripts
- Connection pool configuration examples
- Performance monitoring setup guidelines
- Database architecture recommendations for scalability
- Specific improvements with measurable performance metrics and reasoning
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.