Blog

Thoughts, updates & insights.

Articles about AI systems, developer tools, and building intelligent software — from the VivekMind team.

Subscribe to updates

Get notified when we publish new articles.

The Architecture of a Schema Weaver PostgreSQL Migration Engine
engineeringAug 5, 2026

The Architecture of a Schema Weaver PostgreSQL Migration Engine

Schema Weaver's PostgreSQL Migration Engine is a state-based migration engine for PostgreSQL that introspects 50+ object types, computes dependency-aware schema diffs, classifies every change by risk, and applies safe migration patterns for production databases. This article explores the architecture behind the engine, from introspection and planning to execution, crash recovery, and risk analysis.

By VivekMind Team

Model Provider Architecture: How Schema Weaver's Data Explorer Routes, Streams, and Fails Over Across Four LLM Providers
engineeringJun 19, 2026

Model Provider Architecture: How Schema Weaver's Data Explorer Routes, Streams, and Fails Over Across Four LLM Providers

Most AI products ship with one provider hardcoded. When that provider has an outage, rate limits you, or deprecates a model, your product breaks. Schema Weaver's Data Explorer runs on a provider-agnostic abstraction layer that supports AWS Bedrock, OpenAI, Anthropic, and Google GenAI behind a single interface — with per-provider circuit breakers, automatic failover, streaming normalization across four different SSE formats, and unified token/cost tracking. This is the complete model provider architecture — the BaseProvider contract, the router, the failover chain, and every edge case we hit in production. Part 4 of the Data Explorer Architecture Deep Dive.

By VivekMind Team

PostgreSQL DDL Parser from Scratch: The Architecture Behind Schema Weaver's SQL Parser v4
engineeringJun 16, 2026

PostgreSQL DDL Parser from Scratch: The Architecture Behind Schema Weaver's SQL Parser v4

Every database tool that visualizes schemas, plans migrations, or powers AI agents needs to understand SQL structure. Most reach for libpg_query — a C extension that doesn't run in browsers. We built a pure TypeScript DDL parser from scratch that handles 60+ statement types across PostgreSQL 12–19, detects 11 relationship types, runs in the browser with zero dependencies, and passes 378 tests against 3,373 brutal SQL statements. This is the complete architecture — the 6-phase pipeline, the multi-strategy parser, and every design decision that makes it work.

By VivekMind Team

VivekMind CLI: The Open Source Terminal AI Coding Agent with Native AWS Bedrock
engineeringJun 7, 2026

VivekMind CLI: The Open Source Terminal AI Coding Agent with Native AWS Bedrock

VivekMind CLI is an open source terminal AI coding agent that connects to 20+ LLM providers with your own keys — including native AWS Bedrock support for Claude, Nova, and all Bedrock models. It features subagents for parallel workflows, MCP protocol for unlimited external tools, project memory that persists across sessions, and a Telegram bot that lets you code from your phone. No subscriptions. No vendor lockup. Apache 2.0 licensed.

By VivekMind Team

The Tooling System: 50+ Tools, One Registry, and How Schema Weaver's Data Explorer Actually Executes Work
engineeringJun 6, 2026

The Tooling System: 50+ Tools, One Registry, and How Schema Weaver's Data Explorer Actually Executes Work

An agent loop without tools is just a chatbot. Schema Weaver's Data Explorer ships with 50+ tools across 10 functional phases — from database exploration to predictive modeling and AI self-management. Each tool follows a standardized contract, executes through a secure read-only proxy, compresses results through a 3-tier context limiter, and emits interactive artifacts. Here is the complete tooling system — the registry, the security boundaries, the execution pipeline, and the artifact mapping that makes the agent's work visible to users. Part 3 of the Data Explorer Architecture Deep Dive

By VivekMind Team

The SingleLLM Agent: How One Model, One Loop, and 15 Iterations Build a Reasoning Engine
engineeringMay 30, 2026

The SingleLLM Agent: How One Model, One Loop, and 15 Iterations Build a Reasoning Engine

Most agentic AI systems reach for multi-agent orchestration before they need it. Schema Weaver's Data Explorer takes the opposite path — one LLM, one growing conversation, up to 15 iterations of Plan → Execute → Observe → Reason. No coordinator. No planner agent. Just a single reasoning thread with direct tool access, intent-classified tool filtering, and enough error recovery to survive production. Here is how it actually works. Part 2 of The Data Explorer Chronicles.

By VivekMind Team

Page 1 of 2Next