广告合作
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`.

评论

其他 分类下的更多 MCP 服务器

N

Next Generation Movers: free moving quotes (remote MCP)

Next Generation Movers

Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

FastMCP v2 🚀

jlowin

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

26.0K

The Living Bread

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

广告合作