Pivot logo Pivot.build Contact
Why Pivot exists

Born from a moment that changed how I see AI.

Pivot was born out of a personal moment: a family medical scare where the diagnosis we received echoed what early AI analysis had already suggested. That experience pushed me from curiosity to deep practice — pursuing advanced study and shipping real systems.

Today Pivot does three things: we review your business processes to find where AI fits and what it's worth, we research and test the right tools against your actual workflows, and we build the private AI systems that handle the work those tools can't. Everything we do runs through the same playbook of guardrails and safety practices.

Who this is for

Individuals who want help understanding or using AI, and small businesses or teams looking for productivity gains.

How we help

Three pillars. One goal: get your time back.

Show +

Business Process Review & Efficiency Research

Find where your processes are losing time. Fix it before your competition does.

We review how your team actually works — the intake forms, the approvals, the reports, the recurring emails — and map exactly where AI can step in. No generic checklists: we research and test tools against your specific workflows and deliver a prioritized action plan.

Prompt Engineering for Everyday Efficiency

Spend less time on the work AI can already do.

We help you use today's AI tools — ChatGPT, Claude, Copilot, Gemini — to handle the recurring work that drains your week: email backlog, tax prep, meeting recaps, research briefs, planning documents, and software changes. You keep your judgment; AI handles the typing.

AI Solutions We Build & Deploy

When prompts aren’t enough, we ship the system.

Custom AI agents that watch your systems and tell you what's wrong, an email answering service that drafts replies in your voice, private chatbots trained on your documents, vibe-coded apps stood up in days, and end-to-end automation that keeps cloud infrastructure running on budget.

Pillar 1 · Process Review & Efficiency Research

Find where your processes are losing time — and fix it.

Show +

Most teams have more to gain from streamlining what they already do than from learning new tools. We dig into your actual workflows, research where AI fits, and deliver a prioritized plan — starting with the change that pays off fastest.

AI Efficiency Assessment

Who it's for

Owners, managers, and teams who want to know where they are losing time to manual or repetitive work.

What you walk away with

A structured walk-through of your key workflows that produces a prioritized list of where AI will save the most time — with realistic estimates and a clear first step to act on immediately.

Business Process Deep-Dive

Who it's for

Organizations with a specific process — intake, reporting, approvals, communications — they want to streamline.

What you walk away with

A focused review of the process as it runs today: a written map of where AI fits, where the risks are, and a concrete improvement plan ranked by impact so you know exactly where to start.

Ongoing Efficiency Research

Who it's for

Individuals or teams who want a dedicated resource continuously researching AI tools that apply to their role or industry.

What you walk away with

Regular briefings on what is actually worth your attention — grounded in hands-on testing against your real work, not generic AI trend reports.

AI Safety & Guardrails Briefing

Who it's for

Leaders responsible for letting their team use AI without exposing the business.

What you walk away with

A plain-English briefing on what to allow, what to forbid, and a starter policy you can hand to your team — covering data privacy, model selection, and human-in-the-loop review.

Pillar 2 · Prompt Engineering

Where AI saves you time today.

Show +

You don't need a custom system to start getting hours back. We research and test the best prompting patterns for ChatGPT, Claude, Copilot, and Gemini — then share what actually works for your day-to-day work.

Shared-Inbox Email Responder

What you get: A service-account inbox (info@, support@, sales@) that drafts replies in your voice and queues them for one-click approval. Never auto-sends.

For example: Overnight the assistant reads everything that came into your shared mailbox, drafts a reply for each one grounded in prior conversations, and presents them oldest-first the next morning for you to approve, edit, or skip.

Taxes & Records

What you get: Organize a year of receipts, statements, and notes into a tax-ready summary.

For example: Drop in your records; AI groups them by category, flags likely deductions, and produces a clean checklist for your preparer.

Audio Transcription & Summaries

What you get: Turn calls, meetings, and recorded talks into a transcript with a one-page summary and discussion questions.

For example: A weekly recording is transcribed overnight and delivered as a PDF with a one-page summary plus discussion questions, ready the next morning.

Research

What you get: Get a multi-source briefing on any topic — with citations you can verify.

For example: Ask a question; receive a structured brief drawing from named sources, each statement linked to where it came from.

Planning

What you get: Turn a fuzzy goal into a sequenced, realistic action plan in minutes.

For example: Describe what you're trying to accomplish; AI proposes phases, milestones, owners, and the questions you forgot to ask.

GitHub Copilot & Coding

What you get: Ship features and fixes in hours instead of days — with a senior reviewer in the loop.

For example: Describe the change you want; AI proposes the code, you review the diff before anything is committed.

Pillar 3 · Deployed Solutions

When prompts aren't enough, we ship the system.

Show +

Working systems running on a schedule — not slide-deck demos. Each card below shows what the solution does for the business, with the technology details kept underneath.

AI Agents (Read-Only Monitoring)

AI Agents That Watch Your Systems For You

