MCP.so
Sign In

Introduction

@OpenLinkSoftware

Repository

About Introduction

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

#odbc#data-access#mcp-server

Basic information

Category

Other

License

MIT

Runtime

node

Transports

stdio

Publisher

OpenLinkSoftware

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

Comments

More Other MCP servers

Nginx UI

0xJacky

Yet another WebUI for Nginx

11.3K

MCP Go 🚀

mark3labs

A Go implementation of the Model Context Protocol (MCP), enabling seamless integration between LLM applications and external data sources and tools.

8.9K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K