analyze-db-performance SKILL.md skillA

analyze-db-performance from sgaunet/claude-plugins is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add sgaunet/claude-plugins/analyze-db-performance@git:20260924.72c544d

Pins git:20260924.72c544d in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
sgaunet/claude-plugins
Path
plugins/devops-infrastructure/skills/analyze-db-performance/SKILL.md
Versions recorded
1
Latest version
git:20260924.72c544d, committed Sep 24, 2026
Size
6,957 bytes
Repository stars
18
License
MIT

Analyze PostgreSQL performance with query and index insights.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Analyze Database Performance

Analyze PostgreSQL database performance using pg_stat_statements, slow query logs, and system metrics.

## Process

1. **Validate Input**: Check if argument is:
   - Database connection string (postgres://...)
   - Path to slow query log file
   - None (will look for local log files)

2. **Gather Performance Data**: Launch 3 parallel Haiku agents to collect database metrics concurrently:

   **Agent #1: Slow Query Analyzer**
   - If connection string: Execute query against pg_stat_statements
     ```sql
     SELECT query, calls, total_exec_time, mean_exec_time, max_exec_time
     FROM pg_stat_statements
     ORDER BY mean_exec_time DESC
     LIMIT 20;
     ```
   - If log file: Parse slow query log and extract patterns
   - Return: list of top 20 slowest queries with execution stats

   **Agent #2: Table Size Analyzer**
   - If connection string: Execute table size query
     ```sql
     SELECT schemaname, tablename,
            pg_size_pretty(pg_total_relation_size(schemaname||'.'||tablename))
     FROM pg_tables
     ORDER BY pg_total_relation_size(schemaname||'.'||tablename) DESC;
     ```
   - Return: list of tables sorted by size
…

Read the whole file at its exact version.

How to install

No tool to install first
claude plugin marketplace add https://markdownregistry.com/mp/a/art_v3sbvsho7kvlcnuh/2f6daf9d6bc3f0690a33176206a589e22309a75e7fdc75046cbbc5dcf3b694d4.json

Then /plugin install analyze-db-performance@markdownregistry-v3sbvsho7kvlcnuh in Claude Code. It installs git:20260924.72c544d, the one graded A here, pinned to the commit it was graded at, and leaves it there.

The exact contents, by fingerprint
mdr add sgaunet/claude-plugins/analyze-db-performance@sha256:2f6daf9d6bc3f069

The line at the top of this page pins the label git:20260924.72c544d, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_v3sbvsho7kvlcnuh.svg)](https://markdownregistry.com/a/art_v3sbvsho7kvlcnuh)

2 badge image fetches in 30 days. What the badge shows.

Ask from your agent
claude mcp add --transport http markdownregistry https://markdownregistry.com/mcp/registry

Then ask it: what changed in sgaunet/claude-plugins/analyze-db-performance since the version I have? It reads every saved version here, no key and no account. Any agent that speaks MCP can add it.

Got a copy of analyze-db-performance from somewhere else? Ask it: where did my analyze-db-performance come from, and what was changed? It names the public original, the version yours is closest to and every changed line. The text is not kept.

Versions

The registry has recorded 1 version of this file, committed on Sep 24, 2026.

Watch this file (sign in, one email per new version)

versioncommittedcommitsizeaudit
git:20260924.72c544d latest2026-09-24 72c544d 6,957 BA view
Keep it current by itself, install once

Committed this skill to a repository? Install the markdownregistry skill updates app on it, or on all of them. When the registry saves a newer version, a pull request brings your copy to it within minutes, the newest version first, then what changed and any check it newly trips. A copy you edited is never touched, and nothing is deleted.

Install on GitHub

It asks to read and write contents and pull requests, and to read metadata. No workflow file, no Actions setting, nothing runs on your runners. Uninstall it and everything the registry kept about your repository is deleted.

Keep it current by itself

Committed this skill to a repository? Add one workflow file, and when a newer version is saved, a pull request brings your copy to it, the newest version first, then what changed and any check it newly trips. A copy you edited is never touched, and nothing is deleted.

mkdir -p .github/workflows && curl -fsSL https://markdownregistry.com/ci/skill-updates.yml -o .github/workflows/skill-updates.yml

It runs daily on GitHub Actions, no key and no account. Read the workflow before you add it.

Check a whole project

From the root of your project, one line hashes each installed skill's SKILL.md, your AGENTS.md and your CLAUDE.md, and asks the registry once. Only the fingerprints and paths are sent.

sha256sum .claude/skills/*/SKILL.md AGENTS.md CLAUDE.md | curl -s --data-binary @- https://markdownregistry.com/api/v1/check-copies

In CI, add --fail-with-body: the answer is 409 when any file is behind, so the step fails and still prints which files.

sha256sum .claude/skills/*/SKILL.md AGENTS.md CLAUDE.md | curl -s --fail-with-body --data-binary @- https://markdownregistry.com/api/v1/check-copies

No sha256sum on your machine? shasum -a 256 prints the same lines.

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (6957 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

sgaunet/claude-plugins · 18 stars · license MIT · pushed 2026-10-22 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_v3sbvsho7kvlcnuh
GET https://markdownregistry.com/api/v1/resolve?ref=sgaunet/claude-plugins/analyze-db-performance
GET https://markdownregistry.com/api/v1/blob/2f6daf9d6bc3f0690a33176206a589e22309a75e7fdc75046cbbc5dcf3b694d4

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from sgaunet/claude-plugins

sylvain-marketplace Plugin marketplace
sgaunet/claude-plugins · .claude-plugin/marketplace.json · Specialized Claude Code agents for DevOps infrastructure, software engineering workflows, and Go development. Includes…
v0.21.0 · audit A · 18 stars
audit-plugins SKILL.md skill
sgaunet/claude-plugins · .claude/skills/audit-plugins/SKILL.md · Audit all plugins for adherence to Claude Code official best practices
git:20260924.72c544d · audit A · 18 stars
CLAUDE.md CLAUDE.md file
sgaunet/claude-plugins · CLAUDE.md
git:20260924.72c544d · audit A · 18 stars
gum-beautify SKILL.md skill
sgaunet/claude-plugins · plugins/bash-specialist/skills/gum-beautify/SKILL.md · Integrate Charmbracelet gum for beautiful, TTY-safe terminal output in bash scripts: interactive prompts, styled…
git:20260823.846402d · audit A · 18 stars
gen-forgejo-dir SKILL.md skill
sgaunet/claude-plugins · plugins/go-specialist/skills/gen-forgejo-dir/SKILL.md · Generate complete .forgejo/workflows directory with Forgejo Actions workflows (test, lint, release) for Go projects
git:20260924.72c544d · audit A · 18 stars
gen-github-dir SKILL.md skill
sgaunet/claude-plugins · plugins/go-specialist/skills/gen-github-dir/SKILL.md · Generate complete .github directory with workflows, dependabot, and funding configs for Go projects
git:20260924.72c544d · audit A · 18 stars
gen-gitlab-ci SKILL.md skill
sgaunet/claude-plugins · plugins/go-specialist/skills/gen-gitlab-ci/SKILL.md · Generate GitLab CI/CD pipeline configuration for Go projects with testing, coverage, and automated releases
git:20260924.72c544d · audit A · 18 stars
gen-goreleaser SKILL.md skill
sgaunet/claude-plugins · plugins/go-specialist/skills/gen-goreleaser/SKILL.md · Generate GoReleaser configuration with multi-arch Docker builds and release automation
git:20260924.72c544d · audit A · 18 stars
gen-linter SKILL.md skill
sgaunet/claude-plugins · plugins/go-specialist/skills/gen-linter/SKILL.md · Generate .golangci.yml configuration for Go linting with 90+ linters
git:20260924.72c544d · audit A · 18 stars
gen-taskfiles SKILL.md skill
sgaunet/claude-plugins · plugins/go-specialist/skills/gen-taskfiles/SKILL.md · Generate mise.toml, Taskfile.yml, Taskfile_dev.yml, and .pre-commit-config.yaml for Go projects with comprehensive task…
git:20260924.72c544d · audit B · 18 stars
go-blackbox SKILL.md skill
sgaunet/claude-plugins · plugins/go-specialist/skills/go-blackbox/SKILL.md · Detect white box Go tests and propose conversion to black box tests (package foo_test), creating export_test.go bridges…
git:20260823.846402d · audit A · 18 stars
go-bulma SKILL.md skill
sgaunet/claude-plugins · plugins/go-specialist/skills/go-bulma/SKILL.md · Scaffold the Bulma CSS framework into a Go web app with embedded assets for zero-dependency binaries. Use when building…
git:20260823.846402d · audit B · 18 stars

Every file in sgaunet/claude-plugins

Browse by kind, by grade A, or by owner.