Hikmah Techstack

Market Regime Detection: From Hidden Markov Models to Wasserstein Clustering

Financial markets move through distinct phases — bullish rallies, sharp crashes, quiet consolidations, and volatile swings. These market…

Building Trading Bots That Think Like a Trading Firm: Unpacking the TradingAgents Paper

Stop Renting Your Warehouse: Slash Analytics Costs with Local-First

Search your documents without a vector database

The moment you want to search documents by meaning instead of keywords, someone mentions vector database. Pinecone. Weaviate. Milvus. A new…

Letting Claude Code write your dbt models — and why you still read every line

dbt is the ideal problem for an AI coding agent. Your project is text files — SQL queries and YAML — with a CLI that tells you immediately…

When local-first runs out of road

The local-first data stack works. DuckDB on Parquet, a few dbt models, SQL in your app or notebook — it’s faster to build than the…

Capture Is Easy. Clarify Is the Whole Game.

How AEGIS runs GTD on top of Todoist — and why “references” turned out to be the hardest part

Meet AEGIS: My Weird Little Operating Layer

Every week there’s another agent demo, another workflow canvas, another pitch about software running software for us. OpenClaw, browser…

Turning messy PDFs into clean tables, on your own machine

The hard part of data engineering isn’t moving structured data around. It’s getting structure out of the mess in the first place — invoices…

A Comprehensive Guide to SQL and Databases for Beginners — PART 05

Welcome to Part 5 of our beginner-friendly series on SQL and databases! In this guide, we’re diving deep into some essential SQL…

A Comprehensive Guide to SQL and Databases for Beginners — PART 04

In this part of our SQL guide, we’ll dive into essential data manipulation commands, explore how to maintain data integrity, and look at…

Building with Claude Code: Faster Iteration, Faster Drift

I have been rebuilding a personal project called AEGIS into its third version, and on paper this rewrite should have dragged on for weeks…

Building AEGIS: How Prolog + a Knowledge Graph Make Local LLMs Actually Useful

I’ve been building a personal AI orchestration system. The first version — Jarvis — worked, but became a 20,000-line monolith I dreaded…

Connecting an AI assistant to your database with MCP — without letting it do damage

You want to ask Claude questions about your data without typing SQL. “How many customers signed up last week?” or “What tables relate to…

Should there be an LLM in your data pipeline?

You’re building a data pipeline. The data’s messy. Someone suggests running each row through an LLM — for classification, extraction…

Using an LLM to catch the data quality problems your tests can’t

Your data tests work hard. A dbt not_null test catches missing addresses. A constraint catches duplicate IDs. A range check catches prices…

Running a local model over millions of rows without it falling over

You’ve built a prompt that works. Tested it on 100 rows in your notebook. Got the output format right. Now your manager says “run this over…

Generating realistic test data with a local model

The cheapest way to harden a pipeline is to feed it the ugly rows before production does. Random data will find some bugs. But sometimes…

Proxmox VE: A Comprehensive Guide to Virtualization and Container Management — PART 01

Table of Contents

Local model or paid API? The honest math for data work

You’re sitting in a standup. Someone says, “We could just use GPT for that.” Another voice: “No way, it’s cheaper to run Llama locally.”…