backend--queries_skill

Overview

This skill applies the Agent OS backend queries standard to TypeScript backends. It helps enforce consistent query patterns, typing, error handling, and performance considerations across services. Use it to make backend query code predictable, maintainable, and interoperable with Agent OS conventions.

How this skill works

The skill inspects TypeScript query implementations and checks them against the Agent OS backend queries standard. It validates typing, query composition, parameter handling, and recommended error/response shapes, and flags deviations or missing concerns. It outputs concrete suggestions for alignment and examples for corrections.

When to use it

• When adding or refactoring query logic in a backend service
• During code reviews for TypeScript query modules
• When implementing new endpoints that depend on database or external queries
• Before merging changes affecting query typing, error models, or performance-critical paths

Best practices

• Prefer explicit, narrow TypeScript types for inputs and outputs to reduce runtime errors
• Centralize common query utilities (pagination, filtering, sanitization) for reuse
• Return consistent error shapes and status semantics so callers can handle failures uniformly
• Avoid embedding raw SQL or unparameterized inputs; use parameterized queries or query builders
• Document query contracts and side effects in the module-level comments

Example use cases

• Standardize CRUD query implementations across microservices to share the same input/output contract
• Refactor an endpoint to replace ad-hoc queries with typed, reusable query helpers
• Audit query modules for inconsistent error handling and align them to a single error schema
• Add pagination and filtering to an existing list endpoint while keeping type safety intact