backend-queries-standards

maxritter · Backend

提供编写安全、高性能数据库查询的具体指导。涵盖防止SQL注入的参数化查询、避免N+1问题的预加载、选择性列获取、索引策略、事务、超时设置和缓存。包含Python和JavaScript中SQLAlchemy、Sequelize等ORM的具体代码示例。

Provides concrete guidance for writing secure and performant database queries. Covers parameterized queries to prevent SQL injection, eager loading to avoid N+1 problems, selective column fetching, indexing strategies, transactions, timeouts, and caching. Includes specific code examples in Python and JavaScript with ORMs like SQLAlchemy and Sequelize.

npx skills add https://github.com/maxritter/claude-codepro --skill backend-queries-standards

星标 1749 · 安装量 9

GitHub · SkillBox 全部技能