Tools & Resources
Free, open-source tools and guides for public data research and AI workflows. Something here for every level of experience.
Just Use It
Level Up Your AI Work
Practical guides and patterns. No setup required.
AI & Content Processing
AI Image Generation
Generate photorealistic images of real people with identity preservation. Includes a mannequin-based hairstyle library with 63 styles.
Gemini Vision OCR
OCR and handwriting transcription with Gemini. Model selection, compression pipeline, and batch processing patterns.
Large Document Processing
Strategies for reading and analyzing large documents within AI context limits. Scout-before-reading, chunking, and checkpoint patterns.
Data
Data Deduplication Patterns
Exact and fuzzy matching strategies for cleaning duplicate records across CSV, Airtable, and BigQuery.
Airtable Bulk Operations
Batch updates, project consolidation, filterByFormula patterns, and silent failure debugging.
Infrastructure
DNS & Email Authentication
SPF, DKIM, and DMARC setup patterns for Google Workspace and Mailchimp.
Google Drive Operations
Google Workspace MCP patterns: decision flowchart, Shared Drive operations, and common gotchas.
Campaign Tech
SMS Marketing Compliance
TCPA, CTIA, TCR, and carrier compliance requirements. Registration flow and website checklist.
Archival & Digitization
Physical Media Archive
Systematic approach to digitizing CDs, DVDs, and USB drives with tiered deduplication and verification.
Build Your Own
Open-source MCP servers and system architecture.