Simple Postgres

概要

Provides a minimal Model Context Protocol (MCP) server designed for seamless interaction with PostgreSQL databases. It allows users to execute SQL queries with fine-grained control over permissions, offering both read-only and write access modes configurable at the server level. The tool returns structured results with metadata, making it an ideal solution for integrating PostgreSQL database operations directly into MCP-compatible environments and tools like Cursor or Windsurf with a simple setup using a PostgreSQL connection string.

主な機能

• Server-level mode configurable via command line
• Returns structured results with metadata
• Simple setup using a PostgreSQL connection string
• 6 GitHub stars
• Execute SQL queries with optional read-only or write access

ユースケース

• Automating SQL query execution within MCP-enabled workflows
• Integrating PostgreSQL operations into MCP-compatible coding assistants like Cursor or Copilot
• Providing controlled database access (read-only or write) for AI tools