Every agent gets its own Postgres. https://xitter.cf/t.co/guIbnw0dGQ
Joined June 2026
- Tweets161
- Following1
- Followers187
- Likes700
PostgreSQL INSERT in 3d
PostgreSQL INSERT is not what you think. 🐘
You run one SQL statement.
pgrun.dev/insert-3d
But inside Postgres, an entire system comes alive.
→ Find space in an 8 KB heap page
→ Write a new tuple
→ Generate WAL records
→ Update indexes
→ Track visibility with MVCC
→ Flush WAL at COMMIT
All that work. Just to insert ONE row.
I visualized how it actually works in 3D.
Postgres internals have never looked this cool. ↓
xitter.cf/alxshp/status/21107767…
Understanding Postgres should be fun.
🐘 Introducing Postgres Internals in 3D.
🌟 pgrun.dev/pi
Stop reading boring diagrams. Start exploring PostgreSQL.
An interactive 3D map to understand how Postgres actually works.
100% free. Built for developers.
xitter.cf/alxshp/status/21100494…
PGSync + PGRun = a path from production-like data to disposable Postgres environments for coding agents. 🚀
PGSync is becoming part of PGRun. 🚀
Move a 200GB PostgreSQL database. 🐘 FAST.
No downtime.
No triggers.
No missed changes.
⚡ Initial snapshot + live WAL streaming
⚡ Written in Rust
⚡ 100% open source
One goal: Every AI agent gets its own Postgres.
pgrun.dev
xitter.cf/alxshp/status/21100494…
Postgres → PGSync → Postgres. 🐘. P2P
Introducing PGSync 🐘
Real-time PostgreSQL replication. FREE. OSS
Built in Rust. 🦀
Postgres 16 / 17 / 18.
No extensions. No triggers. No complex setup.
→ snapshot
→ replicate
→ stream changes
→ track WAL
→ recover from crashes
→ resume automatically
→ keep databases in sync
~15 MB RAM during streaming.
Built for developers. Built for AI agents.
Open source.
xitter.cf/alxshp/status/21078790…
Postgres Terminal! ⭐⭐⭐⭐⭐
300 GitHub stars for PGTerm! ⭐⭐⭐⭐⭐
Postgres deserves a modern terminal.
So we built PGTerm: fast, open-source, and written in Rust. 🦀🐘
→ Manage all your Postgres databases in one place
→ Monitor performance in real time
→ PgBot built in for deeper diagnostics
→ Fast. Lightweight. Open source.
pgterm.dev
Built for developers. Powered by Rust.
Every table tells a story. Postgres!
I built pgbot.dev Table Map. 🐘
Stop guessing what's eating your PostgreSQL storage.
A GPU-style visual map for your database.
🟩 Green = live data
⬜ Gray = dead tuples / bloat
Every table. Every GB. One visual map.
→ See what's eating your disk.
→ Spot bloated tables instantly.
→ Watch VACUUM reclaim space.
No SQL. No dashboards.
Free & open source
xitter.cf/alxshp/status/21078790…
100 branches/week today. 10,000 is the goal. 🚀
🚀 We launched pgrun.dev
Postgres for AI agents is getting real.
Here are the early numbers:
→ 100+ branches/week
→ 3,515 hours of Postgres runtime
→ 1.7s average branch creation
→ 5.5s p95
→ 1.4 GB peak storage
Every agent gets its own isolated Postgres.
Create. Test. Destroy. Repeat.
No local database. No cleanup. No conflicts.
We're just getting started.
xitter.cf/alxshp/status/21078790…
KILL your local POSTGRES!
Introducing pgrun.dev 🐘
🚀 KILL your local database. NOW!
Stop creating local and staging databases manually.
That’s the old way. The new way:
→ Every agent gets its own Postgres.
→ Every PR gets its own Postgres.
→ Every CI run gets its own Postgres.
Created in seconds.
Used.
Destroyed.
Databases should be disposable.
xitter.cf/alxshp/status/21024376…
FAKE POSTGRES DATA
Launched today: pgfake.dev 🐘
Deterministic data masking for PostgreSQL.
Real data in. Safe fake data out.
→ Same schema.
→ Same relationships.
→ No real customer data.
v0.1.0 · Go · zero deps · deterministic
[email protected] → pgfake → [email protected]
Built for dev, CI, staging, and AI agents.
xitter.cf/alxshp/status/21057051…
Postgres Bot!
pgbot.dev is still the center of everything I’m building 🐘
inspect → understand → fix Postgres
Slow queries. Locks. Indexes. Bloat. Replication. Connections.
PgBot finds the problem and gives humans + AI agents the context to fix it.
Open source. Read-only. Fast.
xitter.cf/alxshp/status/21060688…
POSTGRES LOCKS 🐘
pgbook.dev - Postgres Book: Locks 🐘
Why a query is stuck, not slow!
Learn how to find:
→ who is blocking whom
→ how long it’s been waiting
→ what lock is involved
→ how to fix it safely
Your query may be fast.
It’s just waiting for another transaction.
xitter.cf/alxshp/status/21060688…
TERMINAL for Postgres!
Modern Postgres Terminal 2.0 🐘
Built in Rust.
Available on Linux + macOS.
pgterm.dev
No dashboards. No 15-tab workflow.
Built for developers. Built for AI agents.
> connect
> explore
> query
> inspect
> debug
> optimize
> understand what is actually happening
> fix the problem
> ship
No jumping between tools just to understand your database.
One terminal for Postgres.
Built for the way we work now.
xitter.cf/alxshp/status/21057051…
2,000+ stars is cool. Seeing people actually use these tools is much cooler.
I launched 7 OSS PostgreSQL products recently 🐘 and got 2,000+ GitHub stars. ⭐⭐⭐⭐⭐
→ pgbot.dev Postgres intelligence
→ pgterm.dev Postgres terminal
→ pgbook.dev learn Postgres
→ pgrun.dev Postgres for agents
→ pglogs.dev Postgres logs
→ pggo.dev Postgres for Go
→ pg??? Postgres in seconds (WIP)
7 products. 30+ days. 2,000+ stars.
I might have a Postgres problem.
xitter.cf/alxshp/status/21024376…
What if Postgres clients were designed for AI agents instead of humans?
~2,000 lines of Go. Zero dependencies. Direct Postgres wire protocol. 🐘
Launched today: pgGo.dev 🐘
tiny, fast Postgres client built for coding agents.
→ Zero dependencies
→ JSON-native
→ Safe parameterized queries
→ Read-only queries by default
→ Bounded output
→ Strict timeouts
→ Predictable errors + SQLSTATE
→ ~8ms one-shot Postgres calls
~2,000 lines of Go.
~4 MB static binary.
~1.7 MB compressed.
No pgx.
No libpq.
No psql parsing.
It speaks the Postgres wire protocol directly.
Minimal. Fast. Agentic.
xitter.cf/alxshp/status/20904845…
10 GB without moving 10 GB.
How does pgrun.dev copy a 100 GB Postgres database in seconds?
It doesn’t
COW = Copy-on-Write
The branch starts by sharing the same disk blocks.
Change 1 MB?
Write ~1 MB.
The other ~9.999 GB stays shared.
That’s how Postgres branching gets fast.
xitter.cf/alxshp/status/21024376…
DBA in one command? Not quite. But we’re getting suspiciously close.
pgbot.dev can score any Postgres database in ~3 seconds ⚡
🟢 DATABASE HEALTH → 90/100
Ask your agent:
“What’s my database score?”
Agent → PgBot → Inspect
pgbot Inspect
One command checks:
queries → indexes → waits → locks → tables → vacuum → replication → more
xitter.cf/alxshp/status/21006265…
pgrun.dev retweeted
WHO launched rustonrails.dev right after Rails World?! 👀🦀
“Love Rust! Rust is amazing.” — @dhh
> Rust is fast.
> Rust is everywhere.
> DHH loves Rust. (bit not read)
But the real question:
Do we actually need Rust on Rails?
Or is Rails already exactly what it needs to be? 🤔
#RailsWorld #Rails #Rust
xitter.cf/bendiken/status/210284…
"I love Rust! Rust is amazing ...if you never, ever, EVER have to look at it yourself." — @dhh
pgterm+ Ghostty ⚡️
pgterm.dev + Ghostty ⚡️
Your entire Postgres workflow. Inside the terminal.
Ghostty → PGTerm → PgBot → Postgres
→ Query data.
→ Inspect performance.
→ Find problems.
→ Debug Postgres.
No dashboard.
No context switching.
Just your terminal.
xitter.cf/alxshp/status/21006265…
Postgres branch in ~1 second
Speed of light!
Launched today: pgrun.dev 2.0 🚀
Create a 1 GB Postgres branch in ~1 second.
PGRun is now 3× faster.
DATABASE_URL: 4.88s → 1.36s
Under the hood:
ZFS snapshot → 22ms
ZFS clone → 31ms
Postgres startup → p50 80ms
DATABASE_URL → p50 1.36s
No database copy. Copy-on-write.
Every agent gets its own Postgres.
xitter.cf/alxshp/status/20999032…
⚡ PgBot + Jev
pgbot.dev now works with Jev ⚡️
pgbot → inspect any Postgres in sec.
Jev AI→ decide what matters next
pgbot → investigate deeper
LLM → explain it
Facts from Postgres.
Fast decisions from Jev.
Better agents.
xitter.cf/alxshp/status/21006265…