Bonnard

To analyse your Postgres data in Claude, ChatGPT or another AI client, connect it to Bonnard on the Data page. Then give people access to it.

PostgreSQL at a glance
FactPostgreSQL
CredentialA read-only user
Port5432 by default
SSLrequire by default
NetworkA public hostname or IP address, reached from Bonnard’s IP addresses
TenancyNone or Row-level security

Requirements

  • The Editor role or higher in your Bonnard workspace.
  • To work from your AI client: Bonnard connected.
  • A PostgreSQL login that can create roles.

1. Create a read-only user

Agents can query only the tables that this user can read.

SQL

-- A user that can log in and read, nothing more
CREATE ROLE mcp_reader LOGIN PASSWORD '<password>'
  NOSUPERUSER NOCREATEDB NOCREATEROLE NOBYPASSRLS;

-- Run these two lines once for each schema agents should query
GRANT USAGE ON SCHEMA <schema> TO mcp_reader;
GRANT SELECT ON <schema>.<table_1>, <schema>.<table_2> TO mcp_reader;

Grant tables that you add later the same way.

2. Allow Bonnard’s IP addresses

If your database has an IP allowlist, add Bonnard’s IP addresses to it for port 5432. Bonnard cannot reach databases on a private network.

3. Start the connection

In your AI client

The agent offers a form link only while the workspace has no data source, or only the sample.

  1. Ask:

    Connect my PostgreSQL database to Bonnard. The host is <host> and the user is mcp_reader.

  2. Open the link that the agent gives. The form opens with the details you gave.

  3. Enter the password in the form. Never put it in the chat.

In the console

In the console at app.bonnard.ai, select Data, then Add data source, then PostgreSQL.

4. Test and connect

In the console

Console only
  1. Enter a Connection name. Then enter the user’s details from the table below.
  2. If you have a connection string, paste it into Import from connection string (optional). Then select Fill fields.
  3. Select Test and connect. Bonnard signs in as the user and reads its tables.
PostgreSQL connection fields
FieldEnter
Connection nameA name for this database in Bonnard, for example Production.
HostThe server’s public hostname or IP address.
Port5432, unless your server listens on another port.
DatabaseThe database to read.
User and PasswordThe read-only user from step 1, for example mcp_reader.
SSL modeUnder Advanced. require, the default, encrypts without validating the certificate. verify-full validates it and the hostname, verify-ca only the certificate. Use disable only for a server with no TLS. For a private CA, for example Amazon RDS, paste its bundle into CA certificate (PEM).

A failed test keeps a draft without the password. Select Continue setup on its card on the Data page. While no data source is connected, the agent also gives a resume link. Exit setup removes it. A refused host or a deleted data source’s name keeps no draft.

Make sure that it is connected

In your AI client

Ask:

Which tables can you read in <connection name>?

The agent calls explore_schema and shows the tables. An Editor first adds themselves on the Access tab.

In the console

A setup started in the console shows <name> is connected and who can use it. Select Give access to change that.

Set tenancy

In the console

Console only

A new data source starts with None. To change it, select the data source’s Tenancy tab. See Tenancy.

Troubleshooting

Host resolves to a private or reserved address.

Use a public hostname or IP address. Host is a private or reserved address. has the same fix.

Couldn't reach <host>

Make sure that Host and Port are correct and that Bonnard’s IP addresses are on your allowlist (step 2).

Signed in, but couldn't read the tables

The user cannot read the table list. Select Show details for the database’s own message.

A table is missing

Grant SELECT on it. Then select Re-scan tables on the data source’s Settings tab.

Change or remove

In the console

Console only

On the data source’s Settings tab:

  • Edit connection changes the connection details.
  • Re-scan tables reads the table list now. Bonnard reads it at approximately 6-hour intervals.
  • Delete data source needs the Admin role. Select Delete, then Delete data source. Its dashboards and charts stop running until you connect one with the same name and engine. Then give access again.

To rename the data source, select its name in the page header.

Charts in your AI client