Menu
Interaction with NeonDB Postgres using Drizzle ORM.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Documentation for the FastAPI backend, endpoints, and dependency injection.
Overview of the project's tech stack, directory structure, and architectural patterns.
Guide to using Better Auth for client and server-side authentication.
Validates and analyzes Docusaurus MDX chapters for structure, pedagogical quality, and component usage.
Details of the RAG Chatbot, including UI and backend logic.
Knowledge of the Vercel deployment pipeline, hybrid build scripts, and environment configuration.
| name | Database & ORM |
| description | Interaction with NeonDB Postgres using Drizzle ORM. |
@neondatabase/serverlessThe database connection is initialized in db/index.ts.
import { neon } from '@neondatabase/serverless';
import { drizzle } from 'drizzle-orm/neon-http';
const sql = neon(process.env.DATABASE_URL!);
export const db = drizzle(sql);
Schema definitions are in db/schema.ts.
users, sessions, accounts, verifications: Auth tables.analyses, chatbot_history: App specific tables.Example of a database query:
import { db } from "@/db";
import { users } from "@/db/schema";
import { eq } from "drizzle-orm";
// Select
const user = await db.select().from(users).where(eq(users.email, "test@example.com"));
// Insert
await db.insert(users).values({ ... });
npx drizzle-kit generatenpx drizzle-kit push (or migrate script)