Back to Components
Neon

Neon

Database Infrastructure
Try Neon Free
Overview Website

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 4eCjZDz

Creates three environment variables:

  • DATABASE_URL — Connection pooler endpoint
  • DATABASE_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-neon

Option 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 \ --yes

Framework Integration

  • Next.js — .env.local, server components and API routes
  • Vite — .env with VITE_ prefix
  • Express — Standard .env with connection pooling
  • SvelteKit — $env/static/private patterns
  • Remix — .env for server-side loaders

ORM support: Drizzle, Prisma, TypeORM, Kysely, and raw SQL via node-postgres.

Additional Resources

Stack Builder

0

Your stack is empty

Click + on components to add them