# Spin up a dbt+Postgres environment with a single click in VS Code for demos and interview assignments

**URL:** <https://discourse.getdbt.com/t/spin-up-a-dbt-postgres-environment-with-a-single-click-in-vs-code-for-demos-and-interview-assignments/5285>\
**Category:** Show and Tell\
**Created:** [November 6, 2022, 4:26am UTC](https://discourse.getdbt.com/t/spin-up-a-dbt-postgres-environment-with-a-single-click-in-vs-code-for-demos-and-interview-assignments/5285 "2022-11-06T04:26:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![panasenco](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/panasenco/32/1178_2.png) [@panasenco](https://discourse.getdbt.com/u/panasenco)\
**Post date:** [November 6, 2022, 4:26am UTC](https://discourse.getdbt.com/t/spin-up-a-dbt-postgres-environment-with-a-single-click-in-vs-code-for-demos-and-interview-assignments/5285/1 "2022-11-06T04:26:30Z")

</div>

Being able to spin up a fully functioning dbt environment is very useful for interview assignments and quick demos. I created a template using [dev containers](https://containers.dev) that allows you to spin up dbt + Postgres + Adminer in a single click right from VS Code. Check it out and make sure to star if you find it useful!

> **[GitHub - panasenco/dbt-devcontainer-demo-template: Template to create...](https://github.com/panasenco/dbt-devcontainer-demo-template)**
>
> Template to create self-contained dev container demos of transforming data with dbt. Useful for interviews. - GitHub - panasenco/dbt-devcontainer-demo-template: Template to create self-contained de...

---

<div class="post-metadata">

**Author:** ![infl](https://avatars.discourse-cdn.com/v4/letter/i/edb3f5/32.png) [@infl](https://discourse.getdbt.com/u/infl)\
**Post date:** [November 6, 2022, 7:06am UTC](https://discourse.getdbt.com/t/spin-up-a-dbt-postgres-environment-with-a-single-click-in-vs-code-for-demos-and-interview-assignments/5285/2 "2022-11-06T07:06:04Z")

</div>

Good job, maybe add a big seed at once? Superstore or something similar

---

<div class="post-metadata">

**Author:** ![panasenco](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/panasenco/32/1178_2.png) [@panasenco](https://discourse.getdbt.com/u/panasenco)\
**Post date:** [November 6, 2022, 4:27pm UTC](https://discourse.getdbt.com/t/spin-up-a-dbt-postgres-environment-with-a-single-click-in-vs-code-for-demos-and-interview-assignments/5285/3 "2022-11-06T16:27:25Z")

</div>

Thanks @infl, feel free to contribute a starter data set and/or data model!

---

<div class="post-metadata">

**Author:** ![joellabes](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/joellabes/32/3980_2.png) [@joellabes](https://discourse.getdbt.com/u/joellabes)\
**Post date:** [November 25, 2022, 8:20am UTC](https://discourse.getdbt.com/t/spin-up-a-dbt-postgres-environment-with-a-single-click-in-vs-code-for-demos-and-interview-assignments/5285/4 "2022-11-25T08:20:47Z")

</div>

I just tried this, super easy! Thank you for writing a great readme 🎉
