Shizhi Gu
Studio, est. 2024 — Independent practice

Shizhi Gu

An independent studio building AI systems with teeth — agent products that touch real data, survive messy inputs, and return outputs you can trust.

PracticeAI & applied systems
Index13works, 2024 – 2026
BasedUnited States / Remote
CurrentlyShipping sqlv & Chronicle

Case no. 01 — Currently in the studio

sqlv

A SQLite viewer built for humans and coding agents to drive at the same time.

Native Tauri desktop app, JSON-first CLI, and MCP server share one Rust core — with a live push flow that mirrors terminal queries straight into the GUI my agent and I both watch. Less demo magic, more shared keyboard.

  1. 01

    One Rust core, three surfaces.

    CLI, Tauri desktop, and MCP server all delegate to the same `sqlv-core` library — semantics can't drift between the human view and the agent view.

  2. 02

    The agent proposes. The human approves writes.

    `sqlv push "SQL"` from any terminal lands the query in the running desktop app's editor. Reads run immediately; writes wait behind a loud consent banner with EXPLAIN QUERY PLAN and an affects-N-rows pill.

  3. 03

    Virtualized grid with a staging queue.

    1000-row pages via react-virtual, inline cell edit, FK navigation, and a Stage toggle that batches edits for a single-transaction commit with per-row revert.

RustTauri 2TypeScriptCodeMirror 6rusqliteMCP

Selected work

An archive, 2024 – 2026
12 entries
Biography

The playbook broke. I'm writing the next one.

I build AI systems for domains where bluffing gets expensive: investment research, analytics, operations, and developer workflows. My background is a mix of quantitative finance, backend engineering, and product-minded shipping.

The common thread across this archive is simple: make the model earn its keep. Structured outputs, sandboxed execution, reproducible pipelines, and interfaces that feel sharp enough to ship — not just cool enough to demo.

Shipped
12+ products & prototypes
Specialism
Agent systems with teeth
Stack
Python · TypeScript · Swift
Years
Building since 2018, AI since 2022

Tools & materials

Claude Agent SDKStructured OutputsLangGraphMCPFastAPINext.jsSwiftUIDuckDBPostgreSQLTypeScriptPythonModalReact
Correspondence

Let's build something. Or just say hello.