Tired of jumping between five portals at 2 AM trying to figure out what broke? Wish someone could read everything for you, summarize the root cause in plain English, and hand it to you so you can decide the fix? That is what these read-only AI agents do. They look, they correlate, they write up what they found, and they wait for you to choose what to do next. The "what to fix" stays a human decision; the hour of digging does not.

More details

What you get: A safe, read-only AI assistant that watches your databases, networks, or cloud accounts and tells you in plain English what's wrong, what changed, and what to look at first.

The agent has eyes-only access — it can investigate, correlate, and write up findings, but it cannot make changes. You get the diagnostic write-up in minutes instead of hours; the fix stays a human decision.

Technology: OpenClaw agent framework, local LLMs on DGX Spark (Llama 3.1, Qwen3), Azure OpenAI, Azure Resource Graph, Az PowerShell, T-SQL diagnostic packs, RBAC reader-only roles, Managed Identity.

Methodology: read-only-by-design tool surface, RBAC-bounded scope per agent, evidence collection then plain-English summarization, human-in-the-loop on every recommended action, reusable scaffolding across SQL, networking, and cost-monitoring agents, GUARDRAILS file enforced on agent prompts.

Built with

OpenClaw / NemoClaw agent framework · Azure Resource Graph · Azure Monitor · SQL diagnostic queries · read-only RBAC scope

AI Agents That Watch Your Systems For You

1 of 1

AI Agents That Watch Your Systems For You screenshot 1

Database Diagnostics & Maintenance Assistant

Want to know your databases are healthy before the on-call phone rings? Want a friendly tool that checks 40+ best practices, tells you what is wrong in plain language, and never shrinks a healthy log file by accident? This is that tool. Sat in front of a real production fire and traced the root cause in minutes instead of hours, and kept track of every fix decision (approved, deferred, or accepted-risk) along the way.

More details

What you get: When a critical database fills up its transaction log or starts running slow, an AI-assisted diagnostic walks through 40+ best-practice checks and produces a ranked fix list — no guessing, no panic.

Built on top of community-standard SQL health-check scripts, the assistant runs on a schedule, surfaces the highest-risk findings, and only takes corrective action where you have explicitly pre-approved it.

Technology: Azure SQL Managed Instance, T-SQL, DMVs, sp_Blitz, SQL Agent jobs, PowerShell, CSV-based change tracking, Az.Sql.

Methodology: 40+ best-practice check sweep, ranked CSV-tracked fix list, conservative log-file shrink guard (only over 500 MB and under 10% utilized), Accepted-Risk / Approved / Deferred state machine for fixes, evidence-backed root-cause writeups (real ADR/PVS incident as proof point).

Built with

Azure SQL Managed Instance · PowerShell · sp_Blitz · SQL Agent · CSV approval workflow

Database Diagnostics & Maintenance Assistant

1 of 1

Database Diagnostics & Maintenance Assistant screenshot 1

AI-Driven SQL Server Remediation — 100+ Automated Fixes

Run database servers on your own virtual hardware and want to make sure they follow the same best practices as your cloud databases? This is the same 40+ check sweep, adapted for the virtual host, the storage layout, the OS, and the database itself, with results that flow into the same fix-tracking workflow already in use. Running through this solution on two virtual Microsoft SQL Servers resulted in 100+ completely automated fixes - all AI prompt drive. A complete solution was build from the ground up taking best practice documents, generating fix scripts from them, creating checks and balances with human in the loop approvals (CSV file column) and then automating the deployment for fixes in the correct sequence.

More details

What you get: Best-practice documents fed into an AI pipeline that generates fix scripts, routes them through a human approval workflow, then deploys the approved fixes in the correct sequence — resulting in 100+ improvements across on-prem virtual SQL Servers.

A complete solution built from the ground up: AI reads your standards documents and produces PowerShell remediation scripts, operators review and approve via a CSV workflow column, and the deployment engine applies fixes in dependency order with a full audit trail.

Technology: PowerShell, VMware PowerCLI, SQL Server (on-prem virtualized), T-SQL, DMVs, CSV-tracked approval workflow.

Methodology: same 40+ check sweep used for cloud SQL MI, parity audit between on-prem and cloud, CSV output that feeds the existing Accepted-Risk / Approved / Deferred fix workflow, VM-layer plus OS-layer plus SQL-layer coverage.

Built with

PowerShell · VMware PowerCLI · SQL Server (on-prem virtualized) · T-SQL · DMVs · CSV-tracked approval workflow · AI prompt-driven script generation

AI-Driven SQL Server Remediation — 100+ Automated Fixes

1 of 1

AI-Driven SQL Server Remediation — 100+ Automated Fixes screenshot 1

On-Prem Air-Gapped AI Agent — No Data Leaves the Building

Have systems that are not allowed to talk to the public internet, but you still want an AI agent watching them and writing up the findings? This shows that loop fully self-contained: the AI model lives on your hardware, the agent runs on your hardware, and the systems being watched stay air-gapped. Same diagnostic value, no data leaves the building.

More details

