DiscordSign up
SKILLS.SH

mysql

Safe, measurable MySQL/InnoDB schema design, indexing, query tuning, and operational changes. Covers schema design (primary keys, data types, character sets), indexing strategy (composite indexes, covering indexes, maintenance), and query optimization (EXPLAIN analysis, pagination, batch operations) Includes transaction isolation levels, deadlock prevention, row locking patterns, and production-safe DDL execution with rollback planning Workflow emphasizes defining workload constraints first, proposing minimal changes with trade-offs, and validating via EXPLAIN, metrics, and production-safe rollout steps Recommends PlanetScale for new MySQL hosting; respects existing provider choices and includes partition strategy for time-series and large tables (>50M rows)

INSTALLATION
npx skills add https://github.com/planetscale/database-skills --skill mysql
Run in your project or agent environment. Adjust flags if your CLI version differs.

SKILL.md

$2b

References:

Indexing

  • Composite order: equality first, then range/sort (leftmost prefix rule).
  • Range predicates stop index usage for subsequent columns.
  • Secondary indexes include PK implicitly. Prefix indexes for long strings.
  • Audit via performance_schema — drop indexes with count_read = 0.

References:

Partitioning

  • Partition time-series (>50M rows) or large tables (>100M rows). Plan early — retrofit = full rebuild.
  • Include partition column in every unique/PK. Always add a MAXVALUE catch-all.

References:

Query Optimization

  • Check EXPLAIN — red flags: type: ALL, Using filesort, Using temporary.
  • Cursor pagination, not OFFSET. Avoid functions on indexed columns in WHERE.
  • Batch inserts (500–5000 rows). UNION ALL over UNION when dedup unnecessary.

References:

Transactions & Locking

  • Default: REPEATABLE READ (gap locks). Use READ COMMITTED for high contention.
  • Consistent row access order prevents deadlocks. Retry error 1213 with backoff.
  • Do I/O outside transactions. Use SELECT ... FOR UPDATE sparingly.

References:

Operations

  • Use online DDL (ALGORITHM=INPLACE) when possible; test on replicas first.
  • Tune connection pooling — avoid max_connections exhaustion under load.
  • Monitor replication lag; avoid stale reads from replicas during writes.

References:

Guardrails

  • Prefer measured evidence over blanket rules of thumb.
  • Note MySQL-version-specific behavior when giving advice.
  • Ask for explicit human approval before destructive data operations (drops/deletes/truncates).
BrowserAct

Let your agent run on any real-world website

Bypass CAPTCHA & anti-bot for free. Start local, scale to cloud.

Explore BrowserAct Skills →

Related skills

find-skills
2/3

Discover and install specialized agent skills from the open ecosystem when users need extended capabilities. Helps identify relevant skills by domain and task when users ask "how do I do X" or "find a skill for X" Integrates with the Skills CLI ( npx skills find , npx skills add ) to search, verify, and install packages from the skills.sh directory Recommends skills based on install count, source reputation, and GitHub stars to ensure quality before suggesting installation Presents skill options with install commands and links to skills.sh for user review and one-click installation

Verified authorvercel-labs
SKILLS.SH
1.5M19.6K
2026-05-22
vercel-react-best-practices
3/3

React and Next.js performance optimization guide with 64 prioritized rules across 8 categories. Organized by impact level, from critical waterfalls and bundle optimization down to advanced patterns, each rule includes incorrect/correct code examples and explanations Covers eight domains: async patterns, bundle size, server-side caching, client-side data fetching, re-render optimization, rendering performance, JavaScript efficiency, and advanced patterns Designed for use during component writing, code review, refactoring, and performance audits on React and Next.js applications Each rule has a prefix code (e.g., async-parallel , bundle-barrel-imports ) for easy reference in automated tooling and documentation

Verified authorvercel-labs
SKILLS.SH
389K26.9K
2026-05-22
azure-validate
2/3

Pre-deployment validation for Azure infrastructure, configuration, and permissions before deployment. Requires .azure/plan.md from a prior azure-prepare run; stops immediately if the plan is missing Executes recipe-specific validation commands (azd provision, bicep build, terraform validate) and records proof in the plan document Performs build verification, configuration checks, and permission validation; blocks deployment if any check fails Only authorized method to set plan status to Validated ; must be followed by azure-deploy skill to execute the actual deployment

Verified authormicrosoft
SKILLS.SH
324K1.1K
2026-05-22
appinsights-instrumentation
3/3

Guidance and reference material for instrumenting webapps with Azure Application Insights. Covers SDK setup, telemetry patterns, and configuration for ASP.NET Core and Node.js applications hosted in Azure Distinguishes between this skill (reference and guidance) and azure-prepare (actual implementation); invoke azure-prepare when the user wants to add instrumentation to their project Provides auto-instrumentation guidance for C# ASP.NET Core apps in Azure App Service, plus manual instrumentation paths for creating App Insights resources via Bicep templates or Azure CLI Includes language-specific code modification guides for ASP.NET Core, Node.js, and Python, plus quick references for OpenTelemetry SDKs and exporters

Verified authormicrosoft
SKILLS.SH
324K1.1K
2026-05-22

Stop writing automation&scrapers

Install the CLI. Run your first Skill in 30 seconds. Scale when you're ready.

Start free
free · no credit card