mysql-best-practices 是做什麼的？
MySQL 資料庫開發的最佳實踐：涵蓋資料表設計、查詢效能調校與資料庫管理指南。
MySQL 開發最佳實踐：涵蓋資料表設計、查詢效能調校與資料庫管理
此技能提供 MySQL 資料庫開發的全面最佳實踐指南，涵蓋資料表結構設計、SQL 查詢效能優化以及日常資料庫管理。它基於權威的 MySQL 文件與實務經驗，為開發者與 DBA 整理出清晰可遵循的建議。支援所有使用 MySQL 或相容資料庫的開發環境與工具。技能內容包括適合索引的欄位類型選擇、避免反模式設計（如 EAV）、索引最佳化策略（包含複合索引與覆蓋索引）、查詢重構技巧（例如以關聯式查詢取代大量逐筆操作）、以及 EXPLAIN 分析與伺服器設定調校方法。透過遵循這些建議，能有效提升應用程式資料層的效能、可維護性與擴充性。
npx skills add https://github.com/mindrally/skills/tree/main/skills/mysql-best-practicesMySQL 資料庫開發的最佳實踐：涵蓋資料表設計、查詢效能調校與資料庫管理指南。
This repo contains 20 individual skills — each has its own dedicated page.
Implement web accessibility (a11y) best practices following WCAG guidelines to create inclusive, accessible user interfaces.
Expert guidelines for Chrome extension development with Manifest V3, covering security, performance, and best practices. Use when building browser extensions, creating popup UIs, implementing content scripts, working with Chrome APIs, managing extension permissions, or publishing to Chrome Web Store.
Expert guidance for computer vision development using OpenCV, PyTorch, and modern deep learning techniques for image and video processing.
Expert guidance for data analysis, visualization, and Jupyter Notebook development with pandas, matplotlib, seaborn, and numpy.
Expert guidance for deep learning, transformers, diffusion models, and LLM development with PyTorch, Transformers, Diffusers, and Gradio.
Expert in Expo React Native TypeScript mobile development with best practices
Expert in FastAPI Python development with best practices for APIs and async operations
Expert guidelines for building performant animations with Framer Motion/Motion library in React applications
HTMX development guidelines for building dynamic web applications with minimal JavaScript using HTML attributes.
Guidelines for implementing JWT authentication with security best practices for token creation, validation, and storage
Machine learning development with JAX, functional programming patterns, and high-performance computing.
Expert in TypeScript, Node.js, Next.js App Router, React, Shadcn UI, Radix UI and Tailwind
Full-stack Next.js 14 development with TypeScript, TailwindCSS, and Supabase for building production-ready web applications.
Expert guidance for Odoo ERP development including Python ORM, XML views, and module architecture
Expert guidance for browser automation using Puppeteer with best practices for web scraping, testing, screenshot capture, and JavaScript execution in headless Chrome.
Redis development best practices for caching, data structures, and high-performance key-value operations
Expert guidance for building web scrapers and crawlers using the Scrapy Python framework with best practices for spider development, data extraction, and pipeline management.
SCSS/Sassy CSS best practices and coding guidelines for maintainable, scalable stylesheets
Guidelines for developing with TypeORM, a full-featured ORM for TypeScript and JavaScript supporting multiple databases
Expert in web scraping and data extraction with Python tools
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.
Generate multiple radically different interface designs for a module using parallel sub-agents. Use when user wants to design an API, explore interface options, compare module shapes, or mentions "design it twice".
Build a throwaway prototype to flesh out a design — a runnable terminal app for state/business-logic questions, or several radically different UI variations toggleable from one route.
Interview the user relentlessly about a plan or design until reaching shared understanding, resolving each branch of the decision tree. Use when user wants to stress-test a plan, get grilled on their design, or mentions "grill me".