A MCP server for database introspection and SQL execution. It lets LLMs list connections and database objects, inspect table schema and indexes, and run read-only or authorized write SQL against supported databases.
From the registry: Database MCP server for schema discovery, comments, and SQL queries.
Please install the `adomcp` MCP server into my current AI client (that's you).
Required prerequisites (do these first if not already done):
- **.NET 10 SDK** — Install the .NET 10 SDK to run the server via dnx or from source. (https://dotnet.microsoft.com/download/dotnet/10.0】},{)
Canonical MCP server config (stdio transport):
- command: `dnx`
- args: ["-y","AdoMcp"]
- optional environment variables:
- `ADOMCP_MODE`: Transport mode override. Set to stdio or http; for stdio client configs this is typically unnecessary because stdio is auto-detected when launched by an MCP client. (example: `stdio`)
- `ADOMCP_URLS`: HTTP listen address when running in HTTP mode. (example: `<your-http-listen-url>`)
Note: Preferred install path is dnx (.NET 10+) because it avoids cloning the repository. The server supports both stdio and HTTP/SSE. In stdio mode, use command 'dnx' with args ['-y','AdoMcp']. To enable write operations via execute_sql, add '--','--allow-any-sql' to the args. Database connections are optional at startup and can be preconfigured in appsettings.json or added dynamically at runtime with the add_connection tool.
Add this MCP server to my current client's config in the correct format for you. If you need secrets or credentials I haven't provided, ASK me — do not invent values or leave raw placeholders. After adding it, tell me how to verify the server is connected.ADOMCP_MODETransport mode, either stdio or httpADOMCP_URLSHTTP listen addressAI orchestration with hive-mind swarms, neural networks, and 87 MCP tools for enterprise dev.