AdoMcp
NUGET · ADOMCP
Database MCP server for schema discovery, comments, and SQL queries.
Available components
Last scanned (20 hours ago)
Scores higher than 73% of NuGet servers
Category Databases
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
- Build provenance not yet verified. View diagnostics → Unverified
- Clear OSI-approved license (MIT).Pass
- Actively maintained (last published 5 days ago).Pass
- Disclosure check failed: no security disclosure policy was found in the source repository. See how to fix → Fail
Schema Quality & AI Usability71
- AI-judged instruction clarity (excellent).Pass
- Context-footprint check failed: tool/resource definitions use about 1370 tokens (~171/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; "remove_connection" implies "remove" 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
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.
- 2 Nov 26 0
- Stability: 0.97 → pass security
- 1 Nov 26 0
- Stability: pass → 0.97 functional
- 30 Oct 26 −1
- Package version: 1.4.0 → 1.5.0 functional
- 27 Oct 26 0
- Package version: 1.0.3 → 1.4.0 functional
- 25 Oct 26 +1
- Stability: 0.97 → pass security
- 24 Oct 26 −1
- Stability: pass → 0.97 functional
- 18 Oct 26 +1
- Stability: 0.97 → pass security
- 16 Oct 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.
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 4 Nov 2026 · Analysed nuget/adomcp@1.5.0
Provenance Inconclusive
We could not complete the check, so nothing is claimed either way. This is a gap on our side, not a finding about the package.
| Result | Inconclusive |
|---|---|
| Ecosystem | nuget |
| Reason | Signature present, unverified |
Signer
| Signed as | Repository signature, names nuget.org |
|---|---|
| Subject | CN=NuGet.org Repository by Microsoft,O=NuGet.org Repository by Microsoft,L=Redmond,ST=Washington,C=US |
| Issuer | CN=DigiCert Trusted G4 Code Signing RSA4096 SHA384 2021 CA1,O=DigiCert\, Inc.,C=US |
| Valid from | 23 Feb 2024 |
| Valid until | 18 May 2027 |
| Service index | https://api.nuget.org/v3/index.json |
| Owners | John0king |
Background: How many MCP packages publish verified provenance →
Dependencies 0 packages
| Packages resolved | 0 |
|---|---|
| Tree resolution | Complete |
Background: SBOMs and build attestations, explained →
Registry declarations For information only
What the registry and the package's own manifest say about this version. The publisher or the registry writes these, nothing here is verified, and none of it affects the score.
| Repository | https://github.com/John0King/AdoMCP |
|---|---|
| Repository type | git |
| Commit | b9f9b6d782bbe710e0ab49ae0ed2bbf8aa474593 |
| Project URL | https://github.com/John0King/AdoMCP |
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 ~301
Dynamically add (or replace) a database connection at runtime without modifying config files. Dynamic connections inherit the global AllowAnySql setting fixed at startup. 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 ~127
Execute a SQL statement that modifies data or schema (INSERT / UPDATE / DELETE / DDL). Requires write access on the target connection. Static connections use their own AllowAnySql setting when specified; otherwise they inherit the global startup setting, as dynamic connections do. 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 ~32
List all configured database connections and their effective write access. Returns CSV (name,dbType,description,canWrite).
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 ~160
Execute a read-only SQL query and return the results as CSV. Accepts a single SELECT or WITH query, with an optional trailing semicolon. Rejects write/control keywords outside strings, identifiers, and comments. Executable comments and ambiguous backslash escapes are rejected. Token filtering cannot detect side effects inside database functions. Use execute_sql for writes when the target connection allows it. 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 | A single SELECT or WITH query, optionally ending with a semicolon. |
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.
How do I install the AdoMcp MCP server?
AdoMcp runs locally as a NuGet package, launched with dnx adomcp@1.5.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.5.0 --yes
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 82 out of 100 on VerifyMCP. We found no known CVEs affecting it as of 4 November 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_connections, add_connection, remove_connection, list_objects, get_table_schema, and 3 more. Their descriptions and schemas cost roughly 1,095 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 4 November 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.