What ChatGPT can do with Postgresql
Ask your agent in plain language. Each of these maps to a real tool on the server.
- Ask ChatGPT to use the describe table tool in Postgresql
- Ask ChatGPT to use the manage roles tool in Postgresql
- Ask ChatGPT to use the manage indexes tool in Postgresql
- Ask ChatGPT to use the update rows tool in Postgresql
- Ask ChatGPT to use the execute sql query tool in Postgresql
Add the Postgresql MCP server to ChatGPT
Run these once. Afterwards, everyone you give access to signs in the same way.
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. Add a custom MCP server
On ChatGPT web, open Plugins, select +, then Add custom MCP server.
3. Paste your Metorial MCP URL
Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>), choose OAuth and accept the risk notice.
4. Create and install the plugin
Select Create as a plugin, install it and sign in to load Postgresql tools.
Give your team Postgresql in ChatGPT
Once Postgresql is enabled in Metorial, teammates sign in with SSO and get the same connection in ChatGPT, 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 ChatGPT
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 ChatGPT
What to expect once Postgresql is connected.
- Type @ and pick the plugin. The selection applies to that message only, so @mention it again when a follow-up needs fresh Postgresql data.
- For write actions, ChatGPT may ask you to confirm first, depending on the app permissions and the action.
- Once published for a workspace, ChatGPT keeps a snapshot of the tool list. When your team adds Postgresql tools in Metorial, an admin refreshes the actions in Workspace settings before they appear.
- You can use several apps in one prompt, for example read Postgresql data and then create a ticket in another app.
Troubleshooting ChatGPT
- Add custom MCP server is missing
- Workspace policy controls it. On Enterprise and Edu, an admin grants the permission to create plugins with MCPs; ask them to enable it for you.
- The plugin exists but no tools appear
- Creating the plugin is not enough: install it from your plugins, then start a new conversation so ChatGPT loads its tools.
- ChatGPT answers without using the tools
- Pick the plugin with @ in the composer and name the action you want, for example "use Metorial to look up the latest ticket".
Based on the ChatGPT MCP documentation.
Frequently asked questions
Common questions about connecting Postgresql to AI agents with Metorial.
Does ChatGPT support the Postgresql MCP server?
Yes. ChatGPT connects to the Postgresql MCP server through its connector settings, pointed at your Metorial URL. You need a ChatGPT plan or workspace that allows custom MCP servers.Do I need an API key to connect Postgresql to ChatGPT?
No. You sign in to Postgresql once through Metorial, and ChatGPT uses that connection. No API keys go into ChatGPT's settings.Which Postgresql tools can ChatGPT use?
All 13 Postgresql tools your team allows, such as List Tables, Delete Rows, List Schemas. Admins can narrow that list per team.Can I control which teammates use Postgresql in ChatGPT?
Yes. Role-based access control decides who can use Postgresql and which of its tools appear in ChatGPT, and every call is logged with the person's identity.What if ChatGPT doesn't show Postgresql tools?
Workspace policy controls it. On Enterprise and Edu, an admin grants the permission to create plugins with MCPs; ask them to enable it for you.
GitHub