OpenLinkSoftware_mcp-odbc-server

OpenLinkSoftware_mcp-odbc-server

0
databases

This project sets up a generic ODBC server designed for the Model Context Protocol (MCP), enabling Large Language Models to access ODBC-compatible data sources. Built using TypeScript and node.js, it integrates with local ODBC Driver Managers and supports various database operations and queries.

Introduction

This document covers the setup and use of an ODBC server for the Model Context Protocol (MCP), known as the mcp-odbc server. It facilitates Large Language Models with access to ODBC-accessible data sources via a configured Data Source Name for a specific ODBC Connector.

Server Implementation

This MCP Server for ODBC is a TypeScript layer utilizing node-odbc, interfacing through the local ODBC Driver Manager via node.js.

Operating Environment Setup & Prerequisites

  • Check node.js version. If it's not 21.1.0, upgrade using nvm.
  • Install MCP components using NPM.

Tools

Following successful installation, tools available to MCP client applications include APIs for listing database schemas and tables, querying databases, and executing SQL and SPARQL queries.

MCP Application Usage

Configuration steps are provided for tools such as Claude Desktop, Cline (Visual Studio Extension), and Cursor Editor for registering and managing the MCP ODBC server.