Skip to content
TrustedSkillsbeta
Back to all skills

Analyzing Database Indexes

Listed
jeremylongshore·vlatest·database·MIT

Identifies missing, redundant, or inefficient database indexes to optimize query performance based on usage patterns.

Repository

Install on your platform

Showing Claude Code. One command installs this skill into any of the agents below.

  1. 1

    Run this in your project

    terminal
    $ npx skills add jeremylongshore/tons-of-skills-marketplace --skill analyzing-database-indexes -a claude-code

  2. Uses the open-source skills CLI and needs Node.js. Add -g to install it for your user instead of this project.

What we know about this skill

Publisher

jeremylongshore

Taken from the source listing. We haven't verified who controls this account.

Install target

Live repository

Not pinned. Installing fetches whatever the repository holds at the time you run the command.

Nobody has reviewed this code. TrustedSkills indexes and links skills; it does not audit, run or scan them. A skill runs with whatever access you give your agent — read the source before you install it.

Automated safety checks

scanned

We could not read this skill's source, so none of the checks below were run.

Not scanned. none of the 396 skills in the repository match this slug — it was most likely renamed or removed upstream after the registry indexed it Source recorded as jeremylongshore/claude-code-plugins-plus-skills.
This is a static scan, not a review. It reads the skill's files; it does not run them, and it cannot tell you whether the skill is any good or whether the code does what its description says. A skill runs with whatever access you give your agent.
What each check looks for →

About this skill

What it does

This skill analyzes database indexes to identify potential performance bottlenecks and areas for optimization. It can assess index usage, fragmentation, and redundancy within a given database schema. The tool provides insights into how existing indexes impact query performance and suggests improvements or removals based on analysis.

When to use it

  • Slow Query Investigation: Identify if missing or inefficient indexes are contributing to slow query execution times.
  • Database Maintenance Planning: Determine which indexes require maintenance (e.g., rebuilding, reorganizing) due to fragmentation.
  • Schema Optimization: Evaluate the overall index strategy for a database and identify redundant or unused indexes that can be removed.
  • Performance Tuning After Changes: Analyze index performance after significant data changes or application updates.

Key capabilities

  • Index usage analysis
  • Fragmentation assessment
  • Redundancy detection
  • Performance impact evaluation
  • Optimization suggestions

Example prompts

  • "Analyze the indexes on the 'orders' table in my database."
  • "Identify any redundant indexes within the 'customers' schema."
  • "What is the fragmentation level of the index on the 'product_id' column?"

Tips & gotchas

This skill requires access to the database schema and metadata. Ensure the AI agent has appropriate permissions to query system views or catalog tables for index information.