MCP ODBC SQLAlchemy Server

Example Use Cases

• 1

  Inspect database schemas and enumerate tables across ODBC-connected DBMS (including Virtuoso) for schema-aware reasoning.

• 2

  Run arbitrary SQL or SPARQL queries and retrieve results in JSONL or Markdown formats for downstream processing or reporting.

• 3

  Virtuoso-specific capabilities (SPASQL, stored procedures, or an AI support assistant) accessible via a simple MCP API.

Description

This server provides an MCP-compatible interface to databases via pyodbc and SQLAlchemy, enabling agents to list schemas and tables, describe table structures, and execute SQL, SPARQL, and Virtuoso-specific stored procedures. It returns results in structured formats (JSONL, JSON, and Markdown) and supports Virtuoso features like SPASQL and an AI support assistant. Configuration is via ODBC DSNs and environment variables, making it easy to run locally or integrate with tools like Claude Desktop.