Overview
The Neon template provides a complete Postgres infrastructure for Claude Code projects. It combines Neon's Instagres provisioning service with specialized AI agents, MCP integration, and monitoring tools.
Template Architecture
The template consists of 10 components organized into four layers:
1. Provisioning Layer
neon-instagres Skill — Auto-activating skill that provisions Postgres databases via npx get-db. Triggers on keywords like "database", "postgres", or "PostgreSQL".
npx get-db --yes --ref 4eCjZDzCreates three environment variables:
DATABASE_URL— Connection pooler endpointDATABASE_URL_DIRECT— Direct connection (required for migrations)PUBLIC_INSTAGRES_CLAIM_URL— Claim URL with 72-hour validity
using-neon Skill — Comprehensive guides for working with Neon Serverless Postgres. Includes 28 reference documents covering core guides, database drivers, auth, data API, platform API, and CLI.
2. Agent Layer
Five specialized agents handle different database operations:
neon-database-architect — Schema design with Drizzle ORM. Handles table relationships, indexes, constraints, and migration generation.
neon-auth-specialist — Authentication integration with Stack Auth. Multi-tenancy, RLS, and session management.
neon-migration-specialist — Zero-downtime deployments, rollback procedures, and data migration patterns.
neon-optimization-analyzer — Query performance analysis with EXPLAIN ANALYZE, index recommendations.
neon-expert — General consulting: branching workflows, compute autoscaling, Neon-specific features.
3. Integration Layer
neon MCP — Model Context Protocol integration providing programmatic access to Neon's management API.
4. Monitoring Layer
neon-database-dev — Development metrics statusline. neon-database-resources — Resource monitoring statusline.
Installation
Option 1: Skills Only
npx claude-code-templates@latest --skill database/neon-instagres,database/using-neonOption 2: Complete Template
npx claude-code-templates@latest \
--skill database/neon-instagres,database/using-neon \
--agent database/neon-expert,database/neon-database-architect,database/neon-auth-specialist,data-ai/neon-migration-specialist,data-ai/neon-optimization-analyzer \
--mcp database/neon \
--setting statusline/neon-database-dev,statusline/neon-database-resources \
--yesFramework Integration
- Next.js —
.env.local, server components and API routes - Vite —
.envwithVITE_prefix - Express — Standard
.envwith connection pooling - SvelteKit —
$env/static/privatepatterns - Remix —
.envfor server-side loaders
ORM support: Drizzle, Prisma, TypeORM, Kysely, and raw SQL via node-postgres.
Additional Resources
Stack Builder
0Your stack is empty
Click + on components to add them