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

コメント

「その他」の他のコンテンツ