AI • JSON • Metadata • Cleanup • Static Data

AI Data Normalization

AI is useful when messy information needs to become structured data. Notes, book lists, resource cards, project metadata, image paths, titles, summaries, and categories can all be cleaned up faster when the structure is clear.

The rule is simple: once the schema works, preserve it. AI should help fill, clean, sort, compare, and review the data. It should not redesign the structure every time you add one more entry.

Main idea: AI is strongest with structured data after the schema exists. Use it to make surgical edits, not to keep inventing new structures.
Messy input Notes, lists, rough descriptions, image names, tags, links, and project ideas.
Stable schema Known fields, expected values, naming rules, and examples.
AI cleanup Normalize text, fill missing fields, check consistency, and preserve structure.
Reviewed data Valid JSON, tested rendering, correct links, and safe public content.
AI is useful for data cleanup when the project already has rules.

Why data normalization matters

A static site can still use structured data. LaunchShell uses plain HTML, shared CSS, local assets, small JavaScript helpers, and JSON data files. That keeps the site simple while making repeated content easier to maintain.

Problem

Messy content does not scale

A few cards can be written by hand. But once a site has many guides, projects, resources, book entries, image files, summaries, categories, and links, repeated manual edits become harder to track.

Small inconsistencies start to matter: one image path is wrong, one category name is different, one summary is too long, or one object is missing a required field.

Solution

Normalize repeated information

Structured data keeps repeated information in predictable fields. AI can help clean that data, but only if the project has a stable schema and clear rules.

That turns AI into a cleanup assistant instead of an architect that redesigns the data model every time.

Structured data is not only a backend idea. Even a static site benefits when repeated content has a clean source of truth.

The AI data cleanup workflow

Use AI after you know what the data should look like. The workflow should move from messy input to stable, reviewed output.

01

Define the fields

Decide what each object needs: title, URL, image, category, summary, type, level, time, tags, or other metadata.

02

Give examples

Show AI a correct object before asking it to add, clean, reorder, or normalize more data.

03

Preserve schema

Tell AI not to rename keys, add fields, nest objects, or redesign the structure unless you explicitly request it.

04

Validate output

Check JSON syntax, preview the rendered page, inspect paths, and confirm the public data is safe to publish.

What AI is good at cleaning up

AI works well with repeated data when the desired output is clear and reviewable.

Cards

Site card metadata

Titles, summaries, page URLs, image paths, categories, levels, time estimates, and homepage sections can be normalized into consistent objects.

Books

Book recommendations

A rough reading list can become public data with title, author, topic, format, notes, and safe display fields.

Resources

Student resource lists

Tool names, links, categories, summaries, and student-use notes can be made consistent without hand-editing every card.

Projects

Project metadata

Project status, difficulty, time estimate, topic, image path, and summary can be cleaned for portfolio pages and indexes.

Notes

Rough human notes

AI can turn messy planning notes into bullets, sections, tables, JSON drafts, or README handoff blocks.

Images

Image path consistency

Filenames like card-ai-data-normalization.png can be checked against page IDs, folders, and JSON references.

Schema rules come first

Before asking AI to clean data, decide the rules. Without rules, AI may “improve” the format in a way that breaks the rest of the project.

Stable

Good schema behavior

  • Same keys: every object uses the same field names.
  • Same value style: categories and types use consistent wording.
  • Same path style: URLs and image paths follow the project pattern.
  • Same level of detail: summaries are similar length and tone.
  • Same public-safety rules: private details are removed before publishing.
Unstable

Bad schema behavior

  • Renaming summary to description without updating the renderer.
  • Turning a simple string into an object because it seems more flexible.
  • Adding fields that the static page does not use.
  • Changing category names in ways that break filters or grouping.
  • Mixing internal notes with public-facing copy.
Important: flexibility is not always an upgrade. A simple schema that stays stable is often better than a clever schema that changes constantly.

LaunchShell example: site card data

The LaunchShell homepage can stay cleaner when repeated card information lives in data/site-index.json. AI can help add or adjust entries, but the field names should stay consistent.

{
  "id": "ai-data-normalization",
  "title": "AI Data Normalization",
  "type": "Guide",
  "level": "Beginner+",
  "time": "45-60 min",
  "category": "AI / Learning",
  "summary": "Use AI to turn messy notes, card metadata, book lists, resource entries, and project data into stable structured content while preserving the schema.",
  "url": "guides/ai-data-normalization/",
  "image": "assets/card-ai-data-normalization.png",
  "homeSection": "none",
  "featured": false
}
Why this matters: once the fields are predictable, the site can render cards consistently and AI can help edit the data without touching the page layout.

