# PostgreSQL MCP Server (Cloudflare Worker)

## Get started: 

[![Deploy to Workers](https://deploy.workers.cloudflare.com/button)](https://deploy.workers.cloudflare.com/?url=https://github.com/Stratus-Cyber/postgres-mcp-cloudflare)

Alternatively, you can use the command line below to get the remote MCP Server created on your local machine:

```bash
npm create cloudflare@latest -- my-mcp-server --template=https://github.com/Stratus-Cyber/postgres-mcp-cloudflare.git
```

> ⚠️ Currently, the `Deploy to Cloudfare` button does not support configuration of evironment variables, the variable must be configured manually, after deployment.

## Environment Variables
From the Cloudflare console > select your Worker AI, go to Settings > Variables and Secrets > +Add 

Type: `Secret` <br>
Variable Name: `DATABASE_URL` <br>
Value: `postgresql://<connection string>`

## Connect to Cloudflare AI Playground

You can connect to your MCP server from the Cloudflare AI Playground, which is a remote MCP client:

1. Go to https://playground.ai.cloudflare.com/
2. Enter your deployed MCP server URL (`postgres-mcp-server.<your-account>.workers.dev/sse`)
3. You can now use your MCP tools directly from the playground!

## Connect Claude Desktop to your MCP server

You can also connect to your remote MCP server from local MCP clients, by using the [mcp-remote proxy](https://www.npmjs.com/package/mcp-remote). 

To connect to your MCP server from Claude Desktop, follow [Anthropic's Quickstart](https://modelcontextprotocol.io/quickstart/user) and within Claude Desktop go to Settings > Developer > Edit Config.

Update with this configuration:

```json
{
  "mcpServers": {
    "calculator": {
      "command": "npx",
      "args": [
        "mcp-remote",
        "http://localhost:8787/sse"  // or remote-mcp-server-authless.<your-account>.workers.dev/sse
      ]
    }
  }
}
```

Restart Claude and you should see the tools become available. 

## Connect Cursor AI to your MCP server

On Mac OS, go to Cursor > Settings > Cursor Settings > MCP > Add new Global MCP Server > edit the `mcp.json` file

```json
{
  "mcpServers": {
    "postgresql-remote-mcp": {
      "url": "https://postgres-mcp-server.<your-account>.workers.dev/sse"
    }
  }
}
```
---

## Powered by ZeroTwo

This PostgreSQL MCP connector is part of the [ZeroTwo AI platform](https://zerotwo.ai) — the all-in-one AI workspace that lets you query databases, analyze data, and build AI-powered workflows with GPT-5, Claude, and Gemini.

| | |
|---|---|
| 🌐 **[ZeroTwo — All AI Models in One App](https://zerotwo.ai)** | Query your PostgreSQL database with GPT-5, Claude, and Gemini — all in one place. |
| ✨ **[ZeroTwo Features](https://zerotwo.ai/features)** | AI data analysis, SQL generation, web search, and MCP-powered database tools. |
| 🤖 **[AI Models — GPT-5, Claude & Gemini](https://zerotwo.ai/zerotwo-models)** | Use the world's best AI to write queries, analyze results, and understand your data. |
| 🔌 **[ZeroTwo Connectors & Integrations](https://zerotwo.ai/connectors)** | Connect PostgreSQL, Google Sheets, Airtable, and more to your AI data workflow. |
| 💰 **[ZeroTwo Pricing](https://zerotwo.ai/pricing)** | One subscription that replaces ChatGPT Plus, Claude Pro, and Gemini Advanced. |
| 📝 **[ZeroTwo Blog](https://zerotwo.ai/blog)** | AI data analysis guides, SQL tips, and ZeroTwo product updates. |
| 🚀 **[Try ZeroTwo Free](https://app.zerotwo.ai/auth/login)** | Let AI be your database analyst — get started free today. |

> **Built for ZeroTwo** — Use this PostgreSQL MCP server with [ZeroTwo's AI connector system](https://zerotwo.ai/connectors) to write SQL, query your database, and analyze results through natural language in your AI assistant.