Design and optimize MySQL schemas, indexes, and queries.
npx skills add https://github.com/cooker/wx-apartment-ledger --skill mysql-cooker
Please help me install this Agent Skill. Skill: mysql Source: https://github.com/cooker/wx-apartment-ledger/tree/main/.agents/skills/mysql Command: npx skills add https://github.com/cooker/wx-apartment-ledger --skill mysql-cooker
The skill helps developers design, optimize, and query MySQL databases efficiently, reducing boilerplate and mistakes.
Design a basic users-posts schema and run a sample query to fetch recent posts with author names.
High-intent search queries and answers about installing and using this skill.
Design a scalable MySQL schema by applying best practices for relational data normalization, selecting appropriate data types, and structuring tables for users, posts, and comments to ensure robust data integrity.
Optimize read-heavy MySQL queries by implementing targeted indexing strategies, constructing efficient SQL syntax, and applying common performance patterns to reduce boilerplate and execution latency.
Manage database transactions and stored procedures by enforcing safe usage patterns and best practice templates to help developers write maintainable, efficient, and reliable MySQL code.
You need specific indexes when optimizing common SQL queries for typical application scenarios, ensuring your database design supports fast data retrieval without sacrificing maintainability.
Writing efficient MySQL code requires query optimization guidelines to reduce mistakes and boilerplate, guiding developers through safe schema design, indexing strategies, and transaction construction.
bradtaylorsfDesign relational and NoSQL data models with Prisma schema examples.
sigmadigitalzaReview database schemas, migration files, and query performance.
jayantrohila57Define TypeScript database schemas and write type-safe SQL queries.
snoodleboot-ioAssess application requirements and recommend suitable NoSQL database types.
