一键在 Manus 中运行任何 Skill

$pwd:

backend-queries

Name: Backend Queries
Author: pdovhomilja

// Write optimized and secure database queries using parameterized queries, eager loading, and proper indexing strategies. Use this skill when writing database queries, constructing SQL statements, using ORM query methods, implementing data fetching logic, preventing SQL injection attacks, optimizing query performance, avoiding N+1 query problems, selecting specific columns instead of all data, implementing transactions for related operations, setting query timeouts, caching expensive queries, or working with WHERE clauses, JOINs, and ORDER BY statements. Apply this skill when fetching data from databases, optimizing slow queries, refactoring data access code, or reviewing query security and performance.

在 Manus 中运行

$ git log --oneline --stat

stars:0

forks:0

updated:2025年11月24日 07:59

SKILL.md

readonly

name

Backend Queries

description

Write optimized and secure database queries using parameterized queries, eager loading, and proper indexing strategies. Use this skill when writing database queries, constructing SQL statements, using ORM query methods, implementing data fetching logic, preventing SQL injection attacks, optimizing query performance, avoiding N+1 query problems, selecting specific columns instead of all data, implementing transactions for related operations, setting query timeouts, caching expensive queries, or working with WHERE clauses, JOINs, and ORDER BY statements. Apply this skill when fetching data from databases, optimizing slow queries, refactoring data access code, or reviewing query security and performance.

Backend Queries

When to use this skill

When writing database queries in any file that interacts with the database
When constructing SQL statements or using ORM query builders (Prisma, Sequelize, ActiveRecord, etc.)
When preventing SQL injection by using parameterized queries
When optimizing queries to avoid N+1 query problems (use eager loading or joins)
When selecting only needed columns instead of using SELECT * or fetching all fields
When adding indexes to columns used in WHERE, JOIN, or ORDER BY clauses
When implementing database transactions for related operations
When setting query timeouts to prevent runaway queries
When caching results of complex or frequently-run queries
When writing JOIN operations to fetch related data efficiently
When implementing pagination, filtering, or sorting with query parameters
When reviewing query performance and optimization opportunities

This Skill provides Claude Code with specific guidance on how to adhere to coding standards as they relate to how it should handle backend queries.

Instructions

For details, refer to the information provided in this file: backend queries

related-skills.json

同仓库

backend-api.md

from "pdovhomilja/dovhomilja-cz"

