secondsky/claude-skills / plugins/nuxt-content/skills/nuxt-content
nuxt-content
VerifiedNuxt Content v3 Git-based CMS for Markdown/MDC content sites. Use for blogs, docs, content-driven apps with type-safe queries, schema validation (Zod/Valibot), full-text search, navigation utilities. Supports Nuxt Studio production editing, Cloudflare D1/Pages deployment, Vercel deployment, SQL storage, MDC components, content collections.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 16.7 KB |
| assets/blog-collection.example.ts | script | 3.7 KB |
| assets/content.config.example.ts | script | 1.8 KB |
| assets/docs-collection.example.ts | script | 5.9 KB |
| assets/nuxt.config.example.ts | script | 1.9 KB |
| references/collection-examples.md | markdown | 6.6 KB |
| references/deployment-checklists.md | markdown | 4.8 KB |
| references/error-catalog.md | markdown | 9.9 KB |
| references/mdc-syntax-reference.md | markdown | 2.0 KB |
| references/query-operators.md | markdown | 2.9 KB |
| references/studio-setup-guide.md | markdown | 4.1 KB |
| scripts/deploy-cloudflare.shexecutable | script | 2.7 KB |
| scripts/deploy-vercel.shexecutable | script | 1.9 KB |
| scripts/setup-nuxt-content.shexecutable | script | 5.2 KB |
| scripts/setup-studio.shexecutable | script | 3.8 KB |
| templates/blog-collection-setup.ts | script | 7.1 KB |
references/query-operators.md
View on GitHub# Query Operators Quick Reference
## SQL Operators
### Equality & Comparison
```ts
// Equal to
.where('published', '=', true)
// Not equal
.where('status', '<>', 'draft')
// Greater than / Less than
.where('date', '>', '2024-01-01')
.where('price', '<', 1000)
// Greater/Less than or equal
.where('views', '>=', 100)
.where('score', '<=', 50)
```
### List Membership
```ts
// IN operator
.where('category', 'IN', ['news', 'tutorial'])
// NOT IN
.where('status', 'NOT IN', ['draft', 'archived'])
```
### Range
```ts
// BETWEEN
.where('date', 'BETWEEN', ['2024-01-01', '2024-12-31'])
// NOT BETWEEN
.where('price', 'NOT BETWEEN', [100, 500])
```
### Null Checks
```ts
// IS NULL
.where('deletedAt', 'IS NULL')
// IS NOT NULL
.where('publishedAt', 'IS NOT NULL')
```
### Pattern Matching
```ts
// LIKE (with % wildcard)
.where('title', 'LIKE', '%Nuxt%')
.where('email', 'LIKE', '%@gmail.com')
// NOT LIKE
.where('title', 'NOT LIKE', '%draft%')
```
---
## Combining Conditions
### AND Conditions (Default)
```ts
queryCollection('blog')
.where('published', '=', true)
.where('category', '=', 'tutorial')
.where('date', '>', '2024-01-01')
.all()
```
### Grouped AND
```ts
queryCollection('blog')
.andWhere(q =>
q.where('date', '>', '2024-01-01')
.where('category', '=', 'news')
)
.all()
```
### OR Conditions
```ts
queryCollection('blog')
.orWhere(q =>
q.where('featured', '=', true)
.where('priority', '>', 5)
)
.all()
```
### Complex Conditions
```ts
queryCollection('blog')
.where('published', '=', true)
.andWhere(q =>
q.where('category', '=', 'news')
.orWhere(sub =>
sub.where('featured', '=', true)
)
)
.all()
```
---
## Ordering
```ts
// Single field
.order('date', 'DESC')
.order('title', 'ASC')
// Multiple fields
.order('category', 'ASC')
.order('date', 'DESC')
```
---
## Pagination
```ts
// Limit
.limit(10)
// Skip and limit
.skip(5)
.limit(10)
// Page-based
const page = 2
const perPage = 10
.skip((page - 1) * perPage)
.limit(perPage)
```
---
## Field Selection
```ts
// Select specific fields
.select('path', 'title', 'description', 'date')
// Benefits: Smaller payload, faster queries
```
---
## Counting
```ts
const count = await queryCollection('blog')
.where('published', '=', true)
.count()
```
---
## Server-Side Queries
```ts
// Pass event as first argument
export default eventHandler(async (event) => {
const posts = await queryCollection(event, 'blog').all()
return posts
})
```
---
## Complete Query Example
```ts
// Get latest 10 published tutorials from 2024,
// ordered by date, with specific fields only
const tutorials = await queryCollection('blog')
.where('published', '=', true)
.where('category', '=', 'tutorial')
.where('date', '>=', '2024-01-01')
.select('path', 'title', 'description', 'date', 'author')
.order('date', 'DESC')
.limit(10)
.all()
```
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deployment | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| xlsxanthropics/skillsUse this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| shipping-and-launchaddyosmani/agent-skillsPrepares production launches. Use when preparing to deploy to production, or when asking what needs to be in place before shipping. Use when you need a pre-launch checklist, when setting up monitoring, when planning a staged rollout, or when you need a rollback strategy. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| childhoodthedotmack/claude-memBabysit a shipped release after merge, publication, or deployment. Verify published packages, production behavior, installed plugins, and late CI or user reports until the observation window is clean; use babysit for PR readiness before release. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |