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.

常见问题

What databases are supported?

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

How do I authenticate with the server?

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

What are the prerequisites?

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

Are there Virtuoso‑only features?

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

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).

其他分类下的更多 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

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

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

Awesome Mlops

visenger

A curated list of references for MLOps

14.0K