nicosuave

Build me a Slack-native Claude agent (thread sessions in disposable containers)

You are building a self-hosted Slack bot in which every thread is its own Claude Code session running in its own throwaway container. This document is the specification. It is written as hard-won design, not as suggestions: where it says "this is load-bearing", the alternative has already been tried and it broke.

Stack assumption: TypeScript on Bun, Slack Bolt in Socket Mode, Hono for the internal HTTP API, Docker Compose, and @anthropic-ai/claude-agent-sdk. Substitute runtimes if you must, but keep every invariant.

nicosuave

Build me a Slack bot that gives every Slack thread its own dedicated Claude Code session running in a disposable container, using the Claude Agent SDK (@anthropic-ai/claude-agent-sdk) on Bun/TypeScript. This is a specific, proven architecture — follow it closely. Here is the design, piece by piece:

Overall shape

Two kinds of Claude sessions, both built on the Agent SDK's streaming query() API:

1. Thread sessions (workers) — the workhorses. Every human @mention of the bot deterministically spawns a dedicated Claude Code session bound to that thread. No model decides whether a mention gets a session — the mention path is pure host code, so it can never be talked out of answering. A thread that ever had a session keeps being Claude's: if a reply arrives after the session idled out and died, a fresh session is rebuilt and seeded with up to ~50 messages of thread history as context. Session IDs are derived from the thread ts, so a rebuilt session shares an identity (and transcript — see below) with

nicosuave

with raw_data as (
  select
    message.id::varchar as message_id,
    requestid::varchar as request_id,
    message.model as model,
    coalesce(message.usage.input_tokens, 0)::bigint as input_tokens,
    coalesce(message.usage.cache_creation_input_tokens, 0)::bigint as cache_creation,
    coalesce(message.usage.cache_read_input_tokens, 0)::bigint as cache_read,
    coalesce(message.usage.output_tokens, 0)::bigint as output_tokens,
    timestamp::timestamp as ts

nicosuave

# /// script
# requires-python = ">=3.11"
# dependencies = [
#     "slack-bolt",
#     "duckdb==1.4.2",
# ]
# ///
"""
Slack bot that uses DuckDB ACP extension to call Claude Code.

nicosuave

#!/usr/bin/env python
"""A Language Server Protocol (LSP) server for SQL with SQLMesh integration."""

import asyncio
import gc
import io
import logging
import re
import typing as t
import weakref

nicosuave

CREATE OR REPLACE MACRO url_encode(input_string) AS (
    replace(
        replace(
            replace(
                replace(
                    replace(
                        replace(
                            replace(
                                replace(
                                    replace(

nicosuave

{
  "statement": "SELECT * FROM MYTABLE",
  "resultSetMetaData": {
    "format": "arrowv1"
  },
  "timeout": 60,
  "database": "MYDATABASE",
  "schema": "MYSCHEMA",
  "warehouse": "MYWAREHOUSE",
  "role": "MYROLE"

nicosuave

Package                    Version
-------------------------- -----------
absl-py                    2.1.0
ace-tools                  0.0.1
aeppl                      0.0.31
aesara                     2.7.3
affine                     2.4.0
aiohttp                    3.8.6
aiosignal                  1.3.1
analytics-python           1.4.post1

nicosuave

ride_id,rideable_type,started_at,ended_at,start_station_name,start_station_id,end_station_name,end_station_id,start_lat,start_lng,end_lat,end_lng,member_casual,distance_km
DAE3C13A5FAAB089,classic_bike,2023-12-29 16:02:20,2023-12-29 16:10:17,Brunswick St,JC023,Communipaw & Berry Lane,JC084,40.72401619,-74.050550103,40.71435836870427,-74.06661093235016,member,1.7278187234240936
1EC6BE46ACF2DE11,classic_bike,2023-12-06 01:58:32,2023-12-06 02:04:48,Brunswick St,JC023,Oakland Ave,JC022,40.724134684,-74.050686002,40.7376037,-74.0524783,casual,1.5052812734284393
105CA439B9CBF57C,classic_bike,2023-12-06 20:15:11,2023-12-06 20:21:02,Brunswick St,JC023,Oakland Ave,JC022,40.72399044,-74.050639033,40.7376037,-74.0524783,member,1.5216384126570526
DC1C46F6090FA1DB,classic_bike,2023-12-09 13:54:19,2023-12-09 13:56:48,Brunswick St,JC023,Manila & 1st,JC082,40.723983169,-74.050732374,40.72165072487999,-74.04288411140442,casual,0.7104214646715642

nicosuave

// ==UserScript==
// @name         Zoomer/Boomer Speak Converter
// @version      0.1
// @description  Translate tweets to zoomer or boomer speak with enhanced UI, response handling, and retry mechanism
// @author       Nico Ritschel
// @match        *://twitter.com/*
// @grant        GM_xmlhttpRequest
// ==/UserScript==

(function() {