AcmeOverviewOverviewCONFIGUREDataDataContextContextActivityActivityCustomersCustomersCONTENTChartsChartsDashboardsDashboardsSettingsSettingsConnect your AI clientConnect your AI clientAMAlex Morganalex@acme.exampleDataAdd data sourceAdd data sourceData sources (2)Acme productionPostgreSQL · No tenancyConnectedAcme productionPostgreSQL · No tenancyConnectedAcme warehouseClickHouse · No tenancyConnectedData sources (1)Acme warehouseClickHouse · No tenancyConnectedData sources (2)Acme productionPostgreSQL · setup not finishedConnection test failedContinue setupAcme warehouseClickHouse · No tenancyConnectedNo data sources yet. Add a database or an integration to start asking questions about it.AcmeOverviewOverviewCONFIGUREDataDataContextContextActivityActivityCustomersCustomersCONTENTChartsChartsDashboardsDashboardsSettingsSettingsConnect your AI clientConnect your AI clientAMAlex Morganalex@acme.exampleDataAdd a data sourceSearch, e.g. Postgres, BigQuery or PostHogDATABASES AND WAREHOUSESPostgreSQLIncluding Supabase, Neon and RDSPostgreSQLIncluding Supabase, Neon and RDSBigQueryGoogle Cloud data warehouseAmazon RedshiftAmazon data warehouseClickHouseSelf-hosted or ClickHouse CloudDuckDB / MotherDuckHosted DuckDBMySQL / MariaDBIncluding PlanetScale and RDSMicrosoft SQL ServerIncluding Azure SQLINTEGRATIONSPostHogProduct analyticsPostHogProduct analyticsAdd a data source1Source2Connect3DoneRead-onlyBonnard only reads your data.Connection details areencrypted at rest.AcmeOverviewOverviewCONFIGUREDataDataContextContextActivityActivityCustomersCustomersCONTENTChartsChartsDashboardsDashboardsSettingsSettingsConnect your AI clientConnect your AI clientAMAlex Morganalex@acme.exampleDataAdd a data sourceSearch, e.g. Postgres, BigQuery or PostHogDATABASES AND WAREHOUSESPostgreSQLIncluding Supabase, Neon and RDSPostgreSQLIncluding Supabase, Neon and RDSBigQueryGoogle Cloud data warehouseAmazon RedshiftAmazon data warehouseClickHouseSelf-hosted or ClickHouse CloudDuckDB / MotherDuckHosted DuckDBMySQL / MariaDBIncluding PlanetScale and RDSMicrosoft SQL ServerIncluding Azure SQLINTEGRATIONSPostHogProduct analyticsPostHogProduct analyticsAdd a data source1Source2Connect3DoneRead-onlyBonnard only reads your data.Connection details areencrypted at rest.AcmeOverviewOverviewCONFIGUREDataDataContextContextActivityActivityCustomersCustomersCONTENTChartsChartsDashboardsDashboardsSettingsSettingsConnect your AI clientConnect your AI clientAMAlex Morganalex@acme.exampleDataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackTesting connection...BackAdd a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldspostgresql://acme_reader:acme-demo-secret@db.acme.internal:5432/acmeFill fieldsFill fieldsHostdb.internalPort (optional)5432DatabaseUsermcp_readerPasswordenter secret valueEncrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackAdd a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsFilled connection details from the string.Hostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackTesting connection...BackAdd a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceCouldn't reach db.acme.internalCheck the host name and port. If the database is behind a firewall, allow Bonnard's IP addresses.Reach hostSign in (not run)Read tables (not run)Show detailsConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectExit setupYour progress is saved. You can come back to this any time.Add a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackTesting connection...BackAdd a data sourceSource2Connect3DoneStarted from ClaudeWhen you're connected, we'llshow you how to get back toyour chat.Need help?Setup guideConnection details areencrypted at rest.Connected to ClaudeConnected to ClaudeDataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPasswordenter secret valueEncrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectExit setupYour progress is saved. You can come back to this any time.Add a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.AcmeOverviewOverviewCONFIGUREDataDataContextContextActivityActivityCustomersCustomersCONTENTChartsChartsDashboardsDashboardsSettingsSettingsConnect your AI clientConnect your AI clientAMAlex Morganalex@acme.exampleDataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackTesting connection...BackAdd a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldspostgresql://acme_reader:acme-demo-secret@db.acme.internal:5432/acmeFill fieldsFill fieldsHostdb.internalPort (optional)5432DatabaseUsermcp_readerPasswordenter secret valueEncrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackAdd a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsFilled connection details from the string.Hostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackTesting connection...BackAdd a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceCouldn't reach db.acme.internalCheck the host name and port. If the database is behind a firewall, allow Bonnard's IP addresses.Reach hostSign in (not run)Read tables (not run)Show detailsConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectExit setupYour progress is saved. You can come back to this any time.Add a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackTesting connection...BackAdd a data sourceSource2Connect3DoneStarted from ClaudeWhen you're connected, we'llshow you how to get back toyour chat.Need help?Setup guideConnection details areencrypted at rest.Connected to ClaudeConnected to ClaudeDataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPasswordenter secret valueEncrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectExit setupYour progress is saved. You can come back to this any time.Add a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.AcmeOverviewOverviewCONFIGUREDataDataContextContextActivityActivityCustomersCustomersCONTENTChartsChartsDashboardsDashboardsSettingsSettingsConnect your AI clientConnect your AI clientAMAlex Morganalex@acme.exampleDataAcme productionAcme production is connectedOnly admins can use it so far.Try it in your AI clientUsing Bonnard's Acme production, what data do I have and what are three questions I could ask?CopyGive accessGive accessOpen Acme production Add a data sourceSourceConnectDoneNeed help?Setup guideConnection details areencrypted at rest.DataAcme productionAcme production is connectedYou can close this tab and carry on in Claude. It can use Acme production straight away.Open Acme production Add a data sourceSourceConnectDoneNeed help?Setup guideConnection details areencrypted at rest.Connected to ClaudeConnected to ClaudeAcmeOverviewOverviewCONFIGUREDataDataContextContextActivityActivityCustomersCustomersCONTENTChartsChartsDashboardsDashboardsSettingsSettingsConnect your AI clientConnect your AI clientAMAlex Morganalex@acme.exampleDataAcme productionAcme production is connectedOnly admins can use it so far.Try it in your AI clientUsing Bonnard's Acme production, what data do I have and what are three questions I could ask?CopyGive accessGive accessOpen Acme production Add a data sourceSourceConnectDoneNeed help?Setup guideConnection details areencrypted at rest.DataAcme productionAcme production is connectedYou can close this tab and carry on in Claude. It can use Acme production straight away.Open Acme production Add a data sourceSourceConnectDoneNeed help?Setup guideConnection details areencrypted at rest.Connected to ClaudeConnected to Claude
Requirements
The Editor role or higher in your Bonnard workspace.
Agents can query only the tables that this user can read.
SQL
-- A user that can log in and read, nothing moreCREATE ROLE mcp_reader LOGIN PASSWORD '<password>' NOSUPERUSER NOCREATEDB NOCREATEROLE NOBYPASSRLS;-- Run these two lines once for each schema agents should queryGRANT USAGE ON SCHEMA <schema> TO mcp_reader;GRANT SELECT ON <schema>.<table_1>, <schema>.<table_2> TO mcp_reader;
Copied
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.
Ask:
Connect my PostgreSQL database to Bonnard. The host is <host> and the user is mcp_reader.
Open the link that the agent gives. The form opens with the details you gave.
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.
AcmeOverviewOverviewCONFIGUREDataDataContextContextActivityActivityCustomersCustomersCONTENTChartsChartsDashboardsDashboardsSettingsSettingsConnect your AI clientConnect your AI clientAMAlex Morganalex@acme.exampleDataAdd a data sourceSearch, e.g. Postgres, BigQuery or PostHogDATABASES AND WAREHOUSESPostgreSQLIncluding Supabase, Neon and RDSPostgreSQLIncluding Supabase, Neon and RDSBigQueryGoogle Cloud data warehouseAmazon RedshiftAmazon data warehouseClickHouseSelf-hosted or ClickHouse CloudDuckDB / MotherDuckHosted DuckDBMySQL / MariaDBIncluding PlanetScale and RDSMicrosoft SQL ServerIncluding Azure SQLINTEGRATIONSPostHogProduct analyticsPostHogProduct analyticsAdd a data source1Source2Connect3DoneRead-onlyBonnard only reads your data.Connection details areencrypted at rest.AcmeOverviewOverviewCONFIGUREDataDataContextContextActivityActivityCustomersCustomersCONTENTChartsChartsDashboardsDashboardsSettingsSettingsConnect your AI clientConnect your AI clientAMAlex Morganalex@acme.exampleDataAdd a data sourceSearch, e.g. Postgres, BigQuery or PostHogDATABASES AND WAREHOUSESPostgreSQLIncluding Supabase, Neon and RDSPostgreSQLIncluding Supabase, Neon and RDSBigQueryGoogle Cloud data warehouseAmazon RedshiftAmazon data warehouseClickHouseSelf-hosted or ClickHouse CloudDuckDB / MotherDuckHosted DuckDBMySQL / MariaDBIncluding PlanetScale and RDSMicrosoft SQL ServerIncluding Azure SQLINTEGRATIONSPostHogProduct analyticsPostHogProduct analyticsAdd a data source1Source2Connect3DoneRead-onlyBonnard only reads your data.Connection details areencrypted at rest.
4. Test and connect
In the console
Console only
Enter a Connection name. Then enter the user’s details from the table below.AcmeOverviewOverviewCONFIGUREDataDataContextContextActivityActivityCustomersCustomersCONTENTChartsChartsDashboardsDashboardsSettingsSettingsConnect your AI clientConnect your AI clientAMAlex Morganalex@acme.exampleDataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackTesting connection...BackAdd a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldspostgresql://acme_reader:acme-demo-secret@db.acme.internal:5432/acmeFill fieldsFill fieldsHostdb.internalPort (optional)5432DatabaseUsermcp_readerPasswordenter secret valueEncrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackAdd a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsFilled connection details from the string.Hostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackTesting connection...BackAdd a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceCouldn't reach db.acme.internalCheck the host name and port. If the database is behind a firewall, allow Bonnard's IP addresses.Reach hostSign in (not run)Read tables (not run)Show detailsConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectExit setupYour progress is saved. You can come back to this any time.Add a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackTesting connection...BackAdd a data sourceSource2Connect3DoneStarted from ClaudeWhen you're connected, we'llshow you how to get back toyour chat.Need help?Setup guideConnection details areencrypted at rest.Connected to ClaudeConnected to ClaudeDataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPasswordenter secret valueEncrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectExit setupYour progress is saved. You can come back to this any time.Add a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.AcmeOverviewOverviewCONFIGUREDataDataContextContextActivityActivityCustomersCustomersCONTENTChartsChartsDashboardsDashboardsSettingsSettingsConnect your AI clientConnect your AI clientAMAlex Morganalex@acme.exampleDataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackTesting connection...BackAdd a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldspostgresql://acme_reader:acme-demo-secret@db.acme.internal:5432/acmeFill fieldsFill fieldsHostdb.internalPort (optional)5432DatabaseUsermcp_readerPasswordenter secret valueEncrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackAdd a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsFilled connection details from the string.Hostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackTesting connection...BackAdd a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceCouldn't reach db.acme.internalCheck the host name and port. If the database is behind a firewall, allow Bonnard's IP addresses.Reach hostSign in (not run)Read tables (not run)Show detailsConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectExit setupYour progress is saved. You can come back to this any time.Add a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.DataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPassword••••••••••••••••Encrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectTest and connectBackTesting connection...BackAdd a data sourceSource2Connect3DoneStarted from ClaudeWhen you're connected, we'llshow you how to get back toyour chat.Need help?Setup guideConnection details areencrypted at rest.Connected to ClaudeConnected to ClaudeDataConnect a data sourceConnection nameAcme productionImport from connection string (optional)postgresql://user:password@host:5432/databaseFill fieldsHostdb.acme.internalPort (optional)5432DatabaseacmeUseracme_readerPasswordenter secret valueEncrypted at rest.Advanced: SSL mode, CA certificateAllow our IP addressesIf your database is firewalled, allowlist these egress IPs so we can reach it:34.187.7.127These addresses are stable. We will give advance notice before any change.Test and connectExit setupYour progress is saved. You can come back to this any time.Add a data sourceSource2Connect3DoneNeed help?Setup guideConnection details areencrypted at rest.
If you have a connection string, paste it into Import from connection string (optional). Then select
Fill fields.
Select Test and connect. Bonnard signs in as the user and reads its tables.
PostgreSQL connection fields
Field
Enter
Connection name
A name for this database in Bonnard, for example Production.
Host
The server’s public hostname or IP address.
Port
5432, unless your server listens on another port.
Database
The database to read.
User and Password
The read-only user from step 1, for example mcp_reader.
SSL mode
Under 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.
AcmeOverviewOverviewCONFIGUREDataDataContextContextActivityActivityCustomersCustomersCONTENTChartsChartsDashboardsDashboardsSettingsSettingsConnect your AI clientConnect your AI clientAMAlex Morganalex@acme.exampleDataAcme productionAcme production is connectedOnly admins can use it so far.Try it in your AI clientUsing Bonnard's Acme production, what data do I have and what are three questions I could ask?CopyGive accessGive accessOpen Acme production Add a data sourceSourceConnectDoneNeed help?Setup guideConnection details areencrypted at rest.DataAcme productionAcme production is connectedYou can close this tab and carry on in Claude. It can use Acme production straight away.Open Acme production Add a data sourceSourceConnectDoneNeed help?Setup guideConnection details areencrypted at rest.Connected to ClaudeConnected to ClaudeAcmeOverviewOverviewCONFIGUREDataDataContextContextActivityActivityCustomersCustomersCONTENTChartsChartsDashboardsDashboardsSettingsSettingsConnect your AI clientConnect your AI clientAMAlex Morganalex@acme.exampleDataAcme productionAcme production is connectedOnly admins can use it so far.Try it in your AI clientUsing Bonnard's Acme production, what data do I have and what are three questions I could ask?CopyGive accessGive accessOpen Acme production Add a data sourceSourceConnectDoneNeed help?Setup guideConnection details areencrypted at rest.DataAcme productionAcme production is connectedYou can close this tab and carry on in Claude. It can use Acme production straight away.Open Acme production Add a data sourceSourceConnectDoneNeed help?Setup guideConnection details areencrypted at rest.Connected to ClaudeConnected to Claude
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.