To analyse your MySQL or MariaDB data in Claude, ChatGPT or another AI client, connect it to Bonnard on the Data page. Then give people access to it.
MySQL / MariaDB at a glance
Fact
MySQL / MariaDB
Credential
A read-only user
Port
3306 by default
SSL
require by default
Network
A public hostname
Tenancy
No tenancy
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)mysql://user:password@host:3306/databaseFill fieldsHostdb.acme.internalPort (optional)3306DatabaseacmeUseracme_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)mysql://user:password@host:3306/databaseFill fieldsmysql://acme_reader:acme-demo-secret@db.acme.internal:3306/acmeFill fieldsFill fieldsHostdb.internalPort (optional)3306DatabaseUsermcp_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)mysql://user:password@host:3306/databaseFill fieldsFilled connection details from the string.Hostdb.acme.internalPort (optional)3306DatabaseacmeUseracme_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.AcmeOverviewOverviewCONFIGUREDataDataContextContextActivityActivityCustomersCustomersCONTENTChartsChartsDashboardsDashboardsSettingsSettingsConnect your AI clientConnect your AI clientAMAlex Morganalex@acme.exampleDataConnect a data sourceConnection nameAcme productionImport from connection string (optional)mysql://user:password@host:3306/databaseFill fieldsHostdb.acme.internalPort (optional)3306DatabaseacmeUseracme_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)mysql://user:password@host:3306/databaseFill fieldsmysql://acme_reader:acme-demo-secret@db.acme.internal:3306/acmeFill fieldsFill fieldsHostdb.internalPort (optional)3306DatabaseUsermcp_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)mysql://user:password@host:3306/databaseFill fieldsFilled connection details from the string.Hostdb.acme.internalPort (optional)3306DatabaseacmeUseracme_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.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.
A MySQL or MariaDB user that can create users and grant privileges.
1. Create a read-only user
Agents can query only the tables that this user can read.
SQL
-- A user that can log in, nothing more. '%' accepts any client address;-- a narrower host part must match Bonnard's IP addressesCREATE USER 'mcp_reader'@'%' IDENTIFIED BY '<password>';-- Run this once for each database you connect-- SHOW VIEW lets agents read how each view is definedGRANT SELECT, SHOW VIEW ON <database>.* TO 'mcp_reader'@'%';
Copied
Connect one data source for each database. The grant covers tables that you add to the database later.
2. Allow Bonnard’s IP addresses
If your database has an IP allowlist, add Bonnard’s IP addresses to it for port 3306. 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 MySQL database to Bonnard. The host is <host> and the user is mcp_reader.
Open the link that the agent gives.
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 MySQL / MariaDB.
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)mysql://user:password@host:3306/databaseFill fieldsHostdb.acme.internalPort (optional)3306DatabaseacmeUseracme_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)mysql://user:password@host:3306/databaseFill fieldsmysql://acme_reader:acme-demo-secret@db.acme.internal:3306/acmeFill fieldsFill fieldsHostdb.internalPort (optional)3306DatabaseUsermcp_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)mysql://user:password@host:3306/databaseFill fieldsFilled connection details from the string.Hostdb.acme.internalPort (optional)3306DatabaseacmeUseracme_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.AcmeOverviewOverviewCONFIGUREDataDataContextContextActivityActivityCustomersCustomersCONTENTChartsChartsDashboardsDashboardsSettingsSettingsConnect your AI clientConnect your AI clientAMAlex Morganalex@acme.exampleDataConnect a data sourceConnection nameAcme productionImport from connection string (optional)mysql://user:password@host:3306/databaseFill fieldsHostdb.acme.internalPort (optional)3306DatabaseacmeUseracme_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)mysql://user:password@host:3306/databaseFill fieldsmysql://acme_reader:acme-demo-secret@db.acme.internal:3306/acmeFill fieldsFill fieldsHostdb.internalPort (optional)3306DatabaseUsermcp_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)mysql://user:password@host:3306/databaseFill fieldsFilled connection details from the string.Hostdb.acme.internalPort (optional)3306DatabaseacmeUseracme_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.
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.
MySQL / MariaDB connection fields
Field
Enter
Connection name
A name for this database, for example Production.
Host
The server’s public hostname. With verify-full, an IP address fails the certificate check.
Port
3306, or your server’s port.
Database
The database to read.
User and Password
The read-only user from step 1.
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
Troubleshooting
Host resolves to a private or reserved address.
Use the public hostname. Host is a private or reserved address. has the same fix.
Couldn't reach <host>
Make sure that Host, Port and your allowlist (step 2) are correct.
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.
Couldn't set up a secure connection to <host>
If Show details gives Hostname/IP does not match certificate's altnames: <reason>, Host is an IP address and SSL mode is verify-full. Enter the hostname that the certificate names, or select verify-ca.
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.