Agent Skills
› civitai/civitai
› retool-query
retool-query
GitHub用于查询审核员PostgreSQL数据库，支持读取用户备注、处罚记录等历史数据。默认只读，需授权方可写入，提供超时保护与JSON输出选项。
Trigger Scenarios
查询用户备注或处罚记录
探索数据库表结构
检索Retool时代审核数据
Install
npx skills add civitai/civitai --skill retool-query -g -y
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
--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-era moderation data
Version History
-
dc828b5
Current 2026-08-29 06:13
2026-08-21 将 Retool 数据库统一至 MODERATOR_DATABASE_URL，并更新相关文档。
- 4214ecb 2026-08-20 18:49
