Introduction
@OpenLinkSoftware
About Introduction
Typescript based Model Context Procotol (MCP) Server for Open Database Connectivity (ODBC)
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"ODBC": {
"command": "/Users/kidehen/.nvm/versions/node/v21.1.0/bin/node",
"args": [
"/Users/kidehen/Documents/Management/Development/modelcontextprotocol/mcp-odbc-server/node_modules/.bin/tsx",
"/Users/kidehen/Documents/Management/Development/modelcontextprotocol/mcp-odbc-server/main.ts"
],
"env": {
"ODBCINI": "/Library/ODBC/odbc.ini",
"NODE_VERSION": "v21.1.0",
"PATH": "/Users/kidehen/.nvm/versions/node/v21.1.0/bin:${PATH}"
},
"disabled": false,
"autoApprove": []
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is Introduction?
Introduction is a generic ODBC server for the Model Context Protocol (MCP) that provides Large Language Models with transparent access to ODBC-accessible data sources via a Data Source Name (DSN) configured for a specific ODBC Connector. It is built as a small TypeScript layer on top of node-odbc and routes calls to the host system's local ODBC Driver Manager.
How to use Introduction?
Install Node.js v21.1.0 or higher, clone the repository, and run npm install to install dependencies (@modelcontextprotocol/sdk, zod, tsx, odbc, dotenv). Set environment variables (ODBC_DSN, ODBC_USER, ODBC_PASSWORD, ODBCINI, optionally API_KEY) in a .env file. Use the MCP Inspector tool or an MCP client to connect and invoke tools such as query_database, get_schemas, or sparql_query.
Key features of Introduction
- Provides generic ODBC data access for LLMs via MCP.
- Supports SQL, SPASQL, and SPARQL queries.
- Offers schema and table inspection tools.
- Includes a Virtuoso-specific AI assistant tool.
- Returns query results in JSON, JSONL, or Markdown format.
Use cases of Introduction
- Enabling LLMs to query relational databases through ODBC.
- Database schema exploration for AI-driven data analysis.
- Querying Virtuoso-specific SPARQL endpoints via ODBC.
- Integrating LLM assistants with database content.
- Running SQL queries and returning results in structured formats.
FAQ from Introduction
What Node.js version is required?
Node.js v21.1.0 or higher is required.
What dependencies are needed?
The server requires @modelcontextprotocol/sdk, zod, tsx, odbc, and dotenv npm packages.
How do I configure the ODBC connection?
Set ODBC_DSN, ODBC_USER, ODBC_PASSWORD, and optionally ODBCINI and API_KEY in a
Frequently asked questions
What Node.js version is required?
Node.js v21.1.0 or higher is required.
What dependencies are needed?
The server requires `@modelcontextprotocol/sdk`, `zod`, `tsx`, `odbc`, and `dotenv` npm packages.
How do I configure the ODBC connection?
Set `ODBC_DSN`, `ODBC_USER`, `ODBC_PASSWORD`, and optionally `ODBCINI` and `API_KEY` in a
Basic information
More Other MCP servers
๐ช Windows-MCP
CursorTouchMCP Server for Computer Use in Windows
Website
FunnyWolfAdversary simulation and Red teaming platform with AI
XcodeBuildMCP
cameroncookeA Model Context Protocol (MCP) server and CLI that provides tools for agent use when working on iOS and macOS projects.
FastMCP v2 ๐
jlowin๐ The fast, Pythonic way to build MCP servers and clients.
ghidraMCP
LaurieWiredMCP Server for Ghidra
Comments