Generate stack insights

What it does

Queries the approved projects in the production directory, aggregates tech-stack trends across them, and writes a new structured markdown file into the insights content collection — ready to publish without any manual data entry.

When it triggers

Run it on a schedule (monthly) or on demand with prompts like “generate monthly insight”, “aylık trend raporu oluştur”, “create stack insights”, or “generate insights report”.

What’s inside

• A query step against the live directory database for approved projects only.
• Aggregation logic that surfaces the month’s most notable stack-adoption shifts.
• A markdown writer that matches the insights content collection schema (title, date, description, sample size, stat callout, FAQ).

Example prompt

Generate this month’s stack insights report.