Simple Postgres
Enables execution of SQL queries on PostgreSQL databases via an MCP-compatible client with configurable read-only or write access.
About
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.
Key Features
- 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
Use Cases
- 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