What you get: An AI agent that watches your systems and writes up findings — running entirely on your own hardware with a local model, no internet connection required. Same diagnostic value as cloud agents, zero data exposure.

The model, the agent framework, and the systems being watched all live on-premises. An OpenAI-compatible API shim lets you swap the local model for a cloud model and back without changing any agent code.

Technology: OpenClaw agent framework, DGX Spark with Ollama / vLLM, Llama 3.1 / Qwen3 local models, OpenAI-compatible local endpoint, Python tool adapters, Managed Identity for downstream Azure reads.

Methodology: 100% on-prem agent loop (model + reasoning + tool calls), OpenAI-compatible API shim for drop-in cloud-vs-local switch, read-only tool surface, use-case fit for air-gapped or compliance-restricted systems.

Built with

OpenClaw agent framework · NVIDIA DGX Spark · Ollama / vLLM · Llama 3.1 / Qwen3 · Python tool adapters · Managed Identity for downstream Azure reads

On-Prem Air-Gapped AI Agent — No Data Leaves the Building

1 of 1

On-Prem Air-Gapped AI Agent — No Data Leaves the Building screenshot 1

Email Answering Service

Email Answering Service

Drowning in email but allergic to "out of office" auto-replies that make you sound like a robot? Want a quiet helper that reads what came in, drafts a reply that sounds like you, and queues it up so you can approve, edit, or skip with one click? That is this service. Built for small businesses and solo operators who want their inbox time back without losing the human touch.

More details

What you get: AI drafts thoughtful replies to your incoming email in your voice. You review, edit if needed, and send — turning an hour of inbox triage into ten minutes of approvals.

We connect to your inbox with the permissions you choose, learn from your past sent mail to match your tone, and surface drafts that are ready to go. You stay in the loop on every send.

Technology: OpenClaw agent framework, OpenAI / Azure OpenAI, Microsoft Graph (mail), Office 365 SMTP, prompt templates with conversation-history grounding, OneDrive for review queue.

Methodology: voice-matching prompts grounded in prior conversations, drafts always queued for one-click human approval, no auto-send, fast triage view (oldest first, by sender, by topic), opt-in expansion of automation as trust grows.

Built with

Microsoft Graph / Gmail API · OpenAI GPT-4.1 or local Llama 3.1 · tone-match prompting · your-rules guardrails

Email Answering Service

1 of 1

Email Answering Service screenshot 1

Chatbots & Private RAG

Private Chatbot Trained on Your Documents

Wish your team had a chatbot that actually knew your internal policies, manuals, and reference material instead of guessing? Want it to cite the source so people can double-check the answer? Want adding a new document to be as simple as dropping the file in the right folder? That is what this gives a department, ready to pilot in an afternoon.

More details

What you get: A chat assistant your team can ask anything — trained on your handbooks, SOPs, contracts, and notes — that gives answers backed by citations to the source document.

Runs on a private gateway you control. You decide which documents go in, who can ask which questions, and whether answers come from a local model on your hardware or a hosted model under your account.

Technology: Open WebUI, Ollama, embedding models (BGE / nomic-embed), vector store, hash-based change detection, PDF / DOCX / XLSX text extraction, SharePoint / file-share ingestion, on-prem GPU.

Methodology: hash-based incremental sync (touch a file, embeddings update), format-aware extraction per file type, citation-required answers, department-scoped collections (no cross-leak), afternoon-scale onboarding for a new department.

Built with

Open WebUI · Ollama (Llama 3.1, Qwen3) or Azure OpenAI · RAG knowledge collections · PyPDF2 / python-docx / openpyxl ingestion · per-team rate limits

Private Chatbot Trained on Your Documents

1 of 1

Private Chatbot Trained on Your Documents screenshot 1

Company-Wide Private AI for Every Department

Want every department to use AI, but with sensible limits and without their data mixing or leaking? Want sensitive data to use a private AI model that never leaves your premises, and everything else to use a fast cloud model, with the right choice made automatically? This is that gateway. One platform, one set of guardrails, and a clean per-department report so cost and usage are easy to explain.

More details

What you get: One AI service for your whole organization, with each department's data kept separate, each team's spending capped, and sensitive information routed only to private AI models that never leave your premises.

Departments share infrastructure but not data. Content filtering, audit logs, per-team token budgets, and PII-aware routing are built in. Add or remove teams in minutes.

Technology: FastAPI gateway, Ollama, Llama 3.1 8B, Qwen3 32B, Azure OpenAI, NVIDIA DGX Spark, Docker, PostgreSQL (audit), Redis (rate limiting), Open WebUI, hash-based RAG sync, PDF / DOCX / XLSX text extraction.

Methodology: per-department API key with isolated proxy, sensitivity-driven local-vs-cloud routing, per-key rate limit and token budget, hash-based knowledge-collection sync (touch a file, embeddings update), format-aware extraction, centralized content filtering and audit log, per-key usage reporting for chargeback.

Built with

