Back to Home
farisahmed123 icon

spring-weather-mcp-server

by farisahmed123

Overview

A Spring Boot server providing weather data and a general database interaction API, following an MCP architectural pattern.

Installation

Run Command
gradle bootRun

Security Notes

CRITICAL SQL INJECTION VULNERABILITY: The DBController endpoints (e.g., /api/db/insert, /api/db/update, /api/db/delete, /api/db/query) accept raw SQL strings directly from the request body and execute them via JdbcTemplate without any sanitization or parameterized queries. This allows any user to inject arbitrary SQL commands, leading to full data compromise (read, modify, delete) and potentially remote code execution depending on the database configuration and permissions. The use of 'sa' user with an empty password for H2 by default further exacerbates this risk.

Similar Servers

Stats

Interest Score0
Security Score2
Cost ClassLow
Avg Tokens200
Stars0
Forks0
Last Update2025-12-03

Tags

Spring BootJavaREST APIH2 DatabaseWeather Data