ODBC MCP Server
About
MCP server for connecting clients like Claude Desktop to ODBC data sources
Details
- License
- MIT
Explore
- 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
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
ODBC MCP ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
- 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
Create a configuration file (.ini) with your database connection details:
[SERVER]
default_connection = my_database
max_rows = 1000
timeout = 30
[my_database]
dsn = MyDatabaseDSN
username = your_username
password = your_password
readonly = true
For SQLite databases with ODBC:
[SERVER]
default_connection = sqlite_db
max_rows = 1000
timeout = 30
[sqlite_db]
dsn = SQLite_DSN_Name
readonly = true
ProvideX requires special configuration for compatibility. Use this minimal configuration for best results:
[SERVER]
default_connection = sage100
max_rows = 1000
timeout = 60
[sage100]
dsn = YOUR_PROVIDEX_DSN
username = your_username
password = your_password
company = YOUR_COMPANY_CODE
readonly = true
Important notes for ProvideX:
- Use a minimal configuration - adding extra parameters may cause connection issues
- Always set readonly = true for safety
- The company parameter is required for Sage 100 connections
- Avoid changing connection attributes after connection is established
odbc-mcp-server
odbc-mcp-server --config path/to/config.ini
```
The ODBC MCP server provides these tools:
1. list-connections: Lists all configured database connections
2. list-available-dsns: Lists all available DSNs on the system
3. test-connection: Tests a database connection and returns information
4. list-tables: Lists all tables in the database
5. get-table-schema: Gets schema information for a table
6. execute-query: Executes an SQL query and returns results
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"odbc mcp server": {
"mcp-odbc": {
"command": "uv",
"args": [
"venv"
]
}
}
}
}McpServers
{
"mcp-odbc": {
"command": "uv",
"args": [
"venv"
]
}
}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 clients to access, analyze, and generate insights from database data while maintaining security and read-only safeguards.
Features
- 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
Prerequisites
- 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
Installation
git clone https://github.com/tylerstoltz/mcp-odbc.git
cd mcp-odbc
uv venv
.venv\Scripts\activate # On Mac / Linux: source .venv/bin/activate (untested)
uv pip install -e .
Configuration
The server can be configured through:
1. A dedicated config file
2. Environment variables
3. Claude Desktop configuration
General Configuration Setup
Create a configuration file (.ini) with your database connection details:
[SERVER]
default_connection = my_database
max_rows = 1000
timeout = 30
[my_database]
dsn = MyDatabaseDSN
username = your_username
password = your_password
readonly = true
SQLite Configuration
For SQLite databases with ODBC:
[SERVER]
default_connection = sqlite_db
max_rows = 1000
timeout = 30
[sqlite_db]
dsn = SQLite_DSN_Name
readonly = true
Sage 100 ProvideX Configuration
ProvideX requires special configuration for compatibility. Use this minimal configuration for best results:
[SERVER]
default_connection = sage100
max_rows = 1000
timeout = 60
[sage100]
dsn = YOUR_PROVIDEX_DSN
username = your_username
password = your_password
company = YOUR_COMPANY_CODE
readonly = true
Important notes for ProvideX:
- Use a minimal configuration - adding extra parameters may cause connection issues
- Always set readonly = true for safety
- The company parameter is required for Sage 100 connections
- Avoid changing connection attributes after connection is established
Claude Desktop Integration
To configure the server in Claude Desktop:
1. Open or create claude_desktop_config.json:
- Windows: %APPDATA%\Claude\claude_desktop_config.json
- macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
2. Add MCP server configuration:
{
"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"
]
}
}
}
Usage
Starting the Server Manually
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
