AgentSkillsCN

neon-drizzle

使用预置的Neon数据库，快速搭建功能完备的Drizzle ORM环境。安装依赖项、配置数据库凭据、设定连接参数、生成Schema并执行迁移操作。最终产出可立即连接并查询数据库的可用代码。当您需要使用Drizzle创建新项目、为现有应用添加ORM，或对数据库Schema进行调整时，可使用此技能。

SKILL.md
--- frontmatter
name: neon-drizzle
description: Creates a fully functional Drizzle ORM setup with a provisioned Neon database. Installs dependencies, provisions database credentials, configures connections, generates schemas, and runs migrations. Results in working code that can immediately connect to and query the database. Use when creating new projects with Drizzle, adding ORM to existing applications, or modifying database schemas.
allowed-tools: ["bash", "write", "read_file"]

Neon Drizzle Integration

Comprehensive Drizzle ORM setup for Neon databases with guided workflows.

When to Use This Skill

  • •Setting up Drizzle in a new project (Next.js, Vite, Express, etc.)
  • •Integrating Drizzle into an existing application
  • •Creating or modifying database schemas
  • •Troubleshooting migration issues

Code Generation Rules

When generating TypeScript/JavaScript code:

  • •BEFORE generating import statements, check tsconfig.json for path aliases (compilerOptions.paths)
  • •If path aliases exist (e.g., "@/": ["./src/"]), use them (e.g., import { x } from '@/lib/utils')
  • •If NO path aliases exist or unsure, ALWAYS use relative imports (e.g., import { x } from '../../../lib/utils')
  • •Verify imports match the project's configuration
  • •Default to relative imports - they always work regardless of configuration

Available Guides

Each guide is a complete, self-contained walkthrough with numbered phases:

  • •guides/new-project.md - Full setup from scratch (see: Table of Contents)
  • •guides/existing-project.md - Add Drizzle to running apps (see: Table of Contents)
  • •guides/schema-only.md - Schema creation and modification (see: Table of Contents)
  • •guides/troubleshooting.md - Debug common issues (organized by error type)

I'll automatically detect your context (package manager, framework, deployment target) and select the appropriate guide based on your request.

Quick Examples

Tell me what you're building - I'll handle the rest:

  • •"Setup Drizzle for my Next.js blog on Vercel" → Auto-detects Vercel + Next.js → HTTP adapter
  • •"Add Drizzle to my Express API" → Auto-detects Node.js server → WebSocket adapter
  • •"Create a users table with auth fields" → Loads schema guide → Generates schema

Reference Documentation

For deeper technical details (loaded on-demand):

  • •references/adapters.md - HTTP vs WebSocket decision guide
  • •references/migrations.md - Migration patterns and troubleshooting
  • •references/query-patterns.md - Example queries and best practices

Templates & Scripts

  • •templates/schema-example.ts - Multi-table schema with relations
  • •templates/drizzle-config.ts - Configuration examples
  • •scripts/generate-schema.ts - Automated migration generation
  • •scripts/run-migration.ts - Programmatic migration runner

Related Skills

  • •neon-auth - Add authentication
  • •neon-js - Full SDK with auth + PostgREST-style data API
  • •neon-serverless - Connection setup without ORM
  • •neon-toolkit - Ephemeral databases for testing
  • •add-neon-docs - Add Neon best practices to your project (run after setup)

Workflow

I will:

  1. •Detect your project context automatically
  2. •Select and load the appropriate guide
  3. •Follow the guide's phases sequentially
  4. •Track progress using the guide's workflow checklist
  5. •Load reference files only when needed
  6. •Offer to add Neon best practices to your project docs

Ready to get started? Just describe what you're building!