2026年AI程式碼生成的最佳PostgreSQL優化指南
這是一個專為AI程式碼生成設計的PostgreSQL優化知識庫，旨在幫助開發者與AI代理掌握最新的PostgreSQL效能調校技術（截至2026年）。技能內容涵蓋索引策略、查詢重寫、資源配置、記憶體管理與平行處理設定等關鍵主題，並特別強調如何讓AI理解PostgreSQL內部機制，以生成更高效、更安全的SQL。適用於Claude Code、Cursor、Codex等AI編碼工具，開發者可直接將此知識庫整合至AI代理的提示或RAG系統中，確保AI生成的資料庫程式碼遵循最佳實務。該技能由bokyostudio維護，透過持續更新的GitHub儲存庫提供實戰範例與配置建議，讓AI能以人類專家的水準進行PostgreSQL優化。
npx skills add bokyostudio/pg-practice-knowledgebaseThe Ultimate guide to PostgreSQL Optimization for AI Code Generation in 2026
ElevenLabs text-to-speech with mac-style say UX.
Oracle CLI second-model review/debug/refactor/design with selected files, dry-run token checks, API or browser engine.
Capture and automate macOS UI with the Peekaboo CLI.
You MUST use this before any creative work - creating features, building components, adding functionality, or modifying behavior. Explores user intent, requirements and design before implementation.
Prisma ORM patterns for TypeScript backends — schema design, query optimization, transactions, pagination, and critical traps like updateMany returning count not records, $transaction timeouts, migrate dev resetting the DB, @updatedAt skipped on bulk writes, and serverless connection exhaustion.
Django + Celery async task patterns — configuration, task design, beat scheduling, retries, canvas workflows, monitoring, and testing. Use when adding background jobs, scheduled tasks, or async processing to a Django app.