retool-query
19
总安装量
18
周安装量
#18548
全站排名
安装命令
npx skills add https://github.com/civitai/civitai --skill retool-query
Agent 安装分布
opencode
18
github-copilot
18
codex
18
gemini-cli
18
kimi-cli
17
amp
17
Skill 文档
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