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

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

Inbox Zero AI MCP

elie222

The world's best AI personal assistant for email. Open source app to help you reach inbox zero fast.

11.6K

Awesome-MCP-ZH

yzfly

MCP 资源精选， MCP指南，Claude MCP，MCP Servers, MCP Clients

7.4K

XcodeBuildMCP

cameroncooke

A Model Context Protocol (MCP) server and CLI that provides tools for agent use when working on iOS and macOS projects.

6.0K

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K