Turn Your Email Into a SQL Database (opens in new tab)

Your inbox is data. Query it like data. The 2-Minute Version: # Install and ingest your Gmail brew tap surveilr/tap && brew install surveilr surveilr admin init -d email.db surveilr ingest imap \ -u you@gmail.com \ -p "your-app-password" \ -a imap.gmail.com \ -d email.db # Query it surveilr shell -d email.db -- Find every email from a specific sender SELECT subject, date, "from" FROM emails WHERE "from" LIKE '%@vendor.com%' ORDER BY date DESC; Your inbox is now a SQL database. Query it like a...