Skip to main content
skill

neon-instagres — Claude Code skill for Postgres setup

This skill creates a Neon PostgreSQL database and writes connection settings to an environment file. Use it when a project needs a development database.

Install into Claude Code · claude-code-templates All methods and platforms ↓
npx claude-code-templates@latest --skill database/neon-instagres
Open on GitHub

What neon-instagres does

The skill checks .env for DATABASE_URL before creating anything. If it finds one, it asks whether to keep that database or make another. For a new database, it runs npx get-db --yes --ref 4eCjZDz and adds DATABASE_URL for app queries, DATABASE_URL_DIRECT for migrations, and PUBLIC_INSTAGRES_CLAIM_URL for claiming the database in Neon.

You can pass --seed schema.sql to load an initial schema or set another environment file with --env .env.local. The instructions cover Drizzle, Prisma, TypeORM, Kysely, and raw SQL. Databases expire after 72 hours unless claimed with npx get-db claim; running npx get-db requires Node.js 18 or newer. Keep PUBLIC_INSTAGRES_CLAIM_URL private because it grants access to the database.

What it helps with

  • create a PostgreSQL development database
  • write connection settings to an environment file
  • load an initial schema from a SQL file
  • configure a database for Drizzle or Prisma

Example prompts for the agent

  • Create a Neon PostgreSQL database for this project and save its connection settings in .env.
  • Set up a fresh database and load the schema from schema.sql.
  • Check .env first; if a database is already configured, ask whether to reuse it.

How to install neon-instagres

1claude-code-templates

npx claude-code-templates@latest --skill database/neon-instagres

2Skills CLI (Vercel)

npx skills add davila7/claude-code-templates --skill neon-instagres -a claude-code

3Manually: put the files in place

~/.claude/skills/neon-instagres/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/neon-instagres/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about neon-instagres

How do I install neon-instagres in Claude Code?

Run npx claude-code-templates@latest --skill database/neon-instagres.

What does neon-instagres do?

It provisions a PostgreSQL database on Neon and saves connection values in an environment file. It also provides setup guidance for several ORMs.

How can I keep the database from expiring after 72 hours?

Claim it with npx get-db claim, or open PUBLIC_INSTAGRES_CLAIM_URL from the environment file and sign in to Neon.

Similar skills

All skills for Data and databases →

From the same set495

The whole set →

Project sponsors

Companies that keep this analytics open
Gold sponsor

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor