MCP.directory

analyzing-database-indexes

by jeremylongshore
2
0
Source

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.

Install

mkdir -p .claude/skills/analyzing-database-indexes && curl -L -o skill.zip "https://mcp.directory/api/skills/download/3840" && unzip -o skill.zip -d .claude/skills/analyzing-database-indexes && rm skill.zip

Installs to .claude/skills/analyzing-database-indexes

About this skill

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.

More by jeremylongshore

View all skills by jeremylongshore →

svg-icon-generator

jeremylongshore

Svg Icon Generator - Auto-activating skill for Visual Content. Triggers on: svg icon generator, svg icon generator Part of the Visual Content skill category.

6814

d2-diagram-creator

jeremylongshore

D2 Diagram Creator - Auto-activating skill for Visual Content. Triggers on: d2 diagram creator, d2 diagram creator Part of the Visual Content skill category.

2412

performing-penetration-testing

jeremylongshore

This skill enables automated penetration testing of web applications. It uses the penetration-tester plugin to identify vulnerabilities, including OWASP Top 10 threats, and suggests exploitation techniques. Use this skill when the user requests a "penetration test", "pentest", "vulnerability assessment", or asks to "exploit" a web application. It provides comprehensive reporting on identified security flaws.

379

designing-database-schemas

jeremylongshore

Design and visualize efficient database schemas, normalize data, map relationships, and generate ERD diagrams and SQL statements.

978

performing-security-audits

jeremylongshore

This skill allows Claude to conduct comprehensive security audits of code, infrastructure, and configurations. It leverages various tools within the security-pro-pack plugin, including vulnerability scanning, compliance checking, cryptography review, and infrastructure security analysis. Use this skill when a user requests a "security audit," "vulnerability assessment," "compliance review," or any task involving identifying and mitigating security risks. It helps to ensure code and systems adhere to security best practices and compliance standards.

86

analyzing-logs

jeremylongshore

Analyze application logs to detect performance issues, identify error patterns, and improve stability by extracting key insights.

965

You might also like

flutter-development

aj-geddes

Build beautiful cross-platform mobile apps with Flutter and Dart. Covers widgets, state management with Provider/BLoC, navigation, API integration, and material design.

643969

drawio-diagrams-enhanced

jgtolentino

Create professional draw.io (diagrams.net) diagrams in XML format (.drawio files) with integrated PMP/PMBOK methodologies, extensive visual asset libraries, and industry-standard professional templates. Use this skill when users ask to create flowcharts, swimlane diagrams, cross-functional flowcharts, org charts, network diagrams, UML diagrams, BPMN, project management diagrams (WBS, Gantt, PERT, RACI), risk matrices, stakeholder maps, or any other visual diagram in draw.io format. This skill includes access to custom shape libraries for icons, clipart, and professional symbols.

591705

ui-ux-pro-max

nextlevelbuilder

"UI/UX design intelligence. 50 styles, 21 palettes, 50 font pairings, 20 charts, 8 stacks (React, Next.js, Vue, Svelte, SwiftUI, React Native, Flutter, Tailwind). Actions: plan, build, create, design, implement, review, fix, improve, optimize, enhance, refactor, check UI/UX code. Projects: website, landing page, dashboard, admin panel, e-commerce, SaaS, portfolio, blog, mobile app, .html, .tsx, .vue, .svelte. Elements: button, modal, navbar, sidebar, card, table, form, chart. Styles: glassmorphism, claymorphism, minimalism, brutalism, neumorphism, bento grid, dark mode, responsive, skeuomorphism, flat design. Topics: color palette, accessibility, animation, layout, typography, font pairing, spacing, hover, shadow, gradient."

318399

godot

bfollington

This skill should be used when working on Godot Engine projects. It provides specialized knowledge of Godot's file formats (.gd, .tscn, .tres), architecture patterns (component-based, signal-driven, resource-based), common pitfalls, validation tools, code templates, and CLI workflows. The `godot` command is available for running the game, validating scripts, importing resources, and exporting builds. Use this skill for tasks involving Godot game development, debugging scene/resource files, implementing game systems, or creating new Godot components.

340397

nano-banana-pro

garg-aayush

Generate and edit images using Google's Nano Banana Pro (Gemini 3 Pro Image) API. Use when the user asks to generate, create, edit, modify, change, alter, or update images. Also use when user references an existing image file and asks to modify it in any way (e.g., "modify this image", "change the background", "replace X with Y"). Supports both text-to-image generation and image-to-image editing with configurable resolution (1K default, 2K, or 4K for high resolution). DO NOT read the image file first - use this skill directly with the --input-image parameter.

452339

fastapi-templates

wshobson

Create production-ready FastAPI projects with async patterns, dependency injection, and comprehensive error handling. Use when building new FastAPI applications or setting up backend API projects.

304231

Related MCP Servers

Browse all servers
Web FetcherWeb Fetcher

Web Fetcher uses Playwright for reliable data web scraping and extraction from JavaScript-heavy websites, returning clea

1,0023 tools
JetBrains IDE IndexJetBrains IDE Index

Supercharge your AI code assistant with JetBrains IDE Index. Unlock advanced code intelligence, navigation & refactoring

960 tools
Gemini Image GeneratorGemini Image Generator

Gemini Image Generator uses AI to create images with prompt enhancement, character consistency, and multi-image blending

790 tools
RtfmbroRtfmbro

Rtfmbro is an MCP server for config management tools—get real-time, version-specific docs from GitHub for Python, Node.j

774 tools
WordPressWordPress

Easily manage WP sites: posts, pages, users, plugins, themes, comments & more. Reliable wp manage tools integrated with

420 tools
AI VisionAI Vision

AI Vision uses Google Cloud Vertex AI to analyze images and videos, leveraging intelligent file handling for optimized u

420 tools

Stay ahead of the MCP ecosystem

Get weekly updates on new skills and servers.