slow-query-analysis
Analyze slow queries and suggest optimizations including missing indexes and query rewrites.
Skill by bonboncinnabon
Chalk Labs
Need help deploying slow-query-analysis?
Chalk Labs sets up agents like this inside real teams: connected to your tools, tested on your data, with a human in the loop where it matters.
Install
Works with Claude Code, Claude apps, Codex, Cursor, Gemini CLI, GitHub Copilot, VS Code, OpenCode, Goose, Windsurf. Read the repository before you give any tool access to your data.
npx agentmarket install skill/bonboncinnabon-slow-query-analysis
Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.
Get the weekly diff
The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.
About
Reviews
Write a reviewNo reviews yet. Installed it? Reviews come from verified installers only. How reviews work
Permissions
What this skill can do and what it asks for, from its SKILL.md. Checked Oct 25, 2026.
- Tools
- No tools found
- Secrets
- None asked for
- Install scripts
- None found
Network hosts it talks to 1
codeload.github.com· found in install command
Files it touches
~/.claude/skills/slow-query-analysis
What's inside
- Skill name
slow-query-analysis- Description
- Analyze slow queries and suggest optimizations including missing indexes and query rewrites. Use when investigating query performance, high CPU usage, or slow response times.
- License
- ISC
- Instructions
- 14 lines in SKILL.md · view on GitHub
Files (1)
- SKILL.md
SKILL.md (first lines)
Workflow: 1. Run get_slow_queries sorted by total_time to find biggest time consumers 2. For the top offender, run explain_query with analyze=true to see the actual execution plan 3. Look for: sequential scans on large tables (suggest index), nested loops with high row counts (suggest join rewrite), sorts spilling to disk (suggest work_mem increase or index) 4. Check list_indexes on affected tables to see what indexes exist 5. Suggest specific actions: CREATE INDEX statements, query rewrites, or configuration changes If pg_stat_statements is not installed, guide setup: - Add shared_preload_libraries = 'pg_stat_statements' to postgresql.conf - Restart PostgreSQL - Run CREATE EXTENSION pg_stat_statements - For RDS/Aurora: modify parameter group, reboot instance
From bonboncinnabon/postgres-mcp, ISC.
More from bonboncinnabon/postgres-mcp
- 0.427score
connection-debug
bonboncinnabon
Debug database connection issues including too many connections, idle transactions, lock contention, and connection pool exhaustion.
SkillDFreshness: D★ 1Claude Code +9 - 0.427score
database-health
bonboncinnabon
Diagnose database health issues including cache performance, connection saturation, vacuum status, and unused indexes.
SkillDFreshness: D★ 1Claude Code +9
Signals
- Stars
- 1
- Forks
- 0
- Open issues
- 1
- Last commit (this folder)
- Mar 8, 2026 (7 months ago)
- Last release
- Jun 16, 2025 (1 year ago)
From GitHub (fetched Oct 24, 2026).
Details
- License
- ISC
- Repository
- github.com/bonboncinnabon/postgres-mcp
- First seen
- Oct 24, 2026
- Last checked
- Oct 24, 2026
- Source
- GitHubgithub-graphql
More from bonboncinnabon
- 0.427score
connection-debug
bonboncinnabon
Debug database connection issues including too many connections, idle transactions, lock contention, and connection pool exhaustion.
SkillDFreshness: D★ 1Claude Code +9 - 0.427score
database-health
bonboncinnabon
Diagnose database health issues including cache performance, connection saturation, vacuum status, and unused indexes.
SkillDFreshness: D★ 1Claude Code +9
Done for you
Rather not set it up yourself?
Chalk Labs scopes, builds and runs agents for your team: the task audit, the eval harness, the integrations and the weekly ops report. Fixed scope, priced before we start.
See how we build AI agents →Read the case studies
Chalk Labs is a two-founder AI and growth studio. We build AI agents, CRMs and MVPs for Web3 and AI companies, and have shipped 50+ product and token launches.
- launches shipped
- 50+
- launches shipped
- media placements
- 500+
- media placements
- founders on every account
- 2
- founders on every account
Press we've placed: Forbes · CoinDesk · Decrypt · Cointelegraph · The Block
Rahil Jain, Co-founder, Chalk Labs. Ex-Goldman Sachs engineer. You talk to the person who builds it.
Get slow-query-analysis running in your business
Tell us what you want to automate. A founder replies within one working day with a plan, not a pitch deck.
Cite this page
slow-query-analysis skill. Agent Mart. https://agentmart.dev/skills/bonboncinnabon-slow-query-analysis (last updated 2026-10-24)