Storage bucket
Confirm that the public bucket construction-photos exists in Storage.
INSERT INTO storage.buckets (id, name, public)
VALUES ('construction-photos', 'construction-photos', true);Deployment tab
Supabase database deployment guide.
Follow this checklist to deploy tables, policies, triggers, storage and test data for ConstructManager.
-
Create a Supabase project
Open Supabase, choose New project, set a strong database password and select the closest region.
-
Deploy database schema
Go to the SQL files tab, open deploy.sql, copy the entire content and run it in Supabase SQL Editor. This creates all tables, security policies, storage rules and triggers.
-
Enable Email authentication
Go to Authentication → Providers and enable Email. Add Site URL and Redirect URLs if OAuth is used.
-
Copy API credentials
In your Supabase dashboard go to Project Settings → Data API. Copy Project URL and anon public key, then paste them in the ConstructManager settings screen.
- Open Project Settings (gear icon in the bottom-left sidebar) → Data API tab.
- Project URL — the first field at the top of the page. It is not the browser URL; it looks like:
https://ejyesfvyhdguhgbuvrzv.supabase.co
Copy onlyhttps://ejyesfvyhdguhgbuvrzv.supabase.co— omit the/rest/v1suffix, the client adds it automatically. - anon public key — in the Project API keys section, the row labelled anon public.
eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6In...
Recommended: deploy all at once
This single file contains the complete database. Open Supabase SQL Editor, create a new query, paste the entire content below and press Run.
Optional realtime
Enable realtime for constructions, budgets and schedules if live synchronization is required.
alter publication supabase_realtime add table constructions;
alter publication supabase_realtime add table budgets;
alter publication supabase_realtime add table schedules;Run verification queries
SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'public';
SELECT trigger_name, event_object_table
FROM information_schema.triggers
WHERE trigger_schema = 'public';Troubleshooting
- relation already existsThe script was already executed; continue if the schema is correct.
- RLS blocks requestsCheck that 002-rls.sql ran and the current user owns the project rows.
- Seed has no usersCreate matching auth.users first or skip 005-seed.sql in production.