Advertise
MCP.so
Sign In

ODBC MCP Server

@tylerstoltz

Repository

Basic information

Category

Other

License

MIT

Transports

stdio

Author

tylerstoltz

About ODBC MCP Server

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

ODBC MCP Server config

Add this server to your MCP-compatible client using the configuration below.

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

ODBC MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

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.

Comments

More Other MCP servers

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K

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.

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

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

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Advertise