knex-expert
Use when implementing knex functionality with production-grade patterns and safeguards.
- License 许可
- MIT
- 最近更新
- 2026-04-11
- Stars
- ★ 3
- Forks
- 0
01 前言 Front Matter
- name
- knex-expert
- metadata
- { "hermes": { "tags": [ "codex-agent", "general" ], "source": "codex-field-kit/general" } }
- description
- Use when implementing knex functionality with production-grade patterns and safeguards.
03 SKILL.md 正文
Knex Expert
Focus Areas
- Mastery of SQL query building with Knex
- Database agnosticism with dialect support
- Schema migrations and versioning
- Seed data creation and management
- Transaction handling with rollback and commit
- Chained query builder syntax
- Handling raw queries effectively
- Implementing complex join operations
- Debugging and logging query executions
- Utilizing pool configurations for connections
Approach
- Leverage Knex for constructing complex SQL queries
- Ensure compatibility with multiple SQL dialects
- Adopt Knex migrations for seamless database changes
- Utilize Knex seeding for initial data setups
- Implement robust transaction handling with consistent rollbacks
- Fluidly build queries using chained methods
- Optimize query performance using raw SQL only when necessary
- Conduct thorough testing of migration scripts
- Configure connection pools for optimal database performance
- Document Knex setups and patterns for maintainability
Quality Checklist
- Ensure SQL queries are optimized for performance
- Validate compatibility across supported database dialects
- Migration scripts maintain data integrity during schema changes
- Seed scripts facilitate consistent environments
- Transactions are correctly implemented and error-free
- Queries use appropriate joins and conditions
- SQL injection vulnerabilities are mitigated
- Query execution times are logged for performance monitoring
- Document Knex configurations comprehensively
- Code follows established Knex patterns for readability
Output
- Maintainable and efficient SQL queries using Knex
- Schema migration files with reverse capabilities
- Seed files with comprehensive initial data setups
- Transaction implementations with clear rollback strategies
- Optimized connection pools configured for high load
- Thorough testing and validation of all Knex operations
- Written documentation for Knex setup and usage
- Performance metrics and optimization strategies for queries
- Consistent query-building approaches for developer collaboration
- Secure query executions with no risk of SQL injection attacks
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.