Labsco
MCP SERVER

ODBC MCP Server

by tylerstoltz ↗

Read-only SQL over any ODBC data source, with Sage 100 through the ProvideX driver called out specifically.

Relational SQL Databases
Summary
Reach the database the ERP is sitting on.

ODBC is often the only way into an older system, and the ProvideX configuration that actually connects to Sage 100 is written down here. Everything runs behind a readonly flag.

What it is

An MCP server that queries databases over ODBC. Connections are declared in an .ini file with a row limit, a timeout and a readonly flag, so an assistant can read a system without being able to change it.

What you get
  • Any ODBC-compatible database queried through its DSN
  • Several named connections configured side by side
  • The DSNs available on the machine listed
  • A connection tested before you rely on it
  • Tables listed and a table's schema read
  • Read-only safeguards that block modification
  • Sage 100 Advanced through the ProvideX driver, with the company code it needs
Requirements

Python 3.10 or higher, the UV package manager, and ODBC drivers for your databases installed on the machine. Connections live in an .ini file that sets dsn, credentials, max_rows, timeout and readonly.