---
metadata:
- name: generator
content: Diplodoc Platform v5.39.1
alternate:
- https://yandex.com.tr/support/forms/en/send-to-database.md
---
> **Documentation Index:** Fetch the complete configuration index at https://yandex.com.tr/support/forms/en/llms.txt
# Delivering responses to a database using Cloud Functions
You can send form responses to a PostgreSQL database created in Yandex Cloud and store them there.
## Step 1. Create a database
1. Go to the [Yandex Cloud management console](https://console.cloud.yandex.com) and select the folder where you want to create a database.
1. In the left-hand panel, click and select Managed Service for PostgreSQL.
1. In the top-right corner, click **Create cluster**.
1. Configure the cluster:
1. Under **Basic parameters**, fill in the **Cluster name** field. The name may contain uppercase and lowercase Latin letters, numbers, underscores, and hyphens.
1. Under **Database**, fill in the **DB name** and **Username** fields. The names may contain uppercase and lowercase Latin letters, numbers, underscores, and hyphens.
1. Under **Database**, fill in the **Password** field.
1. Under **Database**, set the **Locale for sorting (LC_COLLATE)** and **Charset locale (LC_CTYPE)** fields to **en_US.UTF8**. Once you create a database, you cannot change these parameters.
1. Under **Additional settings**, enable **Access from the management console** and **Serverless access**.
1. Configure other parameters if needed. For more information, see [{#T}](https://yandex.cloud/en/docs/managed-postgresql/operations/cluster-create).
1. Click **Create cluster**.
1. Wait until the new cluster's **Availability** field changes to **Alive**.
## Step 2. Create a table
1. Go to the page of the created cluster.
1. In the left-hand panel, click **SQL**.
1. Select the appropriate username and database, enter the password, and click **Connect**.
1. Select the **public** schema.
1. Run the following query in the SQL editor:
```sql
create table answers(
id serial primary key,
answer jsonb,
created timestamp with time zone default now()
);
```
## Step 3. Create a connection to the database
1. In the [management console](https://console.cloud.yandex.com), return to the folder with the new cluster.
1. In the left-hand panel, click and select Cloud Functions.
1. In the left-hand panel, click .
1. In the top-right corner, click **Create connection**.
1. Set up a connection:
1. Fill in the **Name** field. The name may only contain lowercase Latin letters, numbers, and hyphens.
1. In the **Type** field, select **PostgreSQL**.
1. Fill in the **Cluster**, **Database**, **User**, and **Password** fields. Enter the same field values as you set when creating your cluster in step 1.
1. Tap **Create**.
1. Go to the connection page and copy the **Entry point** field value.
## Step 4. Create a service account
1. In the [management console](https://console.cloud.yandex.com), return to the folder with the new cluster.
1. In the top-right corner, click → **Create service account**.
1. In the service account creation window, fill in the following fields:
1. **Name**; it may only contain lowercase Latin letters, numbers, and hyphens.
1. **Description**; it may contain any characters.
1. In the **Roles in folder** field, add the following roles:
* `serverless.functions.invoker`
* `serverless.mdbProxies.user`
1. Tap **Create**.
## Step 5. Create a service account key
1. In the [management console](https://console.cloud.yandex.com), return to the folder with the new cluster.
1. Go to the **Service accounts** tab.
1. Select the account you need.
1. In the top panel on the account page, click **Create new key** → **Create API key**.
1. Provide a brief description for the key.
1. Tap **Create**.
1. This will open a window with the key ID and the secret key. Store them in a secure place. You will not be able to access them after you close the window.
## Step 6. Create a cloud function
1. In the [management console](https://console.cloud.yandex.com), return to the folder with the new cluster.
1. In the left-hand panel, click and select Cloud Functions.
1. In the top-right corner, click **Create function**.
1. On the function creation page, fill in the following fields:
1. **Name**; it may only contain lowercase Latin letters, numbers, and hyphens.
1. **Description**; it may contain any characters.
1. Select the Python programming language.
1. Create a file named `requirements.txt` and add the following line to it:
```
psycopg2
```
1. Create or edit a file named `index.py`:
```python
import json
import psycopg2
def run_function(connection, answer, **params) -> int:
data ={
'answer': answer,
'params': params,
}
args = (json.dumps(data), )
with connection.cursor() as c:
c.execute('insert into answers(answer) values(%s) returning id', args)
rs = c.fetchone()
connection.commit()
return rs[0]
def get_connection(context):
return psycopg2.connect(
database="",
user="",
password=context.token["access_token"],
host="",
port=6432,
sslmode="require",
)
def handler(event, context):
body = json.loads(event.get('body'))
params ={
name: value
for name, value in body.items()
if name != 'answer'
}
connection = get_connection(context)
result ={
'id': run_function(connection, body.get('answer'), **params),
}
return{
'statusCode': 200,
'body': result,
'headers':{
'Content-Type': 'application/json',
}
}
```
Substitute the following values in this function:
* ``: Value of the **ID** field of the database connection you created in step 3. You can copy it on the connection page.
* ``: Database user name that you specified in the cluster settings in step 1. You can find it in the **Users** tab on the cluster page.
* ``: Value of the **Entry point** field of the database connection you created in step 3. You can copy it on the connection page.
1. Click **Save changes**.
1. On the function page, copy the value from the **ID** field.
## Step 7. Set up integration
1. Go to the form whose responses you want to deliver to the database and select the **Integrations** tab.
1. Select a group of actions to set up issue creation in and click Cloud Functions at the bottom of the group.
1. In the **Function code** field, paste the function ID that you copied in the previous step.
1. Under **Parameters**, you can optionally select additional parameters to be transferred to the function.
1. Click **Save**.
From now on, all responses from this form will be additionally saved to your database in the **answers** table.
{% include [style](https://yandex.com.tr/support/forms/en/_assets/style-a13ddc9841bc.md) %}