skills.rest
davila7
davila7COMMUNITY
Explore all skills by this author →
Website𝕏@dani_avila7GitHub

neon-instagres

Provisions temporary Neon PostgreSQL databases and configures connection strings for ORM frameworks.

30.5k|3.5k|Updated Jul 4, 2025
Search Tags:#prisma#Drizzle#Postgres#database provisioning#env configuration#orm setup#NEON
One-click install
npx skills add https://github.com/davila7/claude-code-templates --skill neon-instagres
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: neon-instagres
Source: https://github.com/davila7/claude-code-templates/tree/main/cli-tool/components/skills/database/neon-instagres
Command: npx skills add https://github.com/davila7/claude-code-templates --skill neon-instagres

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Setting up a PostgreSQL database for development normally requires installing servers, configuring credentials, and managing connection strings. This Skill provisions a hosted Neon Postgres database in seconds and writes the connection variables directly into your project's environment file.

Core Features & Use Cases

  • Instant Provisioning: Runs npx get-db to create a Postgres database with pooled and direct connection URLs plus a 72-hour claim link.
  • Framework Integration: Supports Next.js, Vite, SvelteKit, Express, and Node.js with custom env file targets and seed scripts.
  • ORM Setup Guidance: Provides configuration for Drizzle, Prisma, and TypeORM, and can delegate complex schema, migration, or auth work to specialized Neon agents.
  • Use Case: You are starting a new Next.js app and need a development database. The Skill provisions the database, writes DATABASE_URL to .env.local, and gives you the Drizzle configuration to start querying immediately.

Quick Start

Ask the assistant to provision a new Neon Postgres database for your project and set up the connection in your env file.

Frequently Asked Questions about neon-instagres

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I provision a Postgres database for development quickly?▼

Run npx get-db --yes to create a Neon Postgres database in seconds. It writes DATABASE_URL for app queries and DATABASE_URL_DIRECT for migrations into your .env file, ready for Drizzle, Prisma, or raw SQL.

How do I set up a Neon database with Next.js?▼

Run npx get-db --env .env.local --yes to write the connection strings into .env.local, which Next.js loads automatically. Then configure your ORM, such as Drizzle or Prisma, to read process.env.DATABASE_URL.

Does the provisioned Neon database expire?▼

Yes, unclaimed databases expire after 72 hours. Run npx get-db claim or open the PUBLIC_INSTAGRES_CLAIM_URL in a browser and sign in to Neon to make the database permanent on the free tier.

What is the difference between DATABASE_URL and DATABASE_URL_DIRECT?▼

DATABASE_URL uses Neon's connection pooler and is intended for application queries. DATABASE_URL_DIRECT bypasses the pooler and should be used for migrations and administrative tasks that need a direct connection.

Why do I get connection refused when connecting to Neon?▼

Connection refused usually means you used the direct URL instead of the pooled DATABASE_URL, or SSL is not enforced. Switch to DATABASE_URL and append ?sslmode=require if your client does not enable SSL by default.

Related Skills

Explore More Software Engineering Skills→
neondatabaseneondatabase
86

neon-drizzle

Automate Neon database provisioning and Drizzle ORM setup with migrations.

Official
Intermediate
mgd34msumgd34msu
6

database-layer

Implement database layers with Prisma or Drizzle ORMs.

Community
Advanced
tonehqtonehq
11

provisioning-db

Provision Neon databases and configure Infisical secrets for deployment environments.

Official
Advanced
L3DigitalNetL3DigitalNet
6

immich

Administer Immich Docker containers, logs, updates, and troubleshooting.

Official
Advanced