Database orm
Skill ComeOnOliver/skillshub/skills/aiskillstore/marketplace/abdulsamad94/database-orm
Interaction with NeonDB Postgres using Drizzle ORM.From its SKILL.md
npx -y skills add ComeOnOliver/skillshub --skill database-ormAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
SKILL.md
1.0 KB, 255 tokens by cl100k_base, as published. Nobody here has run it
Database Logic
Stack
- Database: Neon (Serverless Postgres)
- ORM: Drizzle ORM
- Driver:
@neondatabase/serverless
Connection
The 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
Schema definitions are in db/schema.ts.
users,sessions,accounts,verifications: Auth tables.analyses,chatbot_history: App specific tables.
Operations
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, "[email protected]"));
// Insert
await db.insert(users).values({ ... });
Migrations
- Generate:
npx drizzle-kit generate - Push:
npx drizzle-kit push(or migrate script)
What ships with it
9.3 KB alongside SKILL.md
GitHub clipped this repository’s file list, so this is at least 1 file and may be more.
- skill-report.json9.3 KB