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.