Database

> A built-in relational database that integrates directly with your flows.

Brickr includes a fully managed relational database. You can create tables, define columns with typed data, and query data from your flows using database nodes -- all without setting up an external database.

What is the Brickr database?

The Brickr database is a relational data store built into every workspace. It supports:

• Tables with typed columns
• Unique row IDs for every record
• Relations between tables
• CRUD operations via visual nodes in the Builder
• A visual table editor in the dashboard for browsing and editing data

How it integrates with flows

Database operations are available as nodes in the Builder. You can:

• Insert rows from form submissions or API requests
• Select rows with filters and conditions
• Update specific records by row ID or condition
• Delete records
• Count matching rows
• Find one record matching a condition

These nodes plug directly into your flow, connecting inputs and outputs like any other node.

Managing tables

Navigate to Dashboard > Databases to view all your tables. From here you can:

• Create new tables
• Edit table schemas (add, rename, or remove columns)
• Browse and edit row data directly
• Import and export data

Changes to table schemas take effect immediately. Be careful when removing columns -- existing data in those columns will be lost.

What's next?

| Topic | Description | |-------|-------------| | Tables | Create tables and define columns | | Operations | Insert, select, update, and delete data | | Relations | Link tables together with foreign keys |