test-data-mcp-server
Verified Safeby 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
node dist/index.jsEnvironment 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
inspector
Local development and debugging platform for Model Context Protocol (MCP) clients and servers, including proxying MCP server interactions, simulating UI widgets, and facilitating OAuth flows. It enables building, testing, and developing MCP clients and servers.
mcp-maintainer-toolkit
This server provides a Model Context Protocol (MCP) interface with various tools and resources designed to assist in maintaining, testing, and developing MCP repositories and clients.
mock-mcp
Facilitates AI-generated mock data for testing web applications by bridging test runners with Model Context Protocol (MCP) clients.
mcp-mock-server
Provides a mock server for the Model Context Protocol (MCP) to aid in the development and testing of MCP clients.