์Šคํ‚ฌ neon-postgres
๐Ÿ“ฆ

neon-postgres

์•ˆ์ „

Implement Neon Postgres Database Patterns

๋˜ํ•œ ๋‹ค์Œ์—์„œ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค: Asmayaseen

Developers struggle with serverless database connection management and ORM configuration. This skill provides proven patterns for Neon Postgres with Prisma and Drizzle integration.

์ง€์›: Claude Codex Code(CC)
๐Ÿฅ‰ 74 ๋ธŒ๋ก ์ฆˆ
1

์Šคํ‚ฌ ZIP ๋‹ค์šด๋กœ๋“œ

2

Claude์—์„œ ์—…๋กœ๋“œ

์„ค์ • โ†’ ๊ธฐ๋Šฅ โ†’ ์Šคํ‚ฌ โ†’ ์Šคํ‚ฌ ์—…๋กœ๋“œ๋กœ ์ด๋™

3

ํ† ๊ธ€์„ ์ผœ๊ณ  ์‚ฌ์šฉ ์‹œ์ž‘

ํ…Œ์ŠคํŠธํ•ด ๋ณด๊ธฐ

"neon-postgres" ์‚ฌ์šฉ ์ค‘์ž…๋‹ˆ๋‹ค. Configure Prisma for Neon Postgres

์˜ˆ์ƒ ๊ฒฐ๊ณผ:

Prisma datasource configured with dual connection strings: DATABASE_URL for pooled runtime connections (PgBouncer) and DIRECT_URL for direct migration operations. Schema includes proper provider and url settings.

"neon-postgres" ์‚ฌ์šฉ ์ค‘์ž…๋‹ˆ๋‹ค. Set up Drizzle with Neon serverless driver

์˜ˆ์ƒ ๊ฒฐ๊ณผ:

Drizzle instance initialized with neon-serverless driver, enabling WebSocket-based sessions for transactions. HTTP driver available for simple queries in edge environments.

๋ณด์•ˆ ๊ฐ์‚ฌ

์•ˆ์ „
v1 โ€ข 2/24/2026

Static analysis flagged 4 patterns that are all false positives. The skill contains documentation-only content with no executable code. Environment variable references are configuration examples, not actual env access. Cryptographic algorithm warnings are pattern-matching errors on unrelated text.

1
์Šค์บ”๋œ ํŒŒ์ผ
61
๋ถ„์„๋œ ์ค„ ์ˆ˜
0
๋ฐœ๊ฒฌ ์‚ฌํ•ญ
1
์ด ๊ฐ์‚ฌ ์ˆ˜
๋ณด์•ˆ ๋ฌธ์ œ๋ฅผ ์ฐพ์ง€ ๋ชปํ–ˆ์Šต๋‹ˆ๋‹ค
๊ฐ์‚ฌ์ž: claude

ํ’ˆ์งˆ ์ ์ˆ˜

38
์•„ํ‚คํ…์ฒ˜
100
์œ ์ง€๋ณด์ˆ˜์„ฑ
87
์ฝ˜ํ…์ธ 
50
์ปค๋ฎค๋‹ˆํ‹ฐ
100
๋ณด์•ˆ
91
์‚ฌ์–‘ ์ค€์ˆ˜

๋งŒ๋“ค ์ˆ˜ ์žˆ๋Š” ๊ฒƒ

Full-Stack Developer Setting Up New Project

Configure database connections for a new Next.js project using Prisma with Neon Postgres, including proper separation of pooled and direct connections.

Edge Application Database Integration

Implement Drizzle ORM with Neon serverless driver for edge runtime compatibility in serverless functions.

Database Migration Workflow

Set up safe migration workflows using direct connections while maintaining pooled connections for application runtime.

์ด ํ”„๋กฌํ”„ํŠธ๋ฅผ ์‚ฌ์šฉํ•ด ๋ณด์„ธ์š”

Basic Neon Setup 
Help me configure a Neon Postgres connection string for my application. I need to understand the difference between pooled and direct connections.
Prisma Schema Configuration 
Generate a Prisma schema configuration for Neon Postgres with proper datasource setup for both DATABASE_URL and DIRECT_URL environment variables.
Drizzle Serverless Driver Setup 
Show me how to configure Drizzle ORM with the Neon serverless driver for use in Vercel Edge Functions, including transaction support.
Connection Pooling Optimization 
Analyze my application connection patterns and recommend optimal PgBouncer pooling settings for Neon Postgres given my expected concurrent user load.

๋ชจ๋ฒ” ์‚ฌ๋ก€

  • Always use pooled connections for application runtime and direct connections for migrations
  • Reserve 7 connections for Neon superuser operations when calculating pool limits
  • Use database branching for isolated development and testing environments

ํ”ผํ•˜๊ธฐ

  • Using direct connection strings for application runtime connections
  • Exceeding connection pool limits without proper error handling
  • Running migrations against pooled connections instead of direct connections

์ž์ฃผ ๋ฌป๋Š” ์งˆ๋ฌธ

What is the difference between pooled and direct connections in Neon?
Pooled connections use PgBouncer for efficient connection reuse (up to 10K connections). Direct connections bypass the pooler and are required for DDL operations like migrations.
How many connections can Neon handle?
Neon supports up to 10,000 concurrent connections to the pooler, with 7 connections reserved for the Neon superuser. Actual Postgres connections depend on your compute size.
Can I use Neon with serverless edge functions?
Yes. Use Drizzle ORM with the neon-http driver for HTTP-based queries or neon-serverless driver for WebSocket transactions in edge environments.
What is database branching in Neon?
Database branching creates instant copies of your database for isolated development, testing, or preview environments without duplicating storage.
Do I need both Prisma and Drizzle?
No. Choose one ORM based on your needs. Prisma offers a full-featured ORM with migrations. Drizzle provides lighter weight with better serverless support.
How do I handle connection errors in serverless environments?
Implement retry logic with exponential backoff. Use connection pooling to reduce connection overhead. Consider the neon-http driver for stateless query patterns.

๊ฐœ๋ฐœ์ž ์„ธ๋ถ€ ์ •๋ณด

์ž‘์„ฑ์ž

sickn33

๋ผ์ด์„ ์Šค

MIT

๋ฆฌํฌ์ง€ํ† ๋ฆฌ

https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/neon-postgres

์ฐธ์กฐ

main

ํŒŒ์ผ ๊ตฌ์กฐ

๐Ÿ“„ SKILL.md