mcp-pyodbc-server

mcp-pyodbc-server

1
databases

The project is a lightweight Model Context Protocol server designed for ODBC interactions, offering extensive database management features using FastAPI and pyodbc. It supports various Virtuoso-specific operations, providing both JSONL and Markdown-formatted query results.

MCP Server ODBC via PyODBC

A lightweight MCP server for ODBC using FastAPI and pyodbc, compatible with Virtuoso DBMS and others.

Features

  • Fetch and list schema names.
  • Retrieve table information.
  • Describe table structures.
  • Search tables by name.
  • Execute stored procedures.
  • Execute queries with JSONL or Markdown format results.

Installation

Clone the repository and set up environment variables.

Tools Provided

  • podbc_get_schemas: List accessible schemas.
  • podbc_get_tables: List tables for schemas.
  • podbc_describe_table: Describe table details.
  • podbc_query_database: Execute SQL with JSONL results.
  • More Virtuoso-specific tools.