Connect your data to Claude in 1 minute. No code needed Try it now

Connect PostgreSQL to Copilot

Send PostgreSQL table or view and custom SQL to Copilot on a schedule. Refresh as often as every 15 minutes.

capterra
star star star star star

4.9/5

Copilot

What changed in our PostgreSQL data since last week?

Querying the PostgreSQL data set in Coupler.io
Copilot queries your PostgreSQL data through the Coupler.io MCP connector. Access is read-only.
Trusted by 200K+ users worldwide
Spotify
fifty-five
Al Jazeera
InPost
Visma
REHAU
Getir
Printify
Macromill
Stanford
Médecins Sans Frontières
Greenpeace
Save the Children
San Diego FC

How to connect PostgreSQL and Copilot

4 steps. You can preview the PostgreSQL data in Coupler.io before anything reaches Copilot.

Step 1 of 4

Connect PostgreSQL

Enter your PostgreSQL host, port, database, user and password. You only do this once per account.

Host••••••••••••
Port••••••••••••
Database••••••••••••
User••••••••••••
Password••••••••••••

Step 2 of 4

Choose what to export

Pick the PostgreSQL data you want in Copilot.

SchemaNot setProvide the schema of the PostgreSQL you want to use for export.
Table / ViewNot setSpecify which table or view you want to export.
SQL queryNot setEnter the SQL query used to select specific data from PostgreSQL.

Step 3 of 4

Connect Copilot

In Copilot Studio, add a Model Context Protocol tool to your agent with the Coupler.io MCP server URL from the destination step. Each user signs in to Coupler.io once.

Data set to shareTable or viewThe data view the agent can read
Coupler.io MCP server URLhttps://mcp.coupler.io/mcpShown in the destination step, paste in Copilot Studio
AuthenticationOAuth 2.0OAuth 2.0 with Dynamic discovery, no client secret

Step 4 of 4

Set a schedule

Copilot sees the data as of the last run. Run it as often as every 15 minutes.

Get the most of PostgreSQL to Copilot integration

Gather data icon

Gather data

Export data from numerous apps and sources into a single destination. Blend data from different apps to get a single source of truth.
Understand data icon

Understand data

Preview, transform, sort, and filter data for better clarity in just a few clicks in the Coupler.io interface. Take your data analytics to the next level.
Automate data icon

Automate data

Access data that is always up to date by enabling the automatic data refresh on a schedule as often as every 15 minutes and using triggered automation.
Act on data icon

Act on data

Visualize your data by quickly connecting to data visualization and BI tools. Build insightful dashboards in a breeze and make better decisions.
PostgreSQL to Copilot questions

2 report types, including Table or view and Custom SQL.

With your PostgreSQL host, port, database, user and password, entered once when you add the connection.

Yes. SQL query lets you write a query instead of picking a ready-made report type.

No. The data stays in Coupler.io, and Copilot queries it read-only when you ask a question. It can't edit or delete PostgreSQL rows.

Microsoft Copilot Studio. Add Coupler.io to your agent as an MCP tool, and the agent can query your PostgreSQL data.

On a schedule you choose, from monthly down to every 15 minutes, depending on your Coupler.io plan.

Yes. Add more sources to the same data flow, for example Google Sheets or Airtable, and join or append them before the data reaches Copilot.

High five for scrolling till the very end!
See you in the app!