Agent skill
neon-postgres
Neon serverless Postgres for Next.js/TypeScript applications. Covers core architecture (branches, compute endpoints, autoscaling, scale-to-zero), the @neondatabase/serverless driver (HTTP + WebSocket), Prisma ORM integration, neonctl CLI, Neon REST/Management API, MCP Server, connection pooling (PgBouncer), database branching workflows, migrations with Prisma Migrate, environment variable patterns, and pricing/limits. Use this skill whenever working with Neon Postgres, @neondatabase/serverless, neonctl, Neon branches, Neon connection pooling, serverless Postgres edge functions, Prisma with Neon, Neon MCP server, DATABASE_URL with -pooler, scale-to-zero Postgres, or any code importing from '@neondatabase/serverless'. Also triggers on: Neon project setup, Neon branching for preview environments, Neon schema diff, neon connection string, serverless database driver, CU-hours, Neon free tier, or Vercel + Neon integration.
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/other/other/neon-postgres-joaquincampo-skills
SKILL.md
Neon Serverless Postgres - Complete Reference
This skill provides everything needed to work with Neon serverless Postgres in Next.js/TypeScript applications, with Prisma as the ORM layer.
Quick Reference: Project Setup Checklist
# 1. Install dependencies (Prisma already in project)
npm install @prisma/client
npm install -D prisma
# 2. Set up environment variables (.env)
DATABASE_URL="postgresql://user:[email protected]/dbname?sslmode=require"
DIRECT_URL="postgresql://user:[email protected]/dbname?sslmode=require"
# 3. Configure prisma/schema.prisma with dual URLs (see references/prisma-integration.md)
# 4. Generate and run migrations
npx prisma migrate dev --name init
npx prisma generate
# 5. (Optional) Set up MCP server for AI-assisted DB management
npx neonctl init
Rule: Use DATABASE_URL (pooled, has -pooler in hostname) for app queries. Use DIRECT_URL (direct, no -pooler) for migrations.
For detailed information on each topic, see the reference files in the references/ directory.
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?