
Stagehand
Year: 2025
Technologies Used
ReactTypeScriptExpressDiscord.jsPostgreSQLDocker
About This Project
Stagehand is a comprehensive content curation tool built for podcast and show producers. It monitors Discord channels for URLs shared by community members, automatically scraping and organising them into a searchable, manageable database with a web-based dashboard.
Core Functionality:
- Discord Integration: Bot-based scraping that finds a configurable "start marker" message and captures all URLs posted afterward, with smart filtering for images/GIFs and Twitter URL normalisation
- Link Preview System: Automatic fetching and 30-day caching of URL metadata (titles, descriptions, images) via linkpreview.net API
- URL Management Dashboard: Full CRUD operations with pagination, advanced filtering (by category, episode, status, poster), sorting, and visual badge system
- Bulk Operations: Multi-select with sticky toolbar for batch category/episode assignment and status marking
- Production Workflow: Specialised "Showtime" view showing only selected URLs grouped by category with drag-and-drop reordering for live show preparation
- Episode Management: Create episodes, assign URLs, and maintain rich-text show notes with auto-save and image paste support
- Scheduling & Automation: Cron-based scheduled scraping with a user-friendly GUI builder and Discord webhook notifications
- Authentication: JWT-based security for admin functions