OpenLinkSoftware_mcp-pyodbc-server

OpenLinkSoftware_mcp-pyodbc-server

0
databasesdeveloper_tools

This project is a lightweight Model Context Protocol server enabling interaction with ODBC-compatible databases using FastAPI and pyodbc. It supports various operations such as schema retrieval, table description, and query execution, particularly optimized for Virtuoso DBMS applications.

MCP Server ODBC via PyODBC

A lightweight MCP (Model Context Protocol) server for ODBC built with FastAPI and pyodbc. It is compatible with Virtuoso DBMS and other DBMS backends with ODBC drivers.

Features

  • Get database schemas.
  • Retrieve and describe table structures.
  • Execute stored procedures for Virtuoso.
  • Execute SQL queries in various formats including JSONL and Markdown.
  • Support for Virtuoso SPARQL and SPASQL queries.

Installation

  1. Clone the repository
  2. Install necessary dependencies (e.g., uv, unixODBC)
  3. Configure ODBC Data Source.