simple-mcp-server
by sathishkannan162
Overview
An MCP server that exposes PostgreSQL table schemas as resources and provides a tool to execute read-only SQL queries against the database.
Installation
pnpm startEnvironment Variables
- DATABASE_URL
- PORT
Security Notes
The 'execute-read-queries' tool directly executes user-provided SQL queries using `client.query(sql)`. While it attempts to wrap queries in a `READ ONLY` transaction, this is a critical security risk. A malicious actor could craft complex read queries to perform denial-of-service (e.g., resource-intensive queries, long-running operations), extract large volumes of sensitive data, or otherwise exploit database-specific read vulnerabilities. Additionally, the server exposes access to `information_schema` tables, which could provide valuable reconnaissance for an attacker.
Similar Servers
tiger-linear-mcp-server
This server acts as a wrapper for the Linear API, providing focused tools for LLMs to manage and query issue tracking and project data.
thoughtbox
Provides a durable, local-first reasoning ledger and structured cognitive tools for AI agents, enabling step-by-step thinking, branching, revisions, and autonomous critique, with progressive tool disclosure and client compatibility adaptations.
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.
deployhq-mcp-server
This is a backend server component, likely acting as a "Master Control Program" for deployment workflows or a core service, developed using Node.js and TypeScript.