Advertise
MCP.so
Sign In

MCP Server ODBC via PyODBC

@OpenLinkSoftware

Repository

Basic information

Category

Other

License

MIT

Transports

stdio

Author

OpenLinkSoftware

About MCP Server ODBC via PyODBC

A simple MCP ODBC server using FastAPI, ODBC and PyODBC.

MCP Server ODBC via PyODBC config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp-pyodbc-server": {
      "command": "npx",
      "args": [
        "@modelcontextprotocol/inspector",
        "uv",
        "--directory",
        "/path/to/mcp-pyodbc-server",
        "run",
        "mcp-pyodbc-server"
      ]
    }
  }
}

MCP Server ODBC via PyODBC tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

Overview

What is MCP Server ODBC via PyODBC?

It is a lightweight MCP (Model Context Protocol) server that provides ODBC database access via FastAPI and pyodbc. It is compatible with Virtuoso DBMS and any other DBMS that has an ODBC driver.

How to use MCP Server ODBC via PyODBC?

Install uv and configure an ODBC Data Source Name (DSN) in ~/.odbc.ini. Clone the repository, set environment variables (ODBC_DSN, ODBC_USER, ODBC_PASSWORD, API_KEY) in a .env file. For Claude Desktop, add the server to claude_desktop_config.json using the uv command. The server exposes tools such as podbc_get_schemas, podbc_get_tables, podbc_describe_table, podbc_filter_table_names, podbc_query_database, and Virtuoso‑specific tools.

Key features of MCP Server ODBC via PyODBC

  • List database schemas via podbc_get_schemas
  • Retrieve table names and metadata per schema
  • Describe table structure including columns, keys, and nullability
  • Search tables by name substring
  • Execute SQL queries returning JSONL or Markdown results
  • Support for Virtuoso‑specific SPASQL queries and AI assistant

Use cases of MCP Server ODBC via PyODBC

  • Discover available schemas and tables in any ODBC‑connected database
  • Inspect table definitions for data modeling or migration tasks
  • Execute SQL queries from MCP clients and receive structured results
  • Run SPASQL (SQL/SPARQL hybrid) queries against Virtuoso DBMS
  • Interact with Virtuoso’s AI Support Assistant via a dedicated tool

Frequently asked questions

1

What are the runtime dependencies?

`uv` (package installer), `pyodbc`, and `unixODBC` with a properly configured ODBC DSN. An `.env` file must set `ODBC_DSN`, `ODBC_USER`, `ODBC_PASSWORD`, and `API_KEY`.

2

Which databases are supported?

Any DBMS that provides an ODBC driver. Virtuoso is explicitly supported, and the server works with other ODBC‑compatible databases.

3

How is authentication handled?

Authentication is passed via environment variables (`ODBC_USER`, `ODBC_PASSWORD`) or per‑call optional parameters. An `API_KEY` is used for additional security and can be configured in the environment.

4

Where does the data live?

The data remains in the remote database system accessed through the ODBC connection. No data is stored locally by the server.

5

What transport protocol does the server use?

The server communicates over standard MCP via stdio. For debugging, the MCP Inspector can be used with `npx`.

Comments

More Other MCP servers

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

N

Next Generation Movers: free moving quotes (remote MCP)

Next Generation Movers

Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

Advertise