Loading...
Loading...
Run queries against the Retool PostgreSQL database for moderation notes, user notes, and other Retool-managed data. Read-only by default. Use when you need to query the Retool database directly.
npx skill4agent add civitai/civitai retool-queryUserNotesnode .claude/skills/retool-query/query.mjs "SELECT * FROM \"UserNotes\" LIMIT 5"| Flag | Description |
|---|---|
| Allow write operations (requires user permission) |
| Query timeout in seconds (default: 30) |
| Read query from a file |
| Output results as JSON |
| Minimal output, only results |
# List tables
node .claude/skills/retool-query/query.mjs "SELECT tablename FROM pg_tables WHERE schemaname = 'public'"
# View UserNotes schema
node .claude/skills/retool-query/query.mjs "SELECT column_name, data_type, is_nullable FROM information_schema.columns WHERE table_name = 'UserNotes'"
# Look up notes for a user
node .claude/skills/retool-query/query.mjs "SELECT * FROM \"UserNotes\" WHERE \"userId\" = 12345 ORDER BY created_at DESC LIMIT 10"
# JSON output
node .claude/skills/retool-query/query.mjs --json "SELECT * FROM \"UserNotes\" LIMIT 3"--writable--writableUserNotes--writable