# Retool Query

> 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.

- Skill: `jsgforever/retool-query` (Agent Skill, multi-file: 3 files)
- Install (CLI): `npx skillmds@latest add jsgforever/retool-query`
- Raw SKILL.md: https://api.skillmd.com/api/skills/jsgforever/retool-query/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: jsgforever (https://skillmd.com/u/jsgforever)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/jsgforever/retool-query

---


# 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

```bash
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

```bash
# 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-managed data