Database Index Advisor
Analyze query patterns and recommend optimal database indexes with impact analysis
- Type
- Plugin
- Repository
- jeremylongshore/tons-of-skills-marketplace
- GitHub stars
- 2.8k
- License
- MIT
- Repo last updated
- Sep 27, 2026
- Version
- 1.27.0
- Author
- Claude Code Plugins
What Database Index Advisor is
Database Index Advisor is a plugin published in the jeremylongshore/tons-of-skills-marketplace repository on GitHub, which has about 2.8k stars. The repository describes itself as: “Model-agnostic agent-skills platform with a harness-free canonical layer, verified adapters, and the ccpi package manager. Explore at tonsofskills.com.”
A plugin is a package that bundles skills, slash commands, subagents, hooks, and MCP connectors so they install together. Plugins are plain files with a manifest at .claude-plugin/plugin.json, and they work in both Claude Code and Claude Cowork.
Installing Database Index Advisor adds everything it ships in one step. Connectors inside a plugin still need to be connected separately, and hooks and subagents only run in Cowork and Claude Code, not in regular chat.
How to install Database Index Advisor
Claude Code
- Add the repository as a plugin marketplace: claude plugin marketplace add jeremylongshore/tons-of-skills-marketplace
- Install the plugin: claude plugin install database-index-advisor@<marketplace-name>, using the marketplace name from the repository's .claude-plugin/marketplace.json.
- Restart the session if the new skills or commands don't appear straight away.
Claude Cowork
- Open Customize → Plugins and choose Add marketplace.
- Enter jeremylongshore/tons-of-skills-marketplace (the owner/repo shorthand works for GitHub).
- Find Database Index Advisor in the list, click Install, then connect any connectors it needs from its Connectors tab.
New to extending Cowork? Our plugins guide and Customize guide explain how skills, plugins, and connectors fit together.
Inside the source file
An excerpt from plugins/database/database-index-advisor/.claude-plugin/plugin.json, shared under the repository's MIT license. Read the full file on GitHub.
Analyze query patterns and recommend optimal database indexes with impact analysis
Installation
/plugin install database-index-advisor@claude-code-plugins-plusUsage
/index-advisorFeatures
- Database best practices
- Multi-database support
- Production-ready implementations
- Comprehensive documentation
Requirements
- Database access
- Appropriate permissions
Files
- commands/index-advisor.md or agents/index-advisor-agent.md - Main plugin logic
License
MIT
Before you install
- Read the whole file first. Skills, commands, and subagents are instructions Claude will follow, so make sure they match what you want.
- Check which tools, scripts, or MCP servers it uses. Local servers and scripts run with your permissions.
- Try it in a test project or a copy of your files before pointing it at real work.
- Pin the version you tested, and review changes before updating.
- Watch for instructions that fetch web content or run shell commands; those are where prompt injection risks start. See our prompt injection guide.
FAQ
What is Database Index Advisor?
Database Index Advisor is a plugin for Claude Code and Claude Cowork from the jeremylongshore/tons-of-skills-marketplace repository on GitHub. Analyze query patterns and recommend optimal database indexes with impact analysis
How do I install Database Index Advisor in Claude Code?
Add the repository as a plugin marketplace: claude plugin marketplace add jeremylongshore/tons-of-skills-marketplace Install the plugin: claude plugin install database-index-advisor@<marketplace-name>, using the marketplace name from the repository's .claude-plugin/marketplace.json. Restart the session if the new skills or commands don't appear straight away.
Can I use Database Index Advisor in Claude Cowork?
Open Customize → Plugins and choose Add marketplace. Enter jeremylongshore/tons-of-skills-marketplace (the owner/repo shorthand works for GitHub). Find Database Index Advisor in the list, click Install, then connect any connectors it needs from its Connectors tab.
Is Database Index Advisor safe to install?
It is a third-party community resource, not reviewed by Anthropic or this site. Read the source file first, check which tools and connectors it uses, and install only from sources you trust.
Similar resources
- Monitor Whales Monitor whale transactions in real-time with market impact analysis and Slash Command · jeremylongshore/tons-of-skills-marketplace
- Monitoring Stack Deployer Deploy monitoring stacks (Prometheus, Grafana, Datadog) Plugin · jeremylongshore/tons-of-skills-marketplace
- Model Selector Recommends the right LLM model for any task by weighing quality, latency, cost, and context-window requirements across OpenAI, Anthropic, Google, and open-source options. Use when choosing a model for a new feature or reducing spend without sacrificing quality. Trigger with "which model should I use", "pick the best LLM for this". Subagent · jeremylongshore/tons-of-skills-marketplace
- Monitoring Setup Set up monitoring stack with Prometheus, Grafana, alerts Slash Command · jeremylongshore/tons-of-skills-marketplace
- Database Migration Manager Manage database migrations with version control, rollback capabilities, and automated schema evolution tracking Plugin · jeremylongshore/tons-of-skills-marketplace
- Database Health Monitor Database plugin for database-health-monitor Plugin · jeremylongshore/tons-of-skills-marketplace
- Database Partition Manager Database plugin for database-partition-manager Plugin · jeremylongshore/tons-of-skills-marketplace
- Database Documentation Gen Database plugin for database-documentation-gen Plugin · jeremylongshore/tons-of-skills-marketplace