backend-queries
Write secure and performant database queries using ORMs or raw SQL. Use this skill when writing database queries, implementing data access logic, or optimizing query performance. Apply when working on files like repositories/*.ts, queries/*.ts, services/*.ts with database operations, or any code that interacts with the database. Essential for preventing SQL injection with parameterized queries, avoiding N+1 query problems with eager loading, selecting only needed columns, using transactions for related operations, implementing query timeouts, and caching expensive queries.
Installation and usage
Write secure and performant database queries using ORMs or raw SQL. Use this skill when writing database queries, implementing data access logic, or optimizing query performance. Apply when working on files like repositories/*.ts, queries/*.ts, services/*.ts with database operations, or any code that interacts with the database. Essential for preventing SQL injection with parameterized queries, avoiding N+1 query problems with eager loading, selecting only needed columns, using transactions for related operations, implementing query timeouts, and caching expensive queries.
Once installed, you can use this skill by running the following command in your terminal:
skills use backend-queries