Simple PostgreSQL

This PostgreSQL MCP server provides direct SQL query execution against PostgreSQL databases through a single execute_query tool that supports both read-only and write operations with configurable safety modes. The implementation uses a singleton connection pattern with connection pooling via the pg library, includes built-in query validation to enforce read-only restrictions when enabled, and supports command-line configuration for database connection strings and operational modes. It's particularly useful for AI assistants that need to perform database analysis, data retrieval, or administrative tasks against PostgreSQL instances, with the flexibility to restrict operations to SELECT-only queries for safety in production environments.

Source

Repository: https://github.com/perrypixel/easy-postgres-mcp