I created Scrumdog – a program to download Jira Issues to a local database

• github-to-sqlite

  7 377 6.0 Python

  Save data from GitHub to a SQLite database

  

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!

Here's my github-to-sqlite tool which imports GitHub Issues https://datasette.io/tools/github-to-sqlite - being able to query them in a local SQLite database is super-handy. I run a demo instance of the resulting database here: https://github-to-sqlite.dogsheep.net/

• steampipe

  146 6,366 9.7 Go

  Zero-ETL, infinite possibilities. Live query APIs, code & more with SQL. No DB required.

  

Readers may also enjoy Steampipe[1], an open source [2] tool that uses Postgres FDW's for live SQL queries against Jira, Confluence, GitHub, GitLab, AWS, Slack and many more tools [3].

1 - https://steampipe.io

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• jira

  8 2,658 0.0 Go

  simple jira command line client in Go

  

I had used https://github.com/go-jira/jira in my previous job. custom-commands is very useful feature. I had built a set of commands to filter out issues for different use cases. The command line approach was way faster than waiting for the jira page to load and click the correct set of filters.

• beekeeper-studio

  59 15,240 9.8 TypeScript

  Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.

  

• dbgate

  27 4,230 7.9 Svelte

  Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application

  

• taskwarrior

  97 3,840 8.7 C++

  Taskwarrior - Command line Task Management

  

Suggest a related project