본문으로 건너뛰기
cccskills
무료GitHub에 공개

drizzle

Drizzle ORM (TypeScript ORM, drizzle-orm / drizzle-kit) の API リファレンス。

pgTable / mysqlTable / sqliteTable, `drizzle()`, `$inferSelect` / `$inferInsert`, RQB (Relational Queries) / `db.query`, `defineRelations`, magic `sql` operator, `drizzle-kit generate` / `push`, `drizzle.config.ts`, drizzle-zod, drizzle-seed, Drizzle Studio。

SQL Server の低レベルドライバーは別スキル mssql。

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

설치 방법 보기

포함된 파일(131)

  • SKILL.md8.5 KB
  • references/advanced/batch-api.md1.2 KB
  • references/advanced/cache.md2.9 KB
  • references/advanced/dynamic-query-building.md1.6 KB
  • references/advanced/jit-mappers.md1.2 KB
  • references/advanced/perf-queries.md1.3 KB
  • references/advanced/perf-serverless.md1.0 KB
  • references/advanced/read-replicas.md1.7 KB
  • references/advanced/README.md1.3 KB
  • references/advanced/set-operations.md1.4 KB
  • references/advanced/transactions.md3.2 KB
  • references/column-types/cockroach.md2.9 KB
  • references/column-types/mssql.md2.8 KB
  • references/column-types/mysql.md2.5 KB
  • references/column-types/pg.md3.0 KB
  • references/column-types/README.md444 B
  • references/column-types/singlestore.md1.9 KB
  • references/column-types/sqlite.md1.8 KB
  • references/connect/cockroach.md1.2 KB
  • references/connect/connect-appwrite-postgres.md3.6 KB
  • references/connect/connect-aws-data-api-pg.md1.5 KB
  • references/connect/connect-bun-sql.md926 B
  • references/connect/connect-drizzle-proxy.md2.8 KB
  • references/connect/connect-effect-postgres.md2.4 KB
  • references/connect/connect-neon.md1.7 KB
  • references/connect/connect-netlify-db.md1.5 KB
  • references/connect/connect-nile.md2.2 KB
  • references/connect/connect-overview.md1.2 KB
  • references/connect/connect-pglite.md1.3 KB
  • references/connect/connect-planetscale-postgres.md1.8 KB
  • references/connect/connect-prisma-postgres.md1.2 KB
  • references/connect/connect-supabase.md1.5 KB
  • references/connect/connect-vercel-postgres.md1.2 KB
  • references/connect/connect-xata.md934 B
  • references/connect/get-started-postgresql.md1.6 KB
  • references/connect/mssql.md1.4 KB
  • references/connect/mysql-drivers.md4.2 KB
  • references/connect/README.md2.4 KB
  • references/connect/singlestore.md1.4 KB
  • references/connect/sqlite-drivers.md8.4 KB
  • references/drizzle-kit/drizzle-config-file.md2.9 KB
  • references/drizzle-kit/drizzle-kit-check.md1.6 KB
  • references/drizzle-kit/drizzle-kit-export.md1.3 KB
  • references/drizzle-kit/drizzle-kit-generate.md2.3 KB
  • references/drizzle-kit/drizzle-kit-migrate.md1.9 KB
  • references/drizzle-kit/drizzle-kit-pull.md1.9 KB
  • references/drizzle-kit/drizzle-kit-push.md2.5 KB
  • references/drizzle-kit/drizzle-kit-studio.md2.4 KB
  • references/drizzle-kit/drizzle-kit-up.md1.2 KB
  • references/drizzle-kit/kit-custom-migrations.md870 B
  • references/drizzle-kit/kit-migrations-for-teams.md1.3 KB
  • references/drizzle-kit/kit-overview.md2.2 KB
  • references/drizzle-kit/kit-web-mobile.md1.4 KB
  • references/drizzle-kit/README.md1.7 KB
  • references/extensions/eslint-plugin.md1.4 KB
  • references/extensions/graphql.md1.3 KB
  • references/extensions/README.md296 B
  • references/getting-started/faq.md1.4 KB
  • references/getting-started/get-started.md2.9 KB
  • references/getting-started/gotchas.md1.2 KB
  • references/getting-started/latest-releases.md2.2 KB
  • references/getting-started/overview.md1.2 KB
  • references/getting-started/README.md945 B
  • references/getting-started/sustainability.md1.8 KB
  • references/getting-started/why-drizzle.md1019 B
  • references/migration/README.md294 B
  • references/migration/upgrade-v1.md1.3 KB
  • references/migration/v0-v1-changes.md4.6 KB
  • references/queries/aliases.md1.9 KB
  • references/queries/data-querying.md1.4 KB
  • references/queries/delete.md1.1 KB
  • references/queries/insert.md2.9 KB
  • references/queries/joins.md4.8 KB
  • references/queries/operators.md3.3 KB
  • references/queries/query-utils.md1.2 KB
  • references/queries/README.md1.2 KB
  • references/queries/select.md7.8 KB
  • references/queries/sql-comments.md1.7 KB
  • references/queries/sql.md4.7 KB
  • references/queries/update.md2.0 KB
  • references/relational-queries/README.md740 B
  • references/relational-queries/relations-schema-declaration.md2.0 KB
  • references/relational-queries/relations-v1-v2.md3.5 KB
  • references/relational-queries/relations.md2.9 KB
  • references/relational-queries/rqb.md2.7 KB
  • references/schema/codecs.md2.1 KB
  • references/schema/custom-types.md2.0 KB
  • references/schema/extensions.md2.0 KB
  • references/schema/generated-columns.md1.3 KB
  • references/schema/indexes-constraints.md2.2 KB
  • references/schema/README.md1.3 KB
  • references/schema/rls.md2.4 KB
  • references/schema/schemas.md969 B
  • references/schema/sequences.md1.3 KB
  • references/schema/sql-schema-declaration.md1.9 KB
  • references/schema/views.md2.1 KB
  • references/seeding/README.md534 B
  • references/seeding/seed-functions.md3.8 KB
  • references/seeding/seed-limitations.md1.7 KB
  • references/seeding/seed-overview.md1.9 KB
  • references/seeding/seed-versioning.md2.2 KB
  • references/validations/arktype.md1.5 KB
  • references/validations/effect-schema.md1.7 KB
  • references/validations/README.md661 B
  • references/validations/typebox-legacy.md1.7 KB
  • references/validations/typebox.md2.0 KB
  • references/validations/valibot.md1.5 KB
  • references/validations/zod.md1.8 KB
  • samples/conditional-filters.md1.3 KB
  • samples/connect-neon.md1.3 KB
  • samples/connect-supabase.md1.2 KB
  • samples/count-rows.md1.4 KB
  • samples/cursor-pagination.md1.6 KB
  • samples/drizzle-zod-validation.md1.9 KB
  • samples/include-exclude-columns.md1.5 KB
  • samples/joins-partial-select.md1.4 KB
  • samples/limit-offset-pagination.md1.4 KB
  • samples/nextjs-neon-todo.md2.2 KB
  • samples/read-replicas.md1.2 KB
  • samples/README.md3.6 KB
  • samples/rqb-avoid-n-plus-one.md1.6 KB
  • samples/schema-definition.md1.9 KB
  • samples/seed-with-relations.md2.1 KB
  • samples/transactions.md1.9 KB
  • samples/upsert.md1.4 KB
  • samples/upstash-cache.md1.6 KB
  • scripts/config.md3.0 KB
  • scripts/drizzle-kit.md4.1 KB
  • scripts/install.md1.6 KB
  • scripts/README.md642 B
  • scripts/studio.md1.9 KB

