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.
📊 pgseries — A light alternative to TimescaleDB that works in any Postgres: pure SQL/PLpgSQL time-series for PG17+ (brief).
🌈 pg_ash — Active Session History for Postgres — wait event sampling with zero bloat.
🖥️ rpg — Modern Postgres terminal written in Rust. psql-compatible, with built-in DBA diagnostics and AI assistant.
🧱 sqlever — Sqitch-compatible Postgres migration tool with static analysis and zero-downtime migrations.
🔧 postgres_dba — Practical Postgres DBA tools for debugging, maintenance, and operations.
🚰 pg_plumbing — Modern Postgres dump/restore on steroids.
🪶 leandex — keep your Postgres indexes lean.
📝 samospec — Git-native CLI for multi-AI spec creation and iterative refinement.
🤖 samoagent — CLI meeting AI agent for Zoom and Google Meet: joins calls, transcribes live speech, and lets AI agents monitor and react.
🗞️ gitzette — Weekly engineering newspaper auto-generated from any GitHub user's activity (live).

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
📊 gaps.wait.events — tracking uninstrumented Postgres wait events; now a GSoC 2026 project where I'm mentoring
🧠 Recognized 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