Backend Database Expert
About
This skill provides expert guidance on database design, SQL optimization, and migration strategies. It helps developers analyze slow queries, design efficient schemas, and execute safe database changes. Key features include EXPLAIN analysis, index optimization, and zero-downtime migration planning.
Quick Install
Claude Code
Recommended/plugin add https://github.com/majiayu000/claude-skill-registrygit clone https://github.com/majiayu000/claude-skill-registry.git ~/.claude/skills/Backend Database ExpertCopy and paste this command in Claude Code to install this skill
Documentation
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 优化模式帮我分析这条查询语句为什么这么慢。"
- 结构变更: "请参考数据库迁移指南,帮我写一个给用户表添加字段的迁移脚本。"
GitHub Repository
Related Skills
content-collections
MetaThis skill provides a production-tested setup for Content Collections, a TypeScript-first tool that transforms Markdown/MDX files into type-safe data collections with Zod validation. Use it when building blogs, documentation sites, or content-heavy Vite + React applications to ensure type safety and automatic content validation. It covers everything from Vite plugin configuration and MDX compilation to deployment optimization and schema validation.
llamaindex
MetaLlamaIndex is a data framework for building RAG-powered LLM applications, specializing in document ingestion, indexing, and querying. It provides key features like vector indices, query engines, and agents, and supports over 300 data connectors. Use it for document Q&A, chatbots, and knowledge retrieval when building data-centric applications.
hybrid-cloud-networking
MetaThis skill configures secure hybrid cloud networking between on-premises infrastructure and cloud platforms like AWS, Azure, and GCP. Use it when connecting data centers to the cloud, building hybrid architectures, or implementing secure cross-premises connectivity. It supports key capabilities such as VPNs and dedicated connections like AWS Direct Connect for high-performance, reliable setups.
polymarket
MetaThis skill enables developers to build applications with the Polymarket prediction markets platform, including API integration for trading and market data. It also provides real-time data streaming via WebSocket to monitor live trades and market activity. Use it for implementing trading strategies or creating tools that process live market updates.
