Postgres MCP Servers Compared: Read-Only Posture, Auth and Auditability
Six Postgres MCP servers compared on write posture, auth and audit trail: Anthropic's archived reference, Postgres MCP Pro, Supabase, Neon, pgEdge, pREST.
Six Postgres MCP servers compared on write posture, auth and audit trail: Anthropic's archived reference, Postgres MCP Pro, Supabase, Neon, pgEdge, pREST.
pREST v2.4.0 adds pgvector nearest-neighbor search and distance filtering, opt-in OpenTelemetry tracing/metrics/logs with a local SigNoz stack, and closes six SQL-injection-adjacent security gaps found via advisory review — including a sibling of the v2.3.0 _select fix living in _groupby.
Vault is a minimal, cross-platform file manager built around search instead of folder trees — Go and Wails under a React UI, 353ms cold start, ~80MB idle RAM, OS-trash-only deletes, and an MCP server so an AI client can drive it.
Leadership · Fractional CTO guide
A fractional CTO is a senior technology leader who works for your company part time. What they do, what they cost in Canada and the US, when to hire one.
pREST v2.3.0 closes an unauthenticated SQL injection in the _select parameter (CVSS 9.8), migrates JWKS handling to jwx v3, and completes the multi-adapter registry that isolates TimescaleDB features from the base Postgres adapter.
pREST 2.2.0 ships an embedded Studio UI, database-backed custom queries, and first-class TimescaleDB support—making instant Postgres APIs easier to explore and operate.
pREST and PostgREST both turn PostgreSQL into a REST API. PostgREST is Haskell and RLS-first; pREST is Go with config ACL, multi-database routing and MCP.
pREST AI tooling ships prest-mcp stdio adapter, Cursor plugin rules/skills, and OpenClaw ClawHub skills — read-only PostgreSQL access for agents via the /_mcp endpoint.
pREST v2.1.0 MCP server exposes read-only PostgreSQL queries over HTTP — connect from Cursor, Claude Desktop, or curl with permission-aware ACL and no separate MCP process.
pREST v2 is a Go PostgreSQL REST API with multi-database registry in v2.0.0 GA and a read-only MCP server in v2.1.0 — permission-aware Postgres queries for agents and API clients.
pREST v2.0.0-rc6 splits the monolithic Adapter into port interfaces, wires HTTP controllers through dependency injection, and keeps a backward-compatible composite Adapter for Go teams running Postgres REST APIs.
I built DeliveryCompass for engineering managers tired of rebuilding spreadsheets before staff meetings — read-only GitHub PR metrics for throughput, lead time, and review health.
We hosted the first Golang Calgary meetup with a full room of 30+ attendees, an excellent talk by Adebayo on concurrency and parallelism, and my session on the Go scheduler.
How I built a production-ready, enterprise-grade platform for running internal company hackathons using Go, Buffalo framework, and PostgreSQL—complete with audit logging, role-based access control, and a comprehensive admin dashboard.
Careers · First developer job guide
Optimize your GitHub profile for first developer job opportunities with better project presentation, README strategy, and recruiter-friendly signals.
Careers · Staff Engineer guide
Understanding the crucial differences between Staff and Senior Software Engineers: scope, responsibilities, impact, and what it really takes to make the leap.
Careers · Staff Engineer guide
A comprehensive breakdown of engineering levels across the tech industry, where Staff Engineer fits in the hierarchy, and what progression looks like beyond.
Careers · Staff Engineer guide
Beyond the job description: the characteristics, traits, and career patterns of successful Staff Software Engineers in the tech industry.
Careers · Staff Engineer guide
A practical guide to reaching Staff Engineer level: the skills you need, experiences to seek, and career moves that matter for advancing to senior technical leadership.
Careers · Staff Engineer guide
Understanding the Staff Software Engineer role: responsibilities, expectations, and how it differs from other engineering positions in the tech industry.