How to connect Postgresql to Claude

  • Claude gets 13 Postgresql tools through one Metorial MCP URL.
  • Setup is 4 steps; teammates then sign in with SSO.
  • You need any Claude plan; Free plans allow one custom connector.

What Claude can do with Postgresql

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Ask Claude to use the list tables tool in Postgresql
  • Ask Claude to use the delete rows tool in Postgresql
  • Ask Claude to use the list schemas tool in Postgresql
  • Ask Claude to use the insert rows tool in Postgresql
  • Ask Claude to use the manage table tool in Postgresql

Add the Postgresql MCP server to Claude

Run these once. Afterwards, everyone you give access to signs in the same way.

  1. 1. Enable Postgresql in Metorial

    In your Metorial portal, enable the Postgresql MCP server and sign in with the account that owns the data. Access stays governed by your team policies.

  2. 2. Add a custom connector

    Open Customize, then Connectors. Select Add, then Custom, then Web.

  3. 3. Paste your Metorial MCP URL

    Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>) and continue.

  4. 4. Sign in

    Select Add and sign in to load Postgresql tools.

Give your team Postgresql in Claude

Once Postgresql is enabled in Metorial, teammates sign in with SSO and get the same connection in Claude, with only the tools their role allows.

One link covers every app you approve. See how the MCP gateway handles access, roles and audit logs for the whole company.

Postgresql tools available in Claude

Full descriptions and inputs are on the Postgresql MCP server page.

  • List Tables: List all tables in the PostgreSQL database, optionally filtered by schema.
  • Delete Rows: Delete rows from a PostgreSQL table based on a WHERE condition.
  • List Schemas: List all schemas in the PostgreSQL database with their table counts and sizes.
  • Insert Rows: Insert one or more rows into a PostgreSQL table.
  • Manage Table: Create, alter, or drop a PostgreSQL table.
  • Describe Table: Get detailed schema information for a specific table, including columns, data types, constraints, indexes, and foreign keys.
  • Manage Roles: Manage PostgreSQL roles and their privileges.
  • Manage Indexes: Create or drop indexes on PostgreSQL tables.
  • Update Rows: Update rows in a PostgreSQL table based on a WHERE condition.
  • Execute SQL Query: Execute an arbitrary SQL query against the PostgreSQL database.
  • Manage Schemas: Create, rename, or drop PostgreSQL schemas.
  • Manage Views: Create and drop PostgreSQL views or materialized views, and refresh materialized views.
  • Select Query: Run a read-only SELECT query against the PostgreSQL database.

Using Postgresql tools in Claude

What to expect once Postgresql is connected.

  • Turn Metorial on for a conversation with the + button, then Connectors; each connector has its own toggle.
  • Claude asks before it runs a Postgresql tool. Choose Allow always only for tools you trust to run unsupervised.
  • Use the Search and tools menu to switch off tools you do not need in the current conversation.
  • Remove the connector from Customize, then Connectors. Team and Enterprise owners can do this for the whole organization.

Troubleshooting Claude

Members on a Team or Enterprise plan cannot add the connector
On Team and Enterprise plans an Owner adds custom connectors in Organization settings, then Connectors. Members then connect it with their own account.
The Free plan only allows one custom connector
One is enough: your Metorial URL carries every app your team approves, so you never need a second connector.
Tools do not show up in a chat
Connectors are switched on per conversation. Open the + menu in the chat, choose Connectors, and turn Metorial on.

Based on the Claude MCP documentation.

Frequently asked questions

Common questions about connecting Postgresql to AI agents with Metorial.

  1. Does Claude support the Postgresql MCP server?
    Yes. Claude connects to the Postgresql MCP server through its connector settings, pointed at your Metorial URL. You need any Claude plan; Free plans allow one custom connector.
  2. No. You sign in to Postgresql once through Metorial, and Claude uses that connection. No API keys go into Claude's settings.
  3. All 13 Postgresql tools your team allows, such as List Tables, Delete Rows, List Schemas. Admins can narrow that list per team.
  4. Yes. Role-based access control decides who can use Postgresql and which of its tools appear in Claude, and every call is logged with the person's identity.
  5. On Team and Enterprise plans an Owner adds custom connectors in Organization settings, then Connectors. Members then connect it with their own account.