MCP Server ODBC via SQLAlchemy

Name: MCP Server ODBC via SQLAlchemy
Author: OpenLinkSoftware

@OpenLinkSoftware

リポジトリ

MCP Server ODBC via SQLAlchemy について

A simple MCP ODBC server using FastAPI, ODBC and SQLAlchemy.

#mcp #database #sqlalchemy

基本情報

カテゴリ

その他

ライセンス

MIT

ランタイム

python

トランスポート

stdio

公開者

OpenLinkSoftware

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "my_database": {
      "command": "uv",
      "args": [
        "--directory",
        "/path/to/mcp-sqlalchemy-server",
        "run",
        "mcp-sqlalchemy-server"
      ],
      "env": {
        "DB_URL": "virtuoso+pyodbc://user:password@VOS"
      }
    }
  }
}

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is MCP Server ODBC via SQLAlchemy?

A lightweight MCP (Model Context Protocol) server for ODBC built with FastAPI, pyodbc, and SQLAlchemy. It connects to any database with a SQLAlchemy provider, with special support for Virtuoso DBMS. Designed for AI agents and applications that need structured database access via ODBC.

How to use MCP Server ODBC via SQLAlchemy?

Clone the repository, install dependencies with uv, configure an ODBC DSN in ~/.odbc.ini, set environment variables (ODBC_DSN, ODBC_USER, ODBC_PASSWORD, API_KEY), and run mcp-sqlalchemy-server. For Claude Desktop, add the server to claude_desktop_config.json as shown in the README.

Key features of MCP Server ODBC via SQLAlchemy

List schema names from the connected database
Retrieve table information by schema or default
Describe table structure including columns, keys, and nullability
Search tables by name substring
Execute stored procedures (Virtuoso-specific)
Run SQL queries returning JSONL or Markdown table results

Use cases of MCP Server ODBC via SQLAlchemy

AI agents querying relational databases via natural language
Automated database schema exploration for data cataloging
Reporting workflows that need Markdown-formatted query results
Integrating Virtuoso-specific features like SPARQL and SPASQL queries
Rapid prototyping of database-backed MCP tools

FAQ from MCP Server ODBC via SQLAlchemy

What databases are supported?

Any DBMS with a SQLAlchemy provider, including Virtuoso, PostgreSQL, MySQL, and SQLite. Virtuoso-specific features like SPARQL and SPASQL queries are also available.