Skip to content
TrustedSkillsbeta
Back to all skills

Database Query Profiler

Listed
jeremylongshore·vlatest·database·MIT

Helps with database, querying as part of working with databases and data persistence workflows.

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 database-query-profiler -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

The database-query-profiler skill analyzes SQL queries to identify performance bottlenecks. It provides detailed insights into query execution plans, resource consumption (CPU, I/O), and potential areas for optimization. This allows users to understand why a query is slow and make informed decisions about how to improve its efficiency.

When to use it

  • Slow Report Generation: Investigate why generating a specific report takes an unexpectedly long time.
  • Database Performance Issues: Diagnose general database slowdowns or performance regressions after code deployments.
  • Query Optimization: Identify inefficient SQL queries that could benefit from rewriting or indexing improvements.
  • Resource Monitoring: Track the resource usage of critical database operations to ensure efficient utilization.

Key capabilities

  • SQL query analysis
  • Execution plan visualization
  • Resource consumption metrics (CPU, I/O)
  • Performance bottleneck identification

Example prompts

  • "Profile this SQL query: SELECT * FROM orders WHERE customer_id = 123;"
  • "Analyze the performance of the 'generate_daily_sales_report' stored procedure."
  • "Show me a breakdown of resource usage for the last hour of queries against the 'products' table."

Tips & gotchas

The skill requires access to the database server and appropriate permissions to execute queries and retrieve execution plans. Results are highly dependent on the specific database system being used (e.g., MySQL, PostgreSQL) as query plan formats vary.