MCP Servers / database / ODBC Server via PyODBC

ODBC Server via PyODBC

JSON →
httpnone4database

An MCP server for connecting to databases like Virtuoso using ODBC drivers via pyodbc.

Install
How to run this server
[ { "cmd": "npx @modelcontextprotocol/inspector", "imports": [] } ]
server path: odbc-server-via-pyodbc
Tools
What this server exposes
podbc_get_schemas
List database schemas accessible to connected database management system (DBMS).
podbc_get_tables
List tables associated with a selected database schema.
podbc_describe_table
Provide the description of a table associated with a designated database schema. This includes information about column names, data types, null handling, autoincrement, primary keys, and foreign keys
podbc_filter_table_names
List tables, based on a substring pattern from the `q` input field, associated with a selected database schema.
podbc_query_database
Execute a SQL query and return results in JSONL format.
podbc_execute_query
Execute a SQL query and return results in JSONL format.
podbc_execute_query_md
Execute a SQL query and return results in Markdown table format.
podbc_spasql_query
Execute a SPASQL query and return results.
podbc_virtuoso_support_ai
Interact with the Virtuoso Support Assistant/Agent -- a Virtuoso-specific feature for interacting with LLMs
Configuration
Environment & auth
authnone
Resources
ODBC Server via PyODBC — MCP Server · libregistry