Loading...
npx @modelcontextprotocol/inspector{
"mcpServers": {
"my_database": {
"command": "java",
"args": ["-jar", "/path/to/mcp-jdbc-server/MCPServer-1.0.0-runner.jar"],
"env": {
"jdbc.url": "jdbc:virtuoso://localhost:1111",
"jdbc.user": "username",
"jdbc.password": "password",
"jdbc.api_key": "sk-xxx"
}
}
}
}jdbc_get_schemasLists database schemas accessible to the connected database management system.
Read-only operation, no data modification.
jdbc_get_tablesLists tables associated with a selected database schema.
Read-only operation, no data modification.
jdbc_describe_tableProvides the description of a table, including column names, data types, and key information.
Read-only operation, no data modification.
jdbc_filter_table_namesLists tables based on a substring pattern from the input, associated with a selected database schema.
Read-only operation, no data modification.
jdbc_query_databaseExecutes a SQL query and returns the results in JSON format.
Executes arbitrary SQL queries, potential for data exposure.
jdbc_execute_queryExecutes a SQL query and returns the results in JSONL format.
Executes arbitrary SQL queries, potential for data exposure.
jdbc_execute_query_mdExecutes a SQL query and returns the results in Markdown table format.
Executes arbitrary SQL queries, potential for data exposure.
jdbc_spasql_queryExecutes a SPASQL query and returns results (Virtuoso-specific).
Executes SPASQL queries, potential for data exposure and Virtuoso dependency.
jdbc_sparql_queryExecutes a SPARQL query and returns results (Virtuoso-specific).
Executes SPARQL queries, potential for data exposure and Virtuoso dependency.
jdbc_virtuoso_support_aiInteracts with LLMs through the Virtuoso Support Assistant/Agent (Virtuoso-specific).
Accesses AI service with potential for data leakage and unexpected behavior.
This server provides useful database interaction capabilities, but the risk of SQL injection and data exposure must be carefully managed. The Virtuoso-specific features should only be enabled when interacting with a Virtuoso database.