mcp-adonet-server

mcp-adonet-server

3

This project provides a lightweight Model Context Protocol (MCP) server specifically designed for ADO.NET integration, working with Virtuoso. It offers a suite of database interaction tools such as schema retrieval, table information access, and both SQL and SPARQL querying capabilities.

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

A lightweight MCP server that integrates with ADO.NET, compatible with Virtuoso, and designed for .NET runtimes on Windows and Linux.

Features

  • Retrieve and list database schemas and tables.
  • Provide detailed table structure descriptions and search capabilities.
  • Execute stored procedures and SQL queries in multiple formats, including JSONL and Markdown tables.
  • Support for SPASQL and SPARQL queries specific to Virtuoso.

Usage

Tools provided: ado_get_schemas, ado_get_tables, ado_describe_table, ado_filter_table_names, ado_query_database, and more for interacting with databases through MCP client applications.

Configuration

Requires .NET 8. Example environment setup involves configuring a connection string and API key in a .env file.