AdoMcp
Let your agent discover database schema, read column comments, and run SQL through MCP without hand-pasting DDL into chat.
Overview
io.github.John0King/adomcp is a MCP server for the Build phase that provides database schema discovery, comment metadata, and SQL query tools via AdoMcp.
What is this MCP server?
- Database schema discovery exposed as MCP tools
- Column and object comments readable by the agent
- SQL query execution path for grounded data questions
- NuGet package adomcp v1.0.2 with stdio and dnx runtime hint
- .NET-friendly AdoMcp server from GitHub John0King/AdoMCP
- Version 1.0.2 published to NuGet as identifier adomcp with stdio transport
- Documented capabilities: schema discovery, comments, and SQL queries
What problem does it solve?
Agents guess table names and relationships because they cannot see your actual database schema or official column comments.
Who is it for?
Solo backend builders on .NET or ADO-friendly stacks who want schema-grounded agent assistance during feature work.
Skip if: Frontend-only projects, teams forbidding agent SQL access, or builders who need full ETL orchestration instead of interactive queries.
What do I get? / Deliverables
After install, your agent discovers schema and runs SQL through MCP so migrations, queries, and data models match the real database.
- Agent-visible database schema structure
- Comment and metadata context on columns or objects
- Executed SQL results feeding backend implementation tasks
Recommended MCP Servers
Journey fit
Schema discovery and ad hoc SQL are core backend build tasks when you model data and wire app logic before production monitoring. Backend is the canonical shelf for database-facing MCP tools—schema, metadata comments, and query execution—not frontend or launch SEO work.
How it compares
ADO database schema and SQL MCP, not a document store browser or Marketing Cloud integration server.
Common Questions / FAQ
Who is io.github.John0King/adomcp for?
Developers shipping data-backed apps who want Claude Code or Cursor to read real schema, comments, and SQL results safely through MCP.
When should I use io.github.John0King/adomcp?
Use it during backend build when modeling tables, debugging queries, or explaining schema to the agent before you ship.
How do I add io.github.John0King/adomcp to my agent?
Install the NuGet tool adomcp v1.0.2, point your MCP host at the stdio entry with your database connection configured per AdoMCP docs, then reload tools.