Pgadmin Manager

通过 docker-compose.yml 与 run.sh 生命周期脚本管理本地 pgAdmin 4 容器，提供 start、stop、status、open 命令，输出容器状态与访问地址；容器接入共享 Docker 网络连接 PostgreSQL，服务器配置持久化在命名卷中，需先启动代理与 PostgreSQL 相关插件。

pereirajair

热度 44.68

最近更新 2026-05-27 01:25:35

分类：开发依赖：代码执行应用场景：DevOps / 自动化脚本 / 工作流

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add pgadmin-manager

Metadata

name: pgadmin-manager
slug: pgadmin-manager
version: 1.0.0
description: Manage the pgAdmin Docker container for local dev environments. Provides a web UI for PostgreSQL at http://localhost:8082. Requires postgres-manager and proxy-manager to be running first.
changelog: Initial release.
triggers: ["abrir pgadmin","start pgadmin","stop pgadmin","pgadmin status","interface postgres","admin postgres","pgadmin-manager"]
metadata: {"clawdbot":{"emoji":"🐘","requires":{"bins":["docker"]},"os":["linux","darwin"]}}

pgAdmin Manager

Manages the pgAdmin Docker container, providing a web UI for PostgreSQL database management.

Architecture

pgadmin-manager/
├── docker-compose.yml   # pgAdmin 4 container (pinned to 8.6)
└── run.sh               # lifecycle CLI

Connects to the shared nginx-proxy_net network and reaches PostgreSQL at codai_postgres:5432. Server configurations are persisted in a named volume (pgadmin_data).

Commands

./run.sh start    # start pgAdmin container
./run.sh stop     # stop container (config persists in volume)
./run.sh status   # show status and URL
./run.sh open     # print access URL

How to Execute Tasks

Start pgAdmin

Check your session context for the absolute script path, then run:

<plugin-root>/pgadmin-manager/run.sh start

Open http://localhost:8082 in a browser. Login: admin@codai.local / pgadmin.

To connect to PostgreSQL inside pgAdmin, add a server with:

Host: codai_postgres
Port: 5432
User: codai / Password: pgpass

Check status

<plugin-root>/pgadmin-manager/run.sh status

Prerequisites

Start in this order:

proxy-manager start — creates the shared Docker network
postgres-manager start — PostgreSQL must be running before pgAdmin connects

Configuration

Variable	Default	Purpose
`PGADMIN_CONTAINER`	`codai_pgadmin`	Container name
`PGADMIN_PORT`	`8082`	Host port
`PGADMIN_EMAIL`	`admin@codai.local`	Login e-mail
`PGADMIN_PASSWORD`	`pgadmin`	Login password
`CODAI_NETWORK`	`nginx-proxy_net`	Shared Docker network name

Rules

Start postgres-manager before this plugin — pgAdmin cannot connect without PostgreSQL.
Port 8082 is bound to 127.0.0.1 — accessible from the host only.
Server configurations survive container restarts (stored in pgadmin_data volume).
Use stop when done; the container uses restart: unless-stopped and survives reboots.
Use docker compose down -v only when you intentionally want to delete saved server configs.

Related Plugins

proxy-manager — creates the shared Docker network (start first)
postgres-manager — PostgreSQL container that pgAdmin connects to