メニュー
Inspect the PostgreSQL schema, tables, and data for a running lifelog instance
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
Validate, stage, and commit current changes with a conventional commit message
Diagnose and fix build failures systematically
Explain how a specific part of the lifelog architecture works with diagrams and data flow
Trace a data modality end-to-end from proto definition through collector, server, and storage
Fix a GitHub issue end-to-end with tests and validation
Generate realistic test data fixtures for a data modality
| name | db-inspect |
| description | Inspect the PostgreSQL schema, tables, and data for a running lifelog instance |
| disable-model-invocation | true |
| allowed-tools | Bash, Read, Grep |
Inspect the lifelog PostgreSQL instance. Focus on: $ARGUMENTS
Available commands (PostgreSQL must be running, default DSN: postgresql://lifelog@127.0.0.1:5432/lifelog):
# List all tables
psql "$LIFELOG_POSTGRES_INGEST_URL" -c "\dt"
# Describe the frames table
psql "$LIFELOG_POSTGRES_INGEST_URL" -c "\d frames"
# Count records per modality
psql "$LIFELOG_POSTGRES_INGEST_URL" -c "SELECT modality, count(*) FROM frames GROUP BY modality ORDER BY count DESC;"
# Sample records
psql "$LIFELOG_POSTGRES_INGEST_URL" -c "SELECT id, modality, origin_id, created_at FROM frames ORDER BY created_at DESC LIMIT 10;"
# Check catalog
psql "$LIFELOG_POSTGRES_INGEST_URL" -c "SELECT * FROM catalog LIMIT 20;"
Steps: