drizzle 是做什麼的？
LobeHub Drizzle ORM 架構與查詢風格。適用於 pgTable 結構、索引、關聯、推論型別、db.select/db.query、結構欄位、外部鍵、中介表或 Postgres 查詢模式。
LobeHub Drizzle ORM 架構與查詢風格。適用於 pgTable 結構、索引、關聯、推論型別、db.select/db.query、結構欄位、外部鍵、中介表或 Postgres 查詢模式。
此技能專門為使用 Drizzle ORM 與 PostgreSQL 的開發者設計，提供一套明確且一致的架構與查詢風格。它涵蓋了從定義 pgTable 結構、建立索引、處理關聯（如 JOIN 與外部鍵）到使用 db.select 或 db.query 進行查詢的完整流程。技能也包含對推論型別的支持，讓 TypeScript 開發者能獲得完整的型別安全優勢。無論是設計中介表、定義結構欄位，還是撰寫複雜的 Postgres 查詢模式，此技能都能確保你的程式碼遵循 LobeHub 的標準，提升團隊協作效率與程式碼可維護性。適用於 Cursor、Claude Code 等支援技能的 AI 輔助開發環境。
npx skills add https://github.com/lobehub/lobehub/tree/main/skills/drizzleInstalled? Explore more 程式設計與開發 skills: steipete/bluebubbles, steipete/eightctl, steipete/blucli · View all 6 →
LobeHub Drizzle ORM 架構與查詢風格。適用於 pgTable 結構、索引、關聯、推論型別、db.select/db.query、結構欄位、外部鍵、中介表或 Postgres 查詢模式。
This repo contains 19 individual skills — each has its own dedicated page.
Add documentation for a new AI provider — usage docs, env vars, Docker config, image resources.
Add server-side environment variables that control default values for user settings.
Debug package usage guide. Use when adding debug logging, understanding log namespaces, or implementing debugging features. Triggers on debug logging requests or logging implementation.
Electron desktop development guide — IPC handlers, controllers, preload scripts, window/menu management.
Add or edit LobeHub keyboard shortcuts. Use for HotkeyEnum, HOTKEYS_REGISTRATION, combineKeys, useHotkeyById, tooltip hotkeys, shortcut scope, conflicts, or Cmd/Ctrl key combos.
LobeHub i18n with react-i18next. Use for user-facing strings, locale keys, namespaces, useTranslation, t(), interpolation, zh-CN/en-US previews, hardcoded UI copy, or pnpm i18n.
Linear issue management. Use for LOBE-xxx issues, Linear links, PRs referencing Linear, retrieving issues, updating status, completion comments, or sub-issue trees.
Use for public LobeHub website documentation under docs/**, including self-hosting, deployment, migration, and configuration guides. Excludes product changelogs and source-code API docs.
UI copy and microcopy guidelines. Use for user-facing copy, buttons, errors, empty states, onboarding, i18n wording, translation, or copy improvements in Chinese or English.
LobeHub imperative modal conventions. Use when creating or migrating modals, dialogs, popups, confirm flows, ModalHost wiring, createModal, confirmModal, useModalContext, or base-ui modal APIs.
Create a PR for the current branch (targets `canary` by default), including splitting one cross-layer branch into ordered stacked PRs so a lower layer (db / shared package / server TRPC) merges before its callers (desktop / CLI / UI). Use when the user asks to create / submit a PR, or to split a branch because clients call a server contract that isn't on the trunk yet. Triggers on 'pr', 'create pr', 'submit pr', 'open a PR', 'pull request', 'split this PR', 'stacked PR', 'backend should merge first', '提 PR', '提个 PR', '新建 PR', '拆 PR', '后端先合', '分层合并'.
LobeHub open-source monorepo architecture map. Use when locating code layers, understanding apps/packages/src layout, business stubs, project structure, or onboarding to the repository.
LobeHub React component conventions. Use when editing TSX UI, choosing base-ui vs @lobehub/ui vs antd, styling with antd-style, routing, desktop variants, layouts, or component state.
LobeHub Zustand store data-shape patterns. Use when designing store state, list/detail splits, normalized maps, reducers, messagesMap, topicsMap, or choosing shared type sources.
Vitest testing guide. Use when writing or updating tests, fixing failing tests, improving coverage, debugging test issues, or setting up mocks.
LobeHub TypeScript style and type-safety guide. Use when editing TS/TSX/MTS, fixing types, choosing interface vs type, avoiding any/object, import type, async flow, or ts-expect-error.
LobeHub Upstash Workflow and QStash guide. Use for async workflows, process/paginate/execute fan-out, serve handlers, context.run/call/sleep, or workflow triggers.
Version release workflow — release process and GitHub Release notes (not docs/changelog pages).
LobeHub Zustand store conventions. Use when editing src/store, store slices, public/internal actions, dispatch actions, flattenActions, optimistic updates, selectors, maps, or class action migration.
Send and manage iMessages via BlueBubbles, including attachments, tapbacks, edits, replies, and groups.
Control Eight Sleep pods (status, temperature, alarms, schedules).
BluOS CLI (blu) for discovery, playback, grouping, and volume.
Create, search, and manage Bear notes via grizzly CLI.
Capture frames or clips from RTSP/ONVIF cameras.
Search GIF providers with CLI/TUI, download results, and extract stills/sheets.