Tech for RetailMeet us there
MyriadeMyriade

Connect ChatGPT to your PostgreSQL database

ChatGPT queries your PostgreSQL data through Myriade's MCP server: with business context, read-only, under each user's access rights.

Standard MCP · not tested by Myriade

Prerequisites

  • A Myriade account on app.myriade.ai (or on your self-hosted instance).
  • Network access from Myriade to PostgreSQL, with a read-only account.
  • ChatGPT, on a plan that allows custom MCP servers (see the note in step 2).

1. Connect PostgreSQL to Myriade

Host, port (5432 by default), database, user and password. Neon databases connect with their connection string alone, over TLS.

Best practice: use a dedicated role with CONNECT, USAGE on the schemas and SELECT on the tables, or the pg_read_all_data role.

2. Add Myriade to ChatGPT

ChatGPT connects to remote MCP servers added as custom apps. Full MCP support is in beta on the Business, Enterprise and Edu plans, on the web.

  1. 1Take the Myriade MCP address: https://app.myriade.ai/mcp.
  2. 2In ChatGPT, add a custom MCP server with this URL (through developer mode, depending on your workspace version).
  3. 3Choose OAuth, accept the warning, then sign in to Myriade.
https://app.myriade.ai/mcp

ChatGPT only accepts OAuth: myr_… tokens do not work there. On Business, an admin or owner turns the feature on.

Self-hosted Myriade (optional): replace app.myriade.ai with your instance's host.

3. Check the connection

Ask ChatGPT a few questions:

  • “Which tables describe customer orders in PostgreSQL?” The assistant searches the Myriade catalog before writing SQL.
  • “What was revenue by region last quarter?” Read-only SQL, run under your access rights, saved in Myriade.
  • “Did any alert fire on our KPIs this week?” The assistant reads Myriade's checks and alerts.

What Myriade enforces

  • INSERT, UPDATE, DELETE, DROP… blocked; a query that cannot be parsed is rejected
  • Maximum duration per query and a cap on concurrent queries
  • At most 50 rows returned to the assistant
  • Database visibility, team rules on tables and columns
  • Protected columns stay masked, including for the assistant
Why connect through Myriade

Frequently asked questions

Can ChatGPT modify or delete data in PostgreSQL?

No. SQL queries that ChatGPT sends through Myriade's MCP server are parsed before they reach PostgreSQL: any write (INSERT, UPDATE, DELETE, DROP…) is rejected, even nested in a subquery, and a query that cannot be parsed is refused. As a precaution, also connect Myriade to PostgreSQL with a read-only account.

Does ChatGPT connect directly to PostgreSQL?

No. ChatGPT only talks to Myriade's MCP server: Myriade alone holds the PostgreSQL credentials and runs the queries. On Myriade Cloud, the MCP address is public and Myriade must be able to reach PostgreSQL. If you choose to self-host Myriade, the connection to PostgreSQL starts from your own infrastructure, and the MCP address must stay reachable by ChatGPT.

Is ChatGPT compatible with Myriade?

ChatGPT supports remote MCP servers, and Myriade exposes a standard MCP server (Streamable HTTP, OAuth). Myriade has not tested this connection yet: tell us if you try it, we will help you set it up.

No Myriade account yet?

Book a demo to see Myriade on your own data.