💻 Coding
Retool Query Resource Map from App Inventory (No Invented API Keys)
Turn a Retool app inventory into a query resource map only. No invented API keys, resource URLs, or environment secrets beyond the inventory.
0Reviews
Prompt
Act as a Retool app engineer who only uses a pasted app inventory. You write a query resource map the inventory already supports. You do not invent API keys, resource URLs, environment secrets, or transformer outputs. This is not a live Retool Cloud deploy and not a security audit. You work only from Inputs. Do not invent stats, citations, quotes, URLs, names, IDs, or records that are not in Inputs. Inputs: - App inventory I lock (query stubs, resource cues, page notes): [Inventory] - Retool / editor version notes I lock: [Version] - Workspace or org label I may quote (or UNKNOWN): [Workspace] - Required query or resource names I may quote (or UNKNOWN): [SpecNames] - Words I must not use: [Banned] - What I must never invent (API keys, resource URLs, environment secrets, transformer outputs): [Never] - Output format: [Format] - Language: [Lang] Generate: 1. Honesty ledger: Inventory nouns, Version, Workspace, SpecNames, Lang. Forbidden: invented API keys, resource URLs, environment secrets, transformer outputs. Banner: not a live Retool Cloud deploy; not a security audit. 2. Query resource map table: one row per Inventory query stub or resource cue. Missing page notes write NOT IN INPUTS. Use Retool REST/SQL query and resource naming language when Inventory supports it. 3. Spec name set: only names in SpecNames. Unnamed queries stay NOT IN INPUTS. Never print API-key or secret VALUES not in Inventory. 4. Version lock: print Version. Refuse Retool features newer than Version if Version is named. 5. Refuse list: inventing API keys, inventing resource URLs, inventing environment secrets, inventing transformer outputs. 6. Compliance pass: quote Banned and Never hits. Cut them. Format as Format. Constraints: - Map from Inventory only. No invented API-key VALUES. Teach Retool query and resource mapping, not a generic CRUD swap. - Honor Version. No emojis.
Instructions
Replace every [bracket] with your details before running. Works on ChatGPT, Claude, and Gemini.
Generated Output
This image was generated using the prompt above.
Examples
Example Input
Inventory: query Harbor Quay List Berths as pasted resource cue postgres_harbor as pasted page note Operations as pasted; query River Ops Notify Ops as pasted resource cue rest_ops as pasted. API key NOT IN INPUTS. Secret NONE. Version: Retool 3.52 as pasted (do not invent unreleased multipage APIs) Workspace: Harbor Quay Ops Workspace as pasted SpecNames: List Berths as pasted; Notify Ops as pasted. Sync UNKNOWN. Banned: guaranteed API key, URL invent, secret invent, transformer invent Never: invent API keys, invent resource URLs, invent environment secrets, invent transformer outputs Format: ledger + table + specs + version + refuse + compliance Lang: English
Example Output
1. Ledger. Inventory: query Harbor Quay List Berths resource cue postgres_harbor page note Operations; query River Ops Notify Ops resource cue rest_ops. API key NOT IN INPUTS. Secret NONE. Version Retool 3.52. Workspace Harbor Quay Ops Workspace. SpecNames List Berths; Notify Ops; Sync UNKNOWN. Lang English. Banner: not a live Retool Cloud deploy; not a security audit. Forbidden: invented API keys, resource URLs, environment secrets, transformer outputs, guaranteed API key, URL invent, secret invent, transformer invent. 2. Query resource map. 1. Harbor Quay List Berths | resource postgres_harbor as pasted | page Operations as pasted | API key NOT IN INPUTS | secret NONE | Retool SQL query map only. 2. River Ops Notify Ops | resource rest_ops as pasted | page NOT IN INPUTS | API key NOT IN INPUTS | secret NONE. Resource URLs not printed. Transformer outputs not invented. 3. Spec name set. List Berths; Notify Ops as SpecNames. Sync UNKNOWN so write Sync NOT IN INPUTS. No API-key VALUES printed. No third query invented. 4. Version lock. Retool 3.52 as pasted. Unreleased multipage APIs not used. Environment schema NOT IN INPUTS. 5. Refuse. API-key invent: refused. URL invent: refused. Secret invent: refused. Transformer invent: refused. Guaranteed API key: refused. 6. Compliance. Banned hits none. Format ledger+table+specs+version+refuse+compliance. Gaps: page for River Ops Notify Ops, Sync decision, retry policy, pagination, auth scheme if any. Missing-data policy: if a field was blank, write NOT IN INPUTS rather than guessing. Lock any tool version named in Inputs; if unnamed, write unknown. No invented testimonials, star ratings, or press logos. If legal, clinical, insurance, HR, education-plan, or veterinary content appears, add a one-line not-advice and de-identify banner. Quote banned-word hits and cut them. End with a gaps list of five bullets the user still owes you. Character and byte caps in the job are hard; print counts when relevant. Refuse to backfill DOIs, exam dumps, PHI, PII, or compensation promises not in Inputs.