Overview
A lightweight MCP server for ODBC built with FastAPI, pyodbc, and SQLAlchemy. This MCP server is compatible with Virtuoso DBMS and other DBMS backends that implement a SQLAlchemy provider. It exposes endpoints to retrieve schemas and tables, describe table structures, filter tables by name, and execute stored procedures (Virtuoso-specific). It also supports executing standard SQL queries and returning results in JSONL format or as Markdown tables for reporting. The server relies on ODBC DSNs and SQLAlchemy URL bindings (e.g., virtuoso+pyodbc://user:password@VOS) and is configurable via environment variables (ODBC_DSN, ODBC_USER, ODBC_PASSWORD, API_KEY). Connections can be defined and tested using DSN configurations, with examples provided for Virtuoso, PostgreSQL, MySQL, and SQLite. Tool endpoints include podbc_get_schemas, podbc_get_tables, podbc_describe_table, podbc_filter_table_names, podbc_query_database, podbc_query_database_md, podbc_query_database_jsonl, podbc_spasql_query, podbc_sparql_query, and podbc_virtuoso_support_ai. Troubleshooting via MCP Inspector is also documented.
Features
Get Schemas
Retrieve and list all schema names from the connected database.
Get Tables
Retrieve table information for specific schemas or all schemas.
Describe Table
Provide a detailed description of a table's columns, data types, nullability, and keys (PK/FK).
Search Tables
Filter and retrieve tables based on name substrings.
Execute Stored Procedures
In Virtuoso, execute stored procedures and retrieve results.
Execute Queries
Execute SQL queries and return results in JSONL format or as Markdown tables.
Who Is This For?
- Claude Desktop users:Integrate Claude AI assistant with the MCP server to run SQL/ODBC queries against Virtuoso and other DBMS.
