Simple Postgres MCP

🚀 Simple PostgreSQL MCP Server

A minimal Model Context Protocol (MCP) server for executing SQL queries on PostgreSQL databases with configurable permissions.

✨ Features

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

🚀 Quick Start

Clone the repository

git clone https://github.com/perrypixel/Simple-Postgres-MCP
cd Simple-Postgres-MCP

Install dependencies

npm install

Build the project

npm run build

📚 Documentation

MCP Configuration

Add the following to your MCP client configuration (mcp.json):

Write Mode (default)

{
  "mcpServers": {
    "simple-postgresql-mcp": {
      "command": "node",
      "args": [
        "/path/to/build/index.js",
        "postgresql://username:password@localhost:5432/database_name",
        "write"
      ]
    }
  }
}

Read-Only Mode

{
  "mcpServers": {
    "simple-postgresql-mcp": {
      "command": "node",
      "args": [
        "/path/to/build/index.js",
        "postgresql://username:password@localhost:5432/database_name",
        "readonly"
      ]
    }
  }
}

⚠️ Important Note

Update the path in the configuration to point to the index.js file inside your build folder.

💻 Usage Examples

Basic Usage

1. Copy the appropriate MCP configuration (read-only or write mode) to your tool’s mcp.json (e.g., Cursor, Windsurf, Copilot, etc.).
2. Start your MCP client. The server is now ready to use!

🤝 Support

If you find this tool helpful, you can support the development by:

• Buying me a coffee at https://ko-fi.com/perrypixel
• UPI to kevinp@apl