Design and implement RESTful API endpoints following REST principles with clear resource-based URLs and appropriate HTTP methods. Use this skill when creating API routes, defining API endpoints, implementing HTTP request handlers, working on route files (routes.ts, route.ts, api/*, controllers/*, handlers/*), building REST APIs, designing API versioning strategies, setting up query parameters for filtering and pagination, implementing rate limiting, or returning appropriate HTTP status codes. Apply this skill when structuring backend API architecture, creating new API endpoints, refactoring existing endpoints, or reviewing API design for consistency and best practices.

2025-11-240

backend-migrations.md

from "pdovhomilja/dovhomilja-cz"

Create and manage database migrations following best practices for schema changes and data migrations. Use this skill when creating database migration files, modifying database schemas, adding or removing tables and columns, working with migration files (prisma/migrations/*, db/migrate/*, migrations/*), implementing reversible migrations with rollback methods, managing database indexes, handling zero-downtime deployments, separating schema changes from data migrations, or ensuring backwards compatibility during schema updates. Apply this skill when setting up new database tables, altering existing database structures, creating migration scripts, or reviewing migration safety and rollback strategies.

2025-11-240

backend-models.md

from "pdovhomilja/dovhomilja-cz"

Define and structure database models with proper naming conventions, data integrity constraints, and relationship definitions. Use this skill when creating or modifying database model files, defining table schemas, setting up model relationships (one-to-many, many-to-many, one-to-one), working with ORM model files (schema.prisma, models/*, app/models/*, entities/*), implementing data validation at the model level, adding timestamps and audit fields, defining foreign keys and indexes, choosing appropriate data types, configuring cascade behaviors, or balancing database normalization with query performance. Apply this skill when designing database schemas, creating new models, refactoring existing model structures, or reviewing data integrity and relationship configurations.

2025-11-240

frontend-accessibility.md

from "pdovhomilja/dovhomilja-cz"

Build accessible user interfaces using semantic HTML, ARIA attributes, keyboard navigation, and proper color contrast. Use this skill when creating or modifying UI components, implementing forms and interactive elements, working with navigation menus, building modals and dialogs, adding images and media content, writing JSX/HTML markup, ensuring keyboard accessibility, testing with screen readers, managing focus states, implementing proper heading hierarchies, providing alternative text for images, maintaining color contrast ratios, using ARIA labels and roles, or ensuring all interactive elements are keyboard-navigable. Apply this skill when building frontend components, reviewing UI accessibility, refactoring markup for better semantics, or implementing WCAG compliance requirements.

2025-11-240

frontend-components.md

from "pdovhomilja/dovhomilja-cz"

Design and build reusable, composable UI components following single responsibility principle with clear interfaces and proper state management. Use this skill when creating React components, Vue components, or other framework components, defining component props and interfaces, managing component state, building reusable UI elements, working with component files (*.tsx, *.jsx, *.vue, *.svelte, components/*, ui/*), implementing component composition patterns, encapsulating component logic, documenting component APIs, keeping state local or lifting it up when needed, designing component hierarchies, or refactoring monolithic components into smaller pieces. Apply this skill when building new components, refactoring existing component structures, reviewing component design patterns, or ensuring components are maintainable and reusable.

2025-11-240

frontend-css.md

from "pdovhomilja/dovhomilja-cz"

Write and maintain CSS following project conventions using consistent methodologies like Tailwind CSS, BEM, CSS modules, or utility classes, while creating distinctive, aesthetically excellent designs. Use this skill when writing CSS styles, applying Tailwind utility classes, creating custom CSS, working with styling files (*.css, *.scss, *.module.css, globals.css, tailwind.config.*), maintaining design systems and design tokens, defining CSS variables for colors and spacing, implementing typography styles with unique font choices, creating atmospheric backgrounds and depth, adding animations and micro-interactions, avoiding framework style overrides, avoiding generic "AI slop" aesthetics (purple gradients, Inter/Roboto everywhere, cookie-cutter designs), optimizing CSS for production with purging and tree-shaking, or ensuring consistent styling patterns across the application. Apply this skill when styling components, refactoring CSS code, setting up design systems, choosing fonts and colors, creating animat

2025-11-240

package.json

"author": "pdovhomilja"

"repository": "pdovhomilja/dovhomilja-cz"

打开 GitHub 仓库查看创作者相关仓库

$ install --global

$ download --local

在 Manus 中运行

$ useful --forSOC

数据库架构师计算机与数学类职业15-1243L4

name

Backend Queries

description

Backend Queries

When to use this skill

When writing database queries in any file that interacts with the database
When constructing SQL statements or using ORM query builders (Prisma, Sequelize, ActiveRecord, etc.)
When preventing SQL injection by using parameterized queries
When optimizing queries to avoid N+1 query problems (use eager loading or joins)
When selecting only needed columns instead of using SELECT * or fetching all fields
When adding indexes to columns used in WHERE, JOIN, or ORDER BY clauses
When implementing database transactions for related operations
When setting query timeouts to prevent runaway queries
When caching results of complex or frequently-run queries
When writing JOIN operations to fetch related data efficiently
When implementing pagination, filtering, or sorting with query parameters
When reviewing query performance and optimization opportunities

This Skill provides Claude Code with specific guidance on how to adhere to coding standards as they relate to how it should handle backend queries.

Instructions

For details, refer to the information provided in this file: backend queries

backend-queries

Backend Queries

When to use this skill

Instructions

同仓库更多 Skills

同仓库更多 Skills

Backend Queries

When to use this skill

Instructions