SKILL.md(원문)

설치하기 전에 에이전트에게 전달되는 지시 내용을 확인할 수 있습니다.

Drizzle ORM API リファレンス

Drizzle ORM / Drizzle Kit — TypeScript の headless ORM(対象バージョン drizzle-orm / drizzle-kit 1.0.0-rc.4(npm dist-tag rc、2026-10-16 実測)。npm dist-tag latest の drizzle-orm 0.45.4 / drizzle-kit 0.31.11 は非対象、 npm i drizzle-orm@rc / npm i -D drizzle-kit@rc でインストールする。drizzle-kit は drizzle-orm と 独立バージョニングだが、本スキル対象時点では両者とも 1.0.0-rc.4。1.0.0-rc.5 は registry に存在せず、 dist-tag rc5 はプレビュービルド 1.0.0-rc.5-5935859 のみ。docs 原本は drizzle-team/drizzle-orm-docs の commit 6659ce0acdfad9b67d89813cc34ac738674390e9(2026-10-10)に pin)。 pgTable / mysqlTable / sqliteTable によるスキーマ宣言、SQL-like クエリビルダーと RQB (Relational Queries, db.query) の2系統のクエリ API、drizzle-kit CLI によるマイグレーション (generate / migrate / push / pull)を中核とする API 設計・実装時に参照する。

SQL Server への低レベル接続(tedious / msnodesqlv8 ドライバー本体)は別スキル mssql を参照する (references/column-types/mssql.md / references/connect/mssql.md に距離線あり)。同様に Supabase 本体の機能は supabase、zod 本体の API は zod、Upstash Redis クライアント本体は upstash を参照する。

