Related MCP Server Resources

Explore more AI models, providers, and integration options:

  • Explore AI Models
  • Explore AI Providers
  • Explore MCP Servers
  • LangDB Pricing
  • Documentation
  • AI Industry Blog
  • AGE-MCP-Server
  • mcp-server-asana
  • Ollama MCP Server
  • Gmail Plugin MCP Server
  • Xano MCP Server for Smithery
Back to MCP Servers
ODBC MCP Server

ODBC MCP Server

Public
tylerstoltz/mcp-odbc

Enables LLM tools to securely query and analyze data from any ODBC-compatible database via Model Context Protocol with read-only safeguards, multi-connection support, and seamless integration.

python
0 tools
May 29, 2025
Updated Jun 4, 2025

Supercharge Your AI with ODBC MCP Server

MCP Server

Unlock the full potential of ODBC MCP Server through LangDB's AI Gateway. Get enterprise-grade security, analytics, and seamless integration with zero configuration.

Unified API Access
Complete Tracing
Instant Setup
Get Started Now

Free tier available • No credit card required

Instant Setup
99.9% Uptime
10,000+Monthly Requests

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

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

# Start with default configuration odbc-mcp-server # Start with a specific config file odbc-mcp-server --config path/to/config.ini

Using with Claude Desktop

  1. Configure the server in Claude Desktop's config file as shown above
  2. Restart Claude Desktop
  3. The ODBC tools will automatically appear in the MCP tools list

Available MCP Tools

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

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:

  1. Verify your ODBC drivers are installed correctly
  2. Test your DSN using the ODBC Data Source Administrator
  3. Check connection parameters in your config file
  4. Look for detailed error messages in Claude Desktop logs

ProvideX-Specific Issues

For Sage 100/ProvideX:

  1. Use minimal connection configuration (DSN, username, password, company)
  2. Make sure the Company parameter is correct
  3. Use the special ProvideX configuration template
  4. If you encounter Driver not capable errors, check that autocommit is being set at connection time

Missing Tables

If tables aren't showing up:

  1. Verify user permissions for the database account
  2. Check if the company code is correct (for Sage 100)
  3. Try using fully qualified table names (schema.table)

License

MIT License - Copyright (c) 2024

Publicly Shared Threads0

Discover shared experiences

Shared threads will appear here, showcasing real-world applications and insights from the community. Check back soon for updates!

Share your threads to help others
Related MCPs5
  • AGE-MCP-Server
    AGE-MCP-Server

    Enables integration of Apache AGE graph database capabilities with Azure Database for PostgreSQL thr...

    Added May 30, 2025
  • mcp-server-asana
    mcp-server-asana

    Enables seamless interaction with Asana API via Model Context Protocol, providing advanced task, pro...

    22 tools
    Added May 30, 2025
  • Ollama MCP Server
    Ollama MCP Server

    Enables seamless integration of local Ollama LLM models with MCP-compatible applications, offering m...

    Added May 30, 2025
  • Gmail Plugin MCP Server
    Gmail Plugin MCP Server

    Enables seamless Gmail integration via Model Context Protocol, allowing MCP clients to securely send...

    Added May 30, 2025
  • Xano MCP Server for Smithery
    Xano MCP Server for Smithery

    Model Context Protocol server enabling seamless integration between Claude AI and Xano databases wit...

    Added May 30, 2025