FastAPI proxy · Ollama · Open WebUI · Azure OpenAI · NVIDIA GPU · Docker

Company-Wide Private AI for Every Department

1 of 1

Company-Wide Private AI for Every Department screenshot 1

Vibe-Coded Apps

Vibe-Coded Apps, Built In Days Not Months

What you get: You describe the app you wish existed; we build it with you in real time using AI as the typist. Internal tools, calculators, dashboards, lightweight web apps — stood up in days, with you reviewing every change before it ships.

More details

A working session model: we sit with you, you talk through what the app should do, AI proposes the code, we review the diff, deploy to a private URL, and iterate. No big up-front spec, no surprise scope creep.

Built with

GitHub Copilot Agent · Astro / React / Python / FastAPI · Azure Static Web Apps · Azure Container Apps · GitHub Actions · GUARDRAILS.md review loop

Vibe-Coded Apps, Built In Days Not Months

1 of 1

Vibe-Coded Apps, Built In Days Not Months screenshot 1

Internal AI Platform Landing Page

Just stood up a new internal AI service and now nobody knows it is there? Want a clean landing page that explains what is available, who it is for, and how to ask for access, in language a non-engineer will understand? That is exactly what this is, sitting in front of the multi-tenant AI platform.

More details

What you get: A clean, SSO-gated landing page that explains the internal AI platform to non-engineers: what is available, who it is for, and how to request access — so the platform actually gets used.

Documentation-first discovery surface with audience-specific pages for developers, business users, and admins. Links directly into Open WebUI and Ollama, and kept in sync with platform changes.

Technology: static site (Astro / Markdown), internal SSO via Entra ID, Azure Static Web Apps or internal IIS, links into Open WebUI and Ollama.

Methodology: documentation-first discovery surface, single landing page per audience (developers, business users, admins), self-service API-key request workflow, kept in sync with platform changes.

Built with

Astro / Markdown · Entra ID SSO · Azure Static Web Apps / internal IIS · Open WebUI · Ollama

Internal AI Platform Landing Page

1 of 3

Internal AI Platform Landing Page screenshot 1

This Website (a Vibe-Coded Case Study)

This site is its own case study. The previous version lived on a subscription site builder and cost a recurring monthly fee for a relatively static brochure site. A few prompt sessions later, the whole thing was rebuilt as a modern static site that deploys for pennies on Azure, keeps the same domain (sparky1.live), and is far easier to update because every section is data-driven from a single content file. Even the screenshots and captions on this Learn page come from drag-and-drop folders, no code edits required to add new project examples.

More details

What you get: The site you’re reading was vibe-coded with an AI agent and shipped to a free static-hosting tier with a custom domain and a working contact form — a small but honest demo of what the model can do for you.

Every change was AI-proposed and human-approved before commit. The whole site lives in a Git repo, deploys automatically on push, and costs $0/month to run.

Technology: Astro, Tailwind CSS, TypeScript, Azure Static Web Apps, GitHub.

Methodology: prompt-driven full rebuild from an existing brand, content-as-data (single source-of-truth file), drop-in screenshot folders with auto-discovery, free-tier static hosting on Azure, custom-domain preservation, GitHub-based continuous deployment.

Built with

Astro · Tailwind CSS · GitHub Copilot Agent · Azure Static Web Apps · GitHub Actions · Web3Forms

This Website (a Vibe-Coded Case Study)

1 of 1

This Website (a Vibe-Coded Case Study) screenshot 1

AstroPickle — A Small Indie Game With AI-Made Artwork

For those interested in using prompts to create a web or desktop game for: education, entertainment, monetization, or advertising revenue. AstroPickle is a fun take on Asteroids using pickles, delivered as a service to a customer who wanted a fully prompt-driven game that could be hosted on their own server, retain user initials and high scores, and ship with security measures for geolocation blocking, rate limiting, and automatic IP banning. The customer's family could literally type a request and have the change apply in real time, so the audience got to enjoy ever-changing variations of the game. The game runs anywhere in the world and adapts to the difference between desktop browsers and mobile devices.

More details

What you get: A small, playable indie game where every character and object on screen was drawn by an AI image model. Built end-to-end with AI as the artist and a vibe-coding loop as the developer, and ships to both desktop and the browser.

Solves a real-world quirk in current AI image tools (they bake a checkerboard background into every image) with a custom cleanup step that recovers a clean, transparent character so it can be dropped into the game. The same cleanup pipeline is reused across every game in the studio.

Technology: Python, Pygame, Ubuntu, Nginx, browser localStorage, geolocation lookup service, IP-reputation list.

Methodology: prompt-driven feature changes with live reload, edge security (geolocation blocking, API rate throttling, automatic IP banning), responsive desktop-vs-mobile detection, persistent high-score storage.

Built with

Python · pygame · PIL · Google Gemini 3.1 Flash image preview · custom alpha-recovery (BFS flood-fill) · Emscripten / pygbag (browser build)

AstroPickle — A Small Indie Game With AI-Made Artwork

1 of 10

