postgres-drizzle

Malicious tool definition detected

Tool: README.md Description: # postgres-drizzle PostgreSQL and Drizzle ORM best practices.

Malicious tool definition detected

Tool: SKILL.md Description: --- name: postgres-drizzle description: Proactively apply when creating APIs, backends, or data models.

Malicious tool definition detected

Tool: references/CHEATSHEET.md [1/2] Description: # Drizzle + PostgreSQL Quick Reference --- ## Schema Definition ### Column Types ```typescript import { pgTable, uuid, text, varchar, integer, bigint, boolean, timestamp, date, numeric, json, jsonb, pgEnum, serial } from 'drizzle-orm/pg-core'; // Primary Keys id: uuid('id').primaryKey().defaultRandom(), // UUIDv4 id: uuid('id').primaryKey().default(sql`uuidv7()`), // UUIDv7 (PG18+) id: integer('id').primaryKey().generatedAlwaysAsIdentity(), // Id

Tool: references/CHEATSHEET.md [2/2] Description: UUIDv4 for better index performance 2.

Malicious tool definition detected

Tool: references/MIGRATIONS.md [1/2] Description: # Drizzle Migrations Comprehensive reference for managing database migrations with drizzle-kit.

Tool: references/MIGRATIONS.md [2/2] Description: on copy of production data pg_dump production_db | psql test_db npx drizzle-kit migrate --config=drizzle.config.test.ts ``` ### 3.

Malicious tool definition detected

Tool: references/PERFORMANCE.md [1/2] Description: # Performance Optimization Comprehensive reference for PostgreSQL and Drizzle ORM performance optimization.

Tool: references/PERFORMANCE.md [2/2] Description: const redis = new Redis(); async function getCachedUser(userId: string) { const cacheKey = `user:${userId}`; // Try cache first const cached = await redis.get(cacheKey); if (cached) return JSON.parse(cached); // Query database const user = await db.query.users.findFirst({ where: eq(users.id, userId), }); // Cache result if (user) { await redis.setex(cacheKey, 3600, JSON.stringify(user)); } return user; } ``` ### Cache Invalidation ```typescript

Malicious tool definition detected

Tool: references/POSTGRES.md [1/2] Description: # PostgreSQL 18 Features & Configuration Comprehensive reference for PostgreSQL 18 features, configuration, and best practices.

Tool: references/POSTGRES.md [2/2] Description: TABLE user_events_0 PARTITION OF user_events FOR VALUES WITH (MODULUS 4, REMAINDER 0); CREATE TABLE user_events_1 PARTITION OF user_events FOR VALUES WITH (MODULUS 4, REMAINDER 1); -- etc.

Malicious tool definition detected

Tool: references/QUERIES.md [1/2] Description: # Drizzle Query Patterns Comprehensive reference for querying PostgreSQL with Drizzle ORM.

Tool: references/QUERIES.md [2/2] Description: ```typescript await db .insert(archivedPosts) .select() .from(posts) .where(lt(posts.createdAt, oneYearAgo)); ``` --- ## Update Operations ### Basic Update ```typescript await db .update(users) .set({ status: 'active' }) .where(eq(users.id, userId)); ``` ### Update with Returning ```typescript const [updated] = await db .update(users) .set({ status: 'active', updatedAt: new Date(), }) .where(eq(users.id, userId)) .returning(); ``` ### Increment/Decr

Malicious tool definition detected

Tool: references/RELATIONS.md [1/2] Description: # Drizzle Relations & Relational Queries Comprehensive reference for defining relations and using the relational queries API.

Tool: references/RELATIONS.md [2/2]

Malicious tool definition detected

Tool: references/SCHEMA.md [1/2] Description: # Drizzle Schema Definition Comprehensive reference for defining PostgreSQL schemas with Drizzle ORM.

Tool: references/SCHEMA.md [2/2] Description: const activeUsers = await db .select() .from(users) .where(isNull(users.deletedAt)); ``` --- ## Multi-Tenant Pattern ```typescript export const tenants = pgTable('tenants', { id: uuid('id').primaryKey().defaultRandom(), name: text('name').notNull(), }); export const users = pgTable('users', { id: uuid('id').primaryKey().defaultRandom(), tenantId: uuid('tenant_id').notNull().references(() => tenants.id), email: text('email').notNull(), }, (table) => [