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.
AnythingMCP is listed in Claude's connector directory: add it to Claude in one click (opens in a new tab), then sign in and choose which MCP servers Claude may use.
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 + Claude
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 Claude
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.
Recommended path — works on claude.ai web without editing any config file.
- In Claude, open Customize → Connectors.
- Click +, then Add custom connector.
- Enter a name, e.g.
PostgreSQL, and the remote MCP server URLhttps://cloud.anythingmcp.com/mcp/YOUR_SERVER_ID, then click Add. - Click Connect and sign in to AnythingMCP (OAuth) to allow access.
All tools below appear in your chat — start typing prompts.
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 it work with Claude Code as well as Claude Desktop? Yes — point both at https://cloud.anythingmcp.com/mcp/YOUR_SERVER_ID.
Next steps
Was this guide helpful?
