DEV Community

Mads Hansen
Mads Hansen

Posted on

How to connect PostgreSQL to Claude in 5 minutes

Your engineering team spent three days last month answering the same question in three different Slack threads.

"What's our churn rate?"

Each time: open terminal, write query, format output, paste to Slack. Repeat.

Here's how to make it stop.


What you need

  • A running PostgreSQL database
  • Access to Claude (any plan)
  • 5 minutes

That's it. No custom code. No infra to manage.


Step 1: Sign up for Conexor.io

Go to conexor.io and create a free account. 14-day trial, no credit card.

Step 2: Connect your database

In the dashboard, click Add Data Source → PostgreSQL. Enter your connection string:

postgresql://user:password@host:5432/dbname
Enter fullscreen mode Exit fullscreen mode

Conexor connects and maps your schema automatically. It reads your tables, columns, and relationships — so the AI understands your data structure without you explaining it.

Step 3: Create an MCP server

Click New MCP Server. Give it a name. Conexor generates an endpoint URL.

Step 4: Point Claude at it

In Claude's settings, add the MCP server URL under Integrations. Done.

Step 5: Ask your first question

What's our MRR this month vs last month?
Enter fullscreen mode Exit fullscreen mode

Claude queries your PostgreSQL database directly and returns a live answer.

No SQL. No copy-paste. No ticket.


What just happened

You connected an AI model directly to your production data using MCP (Model Context Protocol). Every question your team asks now gets answered in seconds — from live data — without touching engineering.

The 5-minute setup. The hours saved every week.

Try it free at conexor.io

Top comments (0)