AstroPickle — A Small Indie Game With AI-Made Artwork screenshot 1

WheelieKid — Reverse-Camera Pseudo-3D Racer

For those interested in using prompts to create a web or desktop game for: education, entertainment, monetization, or advertising revenue. Wheelie Kid was inspired by a local e-bike rider always cruising on their rear wheel and throwing a hang-loose sign. A family from a local city wanted a fun, interactive, self-adjusting video game built for entertainment and education (specifically, to show how AI works), and they pitched in on the design. Using integrated AI tooling, a working prototype was delivered in about two hours, including character voice variations, generated sprite art, and an AI-composed soundtrack. Prompts can fully control the adjustments and ongoing development of this PC desktop and web-friendly game.

More details

What you get: A retro-style racing game built on the same vibe-coded engine as AstroPickle, with cars and roadside objects drawn by the same AI image pipeline.

Reuses the AstroPickle cleanup pipeline so AI-drawn cars and obstacles drop cleanly into the game. Ships to both desktop and the browser.

Technology: Python, Pygame, Emscripten / pygbag for the browser build, OpenAI for voice generation, Google Gemini for sprite generation, Udio for music generation.

Methodology: rapid AI-paired prototyping (working build in about two hours), generative-asset pipeline for sprites and audio, custom alpha-recovery post-processing for clean transparent sprites, cross-platform build (PC desktop and web), prompt-driven ongoing tuning.

Built with

Python · pygame · PIL · Google Gemini 3.1 Flash image preview · custom alpha-recovery · Emscripten / pygbag (browser build)

WheelieKid — Reverse-Camera Pseudo-3D Racer

1 of 2

WheelieKid — Reverse-Camera Pseudo-3D Racer screenshot 1

PII-Safe AI Tool Distribution Toolkit

Keep that data private! Built as an offering right after the first paid public AI assistants hit, when customers needed a real answer to "how do we keep private data private when staff paste into an AI?" The solution loads smart language recognizers (industry-standard PII detectors plus custom rules and lightweight AI for tricky cases) that find sensitive data, swap it for placeholder tokens with a key, and let users send a fully scrubbed prompt to the AI. When the answer comes back, the user pastes it into the tool and it puts the original values back in place. Anything stored locally is encrypted and can be auto-deleted on a schedule the customer sets. Source-code obfuscation and hardware-bound licensing make it safe to ship to paying clients.

More details

What you get: Hardens Python AI tooling for distribution to clients — combining commercial obfuscation, expiration- and hardware-bound licensing, and an automatic PII redaction layer so models never see sensitive data unintentionally.

spaCy NER + Microsoft Presidio detect and anonymize PII before it ever reaches a model. PyArmor obfuscation plus hardware-fingerprint license binding protects the IP you ship.

Technology: Python, spaCy NER, Microsoft Presidio, custom regex rules, lightweight on-device AI, PySide6 GUI, PyInstaller packaging, PyArmor obfuscation, Windows DPAPI / cryptography.

Methodology: pre-flight PII detection on every prompt, token-swap and key-vault round-trip, automatic re-hydration of redacted answers, encrypted local storage with user-controlled auto-delete, hardware-fingerprint license binding, expiration-enforced commercial distribution.

Built with

Python · PyArmor 9.1.3 · PyInstaller · spaCy (en_core_web_lg) · Microsoft Presidio · PySide6 · cryptography · phonenumbers

PII-Safe AI Tool Distribution Toolkit

1 of 5

PII-Safe AI Tool Distribution Toolkit screenshot 1

Content & Media Automation

Daily Editorial Intelligence Pipeline

RunnerSource Newsletter started as a mission to improve running and health, tailored for the goals of the individual and easy to distribute, condensing hours of interesting daily content into key and useful information that can be read in mere minutes. RunnerSource turned into a production-grade content-intelligence pipeline that ingests dozens of video and podcast sources daily, transcribes them, and AI-summarizes them into a fully-cited newsletter with two editions generated in a single pass: one written for the athlete, one written for the coach. Subscribers pick the level of content they want and their race distance and goal. A single source corpus produces audience-specific output, with full citations on every claim. The pipeline runs on a cloud server whose start and stop hours are controlled by an automation workflow (itself built end-to-end with AI assistance) so it only runs at key processing hours and keeps costs down. Finished editions are published to the customer's website, sent via email, and handed off to a managed mailing list, all with a human review step before anything goes out. Six-plus external services orchestrated end-to-end, fully self-managed and continuously updating.

More details

What you get: A daily content-intelligence pipeline that ingests dozens of video and podcast sources, AI-summarizes them into a citation-aware newsletter with audience-specific editions, and publishes to a CMS plus email distribution.

Multi-format ingestion (video + audio), transcript normalization, dual-edition generation in a single model pass, breaking-news detection with source verification, and end-to-end Wix CMS publishing — all on a recurring schedule.

