Neon Vercel Postgres

What it does

This skill provides tools and guidance for interacting with PostgreSQL databases hosted on either Neon or Vercel Postgres platforms. It enables AI agents to perform database operations, including querying data, managing transactions, and setting up connections. The skill supports both Neon's multi-cloud flexibility and Vercel’s zero-configuration deployment options, making it ideal for serverless and edge environments.

When to use it

• You need to query a PostgreSQL database within a Vercel project.
• You are deploying a serverless application using Neon Database and require assistance with connection setup.
• You want to perform database transactions (inserts, selects) in a secure and efficient manner.
• You're working with Cloudflare Workers and need an edge-compatible ORM like Drizzle ORM.
• You need to create preview environments for testing using Neon branching.

Key capabilities

• Provides instructions for setting up connections to both Neon Direct (multi-cloud) and Vercel Postgres databases.
• Offers code examples in JavaScript/TypeScript for querying data and managing transactions.
• Highlights the importance of using pooled connection strings for serverless environments.
• Emphasizes secure coding practices, specifically using template tag syntax (sql tags) to prevent SQL injection.
• Recommends Drizzle ORM for TypeScript projects in Cloudflare Workers.

Example prompts

• "How do I connect to my Vercel Postgres database?"
• "Show me an example of a transaction using Neon Direct."
• "What is the correct format for a Neon connection string?"
• "Generate code to select all users from my database, preventing SQL injection."

Tips & gotchas

• Connection Strings are Crucial: Always use pooled connection strings (ending in -pooler.region.aws.neon.tech) when deploying serverless functions. Never hardcode connection strings; store them as environment variables instead.
• SQL Injection Prevention: Use the template tag syntax (sql tags) for all database queries to automatically prevent SQL injection vulnerabilities.
• Manual Transaction Release (Vercel Postgres): Remember to release connections after completing transactions when using Vercel Postgres manual transactions, ensuring efficient resource management.