Databases

SQL, NoSQL, schema design, migrations, ORMs, and database operations

skills in category: 4,314
pages available: 180

Security grades appear on each card once the skill has been scanned. Newly imported skills may briefly show without a grade until the backfill job runs.

Open in full browser

Browse databases skills

Showing 1–24 of 4,314 skills

Planning PostgresAHow to use @owlmeans/planning-postgres — the durable Postgres PlanningStore for @owlmeans/server-planning — the four resources (planning-card, planning-transition, planning-link, planning-schema) a target registers from resources/planning/*.ts, the service a target registers from services/planning.ts, the inline fold under a per-card advisory lock and its prelude, healing and recover(), the LISTEN/NOTIFY commit bus, the project purge, data-defined types and flows, the limits and the errors. A...databasesgosqlVotes: 0GitHub stars: 3
Planning PostgresAHow to use @owlmeans/planning-postgres — the durable Postgres PlanningStore for @owlmeans/server-planning — the four resources (planning-card, planning-transition, planning-link, planning-schema) a target registers from resources/planning/*.ts, the service a target registers from services/planning.ts, the inline fold under a per-card advisory lock and its prelude, healing and recover(), the LISTEN/NOTIFY commit bus, the project purge, data-defined types and flows, the limits and the errors. A...databasesgosqlVotes: 0GitHub stars: 3
PostgresAExecute read-only SQL queries against multiple PostgreSQL databases. Use when: (1) querying PostgreSQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.databasespythonbashVotes: 0GitHub stars: 158
Review SpecificationsAReview a technical specification for ambiguities, inconsistencies, incoherences, missing information, and implementability concerns.databasesgoapiVotes: 0GitHub stars: 10
Review DecisionAReview a decision record for clarity, completeness, reasoning quality, and consequence coverage.databasesgosqlVotes: 0GitHub stars: 10
SqliteAEmbedded SQLite — sqlite3 CLI, pragmas, JSON1, WAL, migrations; pairs with cursor-mirror; server DBs use postgres.databasesbashsqlVotes: 0GitHub stars: 56
PostgresAServer PostgreSQL operations — connect, migrate, Timescale, pgvector, introspection; delegates deep tuning to postgres-optimization.databasesshellbashVotes: 0GitHub stars: 56
Postgres OptimizationAUnconventional PostgreSQL optimization techniquesdatabasesgosqlVotes: 0GitHub stars: 56
Knowledge FramesAMinsky frames, Drescher schemas, interchange registry, and MOOLLM K-lines — distinct layers.databasesgosqlVotes: 0GitHub stars: 56
CharacterACore patterns for all characters — home, location, relationships, inventorydatabasesgosqlVotes: 0GitHub stars: 56
Sqlperfmon ReviewBAnalyze Windows Performance Monitor counter data for a SQL Server host to establish whether the operating system itself is the bottleneck and which process is responsible. Applies 14 checks (PM1-PM14) covering SQL process CPU saturation, non-SQL CPU competition, privileged/kernel time, page life expectancy, virtual address space growth, OS memory exhaustion, logical disk latency, hot volumes masked by the _Total instance, compilation and recompilation rates expressed against batch throughput,...databasesrustgoVotes: 0GitHub stars: 9
Architecture Decision RecordAArchitecture Decision Records (ADR) — a lightweight method for capturing important architectural decisions with context, trade-offs, and rationale. Based on Michael Nygard's ADR pattern and Google/Meta/ByteDance's design documentation culture. USE WHEN: deciding between technology choices, designing new architecture, changing existing architecture, documenting why a decision was made, onboarding new team members, or preserving design context for future maintainers. Triggered by terms like "t...databasesgosqlVotes: 0GitHub stars: 2
wechat4-db-exportA在 Windows 上解密微信 4.x（含 4.1+）本地数据库，把聊天记录导出成按发言人/时间戳拆分的 txt 或 json，支持增量刷新（自动合并 -wal 里的最新消息）。当用户要求「导出微信聊天记录」「解密微信数据库」「备份/更新微信聊天数据」「按人物拆分聊天」「看微信表情包是什么」「查会话有多少条」时使用。关键词：微信4.1、Weixin.exe、xwechat_files、db_storage、SQLCipher、WCDB、Config.Cipher、-wal、微信聊天记录导出、chatlog、wxbak。databasespythonbashVotes: 0GitHub stars: 2
SyncARun /sync as the last step after a change is complete, around merge, to keep durable knowledge current. Updates root and nested AGENTS.md, reconciles the scope from repo evidence, and flags specs the change made stale. Surgical edits only: it adds lines, and rewrites single lines it owns. Never a whole section, never curated prose.databasesgoshellVotes: 0GitHub stars: 2
ScopeARun /scope to turn a product idea into a living, coarse scope in docs/scope/ and keep it current: plan a new product, plan the next slice, enroll one named feature, or run with no argument to reconcile after shipping and queue what is next. Seeds WHAT to build; /architect designs, /develop builds.databasesgobashVotes: 0GitHub stars: 2
DocumentARun /document `pr` | `changelog` | `release-note` | `postmortem` (or let it ask) to write the human facing prose about a change. Drafts from the real commits and diff, writing to the right place. Does not write code, tests, or specs.databasesshellbashVotes: 0GitHub stars: 2
CheckAConfirm a change before merge. `/check verify` drives the real app to prove behavior against the spec (every acceptance criterion met, every surface built). `/check review` runs a senior code review on a fresh model, one that did not write the code. Verify after /develop, review before a PR. Writes to docs/reviews/, never edits code.databasesshellbashVotes: 0GitHub stars: 2
ArchitectARun /architect when choosing between approaches, designing a feature or page, picking a tech stack, or when /develop says a decision is owed, anytime a load bearing technical decision is unmade. Asks deep questions, recommends an answer, and writes a build spec to docs/specs/. Owns all spec files.databasesgojavaVotes: 0GitHub stars: 2
Mysword Sqlite ForensicsAEspecialista em engenharia reversa de arquivos SQLite desconhecidos do ecossistema MySword/MyBible — quando o schema não está documentado ou o arquivo tem estrutura inesperada. Cobre: técnicas de inspeção de tabelas e índices (sqlite_master), identificação de tipo por assinatura de tabelas, leitura segura de campos desconhecidos, parsing defensivo de dados sem schema garantido, detecção de WAL mode e recovery, diagnóstico de arquivos corrompidos, análise dos arquivos mydata/ (bookmarks.mybibl...databasesgokotlinVotes: 0GitHub stars: 2
Mysword SpecialistAEspecialista de alto nível em todo o ecossistema MySword/MyBible para Android — orquestra o uso correto das skills granulares (mysword-bible-engine, mybible-format, mysword-format-parser, mysword-user-data, mysword-module-manager). Cobre: fluxo completo de descoberta de módulo até renderização na tela, decisões de arquitetura entre MySword nativo vs MyBible .SQLite3 vs e-Sword, integração com Jetpack Compose (BibleScreen, VerseText, ChapterLazyColumn), cache de capítulos com LruCache, prefetc...databasesgojavaVotes: 0GitHub stars: 2
Mysword Module ManagerAEspecialista em gerenciamento completo de módulos para o app Bíblia Android. Scanner assíncrono com Flow de progresso, detecção de tipo por extensão E por conteúdo de tabelas SQLite, suporte a todos os formatos (MySword, MyBible .SQLite3 com todos os 7 subtipos, e-Sword v9 .bblx/.cmtx/.dctx e v11 .bbli/.cmti/.dcti, TheWord .ont/.ot/.nt, USFM .zip), Room entity universal ModuleEntity com ModuleFormat enum, ModuleDao completo com 15+ queries, scan incremental (só novos/modificados), WorkManager...databasesgokotlinVotes: 0GitHub stars: 2
Mysword Bible EngineAReferência definitiva do formato MySword — schema SQLite oficial de TODOS os 5 tipos de módulo de conteúdo (Bible/.bbl.mybible, Commentary/.cmt.mybible, Dictionary/.dct.mybible, Book/.bok.mybible, Journal/.jor.mybible), tabela Details com todos os 13 campos, a query SQLite exata que MySword usa internamente (SELECT verse, scripture, rowid FROM bible WHERE book=? AND chapter=? ORDER BY verse), índice bible_key obrigatório, GBF Bible Tags completos (todos os 30+ tags com exemplos reais HiSB/ABP...databasesgokotlinVotes: 0GitHub stars: 2
Mybible FormatAReferência definitiva e completa do formato MyBible (.SQLite3) baseada na especificação oficial (Revision 2017-01-17). Cobre TODOS os 7 tipos de módulo com schemas completos (Bible/Dictionary/Subheadings/CrossReferences/Commentaries/ReadingPlans/Devotions), tabela INFO key-value com todos os campos de cada tipo, tags embutidas no VERSES.text (<S><m><i><J><n><e><t><br/><pb/><f>), numeração PalmBible+ completa de livros (Genesis=10, Psalms=230, Matthew=470, Revelation=730), BOOKS vs BOOKS_ALL, ...databasesgojavaVotes: 0GitHub stars: 2
Bible Module ConversionAEspecialista em conversão e interoperabilidade entre formatos de módulos bíblicos — MySword (.bbl.mybible), MyBible (.SQLite3), SWORD (Crosswire), e-Sword (.bblx/.bbli), OSIS XML, USFM, e AndBible. Cobre: conversão de GBF→HTML MyBible e HTML MyBible→GBF, mapeamento de numeração de livros PalmBible+↔MySword (Genesis=10↔1, Psalms=230↔19, Matthew=470↔40), conversão de Strong's com prefixo vs sem prefixo, normalização de UTF-8 para módulos RTF e-Sword, criação de módulos MySword compatíveis a par...databasesjavakotlinVotes: 0GitHub stars: 2