Database Query Profiler
Helps with database, querying as part of working with databases and data persistence workflows.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add database-query-profiler npx -- -y @trustedskills/database-query-profiler
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"database-query-profiler": {
"command": "npx",
"args": [
"-y",
"@trustedskills/database-query-profiler"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
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.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.