Bonnard

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
FactMySQL / MariaDB
CredentialA read-only user
Port3306 by default
SSLrequire by default
NetworkA public hostname
TenancyNo tenancy

Requirements

  • The Editor role or higher in your Bonnard workspace.
  • To work from your AI client: Bonnard connected.
  • 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 addresses
CREATE USER 'mcp_reader'@'%' IDENTIFIED BY '<password>';

-- Run this once for each database you connect
-- SHOW VIEW lets agents read how each view is defined
GRANT SELECT, SHOW VIEW ON <database>.* TO 'mcp_reader'@'%';

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.

  1. Ask:

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

  2. Open the link that the agent gives.

  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 MySQL / MariaDB.

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.
MySQL / MariaDB connection fields
FieldEnter
Connection nameA name for this database, for example Production.
HostThe server’s public hostname. With verify-full, an IP address fails the certificate check.
Port3306, or your server’s port.
DatabaseThe database to read.
User and PasswordThe read-only user from step 1.
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.

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.

Charts in your AI client