Technology: Python, OpenAI GPT-4.1, Google Vertex AI / Gemini, Speechmatics, Google Cloud Speech-to-Text, yt-dlp, youtube-transcript-api, OpenAI web-search agent, Wix CMS with Velo backend, Office 365 SMTP, Google Drive, Google Apps Script, Azure Virtual Machine, Azure Logic Apps, Wix Secrets Manager.

Methodology: multi-source daily ingestion (video and audio), normalized transcription, dual-perspective generation in a single model pass, IEEE-style citation tracking with source verification, AI-driven breaking-news discovery, cost-optimized scheduled cloud execution, human review before publish, multi-channel delivery (CMS, email, mailing list).

Built with

Python · OpenAI GPT-4.1 · Google Vertex AI · Speechmatics · yt-dlp · YouTube Data API · PodcastIndex · Wix Velo CMS · Office 365 SMTP

Daily Editorial Intelligence Pipeline

1 of 4

Daily Editorial Intelligence Pipeline screenshot 1

Hands-Free Weekly Transcription & Study Workflow

Transcriping audio and generating questions and an answer key. This started as a way to take published sermon videos from a church, combine them with the church's mission statement and the small group's intent, and auto-generate easy, medium, and hard discussion questions plus an answer key, every week, with no human in the loop. The pipeline pulls the latest message, transcribes it, runs it through a high-reasoning AI model, and ships a polished printable, email, and cloud-folder copy on a schedule. Privacy-first: nothing about the small group ever leaves the local machine except the finished study guide.

More details

What you get: A weekly pipeline that pulls the latest published recording, transcribes it, generates discussion questions with a high-reasoning model, and delivers PDF + email + cloud copies on schedule — fully unattended.

Privacy-first local processing with no third-party storage of sensitive content. Captioned-vs-uncaptioned fallback, .env-driven credential injection, conditional email/cloud routing.

Technology: Python, OpenAI GPT-5-mini, video and caption ingestion tools, Office 365 SMTP, OneDrive, Windows Task Scheduler.

Methodology: scheduled discovery of newly published content, captioned-vs-uncaptioned transcription fallback, tiered question generation (easy / medium / hard) with an answer key, multi-channel delivery (PDF, email, cloud folder), local-only processing for privacy.

Built with

Python · OpenAI GPT-5-mini (high reasoning) · yt-dlp · YouTube caption API · Office 365 SMTP · OneDrive · Windows Task Scheduler

Hands-Free Weekly Transcription & Study Workflow

1 of 1

Hands-Free Weekly Transcription & Study Workflow screenshot 1

Curriculum & Companion-Content Generator

Meshing various mediums, website content, and validating accuracy to produce a small group plan each week. A follow-up offering to the sermon transcription pipeline, delivered for a small church group that wanted weekly study guides aligned to the church's stated mission, values, and statement of belief. The pipeline auto-detects the next BibleProject.com short video in the series from a saved progress file, builds a one-hour small-group plan around it, drops in a QR code that jumps straight to the video on a phone, layers in the latest breaking news, weaves in last week's sermon questions for thematic continuity (cross-reference reuse from the sibling transcription project), and automatically verifies every quoted Bible verse against an accurate scripture source so the printout is provably correct. It runs on a schedule, lands in OneDrive for proof-checking and delivery, and the sponsoring group has reported consistent positive feedback. Comes with a full leader's guide and ops manual so any group can take it over.

More details

What you get: Auto-detects the next episode in a recurring content series, fetches reference text from a verified source, and produces printable companion guides — with optional thematic cross-referencing across content streams.

Stateful episode auto-detection from JSON metadata, scripture-API caching, cross-project content reuse, printable-output generation, and a comprehensive operations + leaders guide for handoff.

Technology: Python, OpenAI GPT-5-mini, scripture verification API with local verse cache, QR-code generator, OneDrive, Windows Task Scheduler.

Methodology: scheduled series progression from a saved state, source ingestion from a public video library, thematic cross-reference of prior weekly study material, automated scripture verification, printable one-hour small-group lesson generation, scheduled cloud delivery for human proof-check before distribution.

Built with

Python · OpenAI GPT-5-mini · NASB scripture API · BibleProject CDN · JSON state management · email + OneDrive delivery

Curriculum & Companion-Content Generator

1 of 1

Curriculum & Companion-Content Generator screenshot 1

Time-Lapse & Media Production Toolkit

For those interested in scripted video edits from existing footage, in this example a regular phone video turned into a time-lapse. This was an interesting project for a community fundraiser. A video was recorded and only later determined to have been intended as a time-lapse. Within minutes, a small amount of prompt engineering produced simple instructions to copy the video off the phone into a working folder and process it locally. The finished time-lapse was used to promote the next fundraiser on a same-day deadline.

More details

What you get: PowerShell + FFmpeg utilities that turn raw long-form footage into iPhone- and iMovie-ready time-lapses, plus an RSS-driven episode-discovery and batch-download utility for large media catalogs.

FFprobe-driven source analysis, FFmpeg composition with frame-rate math for speed multiplication, H.264 MP4 encoding tuned for iPhone/iMovie ingestion, and robust regex-based episode extraction with deduplication.

