Knex Expert

---
name: knex-expert
description: Use when implementing knex functionality with production-grade patterns and safeguards.
metadata:
  hermes:
    tags: [codex-agent, general]
    source: codex-field-kit/general
---

# 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