Communitygithub.com

mindrally/mysql-best-practices

Práticas recomendadas de desenvolvimento MySQL para design de esquemas, otimização de consultas e administração de banco de dados

O que é mysql-best-practices?

Esta skill fornece práticas recomendadas abrangentes para desenvolvimento MySQL, cobrindo design de esquemas, otimização de consultas e administração de banco de dados. É útil para desenvolvedores e DBA que desejam melhorar o desempenho, a manutenibilidade e a segurança de seus sistemas baseados em MySQL. A skill é compatível com agentes de IA como Claude Code, Cursor e Codex, e seu conteúdo é estruturado em formato markdown para fácil referência e integração. Baseia-se em princípios comprovados da indústria, como normalização de dados, uso adequado de índices, análise de consultas com EXPLAIN, e práticas de administração como backup e monitoramento.

Funciona com~Claude Code~Codex CLI~Cursor
Part ofDesign & UI
npx skills add https://github.com/mindrally/skills/tree/main/skills/mysql-best-practices
Ver original→Navegar por todas as habilidades

Perguntar na sua IA favorita

Abre um novo chat com esta habilidade de agente já pré-carregada.

OpenAIChatGPTClaudeClaudeGeminiGeminiGrokGrokPerplexityPerplexityDeepSeekDeepSeek

Documentação

O que mysql-best-practices faz?

Práticas recomendadas de desenvolvimento MySQL para design de esquemas, otimização de consultas e administração de banco de dados

Design de Esquemas

  • Use nomes descritivos para tabelas e colunas.
  • Normalize os dados para evitar redundância.
  • Utilize chaves primárias e estrangeiras apropriadamente.
  • Defina índices estratégicos para acelerar consultas.

Otimização de Consultas

  • Evite SELECT *; selecione apenas colunas necessárias.
  • Use EXPLAIN para analisar planos de execução.
  • Prefira junções (JOIN) a subconsultas aninhadas quando possível.
  • Utilize LIMIT para restringir resultados.

Administração de Banco de Dados

  • Realize backups regulares.
  • Monitore o desempenho com ferramentas como SHOW STATUS.
  • Ajuste configurações de memória e cache.
  • Implemente segurança com usuários e privilégios adequados.

Para mais detalhes, consulte a documentação oficial do MySQL.

Individual skills in this repo

This repo contains 20 individual skills — each has its own dedicated page.

mindrally/accessibility-a11y

Implement web accessibility (a11y) best practices following WCAG guidelines to create inclusive, accessible user interfaces.

mindrally/chrome-extension-development

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.

mindrally/computer-vision-opencv

Expert guidance for computer vision development using OpenCV, PyTorch, and modern deep learning techniques for image and video processing.

mindrally/data-analysis-jupyter

Expert guidance for data analysis, visualization, and Jupyter Notebook development with pandas, matplotlib, seaborn, and numpy.

mindrally/deep-learning-pytorch

Expert guidance for deep learning, transformers, diffusion models, and LLM development with PyTorch, Transformers, Diffusers, and Gradio.

mindrally/expo-react-native-typescript

Expert in Expo React Native TypeScript mobile development with best practices

mindrally/fastapi-python

Expert in FastAPI Python development with best practices for APIs and async operations

mindrally/framer-motion

Expert guidelines for building performant animations with Framer Motion/Motion library in React applications

mindrally/htmx

HTMX development guidelines for building dynamic web applications with minimal JavaScript using HTML attributes.

mindrally/jwt-security

Guidelines for implementing JWT authentication with security best practices for token creation, validation, and storage

mindrally/machine-learning

Machine learning development with JAX, functional programming patterns, and high-performance computing.

mindrally/nextjs-react-typescript

Expert in TypeScript, Node.js, Next.js App Router, React, Shadcn UI, Radix UI and Tailwind

mindrally/nextjs-typescript-tailwindcss-supabase

Full-stack Next.js 14 development with TypeScript, TailwindCSS, and Supabase for building production-ready web applications.

mindrally/odoo-development

Expert guidance for Odoo ERP development including Python ORM, XML views, and module architecture

mindrally/puppeteer-automation

Expert guidance for browser automation using Puppeteer with best practices for web scraping, testing, screenshot capture, and JavaScript execution in headless Chrome.

mindrally/redis-best-practices

Redis development best practices for caching, data structures, and high-performance key-value operations

mindrally/scrapy-web-scraping

Expert guidance for building web scrapers and crawlers using the Scrapy Python framework with best practices for spider development, data extraction, and pipeline management.

mindrally/scss-best-practices

SCSS/Sassy CSS best practices and coding guidelines for maintainable, scalable stylesheets

mindrally/typeorm

Guidelines for developing with TypeORM, a full-featured ORM for TypeScript and JavaScript supporting multiple databases

mindrally/web-scraping

Expert in web scraping and data extraction with Python tools

Habilidades Relacionadas

steipete/sag

ElevenLabs text-to-speech with mac-style say UX.

community

steipete/oracle

Oracle CLI second-model review/debug/refactor/design with selected files, dry-run token checks, API or browser engine.

community

steipete/peekaboo

Capture and automate macOS UI with the Peekaboo CLI.

community

mattpocock/design-an-interface

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".

community

mattpocock/prototype

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.

community

mattpocock/grill-me

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".

community