Build log

Real problems, the approach taken, and what happened — the fuller story behind the project list. Vote on what I write next →

• Retrieval-Augmented Chat: Ask This Site a QuestionA floating chat widget that answers visitor questions using only what's actually published on this site — grounded, cited, no hallucinated claims — and can now take a few bounded actions instead of just answering.Voyage AI (embeddings)Anthropic Claude (generation + tool use)Supabase/pgvector (retrieval)Next.js API routes
• An Agent Toolkit for Running the SiteFour small, bounded agents — research drafts, dev-log summaries, a Telegram admin chat, and a content-health checker — each scoped to one job instead of one agent trying to do everything.Anthropic Claude (web search + tool use)GitHub REST APITelegram Bot APINext.js Server ActionsSupabase
• This Site as MCP ToolsA remote MCP server exposing this site's content and a curated set of admin actions as tools any MCP-speaking client can call — no bespoke integration required.@modelcontextprotocol/server (MCP TypeScript SDK v2)ZodNext.js API routesSupabase/pgvectorVoyage AI
• Site AgentA Telegram- and HTTP-capable agent — reachable on Telegram as @dames81_bot — that publishes posts, build log entries, and site copy directly, no admin UI required.Next.js API routesSupabaseTelegram Bot API (@dames81_bot)bearer-token auth
• A dbt Semantic Layer Over My Own GitHub ActivityA standalone data pipeline — ingest, dbt transformations, a real semantic layer, and an open-source BI tool on top — built specifically to show the ingest-to-insight path, not just a dashboard.Pythondbt-core (dbt Semantic Layer / MetricFlow)PostgreSQLGitHub ActionsGitHub REST APILightdash
• Wiring Up CodeRabbit — a Second Reviewer for Every ChangeConnected CodeRabbit's GitHub App and CLI to this repo, then proved both actually work by deliberately breaking a script and watching the CLI catch it before it was ever committed.CodeRabbit (GitHub App + CLI)HomebrewGitHub
• A Research Pipeline That Filters Vendor Marketing From Real Architecture PatternsA source-registry-driven pipeline that watches Snowflake, Databricks, dbt, Spark, Qlik, Redshift, MS Fabric, and n8n for genuine architecture changes -- not marketing -- and surfaces them at /research, through the chat widget's RAG, and via a public MCP tool.PythonPostgreSQLAnthropic ClaudeVoyage AIGitHub ActionsNext.jsModel Context Protocol