Menu
Creates a new Drizzle ORM table schema and generates the migration. Use when adding a new data entity or database table.
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
PostHog integration for Next.js App Router applications
Use when a feature branch is complete and ready for PR — runs a full diff-based review of the current branch against main, reads every changed file, validates against project rules, and produces a concrete action plan. Do NOT use on main branch.
Identifies and executes the next pending POC task. Fast context pickup from docs/poc/context.json — no build/lint at start. Use for starting the next task, resuming in-progress work, or targeting a specific task by ID.
Use when the Antes da Tela POC needs a new task direction or clearer scope before handing work off to /create-poc-task in the documented AI workflow.
Analyzes current POC task state, creates a standardized new task file, and updates docs/poc/context.json and docs/poc/tasks/summary.md. Use when adding a new task to the Antes da Tela POC backlog.
Unified Figma implementation + refinement workflow that translates Figma designs into production-ready code, reconciles design tokens, and performs regression-safe metadata updates. Use live MCP data with canonical metadata under `docs/design-system/`.
| name | new-drizzle-table |
| description | Creates a new Drizzle ORM table schema and generates the migration. Use when adding a new data entity or database table. |
| argument-hint | [table-name] e.g. scripts, comments, tags |
| allowed-tools | Read, Write, Bash |
Create a new Drizzle ORM table for: $ARGUMENTS
server/db/schema.ts:import { pgTable, text, timestamp, uuid } from "drizzle-orm/pg-core";
export const $ARGUMENTS = pgTable("$ARGUMENTS", {
id: uuid("id").primaryKey().defaultRandom(),
// Add columns here — example:
// title: text("title").notNull(),
// userId: uuid("user_id").notNull().references(() => users.id, { onDelete: "cascade" }),
createdAt: timestamp("created_at").defaultNow().notNull(),
updatedAt: timestamp("updated_at").defaultNow().notNull(),
});
export type $ARGUMENTSInsert = typeof $ARGUMENTS.$inferInsert;
export type $ARGUMENTSSelect = typeof $ARGUMENTS.$inferSelect;
Re-export the table by verifying server/db/index.ts imports * as schema from ./schema.
Generate the migration:
yarn drizzle-kit generate
yarn drizzle-kit migrate
uuid().primaryKey().defaultRandom() for all primary keys..references(() => targetTable.id, { onDelete: "cascade" }).Insert and Select inferred types — use them in tRPC router input/output.DATABASE_URL_UNPOOLED must be set for migrations (session pooler, port 5432)./drizzle/ manually.