OpenLinkSoftware_mcp-odbc-server
If you are the rightful owner of OpenLinkSoftware_mcp-odbc-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.
The mcp-odbc server provides Large Language Models with access to ODBC-accessible data sources via a Data Source Name configured for a specific ODBC Connector.
The mcp-odbc server is a Model Context Protocol (MCP) server designed to facilitate the interaction between Large Language Models (LLMs) and ODBC-accessible data sources. Built on a TypeScript layer over `node-odbc`, it allows seamless routing of calls to the host system's local ODBC Driver Manager using node.js. This server is particularly useful for applications that require transparent data access and manipulation through SQL queries. It supports various ODBC Connectors, with a strong emphasis on community contributions for broader database management system support. The server setup involves installing necessary MCP components, configuring environment variables, and ensuring the correct node.js version. It also provides tools for schema and table management, query execution, and interaction with Virtuoso's AI features. The server can be integrated with different platforms like Claude Desktop, Cline (Visual Studio Extension), and Cursor, each requiring specific configuration settings.
Features
- Transparent access to ODBC-accessible data sources for LLMs.
- Built on TypeScript over `node-odbc` for seamless integration.
- Supports various ODBC Connectors with community-driven expansion.
- Provides tools for schema and table management, and query execution.
- Integrates with platforms like Claude Desktop, Cline, and Cursor.
Tools
get_schemas
List database schemas accessible to connected database management system (DBMS).
get_tables
List tables associated with a selected database schema.
describe_table
Provide the description of a table associated with a designated database schema.
filter_table_names
List tables based on a substring pattern from the
qinput field.query_database
Execute a SQL query and return results in JSONL format.
execute_query
Execute a SQL query and return results in JSONL format.
execute_query_md
Execute a SQL query and return results in Markdown table format.
spasql_query
Execute a SPASQL query and return results.
sparql_query
Execute a SPARQL query and return results.
virtuoso_support_ai
Interact with the Virtuoso Support Assistant/Agent for LLMs.