v0.x → v1.0 の破壊的変更は references/migration/v0-v1-changes.md に一覧があり、影響を受ける 個別ページ(drizzle-kit/ の各コマンド、relational-queries/rqb.md / relations.md、 column-types/mssql.md / cockroach.md、connect/mssql.md 等)には ## Notes に Migration (v0 → v1): ... を per-page で明記している。

ディレクトリ構成

skills/drizzle/
  SKILL.md
  references/
    getting-started/
      README.md
      overview.md
      get-started.md
      why-drizzle.md
      gotchas.md
      faq.md
      sustainability.md
      latest-releases.md
    schema/
      README.md
      sql-schema-declaration.md
      indexes-constraints.md
      sequences.md
      views.md
      schemas.md
      extensions.md
      rls.md
      generated-columns.md
      custom-types.md
      codecs.md
    column-types/
      README.md
      pg.md
      mysql.md
      sqlite.md
      singlestore.md
      cockroach.md
      mssql.md
    connect/
      README.md
      connect-overview.md
      get-started-postgresql.md
      connect-neon.md
      connect-supabase.md
      connect-vercel-postgres.md
      connect-pglite.md
      connect-xata.md
      connect-nile.md
      connect-bun-sql.md
      connect-effect-postgres.md
      connect-netlify-db.md
      connect-appwrite-postgres.md
      connect-aws-data-api-pg.md
      connect-prisma-postgres.md
      connect-planetscale-postgres.md
      connect-drizzle-proxy.md
      mysql-drivers.md
      sqlite-drivers.md
      mssql.md
      cockroach.md
      singlestore.md
    queries/
      README.md
      data-querying.md
      select.md
      insert.md
      update.md
      delete.md
      operators.md
      query-utils.md
      joins.md
      aliases.md
      sql.md
      sql-comments.md
    relational-queries/
      README.md
      rqb.md
      relations.md
      relations-schema-declaration.md
      relations-v1-v2.md
    drizzle-kit/
      README.md
      kit-overview.md
      drizzle-kit-generate.md
      drizzle-kit-migrate.md
      drizzle-kit-push.md
      drizzle-kit-pull.md
      drizzle-kit-export.md
      drizzle-kit-check.md
      drizzle-kit-up.md
      drizzle-kit-studio.md
      kit-custom-migrations.md
      kit-migrations-for-teams.md
      kit-web-mobile.md
      drizzle-config-file.md
    advanced/
      README.md
      transactions.md
      batch-api.md
      cache.md
      dynamic-query-building.md
      read-replicas.md
      set-operations.md
      jit-mappers.md
      perf-queries.md
      perf-serverless.md
    validations/
      README.md
      zod.md
      valibot.md
      typebox.md
      typebox-legacy.md
      arktype.md
      effect-schema.md
    extensions/
      README.md
      eslint-plugin.md
      graphql.md
    migration/
      README.md
      upgrade-v1.md
      v0-v1-changes.md
    seeding/
      README.md
      seed-overview.md
      seed-functions.md
      seed-versioning.md
      seed-limitations.md
  samples/
    README.md
    schema-definition.md
    rqb-avoid-n-plus-one.md
    cursor-pagination.md
    limit-offset-pagination.md
    transactions.md
    joins-partial-select.md
    include-exclude-columns.md
    drizzle-zod-validation.md
    read-replicas.md
    upstash-cache.md
    nextjs-neon-todo.md
    connect-supabase.md
    connect-neon.md
    seed-with-relations.md
    conditional-filters.md
    upsert.md
    count-rows.md
  scripts/
    README.md
    install.md
    drizzle-kit.md
    config.md
    studio.md

探索手順

タスクからカテゴリを引き、カテゴリの README.md で目的のページを特定する:

  1. 下記マッピング表でタスクに対応するカテゴリを探す
  2. そのカテゴリの references/{category}/README.md を参照して目的のページを特定する
  3. 該当ページの .md を Read して詳細を確認する

タスク → カテゴリ マッピング

