Skip to content
NewAI dashboards.See how →
Try free

Postgres MCP

Postgres MCP: ask Claude or ChatGPT about your Postgres tables.

Connect PostgreSQL to Mammoth, then add Mammoth to Claude or ChatGPT. Ask about signups per week, revenue by plan and order value by country in plain words. Mammoth calculates the answer, so the numbers are exact.
Try freeHow to connect
  1. PostgresYour data
  2. MammothCleans and calculates
  3. Your AI assistantClaude, ChatGPT, VS Code

Your two options

Two ways to connect Postgres to your AI assistant

Mammoth answers questions about Postgres and your other data. Other Postgres MCP servers query Postgres directly.

Option 1

Mammoth

Ask about Postgres and your other data. Mammoth calculates the answer, so the numbers are exact. Included on every plan.

You ask
“How many signups did we get each week this quarter?”
Try freeHow to connect
Option 2

Other Postgres MCP servers

Queries your database directly. You install and look after it yourself.

You ask
“Show the 10 newest rows in the orders table.”
How those servers are set up

Option 1 · Mammoth

What you can ask about your Postgres tables

Pick a question to see what your assistant gets back.

ClaudeChatGPTVS Code

orders (PostgreSQL)Counted new users by weekCalculated by Mammoth
Week ofSignups
Oct 61,184
Oct 131,302
Oct 201,247

Shown on sample data. Your questions run on your own data.

More questions, by team

Pick your team, then copy a question into Claude or ChatGPT.

ClaudeChatGPTVS Code
  • How many users signed up each day this month?
  • Which features were used most last month?
  • How many accounts were active each week?
  • What's the average number of projects per account, by plan?

Copy a question and paste it into your assistant once Mammoth is connected.

Option 1 · Mammoth

Ask about Postgres and your other data together

Connect PostgreSQL and any of Mammoth’s 100+ other sources, like Stripe, Jira or Salesforce. Join them once in Mammoth, and your assistant can answer questions that cover all of them.

See all 100+ sources
+100 more

Example: Postgres with Stripe

Which features do our highest-paying customers use most?

Your database holds product usage and Stripe holds the payments. Mammoth matches them on the customer.

Option 1 · Mammoth

Set up Postgres with Mammoth in three steps

  1. Step 1

    Connect Postgres to Mammoth

    Choose PostgreSQL from Mammoth's connectors and sign in. Then pick the data you want.

  2. https://mcp.mammoth.io/mcp
    Step 2

    Add Mammoth to your assistant

    Paste this address into Claude, ChatGPT or VS Code, then sign in with your Mammoth account.

  3. Step 3

    Ask your question

    Ask in Claude or ChatGPT, in plain words. Mammoth works out the numbers and your assistant replies with the answer.

What Mammoth reads from Postgres

You give Mammoth a database login. It shows every table that login can see, and you pick the ones to bring in.

Start free and connect Postgres14-day Pro trial · No credit card

Step-by-step setup for each assistant is in our MCP docs.

Option 2 · Other servers

How other Postgres MCP servers are set up

There's no single official Postgres MCP server. Most are community projects you install and run yourself, with a database login in their settings.

  1. Step 1

    Pick a server

    Choose a community Postgres MCP server and install it with its command.

  2. Step 2

    Add your database login

    Put your connection string in your assistant's MCP settings.

  3. Step 3

    Ask questions

    The server queries your database with that login.

Common questions about Postgres MCP

What other PostgreSQL MCP servers are there?
There's no single official Postgres MCP server. Most are community projects you install and run yourself, with a database login in their settings.
Does my AI assistant get my database password?
No. You connect Postgres inside Mammoth, and your assistant signs in to Mammoth with your Mammoth account. The database login never passes through the chat.
How does my assistant get to my PostgreSQL data?
You connect PostgreSQL to Mammoth once. Mammoth keeps a copy of the data and updates it on demand or on a schedule. Your assistant asks Mammoth, not PostgreSQL.
Are the numbers right?
Yes. Mammoth calculates totals, counts and averages itself and gives your assistant the result. The AI model doesn't add up the rows.
Which AI assistants work with it?
Claude on the web, Claude Desktop and Claude Code, ChatGPT, and VS Code. Cursor can't sign in yet, so use the Mammoth CLI there.
What does it cost?
The MCP server is on every Mammoth plan, including Free. The Free plan reads PostgreSQL, so you can do all of this without paying.
Do I paste a password or API key into the chat?
No. You connect PostgreSQL inside Mammoth and sign in to Mammoth from your assistant. No password passes through the model.
Can my assistant change things by mistake?
Every tool is labelled as read-only, a change you can undo, or one that deletes or sends data out. You can set your assistant to ask you before it uses anything that isn't read-only.

Ask your AI assistant about your Postgres tables.

Start free, connect PostgreSQL, and add Mammoth to Claude or ChatGPT.

Try freeBook a demo
  • ✓ 14-day Pro trial
  • ✓ No credit card
  • ✓ Viewers always free

Keep reading

Read nextGoogle Sheets MCPAsk your assistant about your Google Sheets.Take a lookRead nextMeta Ads MCPAsk your assistant about your Meta ad campaigns.Take a lookRead nextMammoth MCP serverEvery source, one server.Take a look