Claude MarketplacesSubmit

AdoMcp

john0king/adomcp

Connects Claude to SQL Server, MySQL, PostgreSQL, SQLite, and Oracle databases through seven tools that let you list connections, inspect schemas with full column metadata and comments, query indexes, and run read-only SQL that returns CSV. The execute_sql tool handles writes but requires an explicit flag at startup. Built on .NET 10 with Dapper and SqlSugar, it auto-detects stdio mode when launched by MCP clients or falls back to HTTP/SSE for interactive use. You can preconfigure connections in appsettings.json or add them dynamically at runtime through the add_connection tool. Especially handy for Oracle users since it resolves synonyms and pulls comments from ALL_TAB_COMMENTS. Run it via dotnet or dnx once published to NuGet.

GitHub stars: 4
tools: 8
transport: STDIO
last updated: Oct 30, 2026

Tools

8 tools

Public tool metadata for what this MCP can expose to an agent.

list_connections列出已配置的数据库连接

列出已配置的数据库连接

No parameter schema in public metadata yet.

add_connection在当前进程中新增或替换连接

在当前进程中新增或替换连接

No parameter schema in public metadata yet.

remove_connection删除运行时新增的连接

删除运行时新增的连接

No parameter schema in public metadata yet.

list_objects查找表、视图、存储过程、函数、触发器、序列和同义词等对象

查找表、视图、存储过程、函数、触发器、序列和同义词等对象

No parameter schema in public metadata yet.

get_table_schema获取字段、类型、可空性、主键、默认值和注释

获取字段、类型、可空性、主键、默认值和注释

No parameter schema in public metadata yet.

get_table_indexes获取表索引

获取表索引

No parameter schema in public metadata yet.

query_sql执行只读 SQL，返回 CSV

执行只读 SQL，返回 CSV

No parameter schema in public metadata yet.

execute_sql执行写 SQL；默认禁用，需显式启用

执行写 SQL；默认禁用，需显式启用

No parameter schema in public metadata yet.

Sponsors

Promote your product hereReach 125k+ visitors monthly Promote your product hereReach 125k+ visitors monthly

Agent CaffeineSponsoredClose your lid, come back to finished work

SnugSponsoredThe clipboard manager for the AI era Promote your product hereReach 125k+ visitors monthly

WaxSponsoredBlock anything with supervision, without erasing your iPhone Promote your product hereReach 125k+ visitors monthly

knobsSponsoredSee your site on any phone, any day, in any language

Readme

AdoMcp

一个开箱即用的数据库 Model Context Protocol (MCP) Server，让 AI Agent 能够发现数据库对象、理解表结构和注释、检查索引，并安全地执行 SQL。

A ready-to-run database MCP server for schema discovery, comments, indexes, and controlled SQL execution.

支持 SQL Server、MySQL/MariaDB、PostgreSQL、SQLite 和 Oracle；插件核心遵循 Agent Plugins（Open Plugin Spec）1.0，可用于 Codex、Claude Code、GitHub Copilot App 和 Copilot CLI。

Server name 和 version 由 MCP SDK 根据程序集元数据自动生成；Server 会在 MCP initialize/server/discover 响应中返回根级 instructions，指导客户端先定位连接与对象、只用 query_sql 读数据，并仅在明确授权后调用 execute_sql。

功能

Tool	说明
`list_connections`	列出已配置的数据库连接
`add_connection`	在当前进程中新增或替换连接
`remove_connection`	删除运行时新增的连接
`list_objects`	查找表、视图、存储过程、函数、触发器、序列和同义词等对象
`get_table_schema`	获取字段、类型、可空性、主键、默认值和注释
`get_table_indexes`	获取表索引
`query_sql`	执行只读 SQL，返回 CSV
`execute_sql`	执行写 SQL；默认禁用，需显式启用

View the full README on GitHub

Details

Repository: github.com/john0king/adomcp
Website: github.com/John0King/AdoMCP
Category: Databases
Package: adomcp
Transport: STDIO
Registry: MCP registry, active

Related Databases MCP servers

1

oraclemcpmuhdur/oraclemcpEngine-free, governed Oracle Database MCP server with a fail-closed SQL guard (unofficial).4stars

2

DB Connect MCPyugui923/db-connect-mcpMulti-database MCP server for PostgreSQL, MySQL, and ClickHouse4stars

3

Mimer Mcpmimersql/mimer-mcpAn MCP server with Mimer SQL Database Connectivity3stars

4

DataLinkpilat/mcp-datalinkMCP server for secure database access (PostgreSQL, MySQL, SQLite)3stars

5

Fastmcp Sqltoolsatarkowska/fastmcp-sqltoolsA MCP server provides SQL database access with support for PostgreSQL, MySQL, and SQLite.1stars

6

DB MCP Serverstucchi/db-mcp-serverDatabase MCP server for MySQL, PostgreSQL, MongoDB, and SQLite with SSH tunneling support.0stars