Reddit intelligence gathering and analysis tool for extracting, processing, and exporting Reddit posts with sentiment analysis, content classification, and competitive intelligence
Two tools with partial schemas and descriptions. fetch_reddit_posts has a complete input schema with 7 parameters (all typed, most described), but lacks output schema documentation, critical for LLM planning. export_to_excel has 4 input parameters with types and descriptions, but no output schema. Both descriptions are adequate (100+ chars) but lack actionable guidance on when to use each tool or what to do with results. No error handling guidance, no parameter constraints (enums), no idempotent/destructive hints. Tool names follow verb_noun pattern (good), but descriptions do not explain prerequisites, dependencies, or recovery paths.
Generate a dual-sheet Excel report from Reddit posts data: Sheet 1 contains 18-column detailed post analysis with color-coded sentiment, content type, and confidence; Sheet 2 contains overview statistics, sentiment distribution, content quality metrics, category distribution, high-value signals, competitor mentions, and action recommendations
Fetch Reddit posts matching a query using multiple sort strategies (relevance, hot, new, top) across configurable time ranges (week, month, 3month, year, all) with optional subreddit filtering, deduplication, and deep comment extraction
No output schemas documented for either tool. LLMs cannot plan downstream calls or extract required fields (e.g., post IDs, URLs) without knowing what fetch_reddit_posts returns.
fetch_reddit_posts accepts free-form time_range string despite enum constraint in schema. Description should explicitly state valid values: 'week, month, 3month, year, all' to prevent LLM hallucination.
No error handling guidance. If Reddit API rate-limits or a subreddit is invalid, what should the LLM do? No recovery hints provided.
export_to_excel requires posts_json as a file path string. No validation rules stated (file must exist, must be valid JSON). LLMs may pass invalid paths without guidance on what constitutes valid input.
| Scored | Grade | Overall | Spec posture | Rubric |
|---|---|---|---|---|
| 2026-09-23 | F | 43 | 2026-07-28+ | v2 |
No tool annotations (readOnlyHint, destructiveHint, idempotentHint). fetch_reddit_posts is read-only; export_to_excel is destructive (writes file). LLMs need this metadata to reason about side effects and retry safety.