CMS Visualizer with Claude (Free Prompt)

Blog

This is a free prompt for seeing your CMS with Claude

  • Export all your Collections csv

  • Upload them to Claude

  • Use this prompt:

I'm attaching the CSV exports of every CMS collection in our Webflow/Framer/Whatever site [PROJECT NAME]. Build an interactive CMS map as an artifact.

What to infer from the CSVs
- One collection per file. Use the collection name from the file name (Webflow names exports "SITE - Collection Name - CollectionID.csv") and keep the collection ID.
- Skip system columns: Collection ID, Locale ID, Item ID, Archived, Draft, Created On, Updated On, Published On.
- For each field, infer its type from the values: Plain text, Rich text (HTML), Image, Multi-image, Switch (true/false), Color (hex), Number, Link (URL), Date/Time, Option, Slug, Reference, Multi-reference.
- Reference fields: values are slugs of items in another collection. Match them against the slugs of the other CSVs to find the target collection. Several slugs separated by ";" means Multi-reference.
- Option vs Plain text can't be told apart from a CSV: if a field has few repeated values, mark it as "Option (guessed)" and list the values found.
- Empty fields: infer the type from the field name and mark it as "inferred from name".
- For each field, calculate the % of items that have it filled.
- If anything is ambiguous, list it under "Assumptions" at the end of your reply instead of guessing silently.

The map
- One card per collection: header with an emoji, the name and the item count; one row per field with its name and a type pill. Reference pills highlighted. Unused fields (0% filled) greyed out.
- Arrows from each reference field to its target collection: solid for Reference, dashed for Multi-reference.
- Group and colour collections by prefix (e.g. Global, Products, Recipes, Blog). Filter chips per group.
- Search box that highlights matching collections and fields.
- Click a card to open a side panel: collection ID, every field with its type, % filled and Option values, and "Referenced by" (which collections point to it), with links to jump between collections.
- Hovering a card highlights its connections.
- Drag cards, pan the background, zoom (buttons, pinch, Ctrl + scroll), fit to screen.
- "References only" toggle that shows just the name field and reference fields.
- Reset layout, Download PNG, a collapsible legend, and an EN/ES language switch.
- Light and dark mode. Usable on a laptop screen.
- A short note in the panel: "Types inferred from the CSV exports; system fields are left out."

Visual style
Match this look exactly (warm, Claude-like):
- Background: #F0EEE6 with a subtle dot grid (dots #D9D5C8, 22px spacing).
- Cards and panels: #FAF9F5, 10px radius, soft shadow. Text: #141413. Muted text: #6B6A63. Lines: #E3E0D5.
- Accent (primary button, highlights, focus): #D97757.
- Type pills: monospace, background #EAE7DD. Reference pills: background #F6E3D9, text #9C4424.
- Fonts (Google Fonts): Hanken Grotesk for the UI, Source Serif 4 for the page title and panel headings, JetBrains Mono for field types and IDs.
- Group colours for card headers and arrows:
  Global #3E77AE · Products #C2613F · Recipes #5E7244 · Blog/Articles #A84D6D · Stores #A87645 · Merch #6E5FA0 · Other #5E5B53
  If the project has other groups, pick colours in the same muted tone.
- Dark mode: background #1A1918, cards #262624, text #F0EEE6, same accent.

Before building, give me a short summary: number of collections, fields, references and items, and the list of assumptions.

full post at https://fernandocomet.medium.com/cms-visualizer-with-claude-free-prompt-296bc96fd10c

1