Agent Skills › civitai/civitai › retool-query

retool-query

GitHub

用于查询 Moderator PostgreSQL 数据库，获取审核笔记、用户违规等 Retool 历史数据。默认只读，支持写入但需授权，提供超时保护与 JSON 输出选项。

.claude/skills/retool-query/SKILL.md civitai/civitai

Trigger Scenarios

查询审核笔记或用户违规记录探索数据库表结构调查 Retool 时代的数据

Install

npx skills add civitai/civitai --skill retool-query -g -y

More Options

Non-standard path

npx skills add https://github.com/civitai/civitai/tree/main/.claude/skills/retool-query -g -y

Use without installing

npx skills use civitai/civitai@retool-query

指定 Agent (Claude Code)

npx skills add civitai/civitai --skill retool-query -a claude-code -g -y

安装 repo 全部 skill

npx skills add civitai/civitai --all -g -y

预览 repo 内 skill

npx skills add civitai/civitai --list

SKILL.md

Frontmatter

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

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