Neon Database

Standard Patterns

Environment Variables

DATABASE_URL="postgresql://user:[email protected]/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