<story><title>Scrumdog – a program to download Jira Issues to a local database</title><url>https://whoek.com/b/jira-to-sqlite-with-scrumdog.html</url></story><parent_chain></parent_chain><comment><author>nathanwallace</author><text>Readers may also enjoy Steampipe[1], an open source [2] tool that uses Postgres FDW&amp;#x27;s for live SQL queries against Jira, Confluence, GitHub, GitLab, AWS, Slack and many more tools [3].&lt;p&gt;1 - &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;steampipe.io&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;steampipe.io&lt;/a&gt;
2 - &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;turbot&amp;#x2F;steampipe&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;turbot&amp;#x2F;steampipe&lt;/a&gt;
3 - &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;hub.steampipe.io&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;hub.steampipe.io&lt;/a&gt;</text></comment>
<story><title>Scrumdog – a program to download Jira Issues to a local database</title><url>https://whoek.com/b/jira-to-sqlite-with-scrumdog.html</url></story><parent_chain></parent_chain><comment><author>simonw</author><text>Absolutely love this. I have a whole bunch of similar tools for importing stuff from different services into SQLite but I never got up the courage to take on Jira!&lt;p&gt;Here&amp;#x27;s my github-to-sqlite tool which imports GitHub Issues &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;datasette.io&amp;#x2F;tools&amp;#x2F;github-to-sqlite&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;datasette.io&amp;#x2F;tools&amp;#x2F;github-to-sqlite&lt;/a&gt; - being able to query them in a local SQLite database is super-handy. I run a demo instance of the resulting database here: &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;github-to-sqlite.dogsheep.net&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;github-to-sqlite.dogsheep.net&amp;#x2F;&lt;/a&gt;</text></comment>