Copy data as JIRA table from the SQuirreL SQL Client

Quick tip. I use the SQuirreL SQL Client when working with databases. Sometimes, I want to paste the results of an SQL statement into a JIRA issue, but the default text copy doesn’t format well, and you can’t use HTML in a JIRA issue.

Since version 3.3.0, Squirrel allows you to copy as wiki text, once you have defined how the wiki text should be formatted. Here is the configuration that works for JIRA:

Screenshot of a software interface titled "Global Preferences" showing multiple tabs: DB Copy, DB Diff, Derby, L & F, Fonts, MS SQL-Server, MySQL, Oracle, Refactoring, Bookmarks, SQL Scripts, Data Type Controls, Update, Wiki Table, SQL formatting. The "Wiki Table" tab is active, displaying a configuration window with options for creating a wiki table named "JIRA". The window includes fields for table tags, headers, rows, cells, and a checkbox labeled "Enabled." On the right, there's an example of a wiki table with countries (Austria, Italy) and their capitals, along with resulting wiki text. Buttons "New," "Copy," "Delete," "OK," and "Close" are at the bottom.

To use it, run some SQL, then select the data you want to copy and right-click. From the context menu, you can now copy as JIRA.

Dropdown menu with options: Copy as WIKI table (JIRA), Copy as SQL IN statement, Copy as SQL WHERE statement, Copy as SQL UPDATE-SET statement, Copy as SQL INSERT-VALUES statement, Export CSV / MS Excel / XML, Adjust all column widths, Always adjust all column widths (checked), Show row numbers (unchecked), Make Editable, Select All, Select entire row(s), Print.

I’m sure my colleagues will be appreciating the nicer formatting of data in my JIRA issues :-)