Richard Schoen richardschoen

Beast Mode

Beast Mode is a custom chat mode for VS Code agent that adds an opinionated workflow to the agent, including use of a todo list, extensive internet research capabilities, planning, tool usage instructions and more. Designed to be used with 4.1, although it will work with any model.

Below you will find the Beast Mode prompt in various versions - starting with the most recent - 3.1

Installation Instructions

Go to the "agent" dropdown in VS Code chat sidebar and select "Configure Modes".
Select "Create new custom chat mode file"

	-- Purpose: Running QSH command using SQL
	-- Version: 1.0
	-- Date 08/02/2026
	-- Author: Andrea Buzzi
	-- Docs: https://www.ibm.com/docs/en/i/7.6.0?topic=services-qcmdexc-procedure
	-- https://www.ibm.com/docs/en/i/7.6.0?topic=services-environment-variable-info-view

	CREATE OR REPLACE FUNCTION SQLTOOLS.RUN_QSHELL (
	INCMD VARCHAR(10000)
	)

	/*************************************************************************************************/
	/* The goal of this SQL script is to demonstrate various features of SQL PL. This will include */
	/* loops, error handling, parameters, cursor management, returning of result sets, and more. */
	/* The topic of this script will revolve around the management (deletion) of journal receivers. */
	/* */
	/* Created for Common POWERUp 2024 */
	/* Session: Getting Started with SQL Functions and Procedures */
	/* Author: Ryan Moeller (rmoeller@ibm.com) */
	/* Date: May 2024 */
	/*************************************************************************************************/

	/*************************************************************************************************/
	/* Manage consumption of storage by journal receivers, only keep last N days of journals */
	/*************************************************************************************************/
	SELECT *
	FROM QSYS2.JOURNAL_RECEIVER_INFO
	WHERE DETACH_TIMESTAMP < CURRENT DATE - 3 DAYS;


	-- NOTE: *IGNINQMSG is not specified for DLTJRNRCV. Any unsaved journals receivers will not be deleted.
	CREATE OR REPLACE FUNCTION SYSTOOLS.DELETE_OLD_RECEIVERS (

	/******************************************************************************/
	/* Find security-related changes made by potentially vulnerable user profiles */
	/******************************************************************************/

	-- Navigator's Users Tab
	SELECT
	CASE GROUP_ID_NUMBER
	WHEN 0 THEN 'USER'
	ELSE 'GROUP'
	END AS PROFILE_TYPE,

	/************************************************************************************************************/
	/* Check for defective PTFs, new PTF groups, and firmware updates. Email someone a spreadsheet the results! */
	/************************************************************************************************************/
	CREATE OR REPLACE FUNCTION SYSTOOLS.SYSTEM_CURRENCY_STATUS (
	EMAIL VARCHAR(100)
	)
	RETURNS INT
	SPECIFIC SYSTOOLS.SYSCURSTS
	MODIFIES SQL DATA
	LANGUAGE SQL

	/*************************************************************/
	/* Use system limits to find users abusing IFS space */
	/*************************************************************/

	-- Look at all users who have triggered system limits in the last 24 hours...
	SELECT *
	FROM QSYS2.SYSLIMITS
	WHERE LAST_CHANGE_TIMESTAMP > CURRENT TIMESTAMP - 1 DAY
	AND USER_NAME != 'QSYS'
	ORDER BY LAST_CHANGE_TIMESTAMP DESC;

	/**************************************************************************************/
	/* Track temporary storage usage with QSYS2.SYSTEM_STATUS and QSYS2.SYSTMPSTG */
	/**************************************************************************************/

	-- Create schema for function and detail file creation.
	CREATE SCHEMA TMPSTGMON;

	-- Information as presented by Navigator
	SELECT SYSTEM_ASP_STORAGE,
	CURRENT_TEMPORARY_STORAGE,

	// Based: Croy, Steve (2005) Display-attributes-made-simple/setcolor [Source code]. http://search400.techtarget.com/tip/Display-attributes-made-simple


	// --------------------------------------------------
	// Procedure name: RtnDspAtr
	// Purpose: Return Display Attribute hex code that can be used on a
	// screen to set color, underline, or other attributes.
	// Returns: DSPATR hex value
	// Parameter: Color Value - Text representing a color 'GRN' (default)
	// other values: 'BLU' 'PNK' 'RED' 'TRQ' 'WHT' 'YLW'

	<?php
	// This file walks you through the most common features of PHP's SQLite3 API.
	// The code is runnable in its entirety and results in an `analytics.sqlite` file.


	// Create a new database, if the file doesn't exist and open it for reading/writing.
	// The extension of the file is arbitrary.
	$db = new SQLite3('analytics.sqlite', SQLITE3_OPEN_CREATE \| SQLITE3_OPEN_READWRITE);

	// Errors are emitted as warnings by default, enable proper error handling.