MCP Server ODBC via SQLAlchemy

@OpenLinkSoftware

Basic information

About MCP Server ODBC via SQLAlchemy

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

MCP Server ODBC via SQLAlchemy config

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

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

MCP Server ODBC via SQLAlchemy 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 SQLAlchemy?

A lightweight MCP server for ODBC databases built with FastAPI, pyodbc, and SQLAlchemy. It is compatible with Virtuoso DBMS and any DBMS that provides a SQLAlchemy driver (e.g., PostgreSQL, MySQL, SQLite). Designed for developers and AI assistants that need structured database access via the Model Context Protocol.

How to use MCP Server ODBC via SQLAlchemy?

Install the uv package manager, set up an ODBC Data Source Name (DSN), and configure environment variables (ODBC_DSN, ODBC_USER, ODBC_PASSWORD, API_KEY). Run the server with uv run mcp-sqlalchemy-server from the cloned repository. For Claude Desktop, add the server configuration to claude_desktop_config.json.

Key features of MCP Server ODBC via SQLAlchemy

Retrieve and list database schemas.
List tables for a specific schema or all schemas.
Describe table structure including columns, keys, and nullability.
Search tables by name substring.
Execute SQL queries with JSONL or Markdown output.
Execute stored procedures (Virtuoso‑specific).
Execute SPASQL and SPARQL queries (Virtuoso‑specific).
Interact with the Virtuoso Support Assistant AI.

Use cases of MCP Server ODBC via SQLAlchemy

Query a database and get results in a format suitable for AI analysis.
Explore database schema and table metadata without a separate client.
Generate Markdown reports from SQL queries.
Use Virtuoso‑specific features like SPARQL and AI assistant from MCP clients.

Frequently asked questions

What databases are supported?

Compatible with any DBMS that has a SQLAlchemy provider, including Virtuoso, PostgreSQL, MySQL, and SQLite.

How do I authenticate with the server?

Authentication is handled via the `API_KEY` environment variable; no additional authentication mechanism is described.

What are the prerequisites?

You need `uv`, a working unixODBC installation with an ODBC DSN configured, and the corresponding SQLAlchemy/pyodbc driver.

Are there Virtuoso‑only features?

Yes: executing SPASQL and SPARQL queries, running stored procedures, and using the Virtuoso Support Assistant AI tool.

Which transport does the server use?

The README does not specify the transport protocol; it is configured as a standard MCP server for Claude Desktop (stdio).

Comments

More Other MCP servers

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

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K

Awesome Mlops

visenger

A curated list of references for MLOps

14.0K

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K