OpenLinkSoftware_mcp-sqlalchemy-server
If you are the rightful owner of OpenLinkSoftware_mcp-sqlalchemy-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 server for ODBC built with FastAPI, pyodbc, and SQLAlchemy, compatible with Virtuoso DBMS and other DBMS backends.
The MCP Server ODBC via SQLAlchemy is a streamlined server designed to facilitate database interactions using the Model Context Protocol (MCP). Built with FastAPI, pyodbc, and SQLAlchemy, it supports various database management systems (DBMS) that implement a SQLAlchemy provider, including Virtuoso DBMS. The server offers a range of functionalities such as fetching schema and table information, executing stored procedures, and running queries with results formatted in JSONL or Markdown. It is particularly useful for developers and database administrators who need a lightweight, efficient solution for managing and querying databases through a standardized protocol.
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, especially for Virtuoso.
Tools
get_schemas
List database schemas accessible to connected database management system (DBMS).
get_tables
List tables associated with a selected database schema.
describe_table
Provide the description of a table associated with a designated database schema.
filter_table_names
List tables, based on a substring pattern from the
qinput field, associated with a selected database schema.query_database
Execute a SQL query and return results in JSONL format.
execute_query
Execute a SQL query and return results in JSONL format.
execute_query_md
Execute a SQL query and return results in Markdown table format.
spasql_query
Execute a SPASQL query and return results.
sparql_query
Execute a SPARQL query and return results.
virtuoso_support_ai
Interact with the Virtuoso Support Assistant/Agent -- a Virtuoso-specific feature for interacting with LLMs.
