Metabase_

Appwrite's native MySQL database is a standard MySQL engine, so Metabase can connect to it without an Appwrite-specific adapter. Add the database in Metabase, use the host and credentials from the Connections page, and Metabase will sync the schema so your team can build questions and dashboards.

Choose credentials for Metabase

Metabase connects with the MySQL user you provide. Use the least-privilege MySQL account available for analytics. A reporting account typically needs SELECT on the tables and views Metabase should query. The primary admin user returned by Appwrite can read and write data and schema, so reserve it for trusted Metabase instances.

Metabase features such as model actions and editable table data need write privileges. Enable them only on a connection whose MySQL account has the specific write permissions that workflow needs.

Add the database in Metabase

In Metabase, click the grid icon, then open Admin > Databases > Add a database. Choose MySQL as the database type and fill in the connection form with the values from the Connections page.

Turn on Use a secure connection (SSL). Appwrite Cloud requires TLS for native MySQL connections on the public hostname. If your Metabase deployment needs an explicit certificate chain, add it in Metabase's SSL certificate field. See Network security for Appwrite TLS and network controls.

Click Save changes. Metabase verifies the connection and starts its first schema sync.

Build a question or dashboard

Once the first sync finishes, your tables appear in the data picker. To build your first chart:

1. Click + New > Question and pick your Appwrite MySQL database as the data source.
2. Choose a table, add a summary such as count, sum, or average, and group by a column such as a timestamp.
3. Switch the visualization to a line, bar, or table view, then save the question.
4. Add saved questions to a dashboard and use filters to slice data across cards.

Use read-only native SQL questions for analytics dashboards. If the connection uses admin, use Metabase permissions to limit who can run native SQL or enable write-capable features.

How Metabase syncs your schema

After you connect, Metabase scans the database to discover tables, columns, constraints, and field metadata, then keeps that metadata current on a schedule:

• A lightweight schema sync runs hourly by default.
• A more intensive field-value scan runs daily by default to populate filter dropdowns.

New tables and columns appear after the next sync. To pull them in immediately, open Admin > Databases > your database and click Sync database schema. You can also restrict which schemas Metabase tracks and adjust the sync and scan cadence from the database settings. Refer to the Metabase documentation for the full set of sync and scan options.

Use a branch for testing

Branches are isolated copies of a native MySQL database with their own host and credentials. Point a second Metabase database connection at a branch when you want to validate a dashboard against a snapshot of production data without querying the live database. Branches are managed through the API, and you can delete the branch when testing is complete.

Related