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.
安装后，您可以通过在终端运行以下命令来使用此技能：
skills use backend-queries