MCP.so
登录

C# based Model Context Procotol (MCP) Server for ADO.NET

@OpenLinkSoftware

基本信息

分类

其他

许可证

MIT

传输方式

stdio

作者

OpenLinkSoftware

关于 C# based Model Context Procotol (MCP) Server for ADO.NET

C# based Model Context Procotol (MCP) Server for ADO.NET ODBC provider

C# based Model Context Procotol (MCP) Server for ADO.NET 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块,请前往代码仓库查看安装说明。

代码仓库

C# based Model Context Procotol (MCP) Server for ADO.NET 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表,不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is C# based Model Context Protocol (MCP) Server for ADO.NET?

A lightweight C#-based MCP server for ADO.NET, compatible with Virtuoso. It provides tools for database schema inspection, table description, query execution, and more. Intended for developers integrating MCP clients with relational databases via ADO.NET.

How to use C# based Model Context Protocol (MCP) Server for ADO.NET?

Clone the repository, set the ADO_URL and API_KEY environment variables, and configure the server in an MCP client (e.g., Claude Desktop) using the dotnet run command with --framework net8.0 or net9.0. The server exposes tools like ado_get_schemas, ado_get_tables, ado_query_database, etc.

Key features of C# based Model Context Protocol (MCP) Server for ADO.NET

  • Fetch and list database schemas
  • Retrieve table information for specific schemas
  • Describe table structures with columns and keys
  • Search tables by name substring
  • Execute SQL queries in JSONL or Markdown format
  • Run stored procedures on Virtuoso

Use cases of C# based Model Context Protocol (MCP) Server for ADO.NET

  • Allow an AI assistant to explore and query a Virtuoso database
  • Generate Markdown reports from SQL query results
  • Programmatically inspect schema metadata for data migration tasks
  • Enable conversational database interaction via MCP clients like Claude Desktop

常见问题

1

What databases does this server support?

It is built on ADO.NET and designed for full compatibility with Virtuoso. It has been tested on Windows and Linux but may work with other ADO.NET-compatible databases.

2

What are the runtime requirements?

.NET 8 or .NET 9 runtime must be installed. The server can be run using `dotnet run` with the appropriate framework.

3

How do I set up authentication?

Provide an API key via the `API_KEY` environment variable. This key is passed to the server and used for API authentication.

4

Where does the server connect to my database?

The database connection is configured through the `ADO_URL` environment variable (e.g., `HOST=localhost:1111;Database=Demo;UID=demo;PWD=demo`).

5

Can I execute SPARQL or SPASQL queries?

Yes, for Virtuoso databases. The tools `ado_sparql_query` and `ado_spasql_query` are available specifically for that purpose.

评论

其他 分类下的更多 MCP 服务器