Peter Mescalchin magnetikonline

Sending AWS SNS message subscription into Slack workflow

Inspired by: https://stackoverflow.com/a/72574950

A no-code solution to push messages sent to an AWS SNS topic into Slack via a workflow webhook.

Create a new Slack Workflow, using From a webhook as the triggering event.
Include the following Data variables:
```
Message
```

Jira un-thread item comments bookmarklet

Atlassian added the concept of Threaded Comments around September 2025.

Currently there is no formal method to "un-thread" a conversation into a sequential list of comments. This bookmarklet is a (hacky) attempt to un-thread ticket comments and place in descending date order.

Usage

Create a new empty bookmark. Name it appropriately (e.g. Jira comment un-thread).
Copy contents of bookmarklet.js place into the URL of the new bookmark.

Chrome extensions I use

Locate unused AWS security groups

For an AWS Security Group to be considered in-use/active it will be assigned to an Elastic network interface (ENI's).

The following Python script will determine currently unused security groups by:

Query AWS for all active ENI's in an account region.
For each interface, extract the attached security group(s).
Query AWS for all security groups within the same account region.
Determine where and output a security group which currently has zero assignments to any active ENI's.

Extract AWS IAM action list tables to JSON

A quick-and-dirty browser script for extracting action list tables from AWS Identity and Access Management pages to JSON documents.

Once in JSON, these IAM action lists can be easily queried using tools such as jq to answer questions such as:

List all Write IAM actions for service X.
List all Read IAM actions for service X resource type Y.

Usage example

Install Rsync on macOS from source

Bash script to install a much more recent version of rsync from source on macOs.

Requires as a minimum Xcode CLI tools (no need for a full install). Can be installed via the following:

$ xcode-select --install

PostgreSQL list tables without defined primary key

This query can be handy for tasks such as setting up a logical replication publication, where by default a table's PRIMARY KEY is used to identify subscriber side rows for update or delete.

By locating tables without a PRIMARY KEY (tisk!), we're able to either update the table schema, or use an alternative replica identity type.

SELECT tbl.table_catalog,tbl.table_schema,tbl.table_name
FROM information_schema.tables tbl
WHERE

Node.js HTTP echo server

Simple HTTP server, listening on localhost:8083 which just echoes back HTTP requets sent to it.

Blantant ripoff of: https://gist.github.com/bszwej/62c327d773051816ed4949fd40c82c74

Delete all AWS CodeBuild build history

Quick way to delete all existing build history from AWS CodeBuild using the AWS CLI.

#!/bin/bash -e

buffer=()
for buildId in $(aws codebuild list-builds --query 'ids.join(`\n`,@)' --output text); do
 buffer+=($buildId)

	const fs = require('fs');

	function buildCommand(deps,flag = '') {
	if (!deps) return;
	const packages = Object.entries(deps)
	.map(([name,version]) => `${name}@${version.replace(/^[\^~]/,'')}`)
	.join(' ');

	if (flag) {
	flag = ' ' + flag;