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

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

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

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.

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.

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.

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).

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.