# Set up Databases

Create 2 databases, care-db and metabase-db

1. SQL > Create instance > PostgreSQL ([link](https://console.cloud.google.com/sql/instances/create;engine=PostgreSQL))
2. Create instance for care:
   1. Instance ID: **care-db**
   2. Password: **\<use your own strong password>**
   3. Database version: **PostgreSQL 14**
   4. Cloud SQL edition: **Enterprise**
   5. Region: **asia-south1**
   6. Zonal availability: **Single zone**
   7. Click show zones
   8. Primary zone: **asia-south1-a**
   9. Click show configurations
   10. Machine configuration: **Dedicated core (2 vCPU, 8 GB)**
   11. Storage type: **SSD**
   12. Storage capacity: **20 GB**
   13. Enable automatic storage increases: **Enabled**
   14. Under connections, set
   15. Instance IP assignment: **Private IP**
       1. Associated networking: **care-vpc**
       2. If not presented with setup connection dialog, skip to p
       3. Select SET UP CONNECTION for setting up a private service connection and Click ENABLE API
       4. Select Use an automatically allocated IP range
       5. Click create connection
   16. Public IP: **Disabled**
   17. Under Data protection
   18. Automated backups: **Enabled**&#x20;
   19. automated backup window:  **2:30 AM - 6:30 AM**
   20. Enable point-in-time recovery: **Enabled**
   21. Days of logs: **7**
   22. Enable deletion protection: **Enabled**
   23. Maintenance window: **Sunday**
   24. Once the db instance is initialized, create a new database:
       1. Click on **care-db** > Databases > create database
       2. Enter the db name **care**
       3. Click create

Repeate the above steps for metabase-db with the following changes

1. Instance name: **metabase-db**
2. Machine configuration: **Dedicated core (1 vCPU, 3.75 GB)**
3. db name: **metabase**


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://deploydocs.coronasafe.network/cloud-deployment-overview/google-cloud-deployment/set-up-databases.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.