simple-mcp-server-hono
by sathishkannan162
Overview
A Model Context Protocol (MCP) server that provides AI agents or other applications programmatic access to PostgreSQL database schema and a read-only SQL query execution tool.
Installation
npm run devEnvironment Variables
- DATABASE_URL
Security Notes
The `execute-read-queries` tool directly executes user-provided SQL queries (using `client.query(sql)`). While wrapped in a `READ ONLY` transaction to prevent writes, this poses a significant risk for read-only SQL injection, potentially leading to sensitive data leakage, denial-of-service via complex queries, or other resource abuses if the `sql` input is not strictly validated and sanitized by the consuming application before being passed to this endpoint. The current `zod.string()` validation for `sql` is insufficient for preventing SQL injection.
Similar Servers
tiger-gh-mcp-server
Provides a set of focused tools to Large Language Models (LLMs) for interacting with the GitHub API, enabling capabilities like fetching issues, pull requests, commits, releases, and searching code within a specified organization.
mymlh-mcp-server
Provides secure, OAuth-authenticated access to MyMLH API data for AI assistants and Model Context Protocol (MCP) clients.
MyMCP
Dynamically convert any OpenAPI v3 specification into a fully-functional Model Context Protocol (MCP) server, exposing external APIs as MCP tools.
txt2mcp
Converts text files or remote URLs into Model Context Protocol (MCP) servers, providing a searchable interface for AI agents.