postgresql/stack.yaml at main · agentic-stacks/postgresql · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
name: postgresql
namespace: agentic-stacks
version: "0.1.0"
description: >
  Agent-driven PostgreSQL deployment and operations covering the full lifecycle:
  installation, configuration, high availability, backup/restore, performance tuning,
  security, and day-two operations across bare metal, containerized, and Kubernetes
  environments.

repository: https://github.com/agentic-stacks/postgresql

target:
  software: postgresql
  versions: ["16", "17"]

skills:
  - name: concepts
    entry: skills/foundation/concepts
    description: "PostgreSQL architecture, process model, MVCC, WAL, storage layout"
  - name: installation
    entry: skills/foundation/installation
    description: "Installing PostgreSQL on bare metal/VM (apt, yum, source) and Docker/Podman"
  - name: configuration
    entry: skills/foundation/configuration
    description: "postgresql.conf, pg_hba.conf, resource tuning baselines, SSL/TLS setup"
  - name: standalone
    entry: skills/deploy/standalone
    description: "Single-server production deployment — init, config, verification"
  - name: containerized
    entry: skills/deploy/containerized
    description: "Docker/Podman deployment patterns, volumes, networking, compose"
  - name: kubernetes
    entry: skills/deploy/kubernetes
    description: "CloudNativePG, Crunchy PGO, Zalando operator deployment and management"
  - name: replication
    entry: skills/platform/replication
    description: "Streaming replication, logical replication, cascading, synchronous modes"
  - name: ha
    entry: skills/platform/ha
    description: "Patroni + etcd/Consul HA clusters, automatic failover, fencing"
  - name: connection-pooling
    entry: skills/platform/connection-pooling
    description: "PgBouncer, PgCat — installation, configuration, pool modes"
  - name: observability
    entry: skills/platform/observability
    description: "pg_stat views, Prometheus/pg_exporter/Grafana, pgBadger, pgAudit"
  - name: security
    entry: skills/platform/security
    description: "Roles/privileges, RLS, LDAP/SCRAM auth, pgcrypto, encryption, compliance patterns"
  - name: backup-restore
    entry: skills/operations/backup-restore
    description: "pgBackRest, pg_dump/pg_restore, pg_basebackup, Barman, PITR"
  - name: upgrades
    entry: skills/operations/upgrades
    description: "Minor upgrades, pg_upgrade major version, logical replication upgrade path"
  - name: health-check
    entry: skills/operations/health-check
    description: "Cluster validation — connections, replication, disk, locks, bloat"
  - name: performance
    entry: skills/operations/performance
    description: "postgresql.conf tuning, EXPLAIN analysis, indexing, partitioning, vacuum tuning, pgbench"
  - name: schema-management
    entry: skills/operations/schema-management
    description: "Migration tools (Flyway, sqitch, Alembic, golang-migrate), schema diffing, patterns"
  - name: troubleshooting
    entry: skills/diagnose/troubleshooting
    description: "Symptom-based diagnostic decision trees — connections, slow queries, replication, crashes"
  - name: decision-guides
    entry: skills/reference/decision-guides
    description: "Comparison matrices for HA, backup tools, K8s operators, migration tools, poolers, auth methods"
  - name: compatibility
    entry: skills/reference/compatibility
    description: "PostgreSQL version × OS × extension × tooling compatibility"
  - name: known-issues
    entry: skills/reference/known-issues
    description: "Version-specific bugs, caveats, and workarounds for PG 16 and 17"

project:
  structure:
    - postgresql.conf
    - postgresql.conf.orig
    - pg_hba.conf
    - pg_hba.conf.orig
    - pg_ident.conf
    - inventory/
    - patroni/
    - pgbackrest/
    - pgbouncer/
    - kubernetes/
    - migrations/
    - monitoring/
    - scripts/

requires:
  tools:
    - name: psql
      description: "PostgreSQL interactive terminal and CLI"
    - name: pg_isready
      description: "Connection check utility (ships with PostgreSQL)"
    - name: patronictl
      description: "Patroni HA cluster management (optional, for HA deployments)"
    - name: pgbackrest
      description: "Physical backup and restore (optional, for pgBackRest users)"
    - name: pg_dump
      description: "Logical backup utility (ships with PostgreSQL)"
    - name: pgbench
      description: "Performance benchmarking (ships with PostgreSQL)"
    - name: docker
      description: "Container runtime (optional, for containerized deployments)"
    - name: kubectl
      description: "Kubernetes CLI (optional, for K8s deployments)"
    - name: helm
      description: "Helm package manager (optional, for K8s operator installation)"

depends_on: []