# It's Prisma Time - Create Db

> Hi Guys 👋 welcome back. Finally, today it's time to create our database, so don't waste time, and get...

- **Author**: Luca Del Puppo (@puppo92) — AI Native Engineer at Nearform
- **Published**: Dec 23, 2021
- **Canonical URL**: https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-create-db/
- **Series**: It's Prisma Time (Part 4 of 16) — https://delpuppo.net/blog/series/it-s-prisma-time/
- **Series LLMs.txt**: https://delpuppo.net/blog/series/it-s-prisma-time/llms.txt
- **Category**: It's Prisma Time
- **Tags**: javascript, typescript, database, orm
- **Hashnode Mirror**: https://blog.delpuppo.net/its-prisma-time-create-db
- **Dev.to Mirror**: https://dev.to/playfulprogramming/its-prisma-time-create-db-3e8n
- **Blog Index LLMs.txt**: https://delpuppo.net/blog/llms.txt

## Series Context: It's Prisma Time

- Part 1: [It's Prisma Time - Introduction](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-introduction/)
- Part 2: [It's Prisma Time - Setup](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-setup/)
- Part 3: [It's Prisma Time - Create Table](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-create-table/)
- Part 4: [It's Prisma Time - Create Db](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-create-db/) **(Current Article)**
- Part 5: [It's Prisma Time - Create Relations](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-create-relations/)
- Part 6: [It's Prisma Time - Insert](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-insert/)
- Part 7: [It's Prisma Time - Delete](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-delete/)
- Part 8: [It's Prisma Time - Update](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-update/)
- Part 9: [It's Prisma Time - Select](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-select/)
- Part 10: [It's Prisma Time - Pagination](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-pagination/)
- Part 11: [It's Prisma Time - Aggregate and GroupBy](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-aggregate-and-groupby/)
- Part 12: [It's Prisma Time - Transactions](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-transactions/)
- Part 13: [It's Prisma Time - Logging](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-logging/)
- Part 14: [It's Prisma Time - Execute your own queries](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-execute-your-own-queries/)
- Part 15: [It's Prisma Time - Migrations](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-migrations/)
- Part 16: [It's Prisma Time - Seeding](https://delpuppo.net/blog/it-s-prisma-time/its-prisma-time-seeding/)

---

Hi Guys 👋
welcome back.
Finally, today it's time to create our database, so don't waste time, and get started.
How can you create your database?
It's simple! You have to run the following script:
```
npx prisma db push
```
This script creates in your `prisma` folder a SQLite database called `dev.db`.
The database's name is taken from the variable `DATABASE_URL` in the `.env` file and inside of the file you can find the next table.
![Post Table](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/omgblt1n17m43g3ye3pz.png)
Ok, now you have your database so it's time to get back at the challenge left open last article.
Run the script
```
yarn dev
```
```console
{ posts: [] }
```
![it's work](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/va4l54jb21hltymty4ow.jpeg)
Ok, there aren't data but it works 🥳
So now you have a database and you can search data inside it, at this point, it's time to create relations between our entities, but it's the goal of the next article 🤪

That's all for today guys!
See you soon
Bye Bye 👋


_You can find the code relative to this post [in the GitHub repository](https://github.com/Puppo/it-s-prisma-time/tree/04-create-db)_