OpenParable
Skip to content
← Back to skills

Retool Query

Apps & Automation
retool-query

Retool Query is an Agent Skill for apps & automation published in the civitai/civitai repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

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.

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/civitai/civitai/blob/HEAD/.claude/skills/retool-query/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/retool-query, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

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

FlagDescription
--writableAllow write operations (requires user permission)
--timeout <s>, -tQuery timeout in seconds (default: 30)
--file, -fRead query from a file
--jsonOutput results as JSON
--quiet, -qMinimal 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