Agent skill
neon-postgres
Neon serverless Postgres for Next.js/TypeScript applications. Covers core architecture (branches, compute endpoints, autoscaling, scale-to-zero), the @neondatabase/serverless driver (HTTP + WebSocket), Prisma ORM integration, neonctl CLI, Neon REST/Management API, MCP Server, connection pooling (PgBouncer), database branching workflows, migrations with Prisma Migrate, environment variable patterns, and pricing/limits. Use this skill whenever working with Neon Postgres, @neondatabase/serverless, neonctl, Neon branches, Neon connection pooling, serverless Postgres edge functions, Prisma with Neon, Neon MCP server, DATABASE_URL with -pooler, scale-to-zero Postgres, or any code importing from '@neondatabase/serverless'. Also triggers on: Neon project setup, Neon branching for preview environments, Neon schema diff, neon connection string, serverless database driver, CU-hours, Neon free tier, or Vercel + Neon integration.
Install this agent skill to your Project
npx add-skill https://github.com/JoaquinCampo/Skills/tree/main/neon-postgres
SKILL.md
Neon Serverless Postgres - Complete Reference
This skill provides everything needed to work with Neon serverless Postgres in Next.js/TypeScript applications, with Prisma as the ORM layer.
Quick Reference: Project Setup Checklist
# 1. Install dependencies (Prisma already in project)
npm install @prisma/client
npm install -D prisma
# 2. Set up environment variables (.env)
DATABASE_URL="postgresql://user:pass@ep-xyz-pooler.region.aws.neon.tech/dbname?sslmode=require"
DIRECT_URL="postgresql://user:pass@ep-xyz.region.aws.neon.tech/dbname?sslmode=require"
# 3. Configure prisma/schema.prisma with dual URLs (see references/prisma-integration.md)
# 4. Generate and run migrations
npx prisma migrate dev --name init
npx prisma generate
# 5. (Optional) Set up MCP server for AI-assisted DB management
npx neonctl init
Rule: Use DATABASE_URL (pooled, has -pooler in hostname) for app queries. Use DIRECT_URL (direct, no -pooler) for migrations.
For detailed information on each topic, see the reference files in the references/ directory.
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
JoaquinCampo/Skills
sparse-retrieval-eval
Evaluate sparse retrieval models on standard IR benchmarks (BEIR, MIRACL, mMARCO). Covers all IR metrics (nDCG@k, Recall@k, MAP, MRR), dataset loading, sparse corpus encoding to CSR matrices, IDF-weighted retrieval, caching, and result interpretation. Triggers on: evaluate retrieval, BEIR benchmark, nDCG, recall@k, sparse retrieval evaluation, MIRACL evaluation, information retrieval metrics, IR evaluation, search quality metrics.
JoaquinCampo/Skills
wandb-plot
Download and generate plots from Weights & Biases runs. Use when you need to: - List projects you have access to - List runs in a W&B project - Inspect available metrics for a run - Download existing plot images from a run - Generate line plots from metric history (loss, accuracy, etc.)
JoaquinCampo/Skills
go
Go engineering best practices and idioms. This skill should be used when writing, reviewing, or refactoring Go code. Triggers on any .go file work, Go module operations, go test, go build, go run, go vet, go generate, or when the user mentions Go, golang, goroutines, channels, context, Go interfaces, Go error handling, Go testing, or Go concurrency. ALWAYS use this skill when Go code is involved, even for simple functions.
JoaquinCampo/Skills
fastapi
FastAPI best practices and conventions. Use when working with FastAPI APIs and Pydantic models for them. Keeps FastAPI code clean and up to date with the latest features and patterns, updated with new versions. Write new code or refactor and update old code.
JoaquinCampo/Skills
kvpress
kvpress (NVIDIA) KV-cache compression for HuggingFace LLMs. Use when: kvpress imports, compression_ratio, press(model) context managers, StreamingLLMPress, SnapKVPress, ExpectedAttentionPress, TOVAPress, KnormPress, KV-cache eviction, token pruning during generation, or attention sink methods.
JoaquinCampo/Skills
plantuml
Create, edit, and render PlantUML diagrams. Triggers on: architecture diagrams, flowcharts, sequence diagrams, data models, state machines, visual documentation.
Didn't find tool you were looking for?