ODBC MCP Server

ODBC MCP Server is an MCP server that enables LLM tools to connect to and query databases via Open Database Connectivity interfaces. Built for data analysts, software engineers, and system administrators, it bridges language models such as Claude Desktop to any database supporting standard ODBC drivers, including SQLite and enterprise systems like Sage 100 ProvideX. The server exposes tools for discovering existing data source names, testing connections, reading schemas, and running read-only SQL queries directly from a chat interface. It enforces safeguards such as strict read-only execution modes, row limits, and configurable request timeouts to prevent unintentional modifications to underlying data stores. By centralizing multi-database configurations through INI files or desktop client settings, the server allows users to inspect legacy database schemas, explore transactional records, and extract operational insights using plain-language queries without writing external data extraction scripts or switching between standalone database management tools.

Category: Databases & Data Stores

Tags: connectivity, database, odbc, SQL

Visit ODBC MCP Server

How to install and configure ODBC MCP Server

1. Clone the repository and install dependencies using the UV package manager: bash git clone https://github.com/tylerstoltz/mcp-odbc.git cd mcp-odbc uv venv uv pip install -e . 2. Create an INI configuration file specifying your database connection details, timeout, row limits, and credentials. 3. Add the server configuration to your claude_desktop_config.json file: json { "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" ] } } } 4. Restart Claude Desktop to load the ODBC tools.

What you can do with ODBC MCP Server

• Discovering local system DSNs and configured database connections across multiple corporate platforms through natural language prompts. - Inspecting relational table lists and schema definitions in legacy systems like Sage 100 without running desktop management tools. - Executing read-only analytical SQL queries on live SQLite or enterprise databases to retrieve filtered operational reports. - Troubleshooting database connectivity parameters and verifying driver configurations directly within Claude Desktop conversational workflows.

Key facts

• https://github.com/tylerstoltz/mcp-odbc
• Databases & Data Stores, Developer Tools & Code Intelligence
• connectivity, database, odbc, SQL

Part of MCP Servers

How do I install ODBC MCP Server?

You install ODBC MCP Server by cloning its repository from GitHub and using the UV package manager to initialize a virtual environment and execute editable installation. You must ensure Python 3.10 or higher and your required ODBC database drivers are installed on your host system.

What can ODBC MCP Server do?

ODBC MCP Server provides tools to list available DSNs, inspect configured connections, test database connectivity, list tables, view table schemas, and execute read-only SQL queries against any ODBC-compliant database system.

Which MCP clients work with ODBC MCP Server?

ODBC MCP Server works with any standard Model Context Protocol client, including Claude Desktop, by specifying the executable command and configuration file arguments in the client configuration JSON.

Is ODBC MCP Server open source?

Yes, ODBC MCP Server is open source and distributed under the MIT License on GitHub.