Good prompt patterns for data cleanup

The prompt should tell AI what to preserve, what to change, and what not to invent.

Good JSON cleanup prompt:

Clean up the following JSON entries.

Rules:
- Preserve the existing field names
- Do not add new fields
- Do not remove fields
- Do not rename keys
- Do not convert strings into objects
- Keep URLs and image paths in the same style
- Keep summaries concise and public-facing
- Return valid JSON only
- Point out any entries that look incomplete or unsafe
Good metadata prompt:

Here is one correct object:
[paste example]

Now convert these rough notes into matching objects:
[paste rough notes]

Rules:
- Follow the example exactly
- Keep the same keys
- Use short student-friendly summaries
- Use category names consistently
- Do not invent links or filenames if missing
- Mark unknown values as TODO

From messy notes to clean data

AI is useful when you have human notes that are meaningful but not structured.

Messy input

Useful but inconsistent

Rough notes often mix titles, ideas, side comments, possible links, image names, categories, and private thoughts in one place.

That is fine during brainstorming. It becomes a problem when the content needs to render on a public page.

Clean output

Stable and public-facing

Clean data separates fields clearly. Public summaries are polished. Private notes are removed. Missing values are marked. Links and filenames follow the project pattern.

This is where AI can save a lot of time, as long as you still review the result.

Messy note:

AI data cleanup guide - probably AI / Learning
Talk about site-index json, book recs, messy notes, preserving schema.
Image should be card-ai-data-normalization.png.
Do not make homepage card maybe branch page only.

Clean object:

{
  "id": "ai-data-normalization",
  "title": "AI Data Normalization",
  "type": "Guide",
  "level": "Beginner+",
  "time": "45-60 min",
  "category": "AI / Learning",
  "summary": "Use AI to turn messy notes, card metadata, book lists, resource entries, and project data into stable structured content while preserving the schema.",
  "url": "guides/ai-data-normalization/",
  "image": "assets/card-ai-data-normalization.png",
  "homeSection": "none",
  "featured": false
}

Validate before publishing

AI-generated data should be treated like code. It needs review before it becomes part of the public project.

01

Check syntax

Make sure the JSON is valid: commas, quotes, brackets, and braces all need to be correct.

02

Check fields

Confirm every object has the required keys and uses the same field names.

03

Check rendering

Open the page that uses the data and confirm the cards, filters, or list items render correctly.

04

Check safety

Remove private notes, credentials, sensitive URLs, account details, and anything not meant for public view.

# Basic JSON validation with Python
python3 -m json.tool data/site-index.json > /tmp/site-index-check.json

# If no error appears, the JSON syntax is valid

What to avoid

Most AI data mistakes come from letting the model be too creative with structure.

Avoid

Schema redesigns

Do not let AI change field names, nest simple values, or invent a new structure unless you are intentionally redesigning the data model.

Avoid

Invented file paths

AI may invent image names or URLs that sound correct. Check that the actual files and folders exist.

Avoid

Private notes in public data

Brainstorming notes may include private context. Public JSON should contain only safe, reviewed display content.

AI works better after structure exists

AI is most useful after you already know the shape of the data. That is why this guide comes after project planning and project building.

01
Planning decides what belongs
Before data cleanup, decide whether the item is a guide, project, resource, page, future idea, or private note.
02
Building creates the pattern
The first page, first card, first JSON object, and first render path teach the structure.
03
Normalization repeats the pattern
Once the structure exists, AI can help add entries, clean summaries, check paths, and keep categories consistent.
04
Review protects the project
Git diff, JSON validation, local preview, and manual review keep AI cleanup from becoming accidental redesign.

Safe data cleanup rules

Data cleanup often starts from private notes. Review carefully before publishing.

Remove

Credentials and private details

Do not publish API keys, tokens, passwords, private URLs, private hostnames, private logs, unrevised class material, or account details.

Sanitize

Personal exports

If data starts from private exports, trim it down to the public fields needed for the page. Do not publish the raw source history.

Keep

Public learning value

Keep useful summaries, categories, safe project notes, public links, image paths, and explanations that help someone else learn.

Final idea

AI is excellent at cleaning repeated data after the structure is clear. Define the schema, give examples, preserve the fields, validate the output, and review the public content. The data should become cleaner, not more complicated.

Back to top AI hub Previous: Project Building Project Planning Project Memory All guides