San Diego ↔ San Francisco · Postgres since 2005 · Founder of PostgresAI
🐘 Postgres · 📈 Scalability · 🌍 Open Source · 🚀 Startups
I build tools, write, and go deep on Postgres internals, performance, and operations.
- 🧵 PgQue — Zero-bloat Postgres queue. No extensions. No daemon. One SQL file. A revival of PgQ, ancient art from Skype.
- 🌈 pg_ash — Active Session History for Postgres — wait event sampling with zero bloat.
- 🏙️ PGSimCity — An explorable 3D city that shows how Postgres actually works (live).
- 🌿 samogrow — A self-hosted, AI-controlled indoor herb garden built from a camera, smart plugs, and one Bun service (brief).
- 🖥️ samohost — Operator-local CLI for provisioning hardened Linux VMs, deploying apps, and creating per-branch preview environments.
- 🎥 samograph — Lets AI agents join Zoom and Google Meet calls to listen, respond, and take action in real time.
- 📝 samospec — Git-native CLI for multi-AI spec creation and iterative refinement.
- 🛠️ Hacking Postgres — Public workbench for Postgres hacking sessions, patches, progress, blockers, and TODOs (live).
- 🖥️ rpg — Modern Postgres terminal written in Rust. psql-compatible, with built-in DBA diagnostics and AI assistant.
- 🔧 postgres_dba — Practical Postgres DBA tools for debugging, maintenance, and operations.
- 🪶 leandex — keep your Postgres indexes lean.
- 🗞️ gitzette — Weekly engineering newspaper auto-generated from any GitHub user's activity (live).
- 🛑 pg_brakes — Rust safety gateway between AI agents and Postgres, with bounded reads, certified writes, human approval, and tamper-evident auditing.
- 🧱 sqlever — Sqitch-compatible Postgres migration tool with static analysis and zero-downtime migrations.
- 📊 pgseries — A light alternative to TimescaleDB that works in any Postgres: pure SQL/PLpgSQL time-series for PG17+ (brief).
Building software for self-driving Postgres.
- PostgresAI Monitoring and Checkup — Postgres observability built for humans and AI agents.
- DBLab Engine — Database branching & thin cloning for any Postgres database.
- 🎥 Postgres Hacking sessions — live deep-dives on Postgres internals on PostgresTV (YouTube playlist)
- 📊 gaps.wait.events — tracking uninstrumented Postgres wait events
- 🧠 Significant contributor to Postgres core — patches and reviews across multiple releases
- 📜 GSoC 2006 — SQL/XML 2003 support (mentored by Peter Eisentraut) — my first deep dive into Postgres internals
- ✍️ #PostgresMarathon — deep-dive series on Postgres internals
- 🎙️ PostgresFM — podcast
- 📺 PostgresTV — YouTube
- 💼 Nik Samokhvalov on LinkedIn
- 🐙 GitHub — this page
- 🦊 GitLab profile
- 🐦 @samokhvalov on X