tsq-prisma

tsq-prisma is a skill for Claude Code from sonature-lab/timsquad. It costs 70 tokens per session (645 once invoked), scanned A, original, MIT.

A set of Prisma ORM rules for defining database models, writing queries, and managing schema changes. Prisma ORM is a tool that lets application code work with a database using generated types and models.

In plain words
What is it for?
Use it when editing a Prisma schema, creating or deploying migrations, designing data models, optimizing queries, or applying repository and transaction patterns.
Why use it?
It keeps database structure and code aligned and helps avoid unsafe schema changes, inefficient queries, and inconsistent data.

Skill for Claude Code

Written for Claude Code: user-invocable in frontmatter.

Good fit Use it when editing a Prisma schema, creating or deploying migrations, designing data models, optimizing queries, or applying repository and transaction patterns.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/sonature-lab/timsquad/tsq-prisma
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add sonature-lab/timsquad --skill tsq-prisma
Clone the repo
git clone --depth 1 https://github.com/sonature-lab/timsquad

Made for: Claude Code.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for tsq-prisma

README.md
[![agentmods](https://agentmods.dev/badge/skills/sonature-lab/timsquad/tsq-prisma/github.svg)](https://agentmods.dev/skills/sonature-lab/timsquad/tsq-prisma)
Your own site
<a href="https://agentmods.dev/skills/sonature-lab/timsquad/tsq-prisma"><img src="https://agentmods.dev/badge/skills/sonature-lab/timsquad/tsq-prisma/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for tsq-prisma

Your own site · 80×15
<a href="https://agentmods.dev/skills/sonature-lab/timsquad/tsq-prisma"><img src="https://agentmods.dev/badge/skills/sonature-lab/timsquad/tsq-prisma.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 70 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 645 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00070 $0.00645
Opus 5 $0.00035 $0.00322
Sonnet 5 $0.00014 $0.00129
Haiku 4.5 $0.00007 $0.00064

Measured 9d ago against content hash afa754c43b92, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-09, from the pricing page.

Security

Grade A, and why

tsq-prisma scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 9d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

templates/base/skills/tsq-prisma/SKILL.md · 64 lines

What it actually says

Prisma ORM Guidelines

철학

  • Schema as SSOT — 스키마가 진실의 원천
  • Type Safety — 자동 생성 타입 활용
  • Migration First — 스키마 변경은 마이그레이션으로

마이그레이션 워크플로우

명령어 용도
npx prisma migrate dev --name {name} 개발 환경 마이그레이션
npx prisma migrate deploy 프로덕션 적용
npx prisma migrate reset DB 초기화 + 재적용
npx prisma db push 빠른 프로토타이핑 (마이그레이션 없이)
npx prisma generate 클라이언트 재생성

순서: schema.prisma 수정 → migrate dev → SQL 검토 → 커밋

Rules

스키마

  • 모든 모델에 id, createdAt, updatedAt
  • 명시적 인덱스 정의 (@@index)
  • @@map으로 테이블명 명시
  • 관계는 명확히 정의

쿼리

  • select로 필요한 필드만 조회 (성능)
  • 페이지네이션 적용 (take, skip)
  • 복잡한 작업은 트랜잭션 사용
  • 금지: N+1 쿼리, 무한 결과 조회

마이그레이션

  • migrate dev로 개발, migrate deploy로 배포
  • 마이그레이션 파일 커밋 필수
  • 금지: 프로덕션에서 db push

Checklist

Priority Item
CRITICAL 싱글톤 인스턴스 사용
CRITICAL 마이그레이션으로 스키마 관리
HIGH 트랜잭션으로 데이터 정합성
HIGH select로 필요한 필드만 조회
MEDIUM 인덱스 적절히 설정
MEDIUM Repository 패턴 적용

참조

  • rules/schema-design.md — 모델 정의, 공통 필드, 소프트 삭제 패턴
  • rules/queries.md — 싱글톤, CRUD, Relations, 트랜잭션, Repository 패턴
  • tsq-database — DB 설계 원칙, 쿼리 최적화, raw SQL 마이그레이션은 tsq-database 참조
Files

What ships with it

2 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 9d ago First seen · 64 lines · 70 tokens per session scan A afa754c43b92

Subscribe to this mod's changes

tsq-prisma is a skill published in the GitHub repository sonature-lab/timsquad (11 stars, last pushed 9d ago), licensed MIT. It adds 70 tokens to every session and 645 once invoked, about $0.0003 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

record-upgrade-instructions

Record upgrade instructions alongside a Prisma Next breaking-change PR, so downstream consumers (users of @internal/ and authors of Prisma Next extensions) can apply the matching code translation automatically via the published upgrade skills. Use when you have refactored framework code and the test suite went red in…

prisma/orm · 120 tokens

create-pr

Creates a GitHub PR with a Linear-ticket-prefixed title and a decision-led, narrative description for prisma-next. Use when the user wants to create a pull request, open a PR, or submit changes for review.

prisma/orm · 47 tokens

draft-release-notes

Author the committed release-notes file for a Prisma 8 release (stable or 8.0.0-rc.N) by enumerating the merged PRs since the previous release v tag (stable or -rc.N), resolving opaque TML-NNNN: titles via Linear context (never copied verbatim), triaging public-worthiness, and writing categorized notes — breaking…

prisma/orm · 174 tokens

contrib-pr

Open a high-quality external contributor PR against prisma/orm. Use when the user is an outside contributor (not a Prisma maintainer) and wants to submit a change as a pull request from a fork. Encodes the contribution flow from CONTRIBUTING.md so the resulting PR passes review on the first round.

prisma/orm · 65 tokens

triage-contributor-pr

Triage open pull requests from external contributors to prisma/prisma and produce a per-PR verdict with evidence. Use when a maintainer asks to triage, evaluate, assess, or review the queue of incoming contributor PRs, to decide whether a fork PR is safe to run CI on, to check whether a PR is in scope for its version…

prisma/orm · 131 tokens

github-review-iteration

Orchestrates a GitHub PR review loop by delegating triage and implementation to dedicated sub-agents, then repeating until actionable review items are cleared. Use when the user says “address PR review”, “triage review comments”, or “iterate until review is clean”.

prisma/orm · 60 tokens