{"id":"a017ce96-379a-45e0-be31-e7a6608c95a2","shortId":"V3hngh","kind":"skill","title":"Mirror GitHub issues, pull requests, commits, and releases into SQLite for offline analysis","tagline":"Use dogsheep/github-to-sqlite when an agent needs a local, queryable snapshot of GitHub activity instead of bouncing through the web UI or ad hoc API calls. The agent authenticates once, pulls the exact GitHub objects it needs, and leaves behind a SQLite database that can be insp","description":"# Mirror GitHub issues, pull requests, commits, and releases into SQLite for offline analysis\n\nUse dogsheep/github-to-sqlite when an agent needs a local, queryable snapshot of GitHub activity instead of bouncing through the web UI or ad hoc API calls. The agent authenticates once, pulls the exact GitHub objects it needs, and leaves behind a SQLite database that can be inspected, joined, diffed, or handed to downstream tools.\n\n## Prerequisites\n\nPython 3, pip, SQLite, and a GitHub personal access token or GITHUB_TOKEN/auth.json for authenticated or higher-rate fetches.\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- $ pip install github-to-sqlite\n\nRequirements and caveats from upstream:\n- $ github-to-sqlite pull-requests --state=open --org=psf --org=python github.db\n- $ github-to-sqlite pull-requests --search='org:python defaultdict state:closed created:<2023-09-01' github.db\n\nBasic usage or getting-started notes:\n- Run this command and paste in your new token:\n- Example: [issues table](https://github-to-sqlite.dogsheep.net/github/issues)\n- While pull requests are a type of issue, you will get more information on pull requests by pulling them separately. For example, whether a pull request has been merged and when.\n\n- Source: https://github.com/dogsheep/github-to-sqlite\n- Extracted from upstream docs: https://raw.githubusercontent.com/dogsheep/github-to-sqlite/HEAD/README.md\n\n## Documentation\n\n- https://github-to-sqlite.dogsheep.net/\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/mirror-github-issues-pull-requests-commits-and-releases-into-sqlite-for-offline-analysis/)","tags":["mirror","github","issues","pull","requests","commits","and","releases","into","sqlite","for","offline"],"capabilities":["skill","source-agentskillexchange","skill-mirror-github-issues-pull-requests-commits-and-releases-into-sqlite-for-offline-analysis","topic-agent-skills","topic-ai-agents","topic-ai-tools","topic-awesome-list","topic-claude-code","topic-codex","topic-cursor","topic-llm","topic-mcp","topic-npx-skills","topic-openclaw","topic-skills-catalog"],"categories":["skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/agentskillexchange/skills/mirror-github-issues-pull-requests-commits-and-releases-into-sqlite-for-offline-analysis","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add agentskillexchange/skills","source_repo":"https://github.com/agentskillexchange/skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,663 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T19:11:20.130Z","embedding":null,"createdAt":"2026-05-18T13:17:47.039Z","updatedAt":"2026-05-18T19:11:20.130Z","lastSeenAt":"2026-05-18T19:11:20.130Z","tsv":"'-01':200 '-09':199 '/dogsheep/github-to-sqlite':258 '/dogsheep/github-to-sqlite/head/readme.md':265 '/github/issues)':223 '/skills/mirror-github-issues-pull-requests-commits-and-releases-into-sqlite-for-offline-analysis/)':274 '2023':198 '3':128 'access':135 'activ':26,85 'ad':35,94 'agent':18,40,77,99,269 'agentskillexchange.com':273 'agentskillexchange.com/skills/mirror-github-issues-pull-requests-commits-and-releases-into-sqlite-for-offline-analysis/)':272 'analysi':13,72 'api':37,96 'authent':41,100,141 'basic':202 'behind':52,111 'bounc':29,88 'call':38,97 'caveat':167 'close':196 'command':211 'commit':6,65 'creat':197 'databas':55,114 'defaultdict':194 'dif':120 'doc':262 'document':266 'dogsheep/github-to-sqlite':15,74 'downstream':124 'environ':158 'exact':45,104 'exampl':218,245 'exchang':271 'extract':259 'fetch':146 'get':206,234 'getting-start':205 'github':2,25,46,61,84,105,133,138,162,171,185 'github-to-sqlit':161,170,184 'github-to-sqlite.dogsheep.net':222,267 'github-to-sqlite.dogsheep.net/github/issues)':221 'github.com':257 'github.com/dogsheep/github-to-sqlite':256 'github.db':183,201 'hand':122 'higher':144 'higher-r':143 'hoc':36,95 'inform':236 'insp':59 'inspect':118 'instal':147,151,160 'instead':27,86 'issu':3,62,219,231 'join':119 'leav':51,110 'local':21,80 'match':156 'merg':252 'mirror':1,60 'need':19,49,78,108 'new':216 'note':208 'object':47,106 'offlin':12,71 'open':178 'org':179,181,192 'past':213 'path':154 'person':134 'pip':129,159 'prerequisit':126 'psf':180 'pull':4,43,63,102,175,189,225,238,241,248 'pull-request':174,188 'python':127,182,193 'queryabl':22,81 'rate':145 'raw.githubusercontent.com':264 'raw.githubusercontent.com/dogsheep/github-to-sqlite/head/readme.md':263 'releas':8,67 'request':5,64,176,190,226,239,249 'requir':165 'run':209 'search':191 'separ':243 'setup':153 'skill':270 'skill-mirror-github-issues-pull-requests-commits-and-releases-into-sqlite-for-offline-analysis' 'snapshot':23,82 'sourc':255,268 'source-agentskillexchange' 'sqlite':10,54,69,113,130,164,173,187 'start':207 'state':177,195 'tabl':220 'token':136,217 'token/auth.json':139 'tool':125 'topic-agent-skills' 'topic-ai-agents' 'topic-ai-tools' 'topic-awesome-list' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-llm' 'topic-mcp' 'topic-npx-skills' 'topic-openclaw' 'topic-skills-catalog' 'type':229 'ui':33,92 'upstream':150,169,261 'usag':203 'use':14,73,148 'web':32,91 'whether':246","prices":[{"id":"bae75c82-86f8-49fe-9019-0174ba94498b","listingId":"a017ce96-379a-45e0-be31-e7a6608c95a2","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"agentskillexchange","category":"skills","install_from":"skills.sh"},"createdAt":"2026-05-18T13:17:47.039Z"}],"sources":[{"listingId":"a017ce96-379a-45e0-be31-e7a6608c95a2","source":"github","sourceId":"agentskillexchange/skills/mirror-github-issues-pull-requests-commits-and-releases-into-sqlite-for-offline-analysis","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/mirror-github-issues-pull-requests-commits-and-releases-into-sqlite-for-offline-analysis","isPrimary":false,"firstSeenAt":"2026-05-18T13:17:47.039Z","lastSeenAt":"2026-05-18T19:11:20.130Z"}],"details":{"listingId":"a017ce96-379a-45e0-be31-e7a6608c95a2","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"mirror-github-issues-pull-requests-commits-and-releases-into-sqlite-for-offline-analysis","github":{"repo":"agentskillexchange/skills","stars":8,"topics":["agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor","llm","mcp","npx-skills","openclaw","skills-catalog"],"license":"mit","html_url":"https://github.com/agentskillexchange/skills","pushed_at":"2026-05-18T19:02:17Z","description":"The open catalog of AI agent skills — 2,000+ security-scanned skills for Claude Code, Cursor, Codex, and more.","skill_md_sha":"c786b6282ca488fdc24bf4b7394ed356fa033fb8","skill_md_path":"skills/mirror-github-issues-pull-requests-commits-and-releases-into-sqlite-for-offline-analysis/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/mirror-github-issues-pull-requests-commits-and-releases-into-sqlite-for-offline-analysis"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"Mirror GitHub issues, pull requests, commits, and releases into SQLite for offline analysis","description":"Use dogsheep/github-to-sqlite when an agent needs a local, queryable snapshot of GitHub activity instead of bouncing through the web UI or ad hoc API calls. The agent authenticates once, pulls the exact GitHub objects it needs, and leaves behind a SQLite database that can be inspected, joined, diffed, or handed to downstream tools."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/mirror-github-issues-pull-requests-commits-and-releases-into-sqlite-for-offline-analysis"},"updatedAt":"2026-05-18T19:11:20.130Z"}}