メニュー
Aurora Criteria Pattern - Complete guide for QueryStatement usage in Aurora/NestJS. Trigger: When implementing queries, filters, searches, pagination, or complex data retrieval.
デフォルトでは、最初にソースを確認する Prompt が選択されています。直接コマンドに切り替えるか、ローカルコピーをダウンロードすることもできます。
インストールを決める前に、SKILL.md と SkillsMP に表示されている付属ファイルをお読みください。
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
直接コマンドでは確認用 Prompt が省略されます。実行前にソースを確認してください。
npx skills add https://github.com/majiayu000/claude-skill-registry-data --skill aurora-criteriaコマンドは1行のまま表示されます。コピー前に横へスクロールして全体を確認してください。
ローカルで確認しますか？SkillsMP が現在取得できるファイルをダウンロードできます。
SKILL.md を表示中
SOC 職業分類に基づく
Guided, hands-on course teaching architects how to use Claude Code — six short modules, each built around an exercise on a bundled sandbox project (a fictional Brooklyn art museum expansion). Resumable across sessions via PROGRESS.md. Use when the user runs /learn, says they're new to Claude Code, or asks how to learn it.
Upscale and restore video in ComfyUI — both the quick local path (per-frame ESRGAN like 4x_foolhardy_Remacri via ImageUpscaleWithModel + 4x→2x supersample, with its temporal-flicker tradeoff) and temporal-aware super-resolution (SeedVR2, the newer FlashVSR) with the downscale-first restore pipeline; RIFE/FILM frame interpolation via the BUILT-IN ComfyUI 0.26 FrameInterpolate (rife_v4.26 in models/frame_interpolation/) or the ComfyUI-Frame-Interpolation pack; 2x/4x scaling, VRAM tiers, VHS encode. Captures the classic downscale→SeedVR2→RIFE recipe and the current 2026 recommendation.
Auto-tag FF&E products with categories, colors, materials, and style tags using AI. Use when the user asks to "enrich", "tag", or "categorize" products, or to fill in missing category, material, or style columns in the schedule.
| name | aurora-criteria |
| description | Aurora Criteria Pattern - Complete guide for QueryStatement usage in Aurora/NestJS. Trigger: When implementing queries, filters, searches, pagination, or complex data retrieval. |
| license | MIT |
| metadata | {"author":"aurora","version":"1.0","auto_invoke":"Building QueryStatement filters, implementing pagination, creating search queries"} |
Use this skill when:
QueryStatement is Aurora's standardized interface for building complex database queries using the Criteria Pattern.
It provides a unified API for filtering, sorting, pagination, and data selection across all repositories.
interface QueryStatement {
where?: JSON; // Filtering conditions
attributes?: JSON; // Field selection
?: [];
?: ;
?: ;
?: ;
?: ;
?: ;
?: ;
}
Operators MUST be quoted keys wrapped in square brackets:
// ✅ CORRECT
{ "where": { "age": { "[gte]": 18 } } }
{ "where": { "name": { "[startsWith]": "Carlos" } } }
// ❌ INCORRECT (will NOT work)
{ "where": { "age": { gte: 18 } } }
{ "where": { "name": { startsWith: "Carlos" } } }
@Injectable()
export class TeslaGetModelsService {
constructor(private readonly repository: TeslaIModelRepository) {}
async main(
queryStatement?: QueryStatement,
constraint?: QueryStatement,
cQMetadata?: CQMetadata,
): Promise<TeslaModel[]> {
return await this.repository.get({
queryStatement, // User-provided filters
constraint, // System/security constraints
cQMetadata,
});
}
}
export class TeslaGetModelsQuery {
constructor(
public readonly queryStatement?: QueryStatement,
public readonly constraint?: QueryStatement,
public readonly cQMetadata?: CQMetadata,
) {}
}
// AND - All conditions must match
{
where: {
"[and]": [
{ status: "PRODUCTION" },
{ year: { "[gte]": 2020 } }
]
}
}
// OR - Any condition must match
{
where: {
"[or]": [
{ status: "PRODUCTION" },
{ status: "PREPRODUCTION" }
]
}
}
// NOT - Negate condition
{
where: {
"[not]": {
deletedAt: { "[is]": null }
}
}
}
// Simple equality (implicit [eq])
{ where: { id: "uuid-here" } }
// Explicit equality
{ where: { id: { "[eq]": "uuid-here" } } }
// Not equal
{ where: { status: { "[ne]": "DISCLAIMER" } } }
// IS NULL / IS NOT NULL
{ where: { deletedAt: { "[is]": null } } }
{ where: { deletedAt: { "[is]": "[not]null" } } }
// Greater than
{ where: { year: { "[gt]": 2020 } } }
// Greater than or equal
{ where: { year: { "[gte]": 2020 } } }
// Less than
{ where: { year: { "[lt]": 2025 } } }
// Less than or equal
{ where: { year: { "[lte]": 2024 } } }
// Combined range
{
where: {
year: {
"[gte]": 2020,
"[lte]": 2024
}
}
}
// BETWEEN (inclusive)
{ where: { year: { "[between]": [2020, 2024] } } }
// NOT BETWEEN
{ where: { year: { "[notBetween]": [2000, 2010] } } }
// IN - Value in list
{
where: {
status: {
"[in]": ["PRODUCTION", "PREPRODUCTION"]
}
}
}
// NOT IN - Value not in list
{
where: {
status: {
"[notIn]": ["DISCLAIMER", "CONCEPTION"]
}
}
}
// LIKE - Case-sensitive pattern (% = wildcard)
{ where: { name: { "[like]": "%Model%" } } }
// NOT LIKE
{ where: { name: { "[notLike]": "Admin%" } } }
// ILIKE - Case-insensitive pattern
{ where: { name: { "[iLike]": "%roadster%" } } }
// NOT ILIKE
{ where: { name: { "[notILike]": "test%" } } }
// STARTS WITH - Convenience for LIKE "value%"
{ where: { name: { "[startsWith]": "Model" } } }
// ENDS WITH - Convenience for LIKE "%value"
{ where: { name: { "[endsWith]": "S" } } }
// SUBSTRING - Convenience for LIKE "%value%"
{ where: { name: { "[substring]": "Air" } } }
// REGEXP - Regular expression
{ where: { sku: { "[regexp]": "^[A-Z]{3}-[0-9]+$" } } }
// NOT REGEXP
{ where: { sku: { "[notRegexp]": "test" } } }
// IREGEXP - Case-insensitive regex
{ where: { sku: { "[iRegexp]": "abc" } } }
// NOT IREGEXP
{ where: { sku: { "[notIRegexp]": "xyz" } } }
// Compare with another column
{
where: {
updatedAt: { "[col]": "createdAt" }
}
}
// OVERLAP - Arrays have common elements
{
where: {
tags: { "[overlap]": ["react", "node"] }
}
}
// CONTAINS - Array contains all specified elements
{
where: {
tags: { "[contains]": ["graphql"] }
}
}
// ANY - Value matches any array element
{
where: {
roles: { "[any]": ["admin", "editor"] }
}
}
// Select specific fields only
{
attributes: ['id', 'name', 'status']
}
// Exclude fields
{
attributes: {
exclude: ['deletedAt', 'createdAt']
}
}
// Load relations
{
include: [{ association: 'model' }, { association: 'units' }]
}
// In repositories, typically:
{
include: {
model: true,
units: true
}
}
// Single field ascending
{
order: [
{ createdAt: 'asc' }
]
}
// Single field descending
{
order: [
{ createdAt: 'desc' }
]
}
// Multiple fields
{
order: [
{ status: 'asc' },
{ year: 'desc' },
{ name: 'asc' }
]
}
// Limit results
{
limit: 25
}
// Skip results (for pagination)
{
offset: 0
}
// Combined (page 1, 25 per page)
{
offset: 0,
limit: 25
}
// Page 2
{
offset: 25,
limit: 25
}
{
group: ['status', 'year']
}
// Return only unique results
{
distinct: true
}
// Find active Tesla models from 2020 onwards
const queryStatement: QueryStatement = {
where: {
isActive: true,
year: { "[gte]": 2020 }
}
};
await this.repository.get({ queryStatement });
// Search production models, sorted by year, paginated
const queryStatement: QueryStatement = {
where: {
"[and]": [
{ status: { "[in]": ["PRODUCTION", "PREPRODUCTION"] } },
{ name: { "[iLike]": "%model%" } },
{ deletedAt: { "[is]": null } }
]
},
order: [
{ year: 'desc' },
{ name: 'asc' }
],
offset: 0,
limit: 10
};
await this.repository.get({ queryStatement });
// Get models with units, specific fields only
const queryStatement: QueryStatement = {
where: {
status: "PRODUCTION"
},
attributes: ['id', 'name', 'year', 'status'],
include: [{ association: 'units' }],
order: [
{ year: 'desc' }
]
};
await this.repository.get({ queryStatement });
// User query + System constraint
const queryStatement: QueryStatement = {
where: {
name: { "[startsWith]": "Model" }
}
};
const constraint: QueryStatement = {
where: {
isActive: true, // Force only active records
deletedAt: { "[is]": null } // Force soft-delete check
}
};
await this.repository.get({
queryStatement,
constraint // System applies this regardless of user input
});
# GraphQL Query
query GetModels($query: QueryStatement) {
teslaGetModels(query: $query) {
id
name
year
status
}
}
# Variables
{
"query": {
"where": {
"year": { "[gte]": 2020 }
},
"order": [
{ "year": "desc" }
],
"limit": 10
}
}
// REST POST /tesla/model/get
{
"query": {
"where": {
"year": { "[gte]": 2020 }
},
"order": [
{ "year": "desc" }
],
"limit": 10
}
}
const queryStatement: QueryStatement = {
where: {
deletedAt: { "[is]": null }
},
order: [
{ createdAt: 'desc' }
],
offset: (page - 1) * pageSize,
limit: pageSize
};
const queryStatement: QueryStatement = {
where: {
"[or]": [
{ name: { "[iLike]": `%${searchTerm}%` } },
{ sku: { "[iLike]": `%${searchTerm}%` } },
{ description: { "[iLike]": `%${searchTerm}%` } }
]
}
};
const queryStatement: QueryStatement = {
where: {
createdAt: {
"[gte]": startDate,
"[lte]": endDate
}
}
};
const queryStatement: QueryStatement = {
where: {
"[and]": [
{ isActive: true },
{ deletedAt: { "[is]": null } }
]
}
};
Need to filter data?
├─ Single condition → Use simple where: { field: value }
├─ Multiple AND conditions → Use implicit AND or "[and]"
├─ Multiple OR conditions → Use "[or]": [...]
├─ Range (min/max) → Use "[gte]" and "[lte]"
├─ List of values → Use "[in]": [...]
└─ Pattern matching → Use "[like]", "[iLike]", or "[startsWith]"
Need to sort?
└─ Use order: [{ field: 'asc'|'desc' }]
Need pagination?
└─ Use offset + limit
Need specific fields?
└─ Use attributes: [...]
Need relations?
└─ Use include: [...]
Need to ensure security?
└─ Use constraint parameter (separate from queryStatement)
"[gte]", "[startsWith]"constraint for system-enforced filters (security, soft-deletes)queryStatement for user-provided filters{ year: { "[gte]": 2020, "[lte]": 2024 } }[iLike] for case-insensitive searchesdeletedAt: { "[is]": null }gte: ❌ Use "[gte]": ✅"gte" ❌ Use "[gte]" ✅constraint (always set server-side)attributes[like] with user input without validation (SQL injection risk)@aurorajs.dev/core exports QueryStatementsrc/@api/mcp/mcp.server.ts for full operator referencesrc/@api/graphql.ts for QueryStatement interfacetest/acceptance/tesla/*.e2e-spec.ts for real usageaurora-project-structure - Understand where queries livetypescript - Type-safe QueryStatement constructionaurora-cli - Regenerate repositories after schema changes