広告掲載
MCP.so
ログイン

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#database#sqlalchemy

MCP Server ODBC via SQLAlchemy の設定

以下の設定を使って、このサーバーを 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"
      }
    }
  }
}

MCP Server ODBC via SQLAlchemy のツール

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

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

ツールは 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

よくある質問

1

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.

2

What are the runtime requirements?

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

3

How do I configure authentication?

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

4

Can I query using formats other than JSON?

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

5

Does this server support stored procedures?

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

コメント

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

MCP Toolbox for Databases

googleapis

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

15.9K

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

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

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

FastMCP v2 🚀

jlowin

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

26.0K
広告掲載