mcp-odbc-serverTypescript based Model Context Procotol (MCP) Server for Open Database Connectivity (ODBC)

The mcp-odbc-server is a TypeScript-based Model Context Protocol (MCP) server that provides Large Language Models with transparent access to ODBC-accessible data sources. It acts as a bridge between the MCP clients and the host system's local ODBC Driver Manager, routing calls via node.js. The server is built on top of node-odbc and supports various ODBC Connectors, with examples primarily oriented toward the Virtuoso ODBC Connector. The server offers several tools for MCP client applications, including functions to list database schemas, tables, and table descriptions, as well as executing SQL queries, SPASQL queries, and SPARQL queries. It returns results in various formats such as JSON Lines (JSONL) and Markdown table format. To set up the server, users need to install node.js version 21.1.0 or higher, followed by MCP components using npm. The server's configuration is managed through environment variables set in a .env file, which includes bindings for the ODBC Data Source Name, User, Password, ODBC INI, and Large Language Model API Key. The mcp-odbc-server is designed to work with different database management systems (DBMS), and the project encourages code contributions and usage demos related to other DBMS for incorporation into the project. The key features of the server include its ability to interact with ODBC-accessible data sources, support for various query types, and its extensibility to work with different ODBC Connectors and DBMS.