🤖 Agent & MCP Enhancements
This Skill supports and recommends use with specific agent roles and MCP tools for optimal results.
Recommended Agent Roles
- Database Consultant: See AGENTS.md。
- This role focuses on database architecture design, performance tuning, and data security.
- Once enabled, the AI will prioritize Schema introspection and execution plan analysis.
Recommended MCP Tools
- PostgreSQL/MySQL MCP: Allows the AI to connect directly to the database, obtain real-time Schema information and perform EXPLAIN analysis, rather than merely inferring based on static code.
- mcp-feedback-enhanced: Allows the AI, when designing table structures or optimization strategies, to use
ask_followup_questionand other tools to proactively confirm business requirements or trade-off options with the user if uncertainty arises.
Provides professional database development and maintenance capabilities, helping you build a high-performance, highly reliable data layer.
Included Skill Modules
1. SQL Optimization
- Core Value: Solve slow queries and improve database performance.
- Key Techniques: EXPLAIN analysis, indexing strategies, N+1 problem fixes.
- Use Cases: Database performance bottleneck analysis, complex query optimization.
2. Database Migration
- Core Value: Safely and controllably change database structures.
- Key Techniques: Migration script writing, backward compatibility, zero-downtime migration.
- Use Cases: Version iterations, Schema changes, data cleansing.
How to Use
- Performance Tuning: "Please use SQL Optimization to help me analyze why this query statement is so slow."
- Structural Changes: "Please refer to the Database Migration guide and help me write a migration script to add a field to the user table."