Skip to content

mergestat

Get all emails

/* Get list of emails and authors*/
SELECT DISTINCT author_email, author_name FROM commits

/* Get list of emails and authors, with the repo name*/
SELECT DISTINCT author_email, author_name, COUNT(*) FROM commits
mergestat "SELECT UNIQUE(author_email) FROM commits" --format ndjson


REMOTE_URL="https://github.com/mergestat/mergestat.git"
REMOTE_URL="https://github.com/ethereum/EIPs.git"
mergestat "SELECT COUNT(*), author_name, author_email, '${REMOTE_URL}' as remote_url from commits('${REMOTE_URL}') GROUP BY author_email" --format ndjson