Skip to content

Instantly share code, notes, and snippets.

@swalke16
swalke16 / secure_mongodb_query_mcp_tool_8464c4ab.plan.md
Last active January 29, 2026 20:24
Technical plan for a secure, company-scoped MongoDB query MCP tool for LLM agents

Secure MongoDB Query MCP Tool

Architecture Overview

sequenceDiagram
    participant LLM as LLM Agent
    participant MCP as MCP Tool
    participant Auth as Session Token
 participant Rewrite as Query Rewriter
@swalke16
swalke16 / participation_report_discrepancy_investigation.md
Last active January 22, 2026 22:24
Analytics User Count Discrepancy Investigation - TSUP Merge Pipeline Bug

Investigation: User Count Discrepancy Between Analytics Pages

Date: January 20, 2026 Investigated by: Scott Walker Company: 634ecb9e56cf240017ee64cc (Onin Staffing) Period: September 2025


Problem Statement

@swalke16
swalke16 / participation_user_count_discrepancy_investigation.md
Created January 20, 2026 22:24
Investigation: User Count Discrepancy Between Analytics Pages

Investigation: User Count Discrepancy Between Analytics Pages

Date: January 20, 2026
Investigated by: Scott Walker
Company: 634ecb9e56cf240017ee64cc (Onin Staffing)
Period: September 2025


Problem Statement

@swalke16
swalke16 / workday_request.py
Created July 11, 2022 15:32
Workday credential verification
import requests
import json
from xmltodict import parse
# Populate these with your Workday info!
tenant_name = ""
username = f"ISU_USERNAME@{tenant_name}"
password = ""
# Exact URL may vary
url = f"https://services1.myworkday.com/ccx/service/{tenant_name}/Human_Resources/v38.2"
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>IKE Custom Application Example</title>
</head>
<body style="background-color: white; font-size: 32px;">
<input type='text' id="txtBox" />
</body>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>IKE Custom Application Example</title>
</head>
<body style="background-color: white; font-size: 32px;">
<input type='text' id="txtBox" />
</body>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>IKE Custom Application Example</title>
<script>
// For security reasons the external application should only receive or
// send events from the IKE application. The origin below is the correct origin
// for the application to run on production. For the IKE Test environment you
@swalke16
swalke16 / test.ics
Last active October 4, 2019 14:43
test cal
BEGIN:VCALENDAR
PRODID:-//Google Inc//Google Calendar 70.9054//EN
VERSION:2.0
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:October 2019 Events
X-WR-TIMEZONE:America/Chicago
BEGIN:VEVENT
DTSTART:20191003T000000Z
DTEND:20191003T020000Z
@swalke16
swalke16 / sna.ical
Created July 22, 2019 20:52
sna ical test
BEGIN:VCALENDAR
PRODID:-//Google Inc//Google Calendar 70.9054//EN
VERSION:2.0
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:City Events
X-WR-TIMEZONE:America/Chicago
BEGIN:VEVENT
DTSTART:20190725T180000Z
DTEND:20190725T200000Z
@swalke16
swalke16 / sync-places-for-categories.rb
Created February 13, 2019 15:31
Sync Places For New Categories
# this script given that new categories have been created and attached to the relevant apps
# will for the specified account_names and category_names sync all the relevant google places
account_names = ["Baltimore", "Denver", "Los Angeles",
"Short North", "SMRT Columbus"]
category_names = ["Antiques & Vintage", "Beer, Wine, & Spirits", "Juice & Natural Foods"]
accounts = Account.where(name: account_names)
accounts.each do |account|
category_ids = account.categories.where(name: category_names).pluck(:id)