> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/data-pipeline-2/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/data-pipeline-2/getting-started/homepage/create/creating-a-new-job/task-components/writers/db-writer.md).

# DB Writer

This task is used to write data in the following databases: ***MYSQL, MSSQL, Oracle, ClickHouse, Snowflake, PostgreSQL***.

**Please go through the below given steps to configure DB Writer:**

<figure><img src="https://content.gitbook.com/content/q2i9CKCFbySxr6jRoJfA/blobs/GzKqvsgSJQDKJjDOdjKk/image.png" alt=""><figcaption><p>DB Writer Task</p></figcaption></figure>

* **Host IP Address:** Enter the Host IP Address for the selected driver.
* **Port:** Enter the port for the given IP Address.
* **Database name:** Enter the Database name.
* **Table name:** Provide a single or multiple table names. If multiple table name has be given, then enter the table names separated by comma(,)**.**
* **User name:** Enter the user name for the provided database.
* **Password:** Enter the password for the provided database.
* **Driver:** Select the driver from the drop down. There are 6 drivers supported here: ***MYSQL, MSSQL, Oracle, ClickHouse, Snowflake, PostgreSQL***.
* **Schema File Name:** Upload spark schema file in JSON format.
* **Save Mode:** Select the Save mode from the drop down.
  * Append
  * Overwrite
* **Query:** Write the create table query.