mcp-pyodbc-server
If you are the rightful owner of 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 provides a seamless interface for connecting to databases like Virtuoso DBMS and others that support ODBC drivers. The server offers a range of functionalities, including schema and table retrieval, table description, and query execution. It supports various output formats, such as JSONL and Markdown, making it suitable for structured data handling and reporting. The server is easy to set up and configure, requiring minimal prerequisites like the installation of uv and unixODBC runtime environment checks. It also supports integration with platforms like Claude Desktop, allowing users to manage database connections and execute commands efficiently. With its robust feature set, the MCP Server ODBC via PyODBC is an ideal solution for developers and data analysts looking to streamline their 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, primary and foreign keys.
- Search Tables: Filter and retrieve tables based on name substrings.
- Execute Queries: Execute SQL queries with results in JSONL or Markdown table format.
Tools
podbc_get_schemas
List all schema names in the database
podbc_get_tables
List table information in a specific schema
podbc_describe_table
Describe the structure of the table
podbc_filter_table_names
Filter tables by name substring
podbc_query_database
Execute SQL query and return JSON format results
podbc_execute_query_md
Execute SQL query and return Markdown table format results
podbc_spasql_query
Execute SPASQL query (specific to Virtuoso)
podbc_sparql_query
Execute SPARQL query (specific to Virtuoso)
podbc_virtuoso_support_ai
Interact with Virtuoso's AI-enabled assistant (Virtuoso is unique)
