Show HN: Pgclaw – A "Clawdbot" in every row with 400 lines of Postgres SQL

22•calebhwin•2h ago

Hi HN,

Been hacking on a simple way to run agents entirely inside of a Postgres database, "an agent per row".

Things you could build with this: * Your own agent orchestrator * A personal assistant with time travel * (more things I can't think of yet)

Not quite there yet but thought I'd share it in its current state.

Comments

tibbar•1h ago

This is mind-bending. I can't imagine that it performs well enough to be particularly fit for production just yet but..... wow.

swyx•44m ago

how exactly is adding a stored procedure as an agent mind bending

readme•1h ago

i love postgres and pgvector... this is exactly to my tastes

calebhwin•1h ago

Same, it's in a similar vein as pgvector - probably not as performant as turbopuffer or chroma but you get the benefits of being in a really nice ecosystem.

tibbar•1h ago

Is it? pgvector is primarily about indexing, I think? This feels more similar =AI in Google Sheets.

calebhwin•57m ago

True though pgvector is not deterministic in a strict sense since HNSW is probabilistic.

wwweston•1h ago

This... does not seem like separation of concerns.

Not to mention that the data layer seems like the one where you want to keep things most deterministic.

noupdates•49m ago

To decouple this the person would have to broadcast nearly every event and rebuild the observer layers elsewhere.

danr4•1h ago

this is fucking awesome

xnx•1h ago

It feels like we're a week away from the Claw hype supplanting AI hype. Companies will start renaming things ClawX to get on the hype bandwagon.

calebhwin•55m ago

It's just an abstraction people are excited about at the moment. Langchain was an exciting abstraction at one point.

My bet is we converge on a super minimal model<>computer architecture.

maxbond•47m ago

I think "claw" isn't appealing enough to be genericized and that "agent" still continue to be the generic term, but we'll see.

maxbond•51m ago

What's the advantage in putting agents in the persistence layer rather than the application layer? This seems to me strictly less flexible, scalable, secure, easy to work with... I am having a hard time imagining why I would want to integrate with APIs or writing an agentic harness in the database rather than in application code?

Maybe I'm behind the times but I don't understand.

4ndrewl•31m ago

It's similar to when we wrote all our business logic in eg pl/sql, stored procedures etc. Seems attractive at first, but it breaks separation of concerns, becomes difficult to test etc.

debugnik•3m ago

I don't understand why claw is a data type for columns in these examples. It doesn't seem to store any actual per-row state.

GPT‑5.3‑Codex‑Spark

An AI agent published a hit piece on me

Gemini 3 Deep Think

Polis: Open-source platform for large-scale civic deliberation

Show HN: rari, the rust-powered react framework

Major European payment processor can't send email to Google Workspace users

Launch HN: Omnara (YC S25) – Run Claude Code and Codex from anywhere

Improving 15 LLMs at Coding in One Afternoon. Only the Harness Changed

Anthropic raises $30B in Series G funding at $380B post-money valuation

Shut Up: Comment Blocker

A brief history of barbed wire fence telephone networks (2024)

Warcraft III Peon Voice Notifications for Claude Code

Apache Arrow is 10 years old

Culture Is the Mass-Synchronization of Framings

A party balloon shut down El Paso International Airport; estimated cost –$573k

The Future for Tyr, a Rust GPU Driver for Arm Mali Hardware

The "Crown of Nobles" Noble Gas Tube Display (2024)

The Science of the Perfect Second (2023)

Show HN: Generate Web Interfaces from Data

Show HN: Pgclaw – A "Clawdbot" in every row with 400 lines of Postgres SQL

How to make a living as an artist

Show HN: Geo Racers – Race from London to Tokyo on a single bus pass

Run Pebble OS in Browser via WASM

MiniMax M2.5 released: 80.2% in SWE-bench Verified

I Wrote a Scheme in 2025

HDRify: True HDR image viewer, and tool set in pure JavaScript

So many trees planted in Taklamakan Desert that it's turned into a carbon sink

ai;dr

1D Cellular Automata Playground

Using an engineering notebook

Show HN: Pgclaw – A "Clawdbot" in every row with 400 lines of Postgres SQL

Comments

GPT‑5.3‑Codex‑Spark

An AI agent published a hit piece on me

Gemini 3 Deep Think

Polis: Open-source platform for large-scale civic deliberation

Show HN: rari, the rust-powered react framework

Major European payment processor can't send email to Google Workspace users

Launch HN: Omnara (YC S25) – Run Claude Code and Codex from anywhere

Improving 15 LLMs at Coding in One Afternoon. Only the Harness Changed

Anthropic raises $30B in Series G funding at $380B post-money valuation

Shut Up: Comment Blocker

A brief history of barbed wire fence telephone networks (2024)

Warcraft III Peon Voice Notifications for Claude Code

Apache Arrow is 10 years old

Culture Is the Mass-Synchronization of Framings

A party balloon shut down El Paso International Airport; estimated cost –$573k

The Future for Tyr, a Rust GPU Driver for Arm Mali Hardware

The "Crown of Nobles" Noble Gas Tube Display (2024)

The Science of the Perfect Second (2023)

Show HN: Generate Web Interfaces from Data

Show HN: Pgclaw – A "Clawdbot" in every row with 400 lines of Postgres SQL

How to make a living as an artist

Show HN: Geo Racers – Race from London to Tokyo on a single bus pass

Run Pebble OS in Browser via WASM

MiniMax M2.5 released: 80.2% in SWE-bench Verified

I Wrote a Scheme in 2025

HDRify: True HDR image viewer, and tool set in pure JavaScript

So many trees planted in Taklamakan Desert that it's turned into a carbon sink

ai;dr

1D Cellular Automata Playground

Using an engineering notebook