Developer creating MCP server for custom database
“Copilot gets deterministic, consistent blog tag/category suggestions; MCP server auto-launches on extension install with no manual config.”
solo-developer
Why they built it
To replace fragile Bash MCP server with reliable, testable TypeScript implementation integrated into existing VS Code extension for blog metadata management.
What worked
Single codebase for maintainability; standard TypeScript unit testing; automatic VSIX bundling and deployment; scoped stdio transport without network exposure; deterministic AI results.
What broke or was painful
Bash YAML parsing with yq/jq silently failed on multiline/special characters; shell scripts hard to unit test; separate config file needed updates independently.
The result
Copilot gets deterministic, consistent blog tag/category suggestions; MCP server auto-launches on extension install with no manual config.