広告掲載
MCP.so
ログイン

MCP Server ODBC via SQLAlchemy

@OpenLinkSoftware

リポジトリ

基本情報

カテゴリ

その他

ライセンス

MIT

トランスポート

stdio

作者

OpenLinkSoftware

MCP Server ODBC via SQLAlchemy について

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

MCP Server ODBC via SQLAlchemy の設定

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

{
  "mcpServers": {
    "mcp-server-odbc": {
      "command": "npx",
      "args": [
        "@modelcontextprotocol/inspector",
        "uv",
        "--directory",
        "/path/to/mcp-sqlalchemy-server",
        "run",
        "mcp-sqlalchemy-server"
      ]
    }
  }
}

MCP Server ODBC via SQLAlchemy のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

上のボタンで一時的なサンドボックスでこのサーバーを実行し、ツール一覧を取得できます。

概要

What is MCP Server ODBC via SQLAlchemy?

A lightweight MCP server for ODBC databases built with FastAPI, pyodbc, and SQLAlchemy. It is compatible with Virtuoso DBMS and any DBMS that provides a SQLAlchemy driver (e.g., PostgreSQL, MySQL, SQLite). Designed for developers and AI assistants that need structured database access via the Model Context Protocol.

How to use MCP Server ODBC via SQLAlchemy?

Install the uv package manager, set up an ODBC Data Source Name (DSN), and configure environment variables (ODBC_DSN, ODBC_USER, ODBC_PASSWORD, API_KEY). Run the server with uv run mcp-sqlalchemy-server from the cloned repository. For Claude Desktop, add the server configuration to claude_desktop_config.json.

Key features of MCP Server ODBC via SQLAlchemy

  • Retrieve and list database schemas.
  • List tables for a specific schema or all schemas.
  • Describe table structure including columns, keys, and nullability.
  • Search tables by name substring.
  • Execute SQL queries with JSONL or Markdown output.
  • Execute stored procedures (Virtuoso‑specific).
  • Execute SPASQL and SPARQL queries (Virtuoso‑specific).
  • Interact with the Virtuoso Support Assistant AI.

Use cases of MCP Server ODBC via SQLAlchemy

  • Query a database and get results in a format suitable for AI analysis.
  • Explore database schema and table metadata without a separate client.
  • Generate Markdown reports from SQL queries.
  • Use Virtuoso‑specific features like SPARQL and AI assistant from MCP clients.

よくある質問

1

What databases are supported?

Compatible with any DBMS that has a SQLAlchemy provider, including Virtuoso, PostgreSQL, MySQL, and SQLite.

2

How do I authenticate with the server?

Authentication is handled via the `API_KEY` environment variable; no additional authentication mechanism is described.

3

What are the prerequisites?

You need `uv`, a working unixODBC installation with an ODBC DSN configured, and the corresponding SQLAlchemy/pyodbc driver.

4

Are there Virtuoso‑only features?

Yes: executing SPASQL and SPARQL queries, running stored procedures, and using the Virtuoso Support Assistant AI tool.

5

Which transport does the server use?

The README does not specify the transport protocol; it is configured as a standard MCP server for Claude Desktop (stdio).

コメント

「その他」の他のコンテンツ

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K
広告掲載