MCP Jdbc Server

## 🚀 Java Translation

This project provides a set of Java - based interfaces for database operations, including standard SQL queries, SPASQL queries, SPARQL queries, Virtuoso AI support, and database metadata queries.

## ✨ Features

1. **Execute Standard SQL Queries**: Through the `jdbc_query_database` interface, you can execute any standard SQL query and get the results. It supports JSON, Markdown tables, and JSON Lines formats.
2. **SPASQL Queries**: For the special requirements of the Virtuoso database, the `jdbc_spasql_query` interface is provided to execute SPASQL (SQL/SPARQL hybrid) queries and return the results. You can set the maximum number of rows and the timeout.
3. **SPARQL Queries**: Via the `jdbc_sparql_query` interface, you can execute standard SPARQL queries and get the results in the specified format. The default format is JSON.
4. **Virtuoso AI Support**: Leveraging the special features of the Virtuoso database, the `jdbc_virtuoso_support_ai` interface is provided to call AI - support functions. It supports custom prompts and API keys.
5. **Database Metadata Queries**:
   - Use the `jdbc_get_databases` interface to get all available databases.
   - Use the `jdbc_get_tables` interface to get table information in a specified database.
   - Use the `jdbc_get_columns` interface to get column information of a specified table.

## 💻 Usage Examples

### Basic Usage
#### Execute a Standard SQL Query (JSON Format)
```bash
curl -X POST "http://localhost:1234/api/v1/java" \
-H "Content-Type: application/json" \
-d '{"method":"jdbc_query_database","params":{"query":"SELECT * FROM users LIMIT 5"}}'

Execute a SPASQL Query

curl -X POST "http://localhost:1234/api/v1/java" \
-H "Content-Type: application/json" \
-d '{"method":"jdbc_spasql_query","params":{"query":"SELECT TOP 5 * FROM users"}}'

Call Virtuoso AI Support

curl -X POST "http://localhost:1234/api/v1/java" \
-H "Content-Type: application/json" \
-d '{"method":"jdbc_virtuoso_support_ai","params":{"prompt":"生成一个用户数据表的 SQL 创建语句"}}'

📚 Documentation

Common Parameters

Special Interface Parameters

jdbc_spasql_query

jdbc_sparql_query

jdbc_virtuoso_support_ai

💻 Metadata Interface Examples

Get All Databases

curl -X POST "http://localhost:1234/api/v1/java" \
-H "Content-Type: application/json" \
-d '{"method":"jdbc_get_databases"}'

Get Table Information of a Specified Database

curl -X POST "http://localhost:1234/api/v1/java" \
-H "Content-Type: application/json" \
-d '{"method":"jdbc_get_tables","params":{"database":"your_database_name"}}'

Note: The last example in the original Chinese README for getting table information of a specified database was incomplete. I completed it by adding a sample parameter `{"database":"your_database_name"}`. If there is more accurate information, you can adjust it accordingly.