MCP Server ODBC via SQLAlchemy

Name: MCP Server ODBC via SQLAlchemy
Author: OpenLinkSoftware

@OpenLinkSoftware

代码仓库

关于 MCP Server ODBC via SQLAlchemy

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

#mcp #database #sqlalchemy

基本信息

分类

其他

许可证

MIT

运行时

python

传输方式

stdio

发布者

OpenLinkSoftware

配置

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

{
  "mcpServers": {
    "my_database": {
      "command": "uv",
      "args": [
        "--directory",
        "/path/to/mcp-sqlalchemy-server",
        "run",
        "mcp-sqlalchemy-server"
      ],
      "env": {
        "DB_URL": "virtuoso+pyodbc://user:password@VOS"
      }
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MCP Server ODBC via SQLAlchemy?

A lightweight MCP (Model Context Protocol) server for ODBC built with FastAPI, pyodbc, and SQLAlchemy. It connects to any database with a SQLAlchemy provider, with special support for Virtuoso DBMS. Designed for AI agents and applications that need structured database access via ODBC.

How to use MCP Server ODBC via SQLAlchemy?

Clone the repository, install dependencies with uv, configure an ODBC DSN in ~/.odbc.ini, set environment variables (ODBC_DSN, ODBC_USER, ODBC_PASSWORD, API_KEY), and run mcp-sqlalchemy-server. For Claude Desktop, add the server to claude_desktop_config.json as shown in the README.

Key features of MCP Server ODBC via SQLAlchemy

List schema names from the connected database
Retrieve table information by schema or default
Describe table structure including columns, keys, and nullability
Search tables by name substring
Execute stored procedures (Virtuoso-specific)
Run SQL queries returning JSONL or Markdown table results

Use cases of MCP Server ODBC via SQLAlchemy

AI agents querying relational databases via natural language
Automated database schema exploration for data cataloging
Reporting workflows that need Markdown-formatted query results
Integrating Virtuoso-specific features like SPARQL and SPASQL queries
Rapid prototyping of database-backed MCP tools

FAQ from MCP Server ODBC via SQLAlchemy

What databases are supported?

Any DBMS with a SQLAlchemy provider, including Virtuoso, PostgreSQL, MySQL, and SQLite. Virtuoso-specific features like SPARQL and SPASQL queries are also available.

What are the runtime requirements?

Python 3, uv package manager, unixODBC with a configured DSN, and an ODBC driver for your target database.

How do I configure authentication?

Set ODBC_USER, ODBC_PASSWORD, and API_KEY environment variables. The API key is used for server-side authentication.

Can I query using formats other than JSON?

Yes. The server provides tools for JSON, JSON Lines (JSONL), and Markdown table output.

Does this server support stored procedures?

For Virtuoso, you can execute stored procedures. For other databases, you can run arbitrary SQL queries.

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

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