広告掲載
MCP.so
ログイン

MCP Server ODBC via PyODBC

@OpenLinkSoftware

リポジトリ

基本情報

カテゴリ

その他

ライセンス

MIT

トランスポート

stdio

作者

OpenLinkSoftware

MCP Server ODBC via PyODBC について

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

MCP Server ODBC via PyODBC の設定

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

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

MCP Server ODBC via PyODBC のツール

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

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

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

概要

What is MCP Server ODBC via PyODBC?

It is a lightweight MCP (Model Context Protocol) server that provides ODBC database access via FastAPI and pyodbc. It is compatible with Virtuoso DBMS and any other DBMS that has an ODBC driver.

How to use MCP Server ODBC via PyODBC?

Install uv and configure an ODBC Data Source Name (DSN) in ~/.odbc.ini. Clone the repository, set environment variables (ODBC_DSN, ODBC_USER, ODBC_PASSWORD, API_KEY) in a .env file. For Claude Desktop, add the server to claude_desktop_config.json using the uv command. The server exposes tools such as podbc_get_schemas, podbc_get_tables, podbc_describe_table, podbc_filter_table_names, podbc_query_database, and Virtuoso‑specific tools.

Key features of MCP Server ODBC via PyODBC

  • List database schemas via podbc_get_schemas
  • Retrieve table names and metadata per schema
  • Describe table structure including columns, keys, and nullability
  • Search tables by name substring
  • Execute SQL queries returning JSONL or Markdown results
  • Support for Virtuoso‑specific SPASQL queries and AI assistant

Use cases of MCP Server ODBC via PyODBC

  • Discover available schemas and tables in any ODBC‑connected database
  • Inspect table definitions for data modeling or migration tasks
  • Execute SQL queries from MCP clients and receive structured results
  • Run SPASQL (SQL/SPARQL hybrid) queries against Virtuoso DBMS
  • Interact with Virtuoso’s AI Support Assistant via a dedicated tool

よくある質問

1

What are the runtime dependencies?

`uv` (package installer), `pyodbc`, and `unixODBC` with a properly configured ODBC DSN. An `.env` file must set `ODBC_DSN`, `ODBC_USER`, `ODBC_PASSWORD`, and `API_KEY`.

2

Which databases are supported?

Any DBMS that provides an ODBC driver. Virtuoso is explicitly supported, and the server works with other ODBC‑compatible databases.

3

How is authentication handled?

Authentication is passed via environment variables (`ODBC_USER`, `ODBC_PASSWORD`) or per‑call optional parameters. An `API_KEY` is used for additional security and can be configured in the environment.

4

Where does the data live?

The data remains in the remote database system accessed through the ODBC connection. No data is stored locally by the server.

5

What transport protocol does the server use?

The server communicates over standard MCP via stdio. For debugging, the MCP Inspector can be used with `npx`.

コメント

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

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

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

Yuppsy

Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K
広告掲載