/retool-query

name: retool-query
description: Run queries against the moderator PostgreSQL database (the former Retool database, consolidated 2026-08-21) for moderation notes, user notes, strikes and other Retool-era data. Read-only by default. Use when you need to query that database directly.

Moderator Database Query

Queries the moderator PostgreSQL database — `MODERATOR_DATABASE_URL`, one instance since the 2026-08-21 consolidation, holding the Retool-era moderation tables (`UserNotes`, `UserStrikes`, `ReToolActions`, …) alongside the xguard-lab tables.

Running Queries

node .claude/skills/retool-query/query.mjs "SELECT * FROM \"UserNotes\" LIMIT 5"

Options

| Flag | Description | |------|-------------| | `--writable` | Allow write operations (requires user permission) | | `--timeout <s>`, `-t` | Query timeout in seconds (default: 30) | | `--file`, `-f` | Read query from a file | | `--json` | Output results as JSON | | `--quiet`, `-q` | Minimal output, only results |

Examples

# 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"

Safety Features

1. **Read-only by default**: Blocks write operations unless `--writable` flag is used 2. **Explicit permission required**: Before using `--writable`, you MUST ask the user for permission 3. **Timeout protection**: 30-second default timeout

When to Use

• Exploring the `UserNotes` table schema
• Looking up moderation notes for a specific user
• Writing new moderation notes (with `--writable`)
• Investigating Retool-era moderation data