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].
The Steampipe open source project and community are managed by Turbot [1]. We also have Steampipe Cloud [2] in preview if you'd prefer a hosted version focused on teams.
I built a very similar tool for my company to download a set of DataDog logs into SQLite. Products like Jira and DataDog have their own query engines for sure, but you really can't beat the capabilities of true SQL for deeper analysis.
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!
I had used https://github.com/go-jira/jira in my previous job. custom-commands is a 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.
Just noting that you can use an EL(T) tool like Airbyte (OSS) for this as well! The integrations are already built - Jira -> mongo, Jira -> Postgres, etc.
If you're forced to use Jira, and setting up a local replica database is surplus to your interest / requirements, I can recommend the Jira Assistant chrome extension.
The licence is a bit wonky (source-available, basically) but the feature set fills a few gaps with the regrettable stock UI.
You might also try https://www.beekeeperstudio.io/ or https://dbgate.org/ for working with databases (SQLite and others). I really like the UIs of each and they're both open source- supported by donations if you find either useful.
Agreed, but i also think the -dog portion of the name likely refers to *fetching* of data...you know, like a dog fetches...well, i woud guess anyway. ;-)
I wish there was a program to enter hours into Jira (and related tasks of course) and upload them.
We have to use Jira for logging hours at work now because they think that makes us agile. Needless to say the only agile related thing we do is logging hours in Jira so that's a complete joke. Our project management department is full of complete idiots.
But Jira is such a dog to work with. Especially if you only enter stuff for the sake of it. It won't accept "7h33m", no it has to be "7h 33m". For every change you need to refresh all pages before they're picked up. It's ridiculously slow.
A frontend where I could just dump my made-up hours that would then take its time to upload that shit to Jira would really help me to be less stressed.
I've been wanting to suck in Jira tickets to my own database so that I can full-text index them along with code, docs, customer requests, Slack, etc. Then when you're looking for information, you only have to go to one place.
(My ulterior motive is to write a blog post that's like "how I used the product I make at work to index all information at the company". I can usually just do a linear scan across the backlog to find the issue I want, but hey, when marketing and software combine, I can't complain.)
If there's some service I can buy that does this, though, I'd rather use that.
I think this is more of a way to automate pulling large amounts of data from Jira rather than doing it directly from a dashboard. Also could be utilized as a backup repository.
In my case, I find it hard to query related issues of different types. It's kind of hard to explain unless you see how we use Jira, but I basically want to do joins. You can do some interesting things with the Structure plugin, or issueFunction() from the Adaptavist ScriptRunner plugin. The other thing I've done is to pull a few REST queries into a single-page app., but that takes more work.
You might also be interested in the excellent Bugwarrior [1] which syncs issues from a wide variety of issue trackers (JIRA is amongst them) [2] to your Taskwarrior [3] database.
This is what I need but for Mac! Any idea of alternatives? I have multiple Jira instances I want to combine -- literally can't find an app that does this.
Author here - Yes that is exactly what it does. I'll compile it for the Mac later today and load it on the Scrumdog.app website. Thanks for your comments.
My manager a few jobs back did something like this, but just using Microsoft Excel with Power Query. No need to even install sqlite. Normally, that probably isn't much of an obstacle, but this was in a classified environment where it was nearly impossible to get the local IT admins to install additional software on your workstation. Every corporate Microsoft box is going to already have the Office suite.
I'm curious about this. I would say I'm fairly versed in Excel but haven't dug too deep into Power Query / the data model. If you wouldn't mind, how is this done?
While it is possible, it is certainly less than stellar compared to the other languages that were reviewed. Granted my experience was 1 - 2 yrs ago with .Net Core 5. I recall having to deal with setting different temp directories each time I wanted to run a another instance of a 'single binary' because the first thing it did was unzip the bundled runtime into the system wide TEMP directory. It certainly was a single file app but behaved more like an installer.
Whoever came up with that obviously didn't understand the why of single .exe applications.
Jira's querying and reporting facilities leave a lot to be desired. I have some scripts to pull the data down into a sqlite database so I can query it much better.
FYI - This type of workflow automation and connecting to Saas product APIs and moving data around can also be easily built using a no-code RPA tool like PixieBrix[0].
Until the current crop of managers retire, Atlassian will still have business. Some don't know anything other than Jira, so will recommend it on corporate purchases.
There were zero issues with performance/reliability that caused the outage, they just deleted hundreds of customers data, and had to manually restore the data due to lack of automated restore scripts.
Reliability is measured from a customer's perspective, not from a geeky vendor-oriented perspective of a backend service. When the vendor deletes data, the vendor's reliability quotient decreases, because that data is no longer available to the customer.
1 - https://steampipe.io 2 - https://github.com/turbot/steampipe 3 - https://hub.steampipe.io