jvlink-mcp-server
Verified Safeby miyamamoto
Overview
This server allows users to analyze JRA-VAN horse racing data using natural language queries, translating them into SQL for detailed statistical analysis and trend identification.
Installation
DB_TYPE=sqlite DB_PATH=/path/to/keiba.db python run_server.pyEnvironment Variables
- DB_TYPE
- DB_PATH
- DB_CONNECTION_STRING
- JVLINK_DB_PASSWORD
- MCP_HOST
- MCP_PORT
- JVDATA_DIR
Security Notes
The server employs robust SQL injection prevention mechanisms, including explicit checks for dangerous keywords (DROP, DELETE, UPDATE, etc.) in `execute_safe_query` and parameter escaping for LIKE clauses. However, the default setup for network access (SSE/HTTP mode) is unauthenticated, as acknowledged in the documentation (`REMOTE_SETUP.md`), which poses a risk if exposed to untrusted networks without additional security measures like authentication and HTTPS/TLS.
Similar Servers
iracing-data-mcp-server
Provides an MCP server and CLI tool for accessing iRacing racing simulation data API for AI assistant integration and direct command-line use.
mysql-mcp-server
Provides a programmatic interface for interacting with a MySQL database, enabling schema retrieval and arbitrary SQL query execution through an MCP server.
mysql_mcp_server
This server provides a Model Context Protocol (MCP) interface to a MySQL database, enabling AI models to execute SQL queries and retrieve database schema information.
mssql-mcp-server
Provides a simple MCP server with tools to execute queries and retrieve metadata from an MSSQL database.