How to connect Postgresql to Cursor

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 Metorial to your MCP config

   Use ~/.cursor/mcp.json for every project, or .cursor/mcp.json for one.

   Copy

   {
     "mcpServers": {
       "metorial": {
         "url": "<your-magic-mcp-url>"
       }
     }
   }

3. 3. Sign in

   Open Customize in the sidebar, find Metorial and sign in to load Postgresql tools.

• 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.

• Cursor picks MCP tools automatically when they are relevant, including in Plan Mode. Name a Postgresql tool to steer it.
• Cursor asks for approval before it uses an MCP tool by default. Click the arrow next to the tool name to check the arguments first.
• Switch the Metorial server off from Customize in the sidebar without removing it.
• Cursor shows each Postgresql tool response in chat, with expandable views of the arguments and the result.

Metorial connects but tools are missing or failing

Open the Output panel (Cmd+Shift+U), choose MCP Logs, and look for authentication or connection errors.

Your company blocks the server

Enterprise admins approve remote servers in Team Settings, then MCP Configuration. Ask them to add a URL entry for your Metorial URL.

Cursor asks before every tool call

That is the default. Allowlist the Metorial tools you trust in your Run Mode settings to run them without a prompt.

Based on the Cursor MCP documentation.