广告合作
MCP.so
登录

MCP Server ODBC via PyODBC

@MCP-Mirror

代码仓库

基本信息

分类

其他

许可证

MIT license

传输方式

stdio

作者

MCP-Mirror

关于 MCP Server ODBC via PyODBC

Mirror of

MCP Server ODBC via PyODBC 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "OpenLinkSoftware_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?

A lightweight MCP (Model Context Protocol) server built with FastAPI and pyodbc that enables AI agents to interact with ODBC-compatible databases. It is compatible with Virtuoso DBMS and other DBMS backends that have an ODBC driver.

How to use MCP Server ODBC via PyODBC?

Clone the repository, set environment variables (ODBC_DSN, ODBC_USER, ODBC_PASSWORD, API_KEY) in a .env file, and configure an MCP client like Claude Desktop by adding a claude_desktop_config.json entry with the command uv --directory /path/to/mcp-pyodbc-server run mcp-pyodbc-server and the required environment variables.

Key features of MCP Server ODBC via PyODBC

  • List all schema names from the connected database.
  • Retrieve table information for a specific schema.
  • Describe table columns, data types, keys, and nullability.
  • Filter tables by name substring.
  • Execute SQL queries returning results in JSONL or Markdown format.
  • Execute Virtuoso-specific SPASQL and SPARQL queries.

Use cases of MCP Server ODBC via PyODBC

  • Exploring database schemas and tables for data discovery.
  • Generating structured descriptions of table structures for AI agents.
  • Running ad-hoc SQL queries and receiving formatted results.
  • Integrating with Virtuoso DBMS for SPARQL/SPASQL queries.
  • Leveraging the Virtuoso AI Support Assistant for LLM interactions.

常见问题

1

What are the runtime dependencies?

Requires Python with `uv`, the `unixODBC` runtime, and an installed ODBC driver for the target database. An ODBC DSN must be configured in `~/.odbc.ini`.

2

How does the server authenticate?

Authentication is handled via an environment variable `API_KEY` set by the client (e.g., in `claude_desktop_config.json`).

3

Does it work with databases other than Virtuoso?

Yes. The core ODBC functions (get schemas, tables, describe table, execute queries) work with any database that has an ODBC driver. Virtuoso-specific tools (SPASQL/SPARQL, AI Assistant) only apply to Virtuoso.

4

Where does the data live?

The server does not store data; it connects to a remote database via ODBC using the configured DSN.

5

What transport does the server use?

The server runs as a subprocess managed by the MCP client (e.g., Claude Desktop) over stdio, as configured in `claude_desktop_config.json`.

评论

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

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

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

ICSS

chokcoco

不止于 CSS

20.7K

🚀 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

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K
广告合作