Agent Skill
2/7/2026

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.

G
gallop
0GitHub Stars
1Views
npx skills add gallop-systems/claude-skills

SKILL.md

Namekysely-postgres
DescriptionWrite 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:

  1. Run /plugin and select Marketplaces
  2. Choose gallop-systems-claude-skills
  3. 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

  1. Create a new plugin directory: plugins/my-skill/
  2. Add plugins/my-skill/.claude-plugin/plugin.json:
    {
      "name": "my-skill",
      "description": "Short description",
      "version": "1.0.0",
      "author": { "name": "yeedle" }
    }
    
  3. Add plugins/my-skill/skills/my-skill/SKILL.md with frontmatter:
    ---
    name: my-skill
    description: When to use this skill...
    ---
    
    # Skill content here
    
  4. Add any reference files alongside SKILL.md
  5. Register the plugin in .claude-plugin/marketplace.json
  6. Commit and push
Skills Info
Original Name:kysely-postgresAuthor:gallop