Neon Instagres

What it does

When your agent uses it

• Setting up databases
• Users mention PostgreSQL/Postgres
• Need a development database

Example prompts

• “/neon-instagres”

Requirements

• Node.js
• Pre-approved tools (allowed-tools): Read, Write, Bash, Grep, Glob

Workflow steps

3 steps, taken from the step headings in SKILL.md.

1. 1Check Existing Database
2. 2Provision Database
3. 3Confirm Success

What it can do on your machine

Read from SKILL.md and the folder at commit c0ca7da. It shows what the files ask for, not the result of running them.

• Tool permissions

  Pre-approves these tools, so the agent can use them without asking each time:

  • Read
  • Write
  • Bash
  • Grep
  • Glob

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  Shell commands in SKILL.md call:

  • npx
  • npm

  From the folder's file list and the shell code blocks in SKILL.md.

• Network

  Links to these hosts (documentation or services it may open):

  • neon.tech
  • console.neon.tech
  • get.neon.com

  From URLs in SKILL.md, links to its own repository left out.

• Credentials

  Names no API keys, tokens, secrets or passwords.

  From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Neon Instagres loads about 1.6k tokens when it runs. Until then it costs about 62 tokens; SKILL.md has 372 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it

~62

When it runs · the whole SKILL.md, loaded when a task matches

~1.6k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

• NoteMentions a .env fileSKILL.md:27

  cat .env 2>/dev/null | grep DATABASE_URL

• NoteMentions a .env fileSKILL.md:40

  - `--env .env.local` - Custom env file (Next.js, Remix)

• NoteMentions a .env fileSKILL.md:50

  📁 Connection details in .env:

• NoteMentions a .env fileSKILL.md:122

  npx get-db --env .env.local --yes --ref 4eCjZDz

• NoteMentions a .env fileSKILL.md:227

  . Copy `PUBLIC_INSTAGRES_CLAIM_URL` from .env

• NoteMentions a .env fileSKILL.md:245

  - Never commit `.env` to git

• NoteMentions a .env fileSKILL.md:246

  - Add `.env` to `.gitignore`

• NoteMentions a .env fileSKILL.md:277

  TABASE_URL contains credentials** - keep .env private

• NotePre-approves every shell command (allowed-tools: Bash)SKILL.md

  allowed-tools: Read, Write, Bash, Grep, Glob

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from davila7/claude-code-templates at commit c0ca7da, republished under its MIT licence (© davila7). 372 words, ~1,600 tokens.

name

neon-instagres

description

Instantly provision production-ready Postgres databases with Neon Instagres. Use when setting up databases, when users mention PostgreSQL/Postgres, database setup, or need a development database. Works with Drizzle, Prisma, raw SQL.

allowed-tools

Read, Write, Bash, Grep, Glob

user-invocable

true

npx get-db --yes --ref 4eCjZDz

cat .env 2>/dev/null | grep DATABASE_URL

npx get-db --yes --ref 4eCjZDz

✅ Neon Postgres database provisioned!

📁 Connection details in .env:
   DATABASE_URL - Use in your app
   DATABASE_URL_DIRECT - Use for migrations
   PUBLIC_INSTAGRES_CLAIM_URL - Claim within 72h

⚡ Ready for: Drizzle, Prisma, TypeORM, Kysely, raw SQL

⏰ IMPORTANT: Database expires in 72 hours.
   To claim: npx get-db claim

⚠️  SECURITY: PUBLIC_INSTAGRES_CLAIM_URL grants database access.
   Do not share this URL publicly.

Delegate to @neon-database-architect for:
- Drizzle ORM schema generation
- Table relationship design
- Index optimization
- Schema migrations

Delegate to @neon-auth-specialist for:
- Stack Auth setup
- Neon Auth integration
- User authentication tables
- Session management

Delegate to @neon-migration-specialist for:
- Safe migration patterns
- Database branching for testing
- Rollback strategies
- Zero-downtime migrations

Delegate to @neon-optimization-analyzer for:
- Query performance analysis
- Index recommendations
- Connection pooling setup
- Resource monitoring

Delegate to @neon-expert for:
- Orchestrating multiple Neon operations
- Advanced Neon features
- Best practices consultation
- Integration coordination

npx get-db --env .env.local --yes --ref 4eCjZDz

npx get-db --yes --ref 4eCjZDz

// vite.config.ts
import { postgres } from 'vite-plugin-db';

export default defineConfig({
  plugins: [postgres()]
});

npx get-db --yes --ref 4eCjZDz

npm install dotenv postgres

import 'dotenv/config';
import postgres from 'postgres';
const sql = postgres(process.env.DATABASE_URL);

// drizzle.config.ts
import { defineConfig } from 'drizzle-kit';

export default defineConfig({
  schema: './src/db/schema.ts',
  out: './drizzle',
  dialect: 'postgresql',
  dbCredentials: { url: process.env.DATABASE_URL! }
});

// src/db/index.ts
import { drizzle } from 'drizzle-orm/postgres-js';
import postgres from 'postgres';

const client = postgres(process.env.DATABASE_URL!);
export const db = drizzle(client);

npx prisma init
# DATABASE_URL already set by get-db
npx prisma db push

import { DataSource } from 'typeorm';

export const AppDataSource = new DataSource({
  type: 'postgres',
  url: process.env.DATABASE_URL,
  entities: ['src/entity/*.ts'],
  synchronize: true
});

npx get-db --seed ./schema.sql --yes --ref 4eCjZDz

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  email VARCHAR(255) UNIQUE NOT NULL,
  created_at TIMESTAMP DEFAULT NOW()
);

INSERT INTO users (email) VALUES ('demo@example.com');

npx get-db claim

© davila7, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in cli-tool/components/skills/database/neon-instagres of davila7/claude-code-templates.

Open the folder on GitHubat commit c0ca7da