> ## Documentation Index
> Fetch the complete documentation index at: https://docs.celebratemercy.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Database

> Step-by-step guide for Accessing and Managing Data on Supabase for Salawat’s Site and Manifest Mercy

# Standard Operating Procedure (SOP) for Accessing and Managing Data on Supabase for Salawat’s Site and Manifest Mercy

***

## Overview

This SOP outlines the steps for accessing, managing, and exporting data associated with Salawat’s Site and Manifest Mercy using Supabase, a free and secure database platform.

***

## Scope

This SOP applies to administrators and developers responsible for managing data for Salawat’s Site and Manifest Mercy through Supabase.

***

## Responsibilities

* **Administrators**: Access and review database information as needed.
* **Developers**: Ensure data integrity and manage export processes.
* **Support Staff**: Provide guidance on data usage and analysis.

***

## Requirements

* Access to Supabase.
* GitHub credentials for `developer@celebratemercy.com`.
* Basic knowledge of table structures and data management.

***

## Process

### 1. Accessing Supabase

1. Navigate to [Supabase](https://supabase.com).
2. Click **Sign In** on the homepage.
3. Choose **Continue with GitHub**.
4. Log in using the GitHub credentials for the Salawat development account (`developer@celebratemercy.com`).
5. Once logged in, verify that you are on the homepage for Celebrate Mercy’s Supabase database.

***

### 2. Navigating the Supabase Interface

1. On the homepage, you will see two databases:
   * **Manifest Mercy**
   * **Salawat Site**
2. Click on the **Salawat Site** database to view data related to Salawat’s Site.

***

### 3. Using the Table Editor

1. Select the **Table Editor** tab to access and manage tables.
2. View the available tables, such as:
   * **Campaigns Table**: Contains data on all campaigns for Salawat’s Site.
   * **Organizations Table**: Contains data on organizations linked to the site.
   * **Pledges Table**: Includes all pledges made through the site.
   * **Settings Table**: Displays site configuration details.

***

### 4. Viewing and Editing Data

1. Select a table to view its contents, organized like a spreadsheet.
2. For minor updates:
   * Click on a cell to edit directly (e.g., update an organization’s logo by entering a new S3 bucket link).
3. Avoid making significant changes directly in the database unless necessary.
4. Use the Salawat Dashboard for most data updates to ensure consistency.

***

### 5. Understanding Table Relationships

1. **Campaigns Table**:
   * Contains campaign-specific data.
   * Links to other tables via the **campaign ID** column.
2. Example:
   * Data with campaign ID `1` in the **Pledges Table** corresponds to the campaign with ID `1` in the **Campaigns Table**.
3. Other tables reference this structure for organized data linkage.

***

### 6. Exporting Data

1. To export data:
   * Click the **Export** button in the top-left corner of the Supabase interface.
   * Choose the desired format (e.g., CSV, JSON) and save the exported file.
2. Use exported data for analysis, backup, or sharing as required.

***

### 7. Best Practices

#### **Avoid Direct Changes**

* Make changes through the Salawat Dashboard wherever possible to maintain data consistency.
* Direct database edits should only be performed for emergency fixes or advanced configurations.

#### **Backup Before Changes**

* Always export a backup of data before making significant modifications.

#### **Maintain Data Security**

* Restrict access to Supabase and ensure only authorized personnel can log in.

***

### 8. Key Features Summary

* **Salawat Site database**:
  * Campaigns, organizations, pledges, and settings data.
* **Manifest Mercy database**:
  * Separate dataset for additional projects.
* Data export capabilities for analysis or transfer.

***

## References

* [Supabase Official Website](https://supabase.com)
* Salawat Dashboard User Guide
* Database Management Documentation
* [Database Management Tutorial Video](https://www.loom.com/share/3ad9b194bef348b5bdb8bbf047ed1590?sid=0fae2b1d-5408-496a-9d7d-65d18c4d69ab)