MCP Odbc MCP Server

An MCP (Model Context Protocol) server that enables LLM tools like Claude Desktop to query databases via ODBC connections. This server allows Claude

Local serverstdioPython

What is the MCP Odbc MCP Server?

An MCP (Model Context Protocol) server that enables LLM tools like Claude Desktop to query databases via ODBC connections. This server allows Claude and other MCP

The short version

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

What it needs from you

  • Python 3.10 or higher - UV package manager - ODBC drivers for your database(s) installed on your system - For Sage 100 Advanced: ProvideX ODBC driver

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

How to install the MCP Odbc MCP Server

{
  "mcpServers": {
    "odbc": {
      "command": "uv",
      "args": [
        "--directory",
        "C:\\path\\to\\mcp-odbc",
        "run",
        "odbc-mcp-server",
        "--config",
        "C:\\path\\to\\mcp-odbc\\config\\your_config.ini"
      ]
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

  • Python 3.10 or higher - UV package manager - ODBC drivers for your database(s) installed on your system - For Sage 100 Advanced: ProvideX ODBC driver

Frequently asked questions

An MCP (Model Context Protocol) server that enables LLM tools like Claude Desktop to query databases via ODBC connections. This server allows Claude and other MCP Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.