OpenLinkSoftware_mcp-pyodbc-server
If you are the rightful owner of OpenLinkSoftware_mcp-pyodbc-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A lightweight MCP server for ODBC built with FastAPI and pyodbc, compatible with Virtuoso DBMS and other DBMS backends with ODBC drivers.
The MCP Server ODBC via PyODBC is a lightweight server designed to facilitate database interactions using the Model Context Protocol (MCP). Built with FastAPI and pyodbc, it supports various database management systems (DBMS) that have ODBC drivers, including Virtuoso. The server provides a range of functionalities such as fetching schemas, retrieving table information, describing table structures, executing stored procedures, and running SQL queries with results in JSONL or Markdown formats. It is particularly useful for applications requiring structured data retrieval and manipulation, offering a robust interface for database operations.
Features
- Get Schemas: Fetch and list all schema names from the connected database.
- Get Tables: Retrieve table information for specific schemas or all schemas.
- Describe Table: Generate a detailed description of table structures, including column names, data types, nullable attributes, and keys.
- Search Tables: Filter and retrieve tables based on name substrings.
- Execute Queries: Execute SQL queries with results in JSONL or Markdown formats.
Tools
podbc_get_schema
List all schema names that can be accessed by the database management system
podbc_get_table
List the tables associated with the selected database schema
podbc_describe_tabl
Provides a description of the table associated with the specified database schema
podbc_filter_table_name
List tables associated with selected database schema based on substring schema
podbc_query_databas
Format returns result
podbc_execute_quer
Format returns result
podbc_execute_query_m
Table format returns results
podbc_spasql_quer
Query and return the result
podbc_sparql_quer
Query and return the result
podbc_virtuoso_support_a
Support assistant/agent interaction
