// Add or modify database tables, columns, enums, and relations in Drizzle ORM. Use when: adding new tables, adding columns to existing tables, creating indexes, defining relations, or running migrations. Covers the full workflow: schema edit → generate → migrate.
| name | database-schema |
| description | Add or modify database tables, columns, enums, and relations in Drizzle ORM. Use when: adding new tables, adding columns to existing tables, creating indexes, defining relations, or running migrations. Covers the full workflow: schema edit → generate → migrate. |
| argument-hint | Describe the schema change (e.g., 'add a bookmarks table') |
Modify drizzle/db/schema.ts and run migrations following project conventions.
project has 100+ columns — check first)pgEnum)drizzle/db/schema.ts to understand current schemadrizzle/db/schema.tsbun run db:generate to create migration SQLbun run db:migrate to apply migrationbun run db:push skips migration filesimport { pgTable, text, timestamp, boolean, index, primaryKey } from "drizzle-orm/pg-core"
export const bookmark = pgTable(
"bookmark",
{
id: text("id").primaryKey(),
userId: text("user_id")
.notNull()
.references(() => user.id, { onDelete: "cascade" }),
projectId: text("project_id")
.notNull()
.references(() => project.id, { onDelete: "cascade" }),
createdAt: timestamp("created_at").notNull().defaultNow(),
},
(table) => ({
userIdx: index("bookmark_user_idx").on(table.userId),
projectIdx: index("bookmark_project_idx").on(table.projectId),
}),
)
export const myStatus = {
ACTIVE: "active",
INACTIVE: "inactive",
PENDING: "pending",
} as const
export type MyStatus = (typeof myStatus)[keyof typeof myStatus]
export const projectToTag = pgTable(
"project_to_tag",
{
projectId: text("project_id")
.notNull()
.references(() => project.id, { onDelete: "cascade" }),
tagId: text("tag_id")
.notNull()
.references(() => tag.id, { onDelete: "cascade" }),
},
(table) => ({
pk: primaryKey({ columns: [table.projectId, table.tagId] }),
}),
)
drizzle/db/schema.ts (single schema file)text("id").primaryKey() — the app generates string IDsas const, NOT Drizzle pgEnumtext("snake_case")myColumn: text("my_column").references(() => table.id, { onDelete: "cascade" }) or "set null"timestamp("created_at").notNull().defaultNow()pgTablebun run db:generate then bun run db:migratedrizzle.config.ts — migrations output to drizzle/migrations/drizzle/db/index.ts — import db from @/drizzle/dbMachine-readable project skill file for Memescope Monday — a community-driven memecoin discovery and voting platform.
Create new Next.js API route handlers with rate limiting, auth, and validation. Use when: adding REST endpoints, webhook handlers, public API routes, or authenticated API routes. Covers GET/POST handlers, rate limiting with Redis, Zod validation, and error responses.
Add new external coin/token data API integrations. Use when: integrating DexScreener, PumpFun, CoinGecko, or any new blockchain data API. Covers fetch patterns, response types, caching, error handling, and chain mapping.
Scaffold React components using shadcn/ui and project patterns. Use when: creating new UI components, feature components, client components with interactivity, or server components for data display. Covers props, imports, Tailwind styling, and optimistic updates.
Create new server actions following Memescope Monday patterns. Use when: adding data mutations, server-side fetches, authenticated operations, or new app/actions/ files. Handles session checks, Drizzle queries, revalidation, and error returns.