# Heroku with aws lightsail \[Mar 31\]

**URL:** <https://community.nocodb.com/t/heroku-with-aws-lightsail-mar-31/257>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 8:13am UTC](https://community.nocodb.com/t/heroku-with-aws-lightsail-mar-31/257 "2022-11-03T08:13:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:13am UTC](https://community.nocodb.com/t/heroku-with-aws-lightsail-mar-31/257/1 "2022-11-03T08:13:39Z")

</div>

> 🙋‍♂️ **coromandel** _asked_

## hi, just started on Nocodb looks great. Once click install on Heroku nice. Now I’m stuck, how possible to pipe Heroku into AWS Lightsail MySQL database?

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:13am UTC](https://community.nocodb.com/t/heroku-with-aws-lightsail-mar-31/257/2 "2022-11-03T08:13:41Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### for one-click deployment, we are using heroku postgres.

#### 

#### the db connection string is defined in heroku env settings

#### 

#### Go to Heroku \> Choose your app \> Settings \> Config Vars \> Click ‘Reveal Config Vars’ \> DATABASE\_URL

#### 

#### You should see the value like postgres://:@:5432/

#### 

#### however, if you wish to use mysql, you need to remove this and install a mysql plugin to define DATABASE\_URL yourself

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:13am UTC](https://community.nocodb.com/t/heroku-with-aws-lightsail-mar-31/257/3 "2022-11-03T08:13:42Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/958567800329363466)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)
