PyODBC Server
CreatedOpenLinkSoftware
Expose database functionalities through a lightweight Model Context Protocol (MCP) server using FastAPI and pyodbc.
About
The PyODBC Server provides a lightweight MCP (Model Context Protocol) interface for ODBC-compliant databases, leveraging FastAPI and pyodbc. It enables interaction with databases like Virtuoso through a standardized protocol, facilitating tasks such as retrieving schemas and tables, describing table structures, executing queries (in JSONL or Markdown formats), and running stored procedures. It is specifically designed for use with MCP client applications and can be integrated with tools like Claude Desktop.
Key Features
- Filters tables based on name substrings
- 0 GitHub stars
- Supports JSONL and Markdown table result formats
- Executes SQL queries and stored procedures
- Fetches database schemas and tables
- Describes table structures with column details and key information
Use Cases
- Providing a standardized interface for various ODBC-compliant databases
- Integrating database interactions with MCP-compatible applications
- Enabling LLMs to query and understand database structure and content
