Articles for people who
ship the stack
Rewrites on React, Node.js, TypeScript and AI. A translated body is shown when it exists. If it does not, you see the English text and a note that says so.
Tagged: PostgreSQL
MCP Explained: Build a Natural-Language PostgreSQL Assistant for Claude
MCP explained through a project: how Model Context Protocol turns N x M integrations into N + M, then a read-only PostgreSQL server Claude Desktop can query.
10 min readBest Database for a Coding Agent: PostgreSQL for State, Hybrid Search for Recall
The best database for a coding agent: PostgreSQL for run state, tool calls and artifacts, plus a hybrid search layer with an outbox once recall matters.
7 min readAdding PostgreSQL, Drizzle and Auth to a Nest.js, tRPC and Turborepo Monorepo
Extend a type-safe TypeScript monorepo with Docker Postgres, drizzle-orm schemas, Nest.js users and posts modules, JWT auth routers and a React login form.
13 min readSemantic Search in PostgreSQL With pgvector and Node.js, No LLM Needed
Semantic search in PostgreSQL with pgvector and Node.js, no LLM: MiniLM embeddings, chunks, an IVFFlat index, distance operators and how to read the scores.
8 min readA Four-Layer Memory Design for AI Agents With Provenance
Short and long-term memory split, four layers (buffer, episodic, semantic, procedural), storage choices, async writes, and defenses against memory poisoning.
23 min readSemantic Search in PostgreSQL With pgvector and .NET: A Practical Setup
Store embeddings next to relational data, build HNSW or IVFFlat indexes, filter and blend hybrid ranks, and judge when pgvector is enough for your app.
9 min readBeyond Naive RAG: HNSW Memory Costs, Hybrid Search and Long Context
Why in-memory vector indexes hit a wall at scale, where exact-match retrieval fails, and how BM25 hybrids, RRF and PostgreSQL fit in a long-context world.
5 min readPostgreSQL MCP in Practice: Architecture, Security, Best
PostgreSQL MCP in practice: stop giving AI raw database access, what makes the server different, where it fits next to a REST API, security and best practices.
15 min readPostgreSQL + pgvector and SQL Server 2025 as Vector Stores
PostgreSQL 18 with pgvector vs SQL Server 2025 as vector stores: how each works as a vector database, installing pgvector on Windows, and storing embeddings.
18 min read
About these articles
Request a 24h estimate
Need the same stack in a production operator layer? Send the brief — estimate within 24 hours.