Skip to content
Back to skills

Add Table

ASecurity

Add a new database table and generate all six layers. Use when adding a new entity to the platform.

  • 2 stars
  • 0 votes
  • 0 copies
  • 4 views
  • Added October 26, 2026
databasesbashdatabase

Security analysis

A100/100

Scanned October 26, 2026

npx -y skills add JoshuaShepherd/my-skills --skill add-table --agent claude-code

Installs into .claude/skills of the current project.

Are you the author of Add Table?

Add the live security badge to your README. It updates with every re-scan.

Security grade badge for Add Table
[![Security: A — Skills Directory](https://www.skillsdirectory.com/api/skills/joshuashepherd-add-table/badge)](https://www.skillsdirectory.com/skills/joshuashepherd-add-table)

More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.

Download with Pro
SKILL.md
---
name: add-table
description: Add a new database table and generate all six layers. Use when adding a new entity to the platform.
user-invocable: true
disable-model-invocation: true
allowed-tools: Read, Edit, Write, Bash, Grep, Glob
---

Add a new entity to the platform by working bottom-up through all six layers.

Entity name: $0

## Process

1. **Layer 1 — Schema**: Add the table definition to `src/lib/database/schema.ts` following existing patterns. Include `organization_id` for multi-tenant scoping. Use appropriate column types matching existing conventions.
2. **Layer 2 — Zod**: Run `pnpm generate:schemas` then `pnpm contracts:check`
3. **Layer 3 — Services**: Run `pnpm generate:services` then `pnpm services:check`
4. **Layer 4 — Routes**: Run `pnpm generate:routes` then `pnpm routes:check`
5. **Layer 5 — Hooks**: Run `pnpm generate:hooks` then `pnpm hooks:check`
6. **Layer 6 — UI**: Run `pnpm generate:ui` then `pnpm ui:check`

## Rules

- Validate each layer before proceeding to the next
- If any layer fails, fix it before continuing (always fix at the source layer)
- Never modify a lower layer to satisfy an upper layer's needs
- After all layers pass, run `pnpm drizzle:gen` to create the migration
- Do not run `pnpm drizzle:push` without explicit user confirmation

Attribution

Is this your skill, or is something wrong with this listing? Request removal or report an issue. Author removals are honored within 72 hours.

Comments

Loading comments…

Newsletter

Get the weekly list of safe new skills, and the ones we pulled.