Cloud Sync

Version 1.0.52

AmCEO Cloud Database Schema

Last updated: August 2026

Set up your own Supabase database to sync AmCEO data securely to the cloud. Run this SQL once in your Supabase project and AmCEO will handle the rest. Cloud Sync covers all 12 modules — your complete business data in a database you own, with 66 tables documented for licensed customers.

66

Tables

12

Modules covered

Cloud Sync v1.0.52+

Compatible with

Current Cloud Sync SQL covers all 12 modules with a documented schema (66 tables). Your complete business data syncs into a Supabase project you own and control. Sensitive personal identifiers stay on your device by design. The script is safe to re-run.

Download SQL

How to set up Cloud Sync

  1. 1

    Create a free project at supabase.com

    Open Supabase
  2. 2

    In your Supabase dashboard, open SQL Editor

  3. 3

    Click "Download SQL" above and paste it into the SQL Editor, then click Run (safe to run more than once)

  4. 4

    Copy your Project URL and anon key from Supabase → Settings → API

  5. 5

    In AmCEO: Settings → Deployment → Cloud Sync → Enter your credentials

Modules

Modules covered

Businesses & TeamFinance & FP&AHR & PayrollInventorySupply ChainAssetsCRMMarketingHelpdeskPOSTasks & ProjectsLegal

Full schema documentation

The complete Cloud Sync schema — every table and setup statement — is fully documented and available for review once you sign in with your license email. Publicly we share what matters for trust: you own the database, all 12 modules are covered, and sensitive personal identifiers stay on your device.

API

API Reference

Version metadata is public. Full SQL download requires a customer portal session (sign in with your license email).

GET/api/schema/latest

Full schema JSON with SQL, checksum, and modules (requires portal sign-in)

GET/api/schema/version

Version info and changelog (public)

GET/api/schema/download

Download raw SQL file (requires portal sign-in)

History

Changelog

This schema is provided as-is. AmCEO stores your data in YOUR Supabase project — we do not have access to your business data.