PostgreSQL

featured

Live

PostgreSQL database integration for secure, read-only access to your PostgreSQL databases with schema inspection and query capabilities.

What is PostgreSQL?

PostgreSQL database integration provides secure, read-only access to your PostgreSQL databases. Execute SQL queries, explore database schemas, tables, and columns directly from your AI agent. All queries are automatically wrapped in read-only transactions to prevent data modifications.

Available Tools

query
Execute read-only SQL queries with automatic transaction protection
list_tables
List all tables in a database schema with column counts
describe_table
Get detailed column information including data types, constraints, and defaults
list_schemas
List all schemas in the PostgreSQL database

Requirements

PostgreSQL database
Access to a PostgreSQL database (AWS RDS, Azure Database, self-hosted, etc.)
Connection string
PostgreSQL connection URL (postgresql://user:password@host:port/database)
Compatible AI agent
Works with Claude, ChatGPT, and other MCP-compatible agents

Quick Setup Guide

Follow these steps to connect your AI agents to this connector

Navigate to the Dashboard and add your PostgreSQL connection string to establish secure access.

Add the PostgreSQL MCP server URL to your AI agent's configuration file.

Begin asking your AI agent to query your PostgreSQL database using natural language. All queries are read-only for safety.

Connect to Your AI Assistant

Choose your AI assistant below for specific setup instructions

Follow these steps to connect PostgreSQL to Claude:

Step 1: Open Claude Settings

Launch Claude → Click the profile button (bottom left) → Navigate to Settings

Step 2: Access Connectors

Scroll down to the Connectors tab → Navigate to the bottom → Click “Add Custom Connector”

Step 3: Name Your Connector

Enter any name you'd like for this connector

Step 4: Get the Connector URL

Step 5: Add the Connector

Paste the URL in the “Remote MCP Server URL” text box → Click Add

Step 6: Start Using

Your connector is now ready to use in Claude

Follow these steps to connect PostgreSQL to ChatGPT:

Step 1: Enable Developer Mode

Go to Settings → Connectors → Advanced → Enable Developer mode

Step 2: Create New Connector

Go back to Connectors page → Click “Create” (top right)

Step 3: Name Your Connector

Enter any name you'd like for this connector (descriptions are optional)

Step 4: Get the Connector URL

Step 5: Add the URL

Paste the URL in the “MCP Server URL” text box

Step 6: Set Authentication

Click the authentication dropdown → Select “No authentication” (PatchOps handles authentication internally)

Step 7: Create the Connector

Click “I understand and want to continue” checkbox → Press Create

Step 8: Using the Connector

Start a new chat → Click the + button (left of text box) → Open dropdown → Hover over three dots labeled “More” → Select your connector

Instructions for connecting PostgreSQL to GitHub Copilot:

Coming Soon

Detailed setup instructions for GitHub Copilot will be added here.

For other MCP-compatible platforms:

Step 1: Get the Connector URL

Step 2: Add to Configuration

Add this configuration to your MCP settings file. Replace the URL with your specific connector URL from the /mcp page:

"PostgreSQL-MCP": {
  "url": "https://...patchops.ai/mcp/...",
  "type": "http"
}

Example Configuration

Here’s an example using Cambria-MCP:

"Cambria-MCP": {
  "url": "https://cambria.patchops.ai/mcp/...",
  "type": "http"
}