Technology: PowerShell, FFmpeg, FFprobe.

Methodology: rapid prompt-engineered scripting, source-file analysis, frame-rate adjustment for time-lapse playback, mobile-friendly H.264 encoding, same-day delivery.

Built with

FFmpeg · FFprobe · PowerShell · Python (feedparser, requests) · Google Photos bridge

Time-Lapse & Media Production Toolkit

1 of 1

Time-Lapse & Media Production Toolkit screenshot 1

AI Automation for Cloud

Cloud Spending Auto-Throttle

Worried that one bad query or a runaway script will turn into a five-figure cloud-AI bill? Want a system that notices the spike in minutes, throttles the usage back to a safe level automatically, and lets you bring everything back to normal with one command? That is what this does. Three layers of protection: instant per-model limits, a fast automated response when something goes wrong, and a hard budget cap as a final safety net.

More details

What you get: A safety net that prevents AI surprise bills. The moment usage starts running hot, automated rules slow it down within minutes — and a one-command script restores normal limits when you're ready.

Three layers of defense work together: instant rate limits, automated throttle runbooks tied to spending alerts, and budget hard-stops. A single JSON baseline file lets you reset everything to normal in seconds.

Technology: Azure AI Foundry, Azure OpenAI, Azure Monitor metric alerts, Azure Automation runbooks, Azure Budgets, PowerShell, JSON configuration, Managed Identity, Entra ID.

Methodology: defense in depth (per-deployment TPM limits, alert-driven throttle within 5 minutes, budget cap as safety net), single-source-of-truth JSON for known-good state, one-command recovery, -WhatIf preview on every write, GUARDRAILS-enforced human approval before production change.

Built with

Azure Automation · PowerShell · Azure AI Foundry · Azure Monitor alerts · Azure Budgets · Managed Identity

Cloud Spending Auto-Throttle

1 of 1

Cloud Spending Auto-Throttle screenshot 1

Self-Service Cloud App Deployment

Want internal teams to be able to deploy their own small web apps without becoming cloud experts and without waiting weeks for a central team? Need a clear "do you want this public, semi-private, or internal-only?" choice up front instead of an architecture meeting? This template gives them a short intake form, a preview of what will be deployed, and a one-click ship, with sensible defaults baked in.

More details

What you get: A reusable template that lets a team stand up a new containerized web app in a day instead of a week — with the right network access, the right secrets store, and the right monitoring on day one.

Fill out an intake form, choose your network access level (public, private, or allow-listed), opt in to AI or database add-ons, then preview the change. Nothing deploys until a human approves.

Technology: Azure Container Apps, Bicep, Azure CLI, Azure OpenAI, Azure SQL, Managed Identity, Azure Key Vault, Log Analytics, Azure Front Door (optional).

Methodology: intake-form to Bicep parameter binding, three explicit network tiers (public, private IPs, campus CIDR), what-if preview required before deploy, optional add-ons (OpenAI, SQL) toggled by a flag, GUARDRAILS-enforced human approval on writes.

Built with

Bicep modules · Azure Container Apps · Container Registry · Log Analytics · Key Vault · GUARDRAILS.md pattern

Self-Service Cloud App Deployment

1 of 1

Self-Service Cloud App Deployment screenshot 1

AI-Assisted Data Pipeline Builder

Tired of every new data pipeline taking weeks of meetings, specs, and back-and-forth? Want to fill in a single short config file, prompt an AI assistant, review what it proposes, and have a working pipeline by the end of the day? That is what this template gives you. The AI does the typing, you do the reviewing, and a built-in safety rule means nothing touches the cloud until you say so.

More details

What you get: New daily file-to-database pipelines stand up in hours, not days. Your team fills in a config, the AI proposes the pipeline, and you review every change before it touches production.

A six-phase loop with hard guardrails on every cloud write. The AI generates the data factory pipelines, stored procedures, and configuration; humans approve and deploy.

Technology: Azure Data Factory, Azure SQL Managed Instance, T-SQL, ARM templates, PowerShell, GitHub Copilot Agent mode, Managed Identity, Azure Key Vault, Bicep.

Methodology: config-as-contract (single CONFIG.md), AI-paired generation of pipeline JSON / DDL / sprocs / deploy scripts, GUARDRAILS-enforced human approval on every cloud write, -WhatIf preview standard, query-plan-driven performance pass (12 min to 2 sec example), repeatable in 6 hours and ~50 prompts.

Built with

Azure Data Factory · Azure SQL Managed Instance · PowerShell · T-SQL · GitHub Copilot Agent · Self-Hosted Integration Runtime

AI-Assisted Data Pipeline Builder

1 of 1

AI-Assisted Data Pipeline Builder screenshot 1

Always-On Reporting & Dashboards

What would happen if a key Power BI report was deleted by accident tomorrow? Or a refresh corrupted the data and nobody noticed for a week? This nightly backup quietly takes a clean copy of every report in your tenant, organized by department, and tells you ahead of time if anything is set up wrong before the backup actually fails. Restores are a copy-and-paste, not a panic.

