overthinkos/postgresql
infrastructure/skills/postgresql/SKILL.md
PostgreSQL database server on port 5432 with pgvector extension and persistent data. Entrypoint supports POSTGRES_SHARED_PRELOAD_LIBRARIES for extension loading. Use when working with PostgreSQL, database configuration, or pgvector.
tools
Updated Jun 14, 2026
$ install --global
skillsauthnpx skillsauth add overthinkos/overthink-plugins postgresqlInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Jun 14, 2026, 5:51 AM26.4s1 file scanned
SKILL.md
- name:
- postgresql
- description:
- |
postgresql -- PostgreSQL database server
Candy Properties
| Property | Value |
|----------|-------|
| Dependencies | none |
| Ports | 5432 |
| Volumes | pgdata -> ~/.postgresql/data |
| Service | postgresql (supervisord, priority 10) |
| Install files | task: |
Environment Variables
| Variable | Value |
|----------|-------|
| PGDATA | ~/.postgresql/data |
| POSTGRES_HOST_AUTH_METHOD | scram-sha-256 |
| POSTGRES_SHARED_PRELOAD_LIBRARIES | (optional) — comma-separated .so names loaded at startup |
The entrypoint also reads these variables (with defaults, not set in charly.yml):
POSTGRES_USER(default:postgres) — set by consuming candies (e.g., immich setsimmich)POSTGRES_DB(default:$POSTGRES_USER) — set by consuming candiesPOSTGRES_PASSWORD— required unlessPOSTGRES_HOST_AUTH_METHOD=trust
Service Environment (injected into other containers)
| Variable | Template Value | Resolved Example |
|----------|---------------|-----------------|
| PGHOST | {{.ContainerName}} | charly-postgresql |
| PGPORT | 5432 | 5432 |
Pod-aware: same-container consumers receive PGHOST=localhost, cross-container consumers receive PGHOST=charly-postgresql. When charly config runs, these are automatically injected into the global charly.yml env for PostgreSQL service discovery.
See /charly-image:layer for env_provide field docs.
Packages
The candy is multi-distro:
- RPM (Fedora):
postgresql-server,postgresql-contrib,pgvector(vector similarity search extension) - PAC (Arch/CachyOS):
postgresql,postgresql-libs— the Archpostgresqlpackage ships the server + contrib tooling; pgvector on Arch is built from the AUR (see/charly-infrastructure:vectorchord).
Usage
# charly.yml -- typically used as dependency of immich
my-image:
candy:
- postgresql
Used In Boxes
/charly-immich:immich/charly-immich:immich-ml
Entrypoint Features
The custom entrypoint (/usr/local/bin/postgresql-entrypoint.sh) supports:
- First-run initialization —
initdb, database creation, and/docker-entrypoint-initdb.d/scripts - Password management —
POSTGRES_PASSWORDorPOSTGRES_PASSWORD_FILE POSTGRES_SHARED_PRELOAD_LIBRARIES— when set, adds-c shared_preload_libraries=...to both the init-phase temp server and the final exec. Used by thevectorchordcandy to loadvchord.so. Generic mechanism — any extension candy can use it.
Related Candies
/charly-immich:immich-- primary consumer (depends on postgresql)/charly-infrastructure:vectorchord-- setsPOSTGRES_SHARED_PRELOAD_LIBRARIES=vchord.so/charly-infrastructure:redis-- often paired with postgresql in service stacks
Related Commands
/charly-core:charly-config— Deploy with secrets provisioning (db-password)/charly-build:secrets— Manage database credentials
When to Use This Skill
Use when the user asks about:
- PostgreSQL database setup in containers
- pgvector extension
- Database volume or
PGDATAconfiguration - Port 5432 service
- Database initialization
Related
/charly-check:check— declarative testing (check:block,charly check box,charly check live)
Related Skills
overthinkos/plugin
tools
VerifiedTrustedCommunity
Use when authoring or modifying a charly PLUGIN — a candy with a `plugin:` block that contributes Providers (verbs/kinds/deploy-targets/steps/builders/commands), its own CUE schema, builtin (compiled-in) or external (out-of-tree git repo). Covers the unified Provider model, the per-plugin CUE-schema contract (single source → Go params for dev + schema-over-Describe RPC for runtime), the SDK, and the loader.
SKILL.mdUpdated Jun 22, 2026
overthinkos/cue
tools
VerifiedTrustedCommunity
The CUE data-validation / configuration CLI (cue), pinned to v0.16.1. Use when working with the cue candy, installing the cue binary into a box or onto a target:local dev host, or running the offline schema-vendoring pipeline that feeds charly's egress validation.
SKILL.mdUpdated Jun 16, 2026
overthinkos/egress
tools
VerifiedTrustedCommunity
CUE EGRESS validation — validating (and, where it adds value, generating) the config files charly WRITES to a system BEFORE the bytes hit disk. MUST be invoked before working on charly/egress.go, the vendored schemas under candy/plugin-egress/egress-schemas/vendor/, the ValidateEgress / registerVendoredEgressKind path, the offline `task cue:vendor` pipeline, or adding an egress schema for any written artifact (cloud-init, k8s manifests, traefik routes, runtime config, install ledger, systemd/quadlet units, ssh_config, libvirt XML).
SKILL.mdUpdated Jun 16, 2026
overthinkos/check-k8s
tools
VerifiedTrustedCommunity
Kubernetes cluster-probe declarative check verb — the `kube:` check verb (nodes, pods, ingress, storage class, addon health, apply/delete, and arbitrary resource GETs) served out-of-process by the candy/plugin-kube plugin (vendored client-go; no external kubectl required).
SKILL.mdUpdated Jun 14, 2026