タスクカテゴリ参照 README
インストール・クイックスタート・generate と push の違い・FAQgetting-startedreferences/getting-started/README.md
pgTable 等のテーブル宣言、index/constraint、sequence、view、schema 名前空間、RLS、generated column、custom typeschemareferences/schema/README.md
方言別カラム型(PostgreSQL / MySQL / SQLite / SingleStore / CockroachDB / MSSQL)を調べたいcolumn-typesreferences/column-types/README.md
DB / ホスティング(Neon, Supabase, Vercel, PGlite, Xata, Nile, Bun, Effect, Netlify, Appwrite, AWS Data API, PlanetScale, drizzle-proxy)への接続方法、方言別ドライバー(MySQL / SQLite: Turso Database, SQLite Cloud, Cloudflare Durable Objects, Bun SQL (MySQL) を含む)connectreferences/connect/README.md
SQL-like な select / insert / update / delete、フィルタ演算子、join、alias、magic sql operatorqueriesreferences/queries/README.md
db.query (RQB)、defineRelations、with によるネストしたリレーション取得、v1 → v2 移行relational-queriesreferences/relational-queries/README.md
drizzle-kit generate / migrate / push / pull / export / check / up / studio、drizzle.config.tsdrizzle-kitreferences/drizzle-kit/README.md
トランザクション、batch API、クエリキャッシュ、動的クエリ構築、read replica、集合演算、パフォーマンスチューニングadvancedreferences/advanced/README.md
drizzle-zod / valibot / typebox / arktype / effect-schema によるスキーマ生成validationsreferences/validations/README.md
eslint-plugin-drizzle、drizzle-graphqlextensionsreferences/extensions/README.md
v0.x → v1.0 の破壊的変更・アップグレード手順migrationreferences/migration/README.md
drizzle-seed による決定的なフェイクデータ投入seedingreferences/seeding/README.md
典型的な使い方を知りたいsamplessamples/README.md
インストール・CLI コマンドを知りたいscriptsscripts/README.md

将来の拡張

drizzle-orm v1.0.0 GA リリース時(npm dist-tag latest が 1.0.0 になった時点)に /update-skill drizzle check を実行する。

리뷰

아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.

댓글

로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.

아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.

보내면 바로 공개됩니다. 이메일 주소나 전화번호 같은 개인 정보는 쓰지 마세요. URL은 2개까지입니다.

0 / 1,000자

이 양식은 reCAPTCHA로 보호되며 Google 개인정보처리방침 및 서비스 약관이 적용됩니다.

같은 저장소의 스킬

amd-rocm

무료

AMD ROCm / HIP GPU コンピューティングリファレンス。 hipMalloc, hipLaunchKernelGGL, HIP Graph, hipGreenCtx, HIPRTC, hipify, rocBLAS, MIOpen, RCCL, hipThreads, libhipcxx, rocprofv3, amd-smi, rocminfo, TheRock / Core SDK 10, CDNA1-4 / RDNA1-4, MI300 / MI350 / MI350P, gfx942, Matrix Core, wave32/64。

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Fandhe-AI/agent-reference-skills42026년 10월 18일 업데이트

Android アプリ開発 (Kotlin) の推奨アーキテクチャリファレンス。 Jetpack, androidx, UI layer, Domain layer, Data layer, state holder, UDF, SSOT, オフラインファースト, モジュール化, ViewModel, viewModelScope, SavedStateHandle, Lifecycle, repeatOnLifecycle, collectAsStateWithLifecycle, LiveData, Hilt による DI, Paging 3 によるページング処理。

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Fandhe-AI/agent-reference-skills42026년 10월 18일 업데이트

Android アプリ開発 (Kotlin) のバックグラウンド・非同期処理リファレンス。 Jetpack androidx WorkManager: Worker, CoroutineWorker, WorkRequest, Constraints, WorkInfo, WorkContinuation, expedited work, テスト。 Service: フォアグラウンドサービス, バウンドサービス, AIDL, Messenger。 AlarmManager, PendingIntent, BroadcastReceiver, JobScheduler, Doze。 Kotlin コルーチン, Flow, StateFlow, SharedFlow, Channel。

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Fandhe-AI/agent-reference-skills42026년 10월 18일 업데이트

Android アプリ開発 (Kotlin) の Gradle ビルドシステムリファレンス。 Android Gradle Plugin (AGP), Kotlin DSL (build.gradle.kts), version catalog, KSP, R8/ProGuard, App Bundle, baseline profile。

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Fandhe-AI/agent-reference-skills42026년 10월 18일 업데이트

Android Jetpack Compose (Kotlin) の androidx Material3 コンポーネントリファレンス。 Button, IconButton, FloatingActionButton, Checkbox, Switch, Slider, TextField, SearchBar, DropdownMenu, Chip, DatePicker, TimePicker, Card, Scaffold, Dialog, BottomSheet, TopAppBar, NavigationBar, NavigationRail, Tab, Snackbar, ProgressIndicator, Badge, Icon, MaterialTheme, ColorScheme, Typography, Shapes。

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Fandhe-AI/agent-reference-skills42026년 10월 18일 업데이트

Android Jetpack Compose (Kotlin) のアニメーション・描画リファレンス。 androidx.compose.animation / graphics API。 AnimatedVisibility, AnimatedContent, animate*AsState, Animatable, AnimationSpec, Canvas, DrawScope, Brush, Path, Color, Image。

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Fandhe-AI/agent-reference-skills42026년 10월 18일 업데이트

Fandhe-AI의 스킬 모두 보기

이 스킬의 문제 신고