Loading...
npm install @modelcontextprotocol/sdk{
"mcpServers": {
"ODBC": {
"command": "/path/to/.nvm/versions/node/v21.1.0/bin/node",
"args": [
"/path/to/mcp-odbc-server/node_modules/.bin/tsx",
"/path/to/mcp-odbc-server/src/main.ts"
],
"env": {
"ODBCINI": "/Library/ODBC/odbc.ini",
"NODE_VERSION": "v21.1.0",
"PATH": "~/.nvm/versions/node/v21.1.0/bin:${PATH}"
},
"disabled": false,
"autoApprove": []
}
}
}get_schemasLists database schemas accessible to the connected DBMS.
Read-only operation with no side effects.
get_tablesLists tables associated with a selected database schema.
Read-only operation with no side effects.
describe_tableProvides the description of a table associated with a designated database schema.
Read-only operation with no side effects.
filter_table_namesLists tables associated with a selected database schema, based on a substring pattern.
Read-only operation with no side effects.
query_databaseExecutes a SQL query and returns results in JSON Lines format.
Executes arbitrary SQL queries, potential for SQL injection.
execute_queryExecutes a SQL query and returns results in JSON Lines format.
Executes arbitrary SQL queries, potential for SQL injection.
execute_query_mdExecutes a SQL query and returns results in Markdown table format.
Executes arbitrary SQL queries, potential for SQL injection.
spasql_queryExecutes a SPASQL query and returns results.
Executes SPASQL queries, potential for complex vulnerabilities.
sparql_queryExecutes a SPARQL query and returns results.
Executes SPARQL queries, potential for complex vulnerabilities.
virtuoso_support_aiInteracts with the Virtuoso Support Assistant/Agent using LLMs.
Interaction with LLMs can introduce data leakage or unexpected behavior.
The MCP ODBC server offers both safe read-only operations and potentially risky query execution. It is safe to use for listing schemas and tables, but running arbitrary SQL queries should be done with caution and proper input validation to prevent SQL injection attacks. Securely managing database credentials is crucial.