{"id":"7a2c2e89-ca6e-4a19-a71a-f5dbf7d9fc30","shortId":"xMzZWe","kind":"skill","title":"Turn PostgreSQL logs into incident and tuning reports with pgBadger","tagline":"Use pgBadger when an agent needs to convert raw PostgreSQL logs into readable evidence about slow queries, errors, and workload hotspots after an incident.","description":"# Turn PostgreSQL logs into incident and tuning reports with pgBadger\n\nUse pgBadger when an agent needs to convert raw PostgreSQL logs into readable evidence about slow queries, errors, and workload hotspots after an incident.\n\n## Prerequisites\n\npgBadger, PostgreSQL logs with compatible log settings, and a shell environment for report generation.\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- make && sudo make install\n\nRequirements and caveats from upstream:\n- Requires incremental output directories and the\n- month. Requires incremental output directories and\n- You must enable and set some configuration directives in your postgresql.conf\n\nBasic usage or getting-started notes:\n- PostgreSQL log analyzer with fully detailed reports and graphs.\n- Arguments:\n- logfile can be a single log file, a list of files, or a shell command\n\n- Source: https://github.com/darold/pgbadger\n- Extracted from upstream docs: https://raw.githubusercontent.com/darold/pgbadger/HEAD/README.md\n\n## Documentation\n\n- https://pgbadger.darold.net/\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/turn-postgresql-logs-into-incident-and-tuning-reports-with-pgbadger/)","tags":["turn","postgresql","logs","into","incident","and","tuning","reports","with","pgbadger","skills","agentskillexchange"],"capabilities":["skill","source-agentskillexchange","skill-turn-postgresql-logs-into-incident-and-tuning-reports-with-pgbadger","topic-agent-skills","topic-ai-agents","topic-ai-tools","topic-awesome-list","topic-claude-code","topic-codex","topic-cursor","topic-llm","topic-mcp","topic-npx-skills","topic-openclaw","topic-skills-catalog"],"categories":["skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/agentskillexchange/skills/turn-postgresql-logs-into-incident-and-tuning-reports-with-pgbadger","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add agentskillexchange/skills","source_repo":"https://github.com/agentskillexchange/skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,216 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T19:12:57.069Z","embedding":null,"createdAt":"2026-05-18T13:20:06.321Z","updatedAt":"2026-05-18T19:12:57.069Z","lastSeenAt":"2026-05-18T19:12:57.069Z","tsv":"'/darold/pgbadger':163 '/darold/pgbadger/head/readme.md':170 '/skills/turn-postgresql-logs-into-incident-and-tuning-reports-with-pgbadger/)':179 'agent':15,49,174 'agentskillexchange.com':178 'agentskillexchange.com/skills/turn-postgresql-logs-into-incident-and-tuning-reports-with-pgbadger/)':177 'analyz':137 'argument':144 'basic':128 'caveat':102 'command':159 'compat':74 'configur':123 'convert':18,52 'detail':140 'direct':124 'directori':108,115 'doc':167 'document':171 'enabl':119 'environ':80,95 'error':28,62 'evid':24,58 'exchang':176 'extract':164 'file':151,155 'fulli':139 'generat':83 'get':132 'getting-start':131 'github.com':162 'github.com/darold/pgbadger':161 'graph':143 'hotspot':31,65 'incid':5,34,39,68 'increment':106,113 'instal':84,88,99 'list':153 'log':3,21,37,55,72,75,136,150 'logfil':145 'make':96,98 'match':93 'month':111 'must':118 'need':16,50 'note':134 'output':107,114 'path':91 'pgbadger':10,12,44,46,70 'pgbadger.darold.net':172 'postgresql':2,20,36,54,71,135 'postgresql.conf':127 'prerequisit':69 'queri':27,61 'raw':19,53 'raw.githubusercontent.com':169 'raw.githubusercontent.com/darold/pgbadger/head/readme.md':168 'readabl':23,57 'report':8,42,82,141 'requir':100,105,112 'set':76,121 'setup':90 'shell':79,158 'singl':149 'skill':175 'skill-turn-postgresql-logs-into-incident-and-tuning-reports-with-pgbadger' 'slow':26,60 'sourc':160,173 'source-agentskillexchange' 'start':133 'sudo':97 'topic-agent-skills' 'topic-ai-agents' 'topic-ai-tools' 'topic-awesome-list' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-llm' 'topic-mcp' 'topic-npx-skills' 'topic-openclaw' 'topic-skills-catalog' 'tune':7,41 'turn':1,35 'upstream':87,104,166 'usag':129 'use':11,45,85 'workload':30,64","prices":[{"id":"72b55fb9-f120-49c7-b6d0-b4a338e7b4e7","listingId":"7a2c2e89-ca6e-4a19-a71a-f5dbf7d9fc30","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"agentskillexchange","category":"skills","install_from":"skills.sh"},"createdAt":"2026-05-18T13:20:06.321Z"}],"sources":[{"listingId":"7a2c2e89-ca6e-4a19-a71a-f5dbf7d9fc30","source":"github","sourceId":"agentskillexchange/skills/turn-postgresql-logs-into-incident-and-tuning-reports-with-pgbadger","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/turn-postgresql-logs-into-incident-and-tuning-reports-with-pgbadger","isPrimary":false,"firstSeenAt":"2026-05-18T13:20:06.321Z","lastSeenAt":"2026-05-18T19:12:57.069Z"}],"details":{"listingId":"7a2c2e89-ca6e-4a19-a71a-f5dbf7d9fc30","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"turn-postgresql-logs-into-incident-and-tuning-reports-with-pgbadger","github":{"repo":"agentskillexchange/skills","stars":8,"topics":["agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor","llm","mcp","npx-skills","openclaw","skills-catalog"],"license":"mit","html_url":"https://github.com/agentskillexchange/skills","pushed_at":"2026-05-18T19:02:17Z","description":"The open catalog of AI agent skills — 2,000+ security-scanned skills for Claude Code, Cursor, Codex, and more.","skill_md_sha":"be88f2fb2101be761b99dfc3282989f525e860f8","skill_md_path":"skills/turn-postgresql-logs-into-incident-and-tuning-reports-with-pgbadger/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/turn-postgresql-logs-into-incident-and-tuning-reports-with-pgbadger"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"Turn PostgreSQL logs into incident and tuning reports with pgBadger","description":"Use pgBadger when an agent needs to convert raw PostgreSQL logs into readable evidence about slow queries, errors, and workload hotspots after an incident."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/turn-postgresql-logs-into-incident-and-tuning-reports-with-pgbadger"},"updatedAt":"2026-05-18T19:12:57.069Z"}}