Menü
Query PostgreSQL databases running in the app-postgres Docker container
Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.
Basierend auf der SOC-Berufsklassifikation
Author a new Fred agent capability (manifest + middleware) built on fred-sdk. Picks the right authoring lane, maps each runtime need to a middleware hook, wires entry-point registration, and enforces the capability boundary (never hand-edit union/registry hotspots, no capability code in control-plane, no runtime info in LLM tool signatures).
Query OpenFGA authorization tuples and explain why a user has (or doesn't have) a permission on an object
Safety-first review of an external pull request from an untrusted fork. Fetches the diff read-only into an isolated worktree, scans for supply-chain / exfiltration / CI-tampering threats, checks scope, then delegates correctness review. Never builds or runs the fork's code.
Pre-PR audit of the current branch — dead code, duplicate symbols, contract drift, leftover artifacts, import gaps.
Post-merge validation — check that both sides of a merge were fully integrated, nothing was silently dropped, and quality still passes.
Run make code-quality from the monorepo root, covering all modules. Never run it per-module.
| name | psql |
| description | Query PostgreSQL databases running in the app-postgres Docker container |
| user-invocable | true |
| argument-hint | <query or intent> |
You help the user query and inspect the PostgreSQL databases running in the local dev stack.
PostgreSQL runs in the app-postgres Docker container (image: pgvector/pgvector:pg15, port 5432).
Always connect via docker exec to avoid host psql version mismatches:
docker exec -it app-postgres psql -U admin -d <database>
Default dev credentials (used internally by the container — no password prompt needed with docker exec):
adminAzerty123_| Database | Owner | Notes |
|---|---|---|
fred | fred | Main application database |
data | tabular | Tabular data |
keycloak | keycloak_db_user | Auth / identity |
langfuse | langfuse | LLM observability |
openfga | openfga | Authorization tuples |
temporal | temporal | Workflow engine |
temporal_visibility | temporal | Temporal visibility store |
postgres | admin | Default admin database |
# List all databases
docker exec app-postgres psql -U admin -l
# List tables in a database
docker exec app-postgres psql -U admin -d fred -c "\dt"
# Describe a table
docker exec app-postgres psql -U admin -d fred -c "\d <table_name>"
# Run a query
docker exec app-postgres psql -U admin -d fred -c "SELECT * FROM <table> LIMIT 10;"
$ARGUMENTSParse the user's intent from $ARGUMENTS. When no database is specified, default to fred. Examples:
/psql list tables → docker exec app-postgres psql -U admin -d fred -c "\dt"/psql show users → query the users/accounts table in the fred database/psql SELECT * FROM agents LIMIT 5 → run that query against fred/psql list tables in langfuse → docker exec app-postgres psql -U admin -d langfuse -c "\dt"Always use docker exec app-postgres psql -U admin (no -it flag in non-interactive mode).
For multi-line or complex queries, pass them via --command or pipe through echo:
docker exec app-postgres psql -U admin -d fred --command "
SELECT id, name, created_at
FROM agents
ORDER BY created_at DESC
LIMIT 20;
"
pgvector — vector columns (embedding vector(...)) are normal.apps/<backend-name>/alembic/versions/