DevOps

postgres

Helps agents inspect and operate PostgreSQL safely, including configuration, query plans, vacuum, WAL/PITR, replication, failover, extensions, upgrades, and read-only diagnostics.

★ 88 GitHub Stars
96 品質スコア
14 ファイル

このSkillについて

Operate PostgreSQL instances safely: configuration review, index and query-plan analysis, vacuum and bloat management, WAL archiving and point-in-time recovery, replication and failover, extensions, major-version upgrades, and evidence-based diagnostics with the bundled read-only pgdiag script. Use when running or inspecting a PostgreSQL server, diagnosing performance or backup health, or planning an upgrade or failover. Do not use for application-level data access patterns (that's backend-engineering) or schema design (that's data-architect/data-engineering).

利用例

  • Review PostgreSQL configuration and runtime health
  • Analyze indexes, query plans, vacuum, and bloat
  • Verify WAL archiving and point-in-time recovery readiness
  • Assess replication status and plan failover
  • Plan extensions and major-version upgrades

特徴

  • Bundled read-only pgdiag diagnostic collector
  • Bounded JSON evidence from PostgreSQL checks
  • Configuration and query-plan review guidance
  • WAL archiving, PITR, replication, and failover runbooks
  • Major-version upgrade and extension lifecycle guidance

必要要件

  • Python 3.9+
  • psql client for live diagnostics
  • PostgreSQL 10+ server for live diagnostics

対応Agent

指定なし

Skillファイル

関連Skills

release-engineering

Enables agents to design and operate software release processes, CD pipelines, progressive delivery, versioning, quality gates, rollback plans, compliance evidence, and DORA metri…

magnus919/agent-skills ★ 88
release engineering ci-cd continuous delivery progressive delivery

remote-systems-administration

Guides safe administration and troubleshooting of remote Linux, BSD, and macOS hosts using SSH, Ansible, or Paramiko, with platform discovery, controlled changes, rollback plannin…

magnus919/agent-skills ★ 88
remote administration ssh linux freebsd

site-reliability-engineering

Helps agents design and improve reliable production systems using SLOs, observability, error budgets, incident command, on-call practices, postmortems, and operational templates.

magnus919/agent-skills ★ 88
sre reliability slo sli

jellyfin

Provides a Python CLI for querying a running Jellyfin server, including media search, recently added items, library browsing, series navigation, next-up episodes, server informati…

magnus919/agent-skills ★ 88
jellyfin media server movies tv shows

incident-learning

Transforms incident, near-miss, and exercise evidence into owned follow-up work across product, engineering, testing, operations, and governance, with explicit uncertainty and ver…

magnus919/agent-skills ★ 88
incident learning incident management reliability root cause analysis

traefik

Deploy, configure, and troubleshoot Traefik v3 reverse proxy installations, including providers, routing, TLS/ACME, middleware, Kubernetes, observability, and production patterns.

magnus919/agent-skills ★ 88
traefik reverse proxy load balancing routing

resilience-and-recovery

Guides agents in designing, exercising, and documenting system resilience, graceful degradation, disaster recovery, restore testing, failover drills, RTO/RPO decisions, data integ…

magnus919/agent-skills ★ 88
resilience disaster recovery business continuity graceful degradation

grafana

Enables agents to operate, configure, provision, secure, troubleshoot, and integrate Grafana OSS, Enterprise, and Cloud resources through documented workflows and APIs.

magnus919/agent-skills ★ 88
grafana observability dashboards alerting