Nik Samokhvalov NikolayS

Hi, I'm Nik

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