███╗   ██╗███████╗ ██████╗ ███╗   ██╗
████╗  ██║██╔════╝██╔═══██╗████╗  ██║
██╔██╗ ██║█████╗  ██║   ██║██╔██╗ ██║
██║╚██╗██║██╔══╝  ██║   ██║██║╚██╗██║
██║ ╚████║███████╗╚██████╔╝██║ ╚████║
╚═╝  ╚═══╝╚══════╝ ╚═════╝ ╚═╝  ╚═══╝

# Add via Claude Code CLI (HTTP + OAuth)
claude mcp add --transport http neon https://mcp.neon.tech/mcp

{
  "mcpServers": {
    "neon": {
      "type": "http",
      "url": "https://mcp.neon.tech/mcp"
    }
  }
}

{
  "mcpServers": {
    "neon": {
      "command": "npx",
      "args": [
        "-y", "mcp-remote@latest", "https://mcp.neon.tech/mcp",
        "--header", "Authorization:${NEON_AUTH_HEADER}"
      ],
      "env": { "NEON_AUTH_HEADER": "Bearer ${NEON_API_KEY}" }
    }
  }
}

npm i -g neon      # CLI is invoked as `neon`; `neonctl` is a published alias (same binary)

neonctl auth       # OAuth browser login
# Or use API key (CI/scripts):
export NEON_API_KEY=...

# Projects
neonctl projects list
neonctl projects create --name my-project
neonctl projects delete PROJECT_ID

# Branches
neonctl branches list --project-id PROJECT_ID
neonctl branches create --project-id PROJECT_ID --name feature/auth
neonctl branches delete BRANCH_ID --project-id PROJECT_ID
neonctl branches reset BRANCH_ID --project-id PROJECT_ID --parent

# Connection string
neonctl connection-string --project-id PROJECT_ID --branch main
neonctl connection-string --project-id PROJECT_ID --branch feature/auth

# SQL execution
neonctl sql --project-id PROJECT_ID --query "SELECT version();"
neonctl sql --project-id PROJECT_ID --file schema.sql

# Via MCP tool: get_connection_string
# Or via CLI:
neonctl connection-string --project-id PROJECT_ID --branch main

postgresql://user:password@ep-cool-name-123456.us-east-2.aws.neon.tech/neondb?sslmode=require

npm install prisma @prisma/client

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
  // Use a separate direct URL for migrations (no connection pooling)
  directUrl = env("DIRECT_URL")
}

generator client {
  provider = "prisma-client-js"
}

npx prisma migrate dev --name add-users
npx prisma generate

npm install drizzle-orm pg drizzle-kit

import { drizzle } from "drizzle-orm/node-postgres";
import { Pool } from "pg";

const pool = new Pool({ connectionString: process.env.DATABASE_URL });
const db = drizzle(pool);

// Query
const users = await db.select().from(usersTable).limit(10);

-- 1. Enable pgvector
CREATE EXTENSION IF NOT EXISTS vector;

-- 2. Table with a vector column.
--    Dimension must match your embedding model:
--    OpenAI text-embedding-3-small = 1536, Cohere embed-v3 = 1024, etc.
CREATE TABLE items (
  id        BIGSERIAL PRIMARY KEY,
  content   TEXT,
  embedding VECTOR(1536)
);

-- 3. HNSW index. Pick the operator class that matches your distance metric:
--    vector_cosine_ops (cosine), vector_l2_ops (L2), vector_ip_ops (inner product).
--    Cosine is the usual choice for normalized OpenAI/Cohere embeddings.
CREATE INDEX ON items
  USING hnsw (embedding vector_cosine_ops)
  WITH (m = 16, ef_construction = 64);

SELECT id, content
FROM items
ORDER BY embedding <=> '[0.012, -0.034, 0.567, ...]'   -- your query embedding
LIMIT 5;

import { drizzle } from "drizzle-orm/node-postgres";
import { sql } from "drizzle-orm";
import { Pool } from "pg";

const pool = new Pool({ connectionString: process.env.DATABASE_URL });
const db = drizzle(pool);

// queryEmbedding is a number[] from your embeddings provider (e.g. 1536-dim).
async function searchSimilar(queryEmbedding: number[], k = 5) {
  // pgvector accepts the array as a bracketed string literal: '[0.1,0.2,...]'
  const literal = `[${queryEmbedding.join(",")}]`;
  const rows = await db.execute(sql`
    SELECT id, content
    FROM items
    ORDER BY embedding <=> ${literal}
    LIMIT ${k}
  `);
  return rows.rows;
}

# Connection strings (from Neon dashboard or neonctl connection-string)
DATABASE_URL=postgresql://user:pass@ep-....neon.tech/neondb?sslmode=require
DIRECT_URL=postgresql://user:pass@ep-....neon.tech/neondb?sslmode=require

# API key (for CLI and npm MCP package)
NEON_API_KEY=...

# Project and branch (optional, for scripting)
NEON_PROJECT_ID=...
NEON_BRANCH_NAME=main

Create a Neon database branch for feature $ARGUMENTS.

1. Use the Neon MCP tool `create_branch` to create a branch named "feature/$ARGUMENTS"
2. Use `get_connection_string` to get the connection string for this branch
3. Update the `.env.local` file's DATABASE_URL to point to the new branch
4. Report the branch ID, connection string, and confirm `.env.local` was updated

# .github/workflows/neon-preview.yml
name: Neon Preview Branch
on:
  pull_request:
    types: [opened, synchronize]

jobs:
  create-branch:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4
      - name: Create Neon branch
        uses: neondatabase/create-branch-action@v6
        id: create-branch
        with:
          project_id: ${{ secrets.NEON_PROJECT_ID }}
          api_key: ${{ secrets.NEON_API_KEY }}
          branch_name: preview/pr-${{ github.event.pull_request.number }}
      - name: Comment branch URL
        uses: actions/github-script@v7
        with:
          script: |
            github.rest.issues.createComment({
              issue_number: context.issue.number,
              owner: context.repo.owner,
              repo: context.repo.repo,
              body: `DB branch id: \`${{ steps.create-branch.outputs.branch_id }}\`\nConnection: \`${{ steps.create-branch.outputs.db_url_pooled }}\``
            })