Introduction
@OpenLinkSoftware
关于 Introduction
Typescript based Model Context Procotol (MCP) Server for Open Database Connectivity (ODBC)
基本信息
配置
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"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": []
}
}
}工具
未检测到工具
工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。
概览
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
其他 分类下的更多 MCP 服务器
Maestro
mobile-dev-incPainless E2E Automation for Mobile and Web
Mcp
browsermcpBrowser MCP is a Model Context Provider (MCP) server that allows AI applications to control your browser
ghidraMCP
LaurieWiredMCP Server for Ghidra
XcodeBuildMCP
cameroncookeA Model Context Protocol (MCP) server and CLI that provides tools for agent use when working on iOS and macOS projects.
Inbox Zero AI MCP
elie222The world's best AI personal assistant for email. Open source app to help you reach inbox zero fast.
评论