Style de schéma et de requête pour Drizzle ORM de LobeHub. Utilisez-le pour les schémas pgTable, les index, les jointures, les types inférés, db.select/db.query, les champs de schéma, les clés étrangères, les tables de jonction ou les modèles de requête PostgreSQL.
Ce skill fournit un style de codage spécifique pour Drizzle ORM, utilisé par LobeHub, permettant aux agents IA (comme Claude Code, Cursor, Codex) de générer et de manipuler des schémas et des requêtes PostgreSQL de manière cohérente et efficace. Il se concentre sur l'utilisation de `pgTable` pour définir les schémas de table, la création d'index, la gestion des clés étrangères et des tables de jonction, ainsi que les types inférés et les motifs de requête `db.select` et `db.query`. En suivant ce style, les développeurs peuvent s'assurer que leur code Drizzle est aligné avec les pratiques de LobeHub, ce qui facilite la maintenance et la collaboration au sein de l'équipe. Le skill est particulièrement utile pour les projets qui adoptent Drizzle ORM comme couche d'accès aux bases de données PostgreSQL, en standardisant la manière de structurer les modèles de données et d'écrire les requêtes.
npx skills add https://github.com/lobehub/lobehub/tree/main/skills/drizzleInstalled? Explore more Développement et programmation skills: steipete/bluebubbles, steipete/eightctl, steipete/blucli · View all 6 →
Style de schéma et de requête pour Drizzle ORM de LobeHub. Utilisez-le pour les schémas pgTable, les index, les jointures, les types inférés, db.select/db.query, les champs de schéma, les clés étrangères, les tables de jonction ou les modèles de requête PostgreSQL.
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.