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 --writable flag 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 UserNotes table schema

• Looking up moderation notes for a specific user

• Writing new moderation notes (with --writable )

• Investigating Retool-managed data