# Rhyme Analytics MCP

An MCP server that connects Claude Desktop to Rhyme's live Supabase database.
Ask Claude natural language questions about your platform data.

## Setup

### 1. Install dependencies
```pip install mcp supabase python-dotenv```

### 2. Configure credentials
```cp .env.example .env```
# Edit .env and add your Supabase URL and service role key

### 3. Run the simulator (optional — adds realistic demo data)
```python simulate.py```

### 4. Connect to Claude Desktop
Add to ~/.config/Claude/claude_desktop_config.json:
```
{
  "mcpServers": {
    "poetryquill": {
      "command": "python",
      "args": ["/full/path/to/server.py"]
    }
  }
}
```
### 5. Restart Claude Desktop
Look for the hammer icon — your tools are connected.

## Example questions to ask Claude

- "Give me a platform overview of PoetryQuill"
- "What are the top 10 most liked poems?"
- "Who are the most followed authors?"
- "Analyze engagement trends over the last 30 days"
- "What tags are writers using most?"
- "Show me the user growth over the last 90 days"
- "Which collections have the most poems?"
- "Analyze a sample of recent poems and tell me what themes are trending"
- "Who has the longest writing streak?"
- "Where are our users from?"

## Tools available

| Tool | What it does |
|------|-------------|
| get_platform_overview | Totals, ratios, 30-day growth |
| get_top_poems | Most liked/viewed/commented poems |
| get_top_authors | Most followed/active/points authors |
| get_engagement_trends | Activity over a time window |
| get_content_sample | Poems for Claude to analyze themes |
| get_user_growth | Weekly signup trends |
| get_tag_analytics | Tag usage and engagement by tag |
| get_streak_leaderboard | Current and longest writing streaks |
| get_collections_overview | Public collections and sizes |
| get_geographic_distribution | Where users are from |

## Schema
Built for Rhyme's Supabase schema:
profiles, poems, likes, comments, follows, collections, collection_poems