Back to Home
santhosh-genai icon

test-data-mcp-server

Verified Safe

by santhosh-genai

Overview

This MCP server provides tools for generating synthetic test data and fetching prospect leads from an Opentaps MySQL database for QA and development purposes.

Installation

Run Command
node dist/index.js

Environment Variables

  • DB_HOST
  • DB_PORT
  • DB_USER
  • DB_PASSWORD
  • DB_NAME
  • NODE_ENV

Security Notes

The server demonstrates good security practices: - Database credentials are loaded from environment variables. - SQL queries use prepared statements, preventing SQL injection for parameterized values. - Input validation is explicitly performed on all tool parameters, checking types, ranges, and allowed enum values. - There is no use of `eval` or dynamic code execution from external input. - Error handling is structured, providing clear JSON-RPC error responses and tool-specific error payloads. - The server operates over `stdio` which is an IPC mechanism, reducing direct network exposure. One point deduction as it's not using an ORM which would fully abstract SQL, but the current approach with prepared statements is robust.

Similar Servers

Stats

Interest Score0
Security Score9
Cost ClassLow
Avg Tokens2000
Stars0
Forks0
Last Update2025-12-14

Tags

MCPTest DataQAMySQLFaker