AdoMcp
NUGET · ADOMCP · SCANNED SEP 20
Database MCP server for schema discovery, comments, and SQL queries.
Available components
How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. How we score → Why this is hard to score →
Supply Chain Security100
- No malware found by supply-chain analysis.Pass
- No known CVEs affecting this package version or its production dependencies.Pass
- No install/post-install scripts declared.Pass
- No production dependencies, so there is no dependency health to assess. View diagnostics → Pass
Provenance & Transparency45
- Source repository is publicly reachable at the declared URL. View diagnostics → Pass
- Provenance check failed: no build-provenance attestation is published. See how to fix → View diagnostics → Fail
- Clear OSI-approved license (MIT).Pass
- Actively maintained (last published 8 days ago).Pass
- Disclosure check failed: no security disclosure policy was found in the source repository. See how to fix → Fail
Schema Quality & AI Usability74
- AI-judged instruction clarity (excellent).Pass
- Context-footprint check failed: tool/resource definitions use about 1298 tokens (~162/item across 8 items; 8 tools + 0 resources), over budget; trim descriptions and params. See how to fix → Fail
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management100
- No destabilizing schema changes in the last 30 days.Pass
Tool Coverage100
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 100% of tool parameters carry a description.Pass
Tool Safety75
- No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.Pass
- 0 of 3 tool(s) whose name or description implies an irreversible operation declare an MCP destructiveHint annotation; "execute_sql" implies "execute" and declares no destructiveHint at all, which the MCP spec reads as destructive by default. See how to fix → Fail
- An AI judge read all 9 captured unit(s) of tool text and found none that tries to manipulate the model reading it.Pass
Capabilities100
- Implements a current MCP spec version (2026-07-28).Pass
How do I install the AdoMcp MCP server?
AdoMcp runs locally as a NuGet package, launched with dnx adomcp@1.3.0 --yes. Ready-made configuration for Claude, Cursor, VS Code, Codex and 3 more is on this page, copied from each client's own documentation.
nuget · adomcp
claude mcp add john0king-adomcp -- dnx adomcp@1.3.0 --yes
{
"mcpServers": {
"john0king-adomcp": {
"command": "dnx",
"args": [
"adomcp@1.3.0",
"--yes"
]
}
}
} {
"servers": {
"john0king-adomcp": {
"command": "dnx",
"args": [
"adomcp@1.3.0",
"--yes"
]
}
}
} codex mcp add john0king-adomcp -- dnx adomcp@1.3.0 --yes
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"john0king-adomcp": {
"type": "local",
"command": [
"dnx",
"adomcp@1.3.0",
"--yes"
],
"enabled": true
}
}
} mcp_servers:
john0king-adomcp:
command: "dnx"
args: ["adomcp@1.3.0", "--yes"] {
"McpServers": {
"john0king-adomcp": {
"Transport": "stdio",
"Command": "dnx",
"Arguments": [
"adomcp@1.3.0",
"--yes"
]
}
}
} {
"mcpServers": {
"john0king-adomcp": {
"command": "dnx",
"args": [
"adomcp@1.3.0",
"--yes"
]
}
}
} Every change we have recorded for this component, newest first. Security-relevant changes are always shown. ▲ marks a change for the better, ▼ a change for the worse; unmarked changes are neutral.
- 20 Sept 26 +1
- Stability: 0.97 → pass security
- 18 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 90 to 93. That category is still filling its 30-day observation window: 27 days of observed history at the previous scan, 28 at this one. The score rises as the window fills, whether or not the server changes.
- 16 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 83 to 87. That category is still filling its 30-day observation window: 25 days of observed history at the previous scan, 26 at this one. The score rises as the window fills, whether or not the server changes.
- 14 Sept 26 −3
- Stability: pass → 0.80 functional
- 13 Sept 26 +1
- Stability: 0.97 → pass security
- 11 Sept 26 0
- Stability: 0.90 → unverified ▼ security
- Tool safety: pass → unverified ▼ security
- Schema quality: 131 → 162 ▼ functional
- Capabilities: pass → unverified ▼ functional
- Tool coverage: 100 → unverified ▼ functional
- Schema quality: Schema quality not yet verified: we do not have a sandbox capture of the MCP schema this version of the package serves yet. functional
- Package version: 1.2.0 → 1.3.0 functional
- 9 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 83 to 87. That category is still filling its 30-day observation window: 25 days of observed history at the previous scan, 26 at this one. The score rises as the window fills, whether or not the server changes.
- 7 Sept 26 −3
- Stability: pass → 0.80 functional
Diagnostic detail from the automated scan of this channel: what the scanner observed at each step, so you can see exactly where a check passed or failed. It is informational only and never changes the trust score.
Captured 20 Sept 2026 · Analysed nuget/adomcp@1.3.0
Provenance No attestation
The registry publishes no build provenance for this version, so there is nothing to verify.
| Result | No attestation |
|---|---|
| Ecosystem | nuget |
| Reason | Signature present, unreadable |
Background: How many MCP packages publish verified provenance →
Dependencies 0 packages
| Packages resolved | 0 |
|---|---|
| Tree resolution | Complete |
Background: SBOMs and build attestations, explained →
The tools this component advertises to a client, with an estimated token cost for each. Expand a tool to see its parameters and schema. The per-tool counts are indicative and are not scored directly; the schema's total context footprint is one signal in Schema Quality & AI Usability. A tool's description is untrusted text the model reads on every call, which is what makes this list a security surface and not just an inventory: how tool poisoning works →
add_connection ~288
Dynamically add (or replace) a database connection at runtime without modifying config files. The connection is immediately available to all other tools via its name. Supported dbType values: SqlServer | MySql | PostgreSql | Sqlite | Oracle IMPORTANT — SQLite paths: always supply an absolute path in the Data Source (e.g. "Data Source=/home/user/project/mydb.db"). If you only have a relative path, resolve it to an absolute path yourself (based on your current working directory) before calling this tool. The server cannot determine your working directory. The special value ":memory:" is also accepted for an in-memory database.
| Name | Type | Req | Description |
|---|---|---|---|
| connectionString | string | yes | Connection string. For SQLite you MUST use an absolute path: e.g. "Data Source=/absolute/path/to/mydb.db" or "Data Source=:memory:". For SQL Server: "Server=host;Database=db;User Id=sa;Password=***;T… |
| dbType | string | yes | Database engine type: SqlServer | MySql | PostgreSql | Sqlite | Oracle |
| description | string|null | – | Optional human-readable description of the connection. |
| name | string|null | – | Logical name for this connection, used as connectionName in other tools. Auto-generated if omitted. |
| testConnection | boolean | – | Test the connection before saving it. Defaults to true. |
No output schema declared.
No examples provided.
execute_sql ~108
Execute a SQL statement that modifies data or schema (INSERT / UPDATE / DELETE / DDL). Requires the server to be started with the --allow-any-sql argument. Returns the number of rows affected. WARNING: Use with caution — DDL and bulk DELETE/UPDATE may not be reversible. For read-only SELECT queries use query_sql instead.
| Name | Type | Req | Description |
|---|---|---|---|
| connectionName | string | yes | Database connection name. |
| sql | string | yes | SQL statement to execute (INSERT / UPDATE / DELETE / DDL). |
No output schema declared.
No examples provided.
get_table_indexes ~71
Get all indexes defined on a table, including index name, uniqueness, primary-key flag, and the columns involved.
| Name | Type | Req | Description |
|---|---|---|---|
| connectionName | string | yes | Database connection name. |
| schema | string|null | – | Schema name. Leave empty to use the default schema. |
| tableName | string | yes | Table name. |
No output schema declared.
No examples provided.
get_table_schema ~113
Get the detailed structure of a table, including: - Column name, data type, nullability, primary-key flag, default value, max length - Table comment and per-column comments (important for understanding business semantics)
| Name | Type | Req | Description |
|---|---|---|---|
| connectionName | string | yes | Database connection name. |
| schema | string|null | – | Schema name. Defaults: SQL Server = dbo, PostgreSQL = public, Oracle = current user, MySQL/SQLite = leave empty. |
| tableName | string | yes | Table name (without schema prefix). |
No output schema declared.
No examples provided.
list_connections ~44
List all configured database connections (pre-configured + dynamically added at runtime). Use this to discover available connection names for other tools. Returns CSV (name,dbType,description).
Input schema present but exposes no named parameters.
No output schema declared.
No examples provided.
list_objects ~246
List all objects in the database: tables, views, stored procedures, functions, triggers, sequences, synonyms, etc. Includes the schema (owner in Oracle), object type, and comment for each object. Supports filtering by schema, name keyword, and object type. Returns CSV (schema,objectType,objectName,comment).
| Name | Type | Req | Description |
|---|---|---|---|
| connectionName | string | yes | Database connection name from list_connections. |
| namePattern | string|null | – | Filter by object name. Without wildcards, treated as a substring search (e.g. "user" matches all objects containing "user"). Supports SQL LIKE wildcards. Leave empty to return all. |
| objectType | string|null | – | Filter by object type (exact match, case-insensitive): TABLE, VIEW, PROCEDURE, FUNCTION, TRIGGER, SEQUENCE, SYNONYM, etc. Leave empty to return all types. |
| schemaFilter | string|null | – | Filter by schema name (SQL Server/PostgreSQL: schema name; MySQL: database name; Oracle: owner/user). Supports SQL LIKE wildcards: % = any string, _ = single character. Leave empty to return objects… |
No output schema declared.
No examples provided.
query_sql ~143
Execute a read-only SQL query and return the results as CSV. Suitable for SELECT statements and any SQL that produces a result set. Rejects INSERT, UPDATE, DELETE, MERGE, DDL, and other write operations. Use execute_sql (with --allow-any-sql) for writes. Returns CSV with column headers on the first row followed by data rows. Returns a message when the query produces no rows.
| Name | Type | Req | Description |
|---|---|---|---|
| connectionName | string | yes | Database connection name. |
| maxRows | integer | – | Maximum number of rows to return. Default 200, max 1000. |
| sql | string | yes | SQL query to execute (SELECT or any read-only statement). |
No output schema declared.
No examples provided.
remove_connection ~45
Remove a dynamically-added database connection. Note: connections pre-configured in appsettings.json cannot be removed this way.
| Name | Type | Req | Description |
|---|---|---|---|
| connectionName | string | yes | Name of the connection to remove. |
No output schema declared.
No examples provided.
What is the AdoMcp MCP server?
AdoMcp is an MCP server listed in the public MCP registry as io.github.John0King/adomcp. Database MCP server for schema discovery, comments, and SQL queries. This page covers its NuGet package (adomcp).
Is the AdoMcp MCP server safe to use?
AdoMcp scores 83 out of 100 on VerifyMCP. We found no known CVEs affecting it as of 20 September 2026. It declares no install or post-install scripts. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.
What tools does the AdoMcp MCP server expose?
AdoMcp exposes 8 tools: list_objects, list_connections, execute_sql, remove_connection, get_table_schema, and 3 more. Their descriptions and schemas cost roughly 1,058 tokens of context every time the server is loaded.
Is the AdoMcp MCP server still maintained?
AdoMcp is still listed as active in the MCP registry. We last reached this channel on 20 September 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.
What licence is the AdoMcp MCP server under?
AdoMcp declares the MIT licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.