Estilo de esquema e consulta do Drizzle ORM do LobeHub. Use para esquemas pgTable, índices, junções, tipos inferidos, db.select/db.query, campos de esquema, chaves estrangeiras, tabelas de junção ou padrões de consulta PostgreSQL.
Esta habilidade define o estilo de esquema e consulta do Drizzle ORM utilizado pelo LobeHub, projetado para desenvolvedores que trabalham com bancos de dados PostgreSQL e a biblioteca Drizzle ORM. Ela fornece diretrizes para criar esquemas de tabela usando `pgTable`, definir índices, configurar chaves estrangeiras, construir tabelas de junção e realizar consultas complexas com `db.select` e `db.query`. A habilidade também abrange o uso de tipos inferidos automaticamente pelo Drizzle, garantindo segurança de tipos em operações de banco de dados. Com suporte a padrões como junções (joins), consultas aninhadas e otimização de consultas, ela é útil para qualquer agente de IA que precise gerar ou modificar código de banco de dados PostgreSQL seguindo as melhores práticas do Drizzle ORM. É compatível com plataformas como Claude Code, Cursor, Codex e outras ferramentas que interpretam skills de IA, facilitando a geração consistente de código de banco de dados dentro do ecossistema LobeHub.
npx skills add https://github.com/lobehub/lobehub/tree/main/skills/drizzleInstalled? Explore more Programação e Desenvolvimento skills: steipete/bluebubbles, steipete/eightctl, steipete/blucli · View all 6 →
Estilo de esquema e consulta do Drizzle ORM do LobeHub. Use para esquemas pgTable, índices, junções, tipos inferidos, db.select/db.query, campos de esquema, chaves estrangeiras, tabelas de junção ou padrões de consulta 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.