Is io.github.John0King/adomcp safe to use?

io.github.John0King/adomcp has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments.

How do I install io.github.John0King/adomcp?

io.github.John0King/adomcp can be installed by cloning its GitHub repository and following the setup instructions in the README.

What AI clients work with io.github.John0King/adomcp?

io.github.John0King/adomcp is compatible with Claude Desktop, Cursor, Claude Code, and most MCP clients that support stdio transport. It uses stdio transport.

Is io.github.John0King/adomcp actively maintained?

io.github.John0King/adomcp is actively maintained — last commit was 1 day ago.

io.github.John0King/adomcp

Database MCP server for schema discovery, comments, and SQL queries.

0 tools GitHub

No known CVEs

No license

Actively maintained

Last commit 1d ago

Untested

Transport: stdio

0 tools

Grade F

Data

Step 1

Install in your client

Config is the same across clients — only the file and path differ.

Untested on Claude Desktopstdio · Node 18+

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "io-github-john0king-adomcp": {
      "command": "<see-readme>",
      "args": []
    }
  }
}

Are you the author?

Add this badge to your README to show your security score and help users find safe servers.

Embed in your READMEAbout badges →

[![MCPpedia Score](https://mcppedia.org/api/badge/io-github-john0king-adomcp)](https://mcppedia.org/s/io-github-john0king-adomcp)

Read me

What io.github.John0King/adomcp does

AdoMcp is a Model Context Protocol (MCP) server that helps large language models (LLMs) understand database structure, read table comments, and execute SQL queries.

Test This Server

No automated test available for this server. Check the GitHub README for setup instructions.

Loading README…

Scored, not listed

Why this score

Five weighted categories — click any category to see the underlying evidence.

Score breakdown

30/100across 5 weighted dimensions

How we score →

0255075100

−70

Security

Maintenance

Efficiency

Documentation

Compatibility

Categoriesclick a row to see evidence

Security

OSV.dev

No known CVEs.

No package registry to scan.

Community

Reviews

Be the first to review

Have you used this server?

Share your experience — it helps other developers decide.

How easy was setup?Did it work reliably?How was the documentation?

Frequently Asked Questions

Is io.github.John0King/adomcp safe to use?: io.github.John0King/adomcp has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments.
How do I install io.github.John0King/adomcp?: io.github.John0King/adomcp can be installed by cloning its GitHub repository and following the setup instructions in the README.
What AI clients work with io.github.John0King/adomcp?: io.github.John0King/adomcp is compatible with Claude Desktop, Cursor, Claude Code, and most MCP clients that support stdio transport. It uses stdio transport.
Is io.github.John0King/adomcp actively maintained?: io.github.John0King/adomcp is actively maintained — last commit was 1 day ago.

Similar servers

Others in data

View all →

Supabase MCP Server96

Manage Supabase projects — databases, auth, storage, and edge functions

2.6k 4

PostgreSQL MCP Server96

Query and manage PostgreSQL databases directly from AI assistants

84.5k 1

Toolsdk Mcp Registry95

MCPSDK.dev(ToolSDK.ai)'s Awesome MCP Servers and Packages Registry and Database with Structured JSON configurations. Supports OAuth2.1, DCR...

169 1

Mac_messages_mcp95

An MCP server that securely interfaces with your iMessage database via the Model Context Protocol (MCP), allowing LLMs to query and analyze iMessage conversations. It includes robust phone number validation, attachment processing, contact management, group chat handling, and full support for sending and receiving messages.

272 4

MCP Security Weekly

Get CVE alerts and security updates for io.github.John0King/adomcp and similar servers.

Community

Discussion

Start a conversation

Ask a question, share a tip, or report an issue.

Has anyone used this with Cursor?How do you handle auth?Any alternatives?

Data

Step 1

Install in your client

Config is the same across clients — only the file and path differ.

Untested on Claude Desktopstdio · Node 18+

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "io-github-john0king-adomcp": {
      "command": "<see-readme>",
      "args": []
    }
  }
}

Are you the author?

Add this badge to your README to show your security score and help users find safe servers.

Embed in your READMEAbout badges →

