strange-mcp-postgres
Verified Safeby trangpl193
Overview
Provides a Model Context Protocol (MCP) interface for performing PostgreSQL database operations, enabling AI models or other systems to interact with a database via an HTTP API.
Installation
npx mcp-postgresEnvironment Variables
- DB_HOST
- DB_PORT
- DB_NAME
- DB_USER
- DB_PASSWORD
- MCP_API_KEY
- MCP_PORT
Security Notes
The server uses parameterized queries ($1, $2, etc.) for all database operations (SELECT, INSERT, UPDATE, DELETE, transactions, schema introspection), which is a robust defense against SQL injection. Configuration, including database credentials and API keys, is loaded from environment variables or passed programmatically, avoiding hardcoded secrets. API key authentication is implemented to control access to the server's endpoints. No 'eval' or other direct dynamic code execution from user input is apparent in the provided source code.
Similar Servers
enhanced-postgres-mcp-server
This server acts as a Model Context Protocol interface for PostgreSQL, enabling LLMs to query data, modify records, and manage database schema objects with read and write capabilities.
postgres-mysql-mcp-server
A Model Context Protocol (MCP) server that enables AI assistants to query PostgreSQL and MySQL databases for schema introspection and data retrieval.
dx-mcp-server
Empowers AI applications to interact with and query a user-provided Postgres database via the Model Context Protocol (MCP).
mcp-postgres
Provides a read-only Model Context Protocol (MCP) server for AI tools (like Claude Code, Cursor) to query a PostgreSQL database directly.