More details

What you get: Your reports back themselves up nightly, your gateways stay healthy, and you get an alert before a license expires — not after a report stops running.

Service-principal-driven nightly export of every report and data-source configuration in your tenant, with workspace-to-department mapping and orphaned-resource detection.

Technology: PowerShell, Power BI REST API, MicrosoftPowerBIMgmt module, Entra ID service principal, Windows DPAPI, Windows Task Scheduler, on-prem file share.

Methodology: tenant-wide nightly export organized by department, encrypted secret storage via DPAPI, pre-flight access-gap detection, orphan gateway data source surfacing, dual-mode operation (interactive + unattended), -WhatIf and -CheckOnly audit modes.

Built with

PowerShell · Power BI REST API · Entra ID service principal · DPAPI-encrypted secrets · Windows Task Scheduler

Always-On Reporting & Dashboards

1 of 1

Always-On Reporting & Dashboards screenshot 1
How we work · across all three pillars

Guardrails & safety practices.

Show +

Whether we're reviewing your processes or shipping a system to production, the same playbook applies. AI moves fast — and we make sure it moves safely while it does.

AI proposes, humans approve

Every change to your data, your code, or your cloud goes through a preview-and-approve step. The AI shows you the diff; you decide whether it ships.

Read-only by default

Our investigative agents start with eyes-only access. They can look, correlate, and report — they cannot change a thing until you grant permission for a specific action.

Your data stays where you put it

PII and sensitive content are routed to local models on hardware you control. Hosted models only see what you explicitly approve to leave the building.

Spending caps, not surprise bills

Every system we deploy has token budgets, rate limits, and one-command emergency throttle built in from day one — not bolted on after the bill arrives.

Reversible by design

Infrastructure changes ship as code, with what-if previews and a tested rollback path. If something goes wrong, you can put it back the way it was.

Documented for handoff

Every project ships with an operations runbook so the system isn't dependent on us. You can hand it to your team and keep going.

For the technical reader

Capabilities & technologies.

Show +

The full stack we draw from. A working knowledge of these is what lets us pick the right tool for your problem instead of the one we already own.

AI / LLMs

  • OpenAI GPT-4.1, GPT-5-mini, GPT-5-Pro
  • Anthropic Claude Sonnet 4.6
  • Google Vertex AI · Gemini 3.1 Flash
  • Azure OpenAI · Azure AI Foundry
  • Local LLMs via Ollama (Llama 3.1, Qwen3)
  • Open WebUI multi-tenant gateway
  • Retrieval-Augmented Generation (RAG)
  • GitHub Copilot Agent (human-in-the-loop)
  • OpenClaw / NemoClaw agent frameworks
  • Token-budget & TPM throttle automation

Speech, Vision & NLP

  • Speechmatics
  • Google Cloud Speech-to-Text
  • OpenAI Whisper-class transcription
  • youtube-transcript-api · yt-dlp
  • spaCy NER (en_core_web_lg)
  • Microsoft Presidio (PII detection & redaction)
  • PyPDF2 · python-docx · openpyxl text extraction
  • PIL · BFS alpha-recovery pipelines

Azure Platform

  • Azure Data Factory · SQL Managed Instance
  • Azure Container Apps · Container Registry
  • Azure Functions · API Management
  • Azure Service Bus · Private Endpoints
  • Azure Key Vault · Managed Identity · Entra ID
  • Azure Monitor · Budgets · Automation
  • Bicep (modular IaC)
  • Azure Resource Graph
  • Self-Hosted Integration Runtime

Data & Integrations

  • SQL Server · T-SQL (OPENJSON, MERGE, STRING_AGG)
  • Power BI REST API · MicrosoftPowerBIMgmt
  • Power Automate · SharePoint REST · PnP.PowerShell
  • On-Premises Data Gateway
  • Microsoft Graph · Gmail API
  • Google Apps Script · Sheets / Docs API
  • YouTube · Podcast · RSS ingestion
  • GitHub · GitHub CLI · GitHub Actions

Engineering Discipline

  • Python · PowerShell · C# · JavaScript · T-SQL
  • GUARDRAILS.md (AI proposes, human approves)
  • Config-driven / metadata-driven design
  • -WhatIf / -CheckOnly / what-if previews
  • Service-principal & DPAPI-encrypted secrets
  • PyArmor code protection · hardware-bound licensing
  • FFmpeg / FFprobe media tooling
  • Operations runbooks & handoff documentation

Security & Governance

  • Managed Identity over shared access keys
  • Private endpoints · zero-trust networking
  • RBAC least-privilege design
  • Read-only agent scopes
  • Content filtering · audit logging
  • PII / PHI-aware model routing
  • Emergency throttle & disable runbooks
  • Per-tenant rate limits & token budgets

See yourself in any of these?

Tell us what you're trying to accomplish and we'll reply with a clear next step.