Available tools
4 tools| Tool | Description |
|---|---|
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 |
Setup
A few steps to connect your AI agents to PostgreSQL.
- 1
Create Your Account
Sign up for PatchOps to access our MCP server management platform.
- 2
Add PostgreSQL Connection
Navigate to the Dashboard and add your PostgreSQL connection string to establish secure access.
- 3
Configure Your AI Agent
Add the PostgreSQL MCP server URL to your AI agent's configuration file.
- 4
Start Querying
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
Pick the tool your team uses for the exact setup steps.
- 1
Open Claude settings
Launch Claude, click the profile button (bottom left), and go to Settings.
- 2
Access connectors
Open the Connectors tab, scroll to the bottom, and click “Add custom connector”.
- 3
Name your connector
Enter any name you’d like for this connector.
- 4
Get the connector URL
Log in to PatchOps, open the /mcp page, and copy the connector URL you want to use.
- 5
Add the connector
Paste the URL into the “Remote MCP server URL” box and click Add.
- 6
Start using
Your PostgreSQL connector is ready to use in Claude.