Database > Sync Database
Sync a database's schema in Draxlr to pick up new or changed tables and columns, choose schemas again, and learn about the weekly automatic sync.
Draxlr keeps a copy of your database's schema, its tables, columns and their types, to build queries and suggest fields. Sync the database when you add or change tables or columns, so Draxlr sees the changes.
Syncing reads only the schema. Draxlr runs live queries on your database and doesn't store your data.
Open Database Settings
Pick the database in the database menu at the top left. Then open Settings at the top right and choose Database Settings.
Click Sync Schema
Under Sync Database Schema, click Sync Schema. Last Synced shows when the database was last synced.
Confirm, or choose schemas
For most databases, Draxlr asks Sync schema changes?. Click Sync.
For databases with schemas, Select Schemas opens first. Choose the schemas to use in Draxlr, click Next, then confirm with Sync. This is also how you add or remove schemas after connecting.
While the sync runs, Last Synced shows Sync in progress.
Automatic sync
On paid and trial plans, Draxlr also syncs each database automatically once a week, early on Sunday (UTC). Databases with a connection error aren't synced until the error is fixed.
Things to know
- Only admins and members with Full access can sync a database.
- If a table or column you use in a saved query is removed from the database, that query shows an error until you update it.