ODBC MCP Server

MCPOpen SourceMIT20.3

by tylerstoltz • Data & Databases

A lightweight MCP server that exposes ODBC database connections to MCP clients (like Claude Desktop) for safe, read-only querying and analysis.

Example Use Cases

1
Connect to and query any ODBC-compatible database (including SQLite and Sage 100 ProvideX) via MCP without writing custom DB drivers.
2
Enumerate configured connections, available DSNs, database tables, and table schemas to build context-aware prompts or automated reports.
3
Execute read-only SQL queries from within Claude Desktop or other MCP clients while enforcing safety and connection-specific configuration.

Description

This server allows MCP-capable agents to connect to any ODBC-compatible database, list schemas/tables, and run read-only SQL queries. It supports multiple named connections, configurable settings via INI files, environment variables, or Claude Desktop configuration, and includes special handling notes for Sage 100 ProvideX. The server emphasizes safety with read-only safeguards and provides detailed error reporting and logging to aid debugging and integration.

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

D44/100

4/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities0 Tools / 0 Prompts / 0 Resources

Ownertylerstoltz

CategoryData & Databases

DependenciesStandalone