Postgres Manager

AdvisoryAudited by Static analysis on May 10, 2026.

Overview

No suspicious patterns detected.

Findings (0)

Artifact-based informational review of SKILL.md, metadata, install specs, static scan signals, and capability signals. ClawScan does not execute the skill or run runtime probes.

What this means

If invoked with the wrong database name, the user could modify or delete a local development database.

Why it was flagged

The script exposes database mutation operations including create, drop, and dump/import. These are central to the skill's purpose and include validation and confirmation for drop-db, but they can still alter or remove local development data.

Skill content
./run.sh create-db <nome> ... ./run.sh drop-db <nome> ... ./run.sh dump <origem> <destino>
Recommendation

Use the status and list-dbs commands first, keep backups of important dev data, and verify database names before running dump or drop-db.

What this means

On a shared machine or shared Docker network, other local containers/users could access the dev database if the default password is left unchanged.

Why it was flagged

The container defaults to a simple development password. The artifacts disclose this and bind the host port to localhost, but other containers on the shared Docker network may be able to connect using the default credentials.

Skill content
POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-pgpass}
Recommendation

Set a unique POSTGRES_PASSWORD before starting the container, especially on shared machines or when storing non-test data.

What this means

The container image source is a normal dependency for this kind of skill, but users rely on the upstream Docker image matching the expected PostgreSQL build.

Why it was flagged

The runtime depends on pulling a public Docker image. The tag is version-pinned, which is better than latest, but it is not digest-pinned.

Skill content
image: postgres:16.4-alpine
Recommendation

Use trusted Docker registries and consider digest-pinning the image if reproducibility or supply-chain assurance is important.

NoteHigh Confidence
ASI10: Rogue Agents
What this means

The database service and its data may remain available after the immediate task completes, consuming resources and retaining local data.

Why it was flagged

The PostgreSQL container is configured to keep running and restart after Docker daemon restarts. This persistence is disclosed in SKILL.md and is expected for a local database service.

Skill content
restart: unless-stopped
Recommendation

Run ./run.sh stop when finished, and only use docker compose down -v if you intentionally want to delete the persisted volume.