PostgreSQL Diagnostic Analyzer by agentskillexchange/skills
npx skills add https://github.com/agentskillexchange/skills --skill 'PostgreSQL Diagnostic Analyzer'利用 pg_stat_statements、pg_stat_activity 和 pg_locks 系统视图对 PostgreSQL 运行诊断查询。通过 pgstattuple 和 pg_repack 扩展分析,识别慢查询、锁竞争和膨胀问题。
PostgreSQL 诊断分析器 围绕 PostgreSQL 关系数据库构建。它通过使用 SQL、pg_stat_statements、EXPLAIN ANALYZE、锁、索引、扩展等稳定接口,并为实际任务保留重要的操作上下文,为智能体提供了一种比单行命令包装器更技术化、更可靠的工具使用方式。
当智能体需要将自然语言请求转换为具体的 PostgreSQL 级别查询、安全地运行它们,然后用操作术语解释结果而非返回原始输出时,此技能尤其有用。其原始用例很明确:利用 pg_stat_statements、pg_stat_activity 和 pg_locks 系统视图对 PostgreSQL 运行诊断查询。通过 pgstattuple 和 pg_repack 扩展分析,识别慢查询、锁竞争和膨胀问题。实现通常依赖于 SQL、pg_stat_statements、EXPLAIN ANALYZE、锁、索引、扩展,配置通过环境变量、连接字符串、服务令牌或工作区配置传递,具体取决于上游平台。
直接访问 SQL、pg_stat_statements、EXPLAIN ANALYZE、锁、索引、扩展,而非抓取 UI 界面,这使得运行过程更易于审计和重试。
支持结构化的输入和输出,以便其他工具、智能体或 CI 步骤可以消费结果。
可以根据技能格式,将其接入到 cron 作业、webhook 处理器、MCP 传输或本地 CLI 工作流中。
适用于更广泛的集成点,如查询分析、诊断、数据仓库和应用程序后端。
作为一种操作手册风格的技能,其价值不仅在于工具访问,更在于操作序列:首先检查正确的信号,减少警报噪音,并生成其他工程师可以立即采取行动的摘要。关键的集成点包括查询分析、诊断、数据仓库和应用程序后端。在实际环境中,这通常意味着通过环境变量或应用程序配置传递凭据,遵守速率限制和权限范围,并返回可以附加到工单、拉取请求、仪表板或后续自动化流程的结构化工件。
npx skills add agentskillexchange/skills --skill postgresql-diagnostic-analyzer
npx skills add agentskillexchange/skills --skill postgresql-diagnostic-analyzer -a claude-code
npx skills add agentskillexchange/skills --skill postgresql-diagnostic-analyzer -a cursor
广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
npx skills add agentskillexchange/skills --skill postgresql-diagnostic-analyzer -a codex
clawhub install postgresql-diagnostic-analyzer
每周安装数
–
代码仓库
GitHub 星标数
1
首次出现时间
–
安全审计
Runs diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views. Identifies slow queries, lock contention, and bloat using pgstattuple and pg_repack extension analysis.
PostgreSQL Diagnostic Analyzer is built around PostgreSQL relational database. It gives an agent a more technical and reliable way to work with the tool than a thin one-line wrapper, using stable interfaces like SQL, pg_stat_statements, EXPLAIN ANALYZE, locks, indexes, extensions and preserving the operational context that matters for real tasks.
The skill is especially useful when an agent needs to translate a natural-language request into concrete postgresql-level queries, run them safely, and then explain the result in operational terms rather than returning raw output. The original use case is clear: Runs diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views. Identifies slow queries, lock contention, and bloat using pgstattuple and pg_repack extension analysis. The implementation typically relies on SQL, pg_stat_statements, EXPLAIN ANALYZE, locks, indexes, extensions, with configuration passed through environment variables, connection strings, service tokens, or workspace config depending on the upstream platform.
Accesses SQL, pg_stat_statements, EXPLAIN ANALYZE, locks, indexes, extensions instead of scraping a UI, which makes runs easier to audit and retry.
Supports structured inputs and outputs so another tool, agent, or CI step can consume the result.
Can be wired into cron jobs, webhook handlers, MCP transports, or local CLI workflows depending on the skill format.
Fits into broader integration points such as query analysis, diagnostics, warehouses, and application backends.
As a runbook-style skill, the value is not just tool access but operational sequencing: check the right signals first, reduce alert noise, and produce a summary that another engineer can act on immediately. Key integration points include query analysis, diagnostics, warehouses, and application backends. In a real environment that usually means passing credentials through env vars or app config, respecting rate limits and permission scopes, and returning structured artifacts that can be attached to tickets, pull requests, dashboards, or follow-up automations.
npx skills add agentskillexchange/skills --skill postgresql-diagnostic-analyzer
npx skills add agentskillexchange/skills --skill postgresql-diagnostic-analyzer -a claude-code
npx skills add agentskillexchange/skills --skill postgresql-diagnostic-analyzer -a cursor
npx skills add agentskillexchange/skills --skill postgresql-diagnostic-analyzer -a codex
clawhub install postgresql-diagnostic-analyzer
Weekly Installs
–
Repository
GitHub Stars
1
First Seen
–
Security Audits
Azure 升级评估与自动化工具 - 轻松迁移 Functions 计划、托管层级和 SKU
79,900 周安装