[![MCPpedia Score](https://mcppedia.org/api/badge/io-github-john0king-adomcp)](https://mcppedia.org/s/io-github-john0king-adomcp)

Read me

What io.github.John0King/adomcp does

AdoMcp is a Model Context Protocol (MCP) server that helps large language models (LLMs) understand database structure, read table comments, and execute SQL queries.

Test This Server

No automated test available for this server. Check the GitHub README for setup instructions.

README

AdoMcp

AdoMcp is a Model Context Protocol (MCP) server that helps large language models (LLMs) understand database structure, read table comments, and execute SQL queries.

AdoMcp 是一个基于 Model Context Protocol (MCP) 的数据库工具服务，帮助大型语言模型（LLM）理解数据库结构、读取表注释、执行 SQL 查询。

MCP Tools

Tool	Description
`list_connections`	List configured database connections
`add_connection`	Add (or replace) a database connection at runtime
`remove_connection`	Remove a dynamically-added connection
`list_objects`	List database objects (table/view/procedure/function/trigger/sequence/synonym, etc.)
`get_table_schema`	Get table schema details (columns/types/nullability/PK/default/comments)
`get_table_indexes`	Get table indexes
`query_sql`	Execute read-only SQL and return CSV
`execute_sql`	Execute write SQL (requires `--allow-any-sql`)

Recommended Tool Workflow (for LLM agents)

To reduce mistakes (wrong database/schema/object), use tools in this order:

list_connections to discover available connections.
If none are available, call add_connection.
Before inspecting a table/view, call list_objects to locate schema + objectType + objectName.
Use get_table_schema for column details (type, nullability, PK, default, comments).
Use get_table_indexes when index/key design matters.
Use query_sql only for read-only verification.
Use execute_sql only when explicitly authorized and server is started with --allow-any-sql.

Oracle note: objects without owner prefix may be synonyms. Always confirm the real schema via list_objects first.

Supported Databases

Database	Driver	Comment support
SQL Server	`Microsoft.Data.SqlClient`	`MS_Description` extended properties
MySQL / MariaDB	`MySqlConnector`	`TABLE_COMMENT` / `COLUMN_COMMENT`
PostgreSQL	`Npgsql`	`obj_description` / `col_description`
SQLite	`Microsoft.Data.Sqlite`	— (SQLite has no native comments)
Oracle	`Oracle.ManagedDataAccess.Core`	`ALL_TAB_COMMENTS` / `ALL_COL_COMMENTS` (includes PUBLIC synonyms)

ORM support: Dapper · SqlSugarCore

Requirements

.NET 10 SDK

Quick Start

1. Configure database connections (optional)

Edit src/AdoMcp/appsettings.json and add pre-configured connections under the Databases array.
You can also skip this step entirely and let the LLM add connections dynamically via the add_connection tool.

"Databases": [
  {
    "Name": "mydb",
    "DbType": "SqlServer",
    "ConnectionString": "Server=localhost;Database=MyDb;User Id=sa;Password=***;TrustServerCertificate=true;",
    "Description": "Main business database"
  }
]

Supported DbType values: SqlServer | MySql | PostgreSql | Sqlite | Oracle

Security tip: Use .NET User Secrets or environment variables to manage connection strings in production.

2. Run the server

Automatic mode detection (recommended)

When stdin is redirected (i.e. launched by an MCP client), stdio mode is used automatically.
When run interactively in a terminal, HTTP/SSE mode is used automatically.

dotnet run --project src/AdoMcp

Specify mode manually

# stdio mode (all logs go to stderr; stdout carries only MCP JSON-RPC)
dotnet run --project src/AdoMcp -- --stdio

# HTTP/SSE mode (default: http://localhost:5100, MCP endpoint /mcp)
dotnet run --project src/AdoMcp -- --http

# Via environment variable
ADOMCP_MODE=http dotnet run --project src/AdoMcp

Enable execute_sql (write operations)

By default the execute_sql tool is disabled to prevent unauthorised writes.

... View full README on GitHub

Loading README…

Scored, not listed

Why this score

Five weighted categories — click any category to see the underlying evidence.

Score breakdown

30/100across 5 weighted dimensions

How we score →

0255075100

−70

Security

Maintenance

Efficiency

Documentation

Compatibility

Categoriesclick a row to see evidence

Security

OSV.dev

No known CVEs.

No package registry to scan.

Community

Reviews

Be the first to review

Have you used this server?

Share your experience — it helps other developers decide.

How easy was setup?Did it work reliably?How was the documentation?

Frequently Asked Questions

Is io.github.John0King/adomcp safe to use?: io.github.John0King/adomcp has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments.
How do I install io.github.John0King/adomcp?: io.github.John0King/adomcp can be installed by cloning its GitHub repository and following the setup instructions in the README.
What AI clients work with io.github.John0King/adomcp?: io.github.John0King/adomcp is compatible with Claude Desktop, Cursor, Claude Code, and most MCP clients that support stdio transport. It uses stdio transport.
Is io.github.John0King/adomcp actively maintained?: io.github.John0King/adomcp is actively maintained — last commit was 1 day ago.