Fuzzwah's Agentic Coding Learnings

The Two Paths to MCP Integration

When building a Model Context Protocol (MCP) server for VS Code, one of your first architectural decisions is choosing the transport mechanism: STDIO or HTTP. Each has distinct advantages and trade-offs that affect deployment, security, and user experience.

Let me share what I’ve learned building and deploying both types of MCP servers.

STDIO Servers: The Automatic Advantage

The Core Benefit: Zero-Touch Startup ✨

The killer feature of STDIO MCP servers is elegantly simple: VS Code automatically starts them for you.

When a user installs your MCP server and adds it to...
Continue reading →

The Problem: A Missing Middle Ground

When I started working with postgres-mcp, I quickly realized there was a gap in the access control system. The server offered two modes:

• UNRESTRICTED: Full database access - perfect for development, but too dangerous for production agents
• RESTRICTED: Read-only mode - safe, but useless when you need to write data

But what if you need an AI agent that can insert records, update statuses, or delete outdated data—without giving it the keys to restructure your entire database schema?

That’s the use case that led me to build DML_ONLY mode: a...
Continue reading →