# Show charts from your own database in Claude

> Connect your database to Claude through an MCP server you govern, and ask for your first chart.

Updated: 2026-10-12

Get a chart in Claude from your own data, through an MCP server only your team can use. You need a workspace:
[sign up](https://app.bonnard.ai/sign-up), with no card.

## Connect your database

> [!NOTE]
> Without a database of your own, add the [sample data](https://bonnard.ai/docs/connect-data/sample-data.md), an online shop's orders, in one click,
> then skip to [Create an app](#create-an-app).

1. In the console at `app.bonnard.ai`, select **Data**, then your engine, such as **PostgreSQL**.
2. Enter the connection details for a read-only user and select **Test & connect**. Each engine's page shows how to
   create the user, such as [PostgreSQL](https://bonnard.ai/docs/connect-data/postgresql.md) or [BigQuery](https://bonnard.ai/docs/connect-data/bigquery.md).
3. Select **No tenancy**, so everyone who connects sees the same data, then **Save & continue**.

[Image: The Available connections card: PostgreSQL, BigQuery, Redshift, ClickHouse, MySQL / MariaDB, and MSSQL under Databases, PostHog under Integrations, and Ecommerce under Demo data]

## Create an app

An app comes with an MCP server that you govern. Select **Apps**, then **+ New app**. Name it, choose your database,
and keep **Internal**, so only your team can connect. Select **Create & configure**.

[Image: The New app form with the name Acme analytics (sample), the Acme sample database, the Internal audience, and the Create & configure button]

## Publish it

Select **Publish** in the app's header to turn on its MCP server at the
[production URL](https://bonnard.ai/docs/apps/publish-and-staging.md). **Internal** still limits who can connect.

## Install it in Claude

On the **Overview** tab, open **More install options** next to the **Production** URL, select **Install in Claude**, and
confirm in Claude. Sign in to Bonnard if asked, then select **Authorize**. Your team installs it the same way. Other
clients: see [Install in AI clients](https://bonnard.ai/docs/apps/install-in-ai-clients.md).

[Image: The Authorize access page: claude.ai wants to connect to your Bonnard account, with a Verified origin badge, what it will be able to do, and the Deny and Authorize buttons]

## Ask Claude for a chart

Name the app and ask about your data. With the sample data, for example:

```prompt
Using Acme analytics, chart revenue by product category.
```

[Image: A conversation in an AI client: the question asking to chart revenue by product category, the Acme analytics (sample) app running Explore schema and Render chart, and a bar chart of revenue with Gadgets at 75,463, Parts at 68,547, Tools at 29,640, and Widgets at 26,962]

Claude wrote the SQL; Bonnard checked your access and ran it.

## See the call

Every call through your apps is recorded. Select **Observability**, then **Logs**: Claude's calls are at the top, with
the tool each used and its status.

## Related

- [Audience](https://bonnard.ai/docs/apps/audience.md): give your customers access.
- [Table curation](https://bonnard.ai/docs/connect-data/table-curation.md): choose which tables the agent finds.