How I Built RepoSense: A GitHub Intelligence CLI With Coral SQL

ATHULKRISHNAN H Posted on May 31 How I Built RepoSense: A GitHub Intelligence CLI With Coral SQL # coral # sql # github # hackathon Every developer I know has the same problem: 300 open issues, 40 stale PRs, a security label buried somewhere in the noise — and no fast answer to what actually needs attention right now? I built RepoSense to answer that question in under 10 seconds, for any public GitHub repo, with one terminal command and no dashboard. The Idea RepoSense is a terminal intelligence layer for GitHub repos. You point it at any repo and get: The oldest unattended issues (triage) Non-draft PRs that have been waiting too long (stale-prs) What shipped in the last two weeks (release-notes) What Hacker News is saying about the project (hn-buzz) Known CVEs for your dependencies (cve-scan) Who is contributing most right now (contributors) Issues that might be duplicates of each other (duplicates) A repo health score with a live progress bar What the tech community is discussing alongside your open issues (pulse — cross-source SQL JOIN) What developers are struggling with on Stack Overflow right now (so-buzz) What developers are writing about this tech on Dev.to (dev-buzz) The full OpenSSF security posture — 18 checks, zero config (scorecard) And if none of those match what you need, you can just type a question in plain English and the built-in AI agent (Claude, Groq, or GPT-4o) writes the SQL and runs it for you. The whole thing runs in your terminal. No browser, no dashboard, no SaaS login. Why Coral The data I needed — GitHub issues, PRs, Hacker News posts, OSV vulnerability records — lives in completely different APIs with completely different schemas and auth systems. The traditional approach is to write a separate HTTP client for each, normalise the responses into Python dicts, and glue them together in application code. Coral makes all of that disappear. It exposes live APIs as SQL tables. GitHub becomes github.search_issues() . Hacker News becomes hn.sea