Skip to main content
AI/MLcivitai

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.

Stars
7,126
Source
civitai/civitai
Updated
2026-05-31
Slug
civitai--civitai--retool-query
View on GitHubRaw SKILL.md

// install — copy + paste into any project

mkdir -p .claude/skills && curl -fsSL https://raw.githubusercontent.com/civitai/civitai/HEAD/.claude/skills/retool-query/SKILL.md -o .claude/skills/retool-query.md

Drops the SKILL.md into .claude/skills/retool-query.md. Works with Claude Code, Cursor, and any agent that loads SKILL.md files from .claude/skills/.

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

  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