Neon Database Skill

Quick Start Workflow

When working with Neon PostgreSQL:

1. •

   Check if database exists

   • •Look in .env or .env.local for DATABASE_URL
   • •Verify connection with neon connection-string
2. •

   For schema changes

   • •Always use Drizzle migrations (never manual SQL)
   • •Check drizzle.config.ts is configured
   • •Generate migration: drizzle-kit generate
   • •Apply migration: drizzle-kit push
3. •

   For user data storage

   • •Use users table for authentication
   • •Use sessions table for session management
   • •Use chat_history table for conversations
   • •Always include user_id foreign key
4. •

   For queries

   • •Use Drizzle ORM for type safety
   • •Implement proper error handling
   • •Use transactions for multi-table operations

Standard Patterns

Environment Variables

DATABASE_URL="postgresql://user:pass@ep-xxx.us-east-2.aws.neon.tech/neondb?sslmode=require"

Connection Setup

import { drizzle } from 'drizzle-orm/neon-http';
import { neon } from '@neondatabase/serverless';

const sql = neon(process.env.DATABASE_URL!);
export const db = drizzle(sql);

Database Design Principles

For this Physical AI RAG chatbot:

• •Users table: Store authentication data (email, password_hash, email_verified)
• •Sessions table: Manage user sessions (connect to users via user_id)
• •Chat history table: Store Q&A pairs with user attribution
• •All timestamps: Use timestamp('created_at').defaultNow()
• •All IDs: Use text('id').primaryKey() with crypto.randomUUID()

Knowledge Base

For detailed information, check these references:

• •CLI Commands → references/neon-cli.md
• •Drizzle ORM Setup → references/drizzle-orm.md
• •Schema Patterns → references/database-schemas.md
• •Query Examples → references/query-patterns.md
• •Migrations Guide → references/migrations.md