mcp-adonet-server
If you are the rightful owner of mcp-adonet-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A lightweight MCP (Model Context Protocol) server for ADO.NET, compatible with Virtuoso, tested on .NET runtimes for Windows and Linux.
The C# based Model Context Protocol (MCP) Server for ADO.NET is designed to facilitate seamless interaction with databases using the ADO.NET framework. This server is particularly compatible with Virtuoso and has been tested on .NET runtimes across Windows and Linux platforms. It offers a range of functionalities including schema retrieval, table information extraction, and query execution. The server supports various query result formats such as JSONL and Markdown, making it versatile for different reporting and visualization needs. Additionally, it provides tools for executing stored procedures and SPARQL queries, specifically tailored for Virtuoso environments. The server is easy to set up and configure, with support for environment variable customization and integration with platforms like Claude Desktop.
Features
- Get Schemas: Fetch and list all schema names from the connected database.
- Get Tables: Retrieve table information for specific schemas or all schemas.
- Describe Table: Generate a detailed description of table structures, including column names, data types, nullable attributes, and keys.
- Search Tables: Filter and retrieve tables based on name substrings.
- Execute Stored Procedures: Execute stored procedures and retrieve results, specifically for Virtuoso.
Tools
ado_get_schemas
List database schema
ado_get_tables
List tables in the specified schema
ado_describe_table
Describe the table structure
ado_filter_table_names
Filter table names based on substrings
ado_query_database
Execute SQL query and return JSON results
ado_execute_query
Execute SQL query and return JSONL results
ado_execute_query_md
Execute SQL query and return Markdown table results
ado_spasql_query
Execute SPASQL query (Virtuoso specific)
ado_sparql_query
Execute SPARQL query (Virtuoso specific)
ado_virtuoso_support_ai
Interact with Virtuoso Support Assistant (Virtuoso specific)
