mcp-sqlalchemy-server
12
The project is a lightweight MCP server designed for ODBC connections, utilizing FastAPI, pyodbc, and SQLAlchemy. It provides a variety of features for managing and querying databases, including support for Virtuoso DBMS and functionality to execute SQL and SPARQL queries with results in structured formats.
MCP Server ODBC via SQLAlchemy
A lightweight MCP server for ODBC built with FastAPI, pyodbc, and SQLAlchemy. Compatible with Virtuoso DBMS and other SQLAlchemy provider backends.
Features
- Fetch database schema names
- Retrieve and describe tables
- Search for tables by name
- Execute stored procedures in Virtuoso
- Execute queries with results in JSONL or Markdown format
Installation
Clone the repository and set up environment variables in a .env file.
Configuration
Integrate with Claude Desktop by updating claude_desktop_config.json to run the server with specified environment variables.
Usage
Connect to DBMS using provided pyodbc URL examples, including PostgreSQL, MySQL, and SQLite.