広告掲載
MCP.so
ログイン

ODBC MCP Server

@tylerstoltz

リポジトリ

基本情報

カテゴリ

その他

ライセンス

MIT

トランスポート

stdio

作者

tylerstoltz

ODBC MCP Server について

MCP server for connecting clients like Claude Desktop to ODBC data sources

ODBC MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "mcp-odbc": {
      "command": "uv",
      "args": [
        "venv"
      ]
    }
  }
}

ODBC MCP Server のツール

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

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

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is ODBC MCP Server?

ODBC MCP Server is an MCP (Model Context Protocol) server that enables LLM tools like Claude Desktop to query databases via ODBC connections. It allows Claude and other MCP clients to access, analyze, and generate insights from database data while maintaining security and read-only safeguards.

How to use ODBC MCP Server?

Install via git clone, create a Python virtual environment with UV, and run uv pip install -e .. Configure using a .ini config file or Claude Desktop settings, then start the server with odbc-mcp-server --config path/to/config.ini. Tools like list-tables and execute-query become available in the MCP client.

Key features of ODBC MCP Server

  • Connect to any ODBC-compatible database
  • Support for multiple database connections
  • Flexible configuration via config file or Claude Desktop settings
  • Read-only safeguards to prevent data modification
  • Easy installation with UV package manager
  • Detailed error reporting and logging

Use cases of ODBC MCP Server

  • Query databases directly from Claude Desktop conversations
  • Explore table schemas and database structures
  • Run ad‑hoc SQL queries for data analysis
  • Generate insights from sales or customer data
  • Troubleshoot database issues with guided prompts

よくある質問

1

What are the prerequisites for ODBC MCP Server?

Python 3.10 or higher, the UV package manager, and ODBC drivers for your database(s) installed on the system. For Sage 100 Advanced, the ProvideX ODBC driver is required.

2

How do I configure ODBC MCP Server?

Configuration can be done through a dedicated `.ini` config file, environment variables, or directly in the Claude Desktop `claude_desktop_config.json` file. The config file specifies DSN, credentials, connection timeout, and maximum rows returned.

3

Does ODBC MCP Server allow data modification?

No, the server enforces read-only safeguards by default (set `readonly = true` in the configuration). This prevents accidental or unauthorized writes to the database.

4

How do I resolve ProvideX (Sage 100) connection issues?

Use a minimal configuration with only DSN, username, password, and company parameters. Always set `readonly = true`. If you encounter "Driver not capable" errors, ensure autocommit is being set at connection time.

5

What should I do if tables are missing?

Verify the database user’s permissions, check that the company code is correct (for Sage 100), and try using fully qualified table names (schema.table) in queries.

コメント

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

Glasswarp

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

Hindsight

vectorize-io

Hindsight: Agent Memory That Learns

50.4K

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

MaxKB

1Panel-dev

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

22.0K

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
広告掲載