mcp-odbc-server
by OpenLinkSoftware
The mcp-odbc-server is a generic ODBC server for the Model Context Protocol (MCP). It provides Large Language Models with transparent access to ODBC-accessible data sources via a Data Source Name.
Last updated: N/A
What is mcp-odbc-server?
The mcp-odbc-server is a TypeScript layer built on top of node-odbc that acts as an MCP Server, routing calls to the host system's local ODBC Driver Manager via node.js. It enables LLMs to interact with various databases through ODBC connectors.
How to use mcp-odbc-server?
The server requires node.js, MCP components, and an ODBC Driver Manager. Installation involves cloning the repository, installing dependencies, and configuring environment variables for the ODBC Data Source Name (DSN), user, password, and ODBC INI file. The README provides detailed instructions for setting up the environment, installing the server, and configuring it for use with Claude Desktop, Cline (Visual Studio Extension), and Cursor.
Key features of mcp-odbc-server
Transparent access to ODBC-accessible data sources for LLMs
Supports various ODBC Connectors
Provides tools for schema and table exploration (get_schemas, get_tables, describe_table, filter_table_names)
Enables SQL and SPARQL query execution (query_database, execute_query, execute_query_md, spasql_query, sparql_query)
Includes a Virtuoso-specific feature for interacting with LLMs (virtuoso_support_ai)
Use cases of mcp-odbc-server
Enabling LLMs to query and analyze data from relational databases
Building AI-powered applications that leverage existing ODBC data sources
Integrating LLMs with Virtuoso databases using the Virtuoso Support Assistant/Agent
Providing a standardized interface for LLMs to access data across different database systems
FAQ from mcp-odbc-server
What is MCP?
What is MCP?
Model Context Protocol, a protocol for enabling LLMs to interact with external data sources and services.
What ODBC Connectors are supported?
What ODBC Connectors are supported?
While examples are oriented toward the Virtuoso ODBC Connector, this guide will also work with other ODBC Connectors.
What are the key prerequisites?
What are the key prerequisites?
node.js (version 21.1.0), MCP components, and a configured ODBC Driver Manager.
How do I configure the server for Claude Desktop?
How do I configure the server for Claude Desktop?
Configuration involves modifying the claude_desktop_config.json file with the correct paths and environment variables.
How do I test the installation?
How do I test the installation?
Start the inspector from the mcp-server directory and click on the "Connect" button, then click on the "Tools" tab to get started.