kysely-postgres
Write effective, type-safe Kysely queries for PostgreSQL. This skill should be used when working in Node.js/TypeScript backends with Kysely installed, covering query patterns, migrations, type generation, and common pitfalls to avoid.
SKILL.md
| Name | kysely-postgres |
| Description | Write effective, type-safe Kysely queries for PostgreSQL. This skill should be used when working in Node.js/TypeScript backends with Kysely installed, covering query patterns, migrations, type generation, and common pitfalls to avoid. |
Claude Skills
A collection of Claude Code skills.
Installation
First, add the marketplace:
/plugin marketplace add gallop-systems/claude-skills
Then install the skills you want:
/plugin install kysely-postgres@gallop-systems-claude-skills
/plugin install nuxt-nitro-api@gallop-systems-claude-skills
/plugin install nitro-testing@gallop-systems-claude-skills
/plugin install linear@gallop-systems-claude-skills
/plugin install setup-permissions@gallop-systems-claude-skills
Updating
Update a specific skill to the latest version:
/plugin update kysely-postgres@gallop-systems-claude-skills
Auto-updates: Third-party marketplaces don't auto-update by default. To enable:
- Run
/pluginand select Marketplaces - Choose
gallop-systems-claude-skills - Select Enable auto-update
Available Skills
kysely-postgres
Type-safe Kysely query patterns for PostgreSQL. Automatically activates when working in Node.js/TypeScript projects with Kysely.
Covers:
- Query patterns (SELECT, JOIN, WHERE, aggregations)
- Migrations and recommended column types
- JSON/JSONB and array handling
- String concatenation
- Common pitfalls to avoid
nuxt-nitro-api
Nuxt 3 / Nitro API patterns for building type-safe full-stack applications. Automatically activates when working in Nuxt 3 projects.
Covers:
- Zod validation with h3 (Standard Schema support)
- useFetch vs $fetch vs useAsyncData
- Type inference (don't add manual types!)
- nuxt-auth-utils (OAuth, WebAuthn, middleware)
- Page structure (keep pages thin)
- Composables vs utils
- SSR + localStorage patterns
- Deep linking (URL params sync)
- Nitro tasks and job queues
- Server-Sent Events (SSE)
- Third-party service integrations
nitro-testing
Test Nitro API handlers with real PostgreSQL using transaction rollback isolation. Each test runs in a transaction that auto-rolls back for complete isolation without cleanup overhead.
Covers:
- Transaction rollback pattern (fast, isolated, real SQL)
- Vitest custom fixtures (
factories,db) - Mock event helpers (
mockGet,mockPost,mockPatch,mockDelete) - Factory pattern for test data creation
- Global stubs for Nuxt auto-imports
- Async/automation testing utilities
- CI/CD setup with GitHub Actions and PostgreSQL
Adding New Skills
- Create a new plugin directory:
plugins/my-skill/ - Add
plugins/my-skill/.claude-plugin/plugin.json:{ "name": "my-skill", "description": "Short description", "version": "1.0.0", "author": { "name": "yeedle" } } - Add
plugins/my-skill/skills/my-skill/SKILL.mdwith frontmatter:--- name: my-skill description: When to use this skill... --- # Skill content here - Add any reference files alongside
SKILL.md - Register the plugin in
.claude-plugin/marketplace.json - Commit and push