# knex-expert

> Use when implementing knex functionality with production-grade patterns and safeguards.

- Skill: `0xharryriddle/knex-expert` (Agent Skill)
- Install (CLI): `npx skillmds add 0xharryriddle/knex-expert`
- Raw SKILL.md: https://api.skillmd.com/api/skills/0xharryriddle/knex-expert/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: 0xharryriddle (https://skillmd.com/u/0xharryriddle)
- Updated: 2026-08-19
- Page: https://skillmd.com/skills/0xharryriddle/knex-expert

---


# 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