The Data Model is where you design your app’s database schema, define relationships, and configure data validation. Every change is published in real time and stays in sync with the auto-generated GraphQL and REST APIs that your frontend and integrations consume.Documentation Index
Fetch the complete documentation index at: https://archie.com/docs/llms.txt
Use this file to discover all available pages before exploring further.
What lives in the Data Model
The Data Model sidebar groups the schema into three item types:| Item type | What it is | Where to learn more |
|---|---|---|
| Tables | The standard database tables that store your records. | Tables |
| Views | Virtual tables defined by a saved SQL SELECT query. | Views |
| Data Types | Reusable named enums you can apply to fields across tables. | Data Types |
The two tabs on every table
When you open a table, you switch between two tabs:- Schema — the visual schema designer. Add and remove fields, configure validation, define relationships, and create indexes. See Tables and Fields.
- Data — a spreadsheet-style viewer for the records inside the table. Add, edit, filter, sort, import, and export rows. See Data Viewer.
Auto-generated APIs
Every table and view in the Data Model is automatically exposed through:- A GraphQL API with type-safe queries, mutations, and real-time subscriptions. See the GraphQL API Explorer.
- A REST API with CRUD endpoints per table. See the REST API Explorer.
Schema is stored as structured JSON
The Data Model is persisted as a structured JSON representation of your schema, not flat SQL files. Code generation reads from this representation so the rest of your project — types, queries, validation — stays in sync. You configure the model through the UI; you don’t edit raw SQL files.Permissions live elsewhere
Per-table access control is not configured inside the Data Model. Every table is governed by role-based permissions defined in App Services → Role-Based Access. See Role-Based Access.Where to go next
Tables
Create, rename, and delete tables.
Fields
The 9 field types and their configuration options.
Data Types
Reusable enums shared across tables.
Views
Virtual tables defined by a SQL query.
Indexes
Speed up lookups and enforce uniqueness.
Relationships
Foreign keys and cardinality between tables.
Data Viewer
Browse and edit records.
Importing & exporting
Move data in and out via CSV.
FAQ
Do I need to write SQL to use the Data Model?
Do I need to write SQL to use the Data Model?
No. You design tables, fields, relationships, and indexes through the visual UI. The only place SQL is required is when you create a View, which is defined by a saved
SELECT query.What database is Archie running under the hood?
What database is Archie running under the hood?
Each workspace gets a dedicated PostgreSQL database. The Data Model maps directly to PostgreSQL tables, columns, indexes, and enum types.
Where do I configure who can read or write each table?
Where do I configure who can read or write each table?
Permissions live in App Services → Role-Based Access, not in the Data Model. The Data Model defines the shape of your data; Role-Based Access governs which user types can read, write, or administer it.
Do I have to update my GraphQL or REST endpoints when I change the schema?
Do I have to update my GraphQL or REST endpoints when I change the schema?
No. Both APIs are generated from the Data Model and refresh automatically whenever the schema changes.
Can I edit the schema as raw SQL files in my repo?
Can I edit the schema as raw SQL files in my repo?
No. The schema is stored as structured JSON, not SQL files. Use the Data Model UI to make changes — code generation and the auto-generated APIs read from that representation.