OpenLink ODBC MCP Server

Example Use Cases

• 1

  Discover and enumerate database schemas and tables from an ODBC data source to build contextual database-aware prompts.

• 2

  Run arbitrary SQL or SPASQL queries (including stored procedures) and retrieve results in JSONL or Markdown for downstream processing or presentation.

• 3

  Inspect table structures (columns, types, nullability, primary/foreign keys) to generate safe, schema-aware queries or migrations.

Description

This project implements an MCP (Model Context Protocol) server that lets agents interact with ODBC-backed databases via a set of tools for listing schemas, inspecting tables, describing table schemas, searching table names, executing SQL/SPASQL queries, and calling stored procedures. It is built with FastAPI and pyodbc and includes Virtuoso-specific helpers (e.g., SPASQL and AI support assistant) while remaining compatible with other ODBC drivers. The server returns results in JSON/JSONL or Markdown table formats to suit integrations with LLM agents and other clients. It simplifies connecting agents to relational and Virtuoso backends for exploration, reporting, and automated query execution.