AgentSkillsCN

neon

通过@neondatabase/serverless实现Neon无服务器PostgreSQL的集成。当您使用Neon执行数据库操作时,此方法将助您事半功倍。

SKILL.md
--- frontmatter
name: neon
description: Neon serverless PostgreSQL integration using @neondatabase/serverless. Use when implementing database operations with Neon.

Neon Integration

Neon is a serverless PostgreSQL database.

Guidelines

  • Use the @neondatabase/serverless package to interact with a Neon database.

  • Use the neon(...) function to create a reusable SQL client:

    typescript
    import { neon } from '@neondatabase/serverless'
    
    const sql = neon(process.env.DATABASE_URL)
    
  • NEVER use the @vercel/postgres package to interact with a Neon database.

  • Use parameterized queries to prevent SQL injection.

Environment Variables

  • DATABASE_URL - Neon connection string

Example Usage

typescript
import { neon } from '@neondatabase/serverless'

const sql = neon(process.env.DATABASE_URL)

// Query example
const users = await sql`SELECT * FROM users WHERE id = ${userId}`

// Insert example
await sql`INSERT INTO users (name, email) VALUES (${name}, ${email})`