鱼皮AI导航
鱼皮AI导航
  • 主页
  • 社区
  • AI工具
  • AI知识库
  • AI提示词
  • MCP
  • Skills
  • AI学习资源
  • AI资讯
  • GitHub开源
登录/注册

database-index-advisor

通过分析数据库查询负载与现有索引配置,自动识别缺失的高效索引以加速慢查询,同时发现长期未被使用的冗余索引以便清理,从而在提升读取性能的同时节省存储并优化写入效率。

数据与分析数据库
访问 GitHub
文档Skills.MD
name
analyzing-database-indexes
description
This skill uses the database-index-advisor plugin to analyze query patterns and recommend optimal database indexes. It identifies missing indexes to improve query performance and unused indexes that can be removed to save storage and improve write performance. Use this skill when the user asks to "analyze database indexes", "optimize slow queries", "find missing indexes", "remove unused indexes", or requests help with "database index optimization". The plugin analyzes database workloads, detects potential indexing issues, and provides actionable recommendations for indexing strategies.
allowed-tools
Read, Write, Edit, Grep, Glob, Bash
version
1.0.0

Overview

This skill empowers Claude to analyze database workloads, identify suboptimal or missing indexes, and suggest improvements to enhance database performance. It leverages the database-index-advisor plugin to provide concrete recommendations for indexing strategies, including identifying unused indexes for removal.

How It Works

  1. Initiate Analysis: The skill activates the database-index-advisor plugin.
  2. Workload Analysis: The plugin analyzes the database's query workload and existing index configurations.
  3. Recommendation Generation: The plugin identifies missing index opportunities and unused indexes, generating a report with suggested actions.

When to Use This Skill

This skill activates when you need to:

  • Optimize slow-running database queries.
  • Identify potential performance bottlenecks related to missing indexes.
  • Reclaim storage space by identifying and removing unused indexes.

Examples

Example 1: Optimizing a Slow Query

User request: "My orders table query is running slowly. Can you help optimize it?"

The skill will:

  1. Activate the database-index-advisor plugin.
  2. Analyze the query patterns against the orders table.
  3. Recommend creating a specific index on the orders table to improve query performance.

Example 2: Identifying Unused Indexes

User request: "Can you help me identify and remove any unused indexes in my database?"

The skill will:

  1. Activate the database-index-advisor plugin.
  2. Analyze the existing indexes and their usage patterns.
  3. Generate a report listing unused indexes that can be safely removed.

Best Practices

  • Database Connection: Ensure the database connection is properly configured for the plugin to access the database.
  • Permissions: Grant the plugin the necessary permissions to analyze query patterns and retrieve index information.
  • Impact Assessment: Review the recommended index changes and assess their potential impact on other queries before applying them.

Integration

This skill can be used in conjunction with other database management plugins to automate index creation and removal based on the advisor's recommendations. It also integrates with monitoring tools to track the performance impact of the applied index changes.

数据与分析
数据库

快捷安装

复制到终端去安装 Skill

npxskillsaddjeremylongshore/claude-code-plugins-plus-skills--skill"database-index-advisor"
站长:程序员鱼皮 老鱼简历 商务合作 增值电信业务经营许可证
2026 鱼皮AI导航 | 沪ICP备19026706号-6
站长:程序员鱼皮 老鱼简历 商务合作 增值电信业务经营许可证
2026 鱼皮AI导航 | 沪ICP备19026706号-6
🔥热门工具
朱雀AI检测朱雀AI检测
朱雀AI检测助手朱雀AI检测助手
LovartLovart
老鱼简历老鱼简历
WritePass官网WritePass官网
面多多面多多
CursorCursor
星月写作星月写作
朱雀AI检测助手朱雀AI检测助手
零感AI零感AI
Skills 推荐
definition-of-done-generator
自动生成项目完成标准的规范定义与配置文件,提供符合企业级工作流要求的最佳实践指导,输出可直接投入生产环境的代码和验证结果,适用于需要标准化流程审批、合规审查及跨系统集成的复杂项目管理场景。
sagemaker-endpoint-deployer
自动化部署机器学习模型至云端服务端点,支持从配置生成到生产验证的全流程,适用于模型上线、服务监控与推理优化等场景,确保部署方案符合工业级标准。
docx
支持专业级 Word 文档的全生命周期处理,包括从零创建结构化文档、精准编辑内容、管理修订痕迹与批注、提取纯文本或原始 XML 数据、转换为 PDF 或图像用于视觉分析,适用于法律、学术及企业场景下的高保真文档协作与自动化处理。
skills-search
提供对 Claude Code 技能生态的全周期管理能力,支持按功能关键词检索技能、查看详细信息、安装或卸载指定技能,并区分用户级与项目级作用域,覆盖发现、评估、部署及维护各环节。
moai-foundation-core
构建高质量、可扩展的AI开发工作流,通过领域驱动设计与模块化架构实现需求规范先行,结合自动化质量门禁、精细化上下文管理与渐进式知识呈现,在保障安全与可维护性的同时提升开发效率与协作清晰度。