majiayu000/claude-arsenal
xiaohongshu
xiaohongshu
286 148
View 
SKILL.md
Full skill instructions
Backend Database Skills
🤖 智能体与 MCP 增强 (Agent & MCP Enhancements)
本 Skill 支持并推荐配合特定的智能体角色和 MCP 工具使用，以获得最佳效果。
推荐智能体角色
- Database Consultant: 详见 AGENTS.md。
- 该角色专注于数据库架构设计、性能调优和数据安全。
- 启用后，AI 将优先进行 Schema 内省和执行计划分析。
推荐 MCP 工具
- PostgreSQL/MySQL MCP: 允许 AI 直接连接数据库，获取实时的 Schema 信息和执行 EXPLAIN 分析，而不仅仅是基于静态代码推断。
- mcp-feedback-enhanced: 允许 AI 在设计表结构或优化策略时，如果遇到不确定性，使用
ask_followup_question等工具主动向用户确认业务需求或权衡方案。
提供专业的数据库开发与维护能力，帮助你构建高性能、高可靠的数据层。
包含的技能模块
1. SQL 优化模式 (SQL Optimization)
- 核心价值: 解决慢查询，提升数据库性能。
- 关键技术: EXPLAIN 分析, 索引策略, N+1 问题修复.
- 使用场景: 数据库性能瓶颈分析、复杂查询优化。
2. 数据库迁移 (Database Migration)
- 核心价值: 安全、可控地变更数据库结构。
- 关键技术: 迁移脚本编写, 向后兼容性, 零停机迁移.
- 使用场景: 版本迭代、Schema 变更、数据清洗。
如何使用
- 性能调优: "请使用 SQL 优化模式帮我分析这条查询语句为什么这么慢。"
- 结构变更: "请参考数据库迁移指南，帮我写一个给用户表添加字段的迁移脚本。"
More skills from majiayu000
majiayu000/claude-arsenal
technical-spec
technical spec
286 141
View majiayu000/claude-arsenal
product-ux-expert
product ux expert
286 133
View majiayu000/claude-arsenal
database-patterns
database patterns
286 119
View majiayu000/claude-skill-registry
agent-task-conductor
Conduct multi-agent task orchestration and workflow coordination.
663 1
View majiayu000/claude-skill-registry
conductor-setup
Initialize project with Conductor artifacts (product definition,
663 1
View majiayu000/claude-skill-registry
animation-designer
Expert in web animations, transitions, and motion design using Framer Motion and CSS
663 1
View majiayu000/claude-skill-registry
diagramming
Creates Mermaid and ASCII diagrams for flowcharts, architecture, ERDs, state machines, mindmaps, and more. Use when user mentions diagram, flowchart, mermaid, ASCII diagram, text diagram, terminal diagram, visualize, C4, mindmap, architecture diagram, sequence diagram, ERD, or needs visual docume...
663 1
View majiayu000/claude-skill-registry-data
h3-pg
PostgreSQL bindings for H3 hexagonal grid system. Use when working with H3 cells in Postgres, including spatial indexing, geometry/geography integration, and raster analysis.
23 1
View majiayu000/claude-skill-registry
conductor-development
Context-Driven Development skill for projects using Conductor. Use this skill when you detect a `conductor/` directory in the project, when working on tasks defined in a `plan.md` file, or when the user asks about tracks, specs, or plans. Automatically applies TDD workflow, tracks task completion...
663 1
View majiayu000/claude-skill-registry
conductor-status
Display project status, active tracks, and next actions
663 1
View majiayu000/claude-skill-registry
dockerization
Official Stakpak application containerization standard operating procedure, a step-by-step guidline to properly dockerize applications. This is a rule book curated by the Stakpak Team.
663 1
View Popular AI tools
Video
Kaiber
Generate, edit, and beat-sync AI video with leading models in one workspace.
Paid
View Productivity
Vimcal
The world's fastest calendar for remote work
Free
View I
Images
IMGCreator.ai
Transform Your Design with AI Designer by ImgCreator.ai
Freemium
View Content & writing
Akool AI
Revolutionizing Video Production with AI-Powered Creativity
Paid
View Images
Clipdrop Uncrop
Extend an image past the frame and let AI fill the new aspect ratio.
Freemium
View Security
StarByFace
Discover your celebrity doppelgänger with StarByFace!
Free
View C
Finance
ChainClarity
ChainClarity explains 700+ crypto whitepapers in plain English, with layered summaries, comparisons, research tools, alerts, and a $4.99 Pro plan.
Freemium
View Coding & apps
Opus Clip
Opus.ai: Revolutionize Your Web Experience
Free
View