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.
npx claude-code-templates@latest --skill database/neon-instagresWhat 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
.envfirst; 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-instagres2Skills CLI (Vercel)
npx skills add davila7/claude-code-templates --skill neon-instagres -a claude-code3Manually: put the files in place
~/.claude/skills/neon-instagres/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/neon-instagres/
Manually: put the files in place
.agents/skills/neon-instagres/SKILL.mdFor all projects use ~/.agents/skills/
Manually: put the files in place
.cursor/skills/neon-instagres/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install davila7/claude-code-templates neon-instagres2Manually: put the files in place
.github/skills/neon-instagres/SKILL.mdPlatform CLI
gemini skills install https://github.com/davila7/claude-code-templates --path cli-tool/components/skills/database/neon-instagresManually: put the files in place
.devin/skills/neon-instagres/SKILL.mdThe legacy .windsurf/skills/ path still works
Claude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
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.