MCP.so
登录

Introduction

@OpenLinkSoftware

关于 Introduction

Typescript based Model Context Procotol (MCP) Server for Open Database Connectivity (ODBC)

基本信息

分类

其他

许可证

MIT

运行时

node

传输方式

stdio

发布者

OpenLinkSoftware

配置

使用下面的配置,将此服务器添加到你的 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 服务器