OpenLinkSoftware_mcp-sqlalchemy-server

OpenLinkSoftware_mcp-sqlalchemy-server

0
databases

The MCP Server ODBC via SQLAlchemy is a lightweight server that facilitates interactions with ODBC-compatible databases, specifically Virtuoso DBMS, using FastAPI, pyodbc, and SQLAlchemy. It offers features like schema fetching, table description, and query execution.

MCP Server ODBC via SQLAlchemy

A lightweight Model Context Protocol server designed for ODBC, utilizing FastAPI, pyodbc, and SQLAlchemy. It is compatible with Virtuoso DBMS and other DBMS backends with SQLAlchemy support.

Features

  • Fetch schemas and list table information for connected databases.
  • Describe table structures, including columns, data types, and keys.
  • Filter tables based on name substrings.
  • Execute stored procedures and queries, with results in JSONL or Markdown.

Prerequisites

  • Install the necessary packages and configure the ODBC DSN for your database.

Installation

  • Clone the repository and configure environment variables.

Configuration

  • Modify Claude Desktop configuration if applicable.

Usage

  • Connect to DBMS systems using pyodbc URLs and interact with Claude's AI capabilities.

Tools Provided

  • Tools for listing schemas and tables, executing queries, and interacting with Virtuoso AI features.

Troubleshooting

  • Install and use the MCP Inspector for troubleshooting server interactions.