Provides specialized support for Sage 100 Advanced via the ProvideX ODBC driver, with company code selection and Sage-specific configuration options
Allows querying SQLite databases via ODBC connections, with support for listing tables, retrieving schema information, and executing read-only SQL queries
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 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
Configuration
The server can be configured through:
A dedicated config file
Environment variables
Claude Desktop configuration
General Configuration Setup
Create a configuration file (.ini
) with your database connection details:
SQLite Configuration
For SQLite databases with ODBC:
Sage 100 ProvideX Configuration
ProvideX requires special configuration for compatibility. Use this minimal configuration for best results:
Important notes for ProvideX:
Use a minimal configuration - adding extra parameters may cause connection issues
Always set
readonly = true
for safetyThe
company
parameter is required for Sage 100 connectionsAvoid changing connection attributes after connection is established
Claude Desktop Integration
To configure the server in Claude Desktop:
Open or create
claude_desktop_config.json
:Windows:
%APPDATA%\Claude\claude_desktop_config.json
macOS:
~/Library/Application Support/Claude/claude_desktop_config.json
Add MCP server configuration:
Usage
Starting the Server Manually
Using with Claude Desktop
Configure the server in Claude Desktop's config file as shown above
Restart Claude Desktop
The ODBC tools will automatically appear in the MCP tools list
Available MCP Tools
The ODBC MCP server provides these tools:
list-connections: Lists all configured database connections
list-available-dsns: Lists all available DSNs on the system
test-connection: Tests a database connection and returns information
list-tables: Lists all tables in the database
get-table-schema: Gets schema information for a table
execute-query: Executes an SQL query and returns results
Example Queries
Try these prompts in Claude Desktop after connecting the server:
"Show me all the tables in the database"
"What's the schema of the Customer table?"
"Run a query to get the first 10 customers"
"Find all orders placed in the last 30 days"
"Analyze the sales data by region and provide insights"
Troubleshooting
Connection Issues
If you encounter connection problems:
Verify your ODBC drivers are installed correctly
Test your DSN using the ODBC Data Source Administrator
Check connection parameters in your config file
Look for detailed error messages in Claude Desktop logs
ProvideX-Specific Issues
For Sage 100/ProvideX:
Use minimal connection configuration (DSN, username, password, company)
Make sure the Company parameter is correct
Use the special ProvideX configuration template
If you encounter
Driver not capable
errors, check that autocommit is being set at connection time
Missing Tables
If tables aren't showing up:
Verify user permissions for the database account
Check if the company code is correct (for Sage 100)
Try using fully qualified table names (schema.table)
License
MIT License - Copyright (c) 2024
This server cannot be installed
local-only server
The server can only run on the client's local machine because it depends on local resources.
Enables LLM tools like Claude Desktop to query databases via ODBC connections, allowing access, analysis, and insight generation from database data while maintaining security through read-only safeguards.
Related MCP Servers
- -securityAlicense-qualityConnects Claude Desktop directly to databases, allowing it to explore database structures, write SQL queries, analyze datasets, and create reports through an API layer with tools for table exploration and query execution.Last updated -336Mozilla Public License 2.0
- -securityFlicense-qualityA server that enables interaction with PostgreSQL, MySQL, MariaDB, or SQLite databases through Claude Desktop using natural language queries.Last updated -
- -securityFlicense-qualityProvides Claude Desktop with secure access to multiple database connections, allowing users to query MySQL, PostgreSQL, SQLite, and SQL Server databases directly through natural language.Last updated -
- -securityAlicense-qualityProvides Claude with direct access to databases including SQLite, SQL Server, PostgreSQL, and MySQL, enabling execution of SQL queries and table management through natural language.Last updated -3,2211MIT License