Skip the install. Get this working in under 2 minutes.
Start a free trial on cloud.anythingmcp.com, add the PostgreSQL in one click, then point your AI client (Claude, ChatGPT, Copilot or Cursor) at the generated MCP endpoint. No Docker, no git clone, zero engineering experience required.
Summary
Query a PostgreSQL database directly: list tables, describe columns and run read-only SQL. Installs read-only; credentials are held encrypted rather than in the connection string.
Try asking
Example prompts for PostgreSQL
Click any prompt to copy it. Paste into Claude, ChatGPT, Cursor, Gemini, Copilot or OpenClaw to run it against this connector.
Claude is AI and can make mistakes. Please double-check responses.
💡 No install? Use cloud.anythingmcp.com directly. Sign in, click Connectors → PostgreSQL, paste your credentials, mint an MCP API key — done. No Docker, no
git clone, no local server.
PostgreSQL + ChatGPT
Query a PostgreSQL database directly: list tables, describe columns and run read-only SQL. Installs read-only; credentials are held encrypted rather than in the connection string.
Prerequisites
See the full setup instructions baked into the connector (visible in the in-app store when you select the connector). The required environment variables for this connector are:
POSTGRES_HOST, POSTGRES_PORT, POSTGRES_DATABASE, POSTGRES_USER, POSTGRES_PASSWORD
Step 1 — Get credentials
Setup
- Create a dedicated role for the agent and grant it only what it needs:
The last line matters: without it, tables created tomorrow are invisible.CREATE ROLE amcp_reader LOGIN PASSWORD 'change-me'; GRANT CONNECT ON DATABASE sales TO amcp_reader; GRANT USAGE ON SCHEMA public TO amcp_reader; GRANT SELECT ON ALL TABLES IN SCHEMA public TO amcp_reader; ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO amcp_reader; - Set
POSTGRES_HOST,POSTGRES_PORT(5432),POSTGRES_DATABASE,POSTGRES_USERandPOSTGRES_PASSWORD.
…(continued in the in-app connector instructions)
Step 2 — Install the adapter
curl -fsSL https://raw.githubusercontent.com/HelpCode-ai/anythingmcp/main/docker-compose.quickstart.yml -o docker-compose.yml
printf 'JWT_SECRET=%s\nENCRYPTION_KEY=%s\n' "$(openssl rand -hex 32)" "$(openssl rand -hex 32)" > .env
docker compose up -d
Step 3 — Add the connector in ChatGPT
Your server URL: in AnythingMCP, open MCP Servers → the server this connector is on, and copy its URL (
https://cloud.anythingmcp.com/mcp/…). Use it wherever this guide showsYOUR_SERVER_ID.
ChatGPT connects to MCP servers as custom apps in developer mode, available on paid plans (not on Free). On Business and Enterprise workspaces an admin may have to allow it first.
- In ChatGPT, open Settings → Security and login and turn on Developer mode.
- Go to chatgpt.com/plugins and click +.
- Enter a name and a short description, e.g. Name:
PostgreSQL. - Under Connection, enter the MCP server URL
https://cloud.anythingmcp.com/mcp/YOUR_SERVER_IDand create the connection. - When ChatGPT asks, sign in to AnythingMCP (OAuth) and allow access.
Available tools
| Tool | What it does |
|---|---|
postgres_list_tables | List the tables and views in the database with their schema and, where the server tracks it, an approximate row count |
postgres_describe_table | Describe one table: every column with its data type, nullability and default |
postgres_find_columns | Find columns across every table whose name matches a pattern — the fast way to locate where customer e-mail addresses, IBANs or order number |
postgres_query | Run a read-only SQL statement against PostgreSQL and return up to 1000 rows |
postgres_query_examples | Show worked example queries for PostgreSQL: how to list schemas, find large tables, inspect indexes and check what is running right now |
FAQ
Does the free ChatGPT plan work with custom MCP connectors? No. Custom MCP connections need developer mode, which is only on paid plans.
Next steps
Was this guide helpful?
