jsgforever Retool Database Query
Use this skill to query the Retool PostgreSQL database. This database stores moderation notes (UserNotes), and other data managed through Retool dashboards.
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
- Read-only by default: Blocks write operations unless
--writableflag is used - Explicit permission required: Before using
--writable, you MUST ask the user for permission - Timeout protection: 30-second default timeout
When to Use
- Exploring the
UserNotestable schema - Looking up moderation notes for a specific user
- Writing new moderation notes (with
--writable) - Investigating Retool-managed data