# CRUD operations manually to the database

**URL:** <https://community.appfarm.io/t/crud-operations-manually-to-the-database/541>\
**Category:** Ask the community\
**Tags:** app-data\
**Created:** [June 19, 2023, 3:49pm UTC](https://community.appfarm.io/t/crud-operations-manually-to-the-database/541 "2023-06-19T15:49:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![2ray](https://avatars.discourse-cdn.com/v4/letter/2/fbc32d/32.png) [@2ray](https://community.appfarm.io/u/2ray)\
**Post date:** [June 19, 2023, 3:49pm UTC](https://community.appfarm.io/t/crud-operations-manually-to-the-database/541/1 "2023-06-19T15:49:54Z")

</div>

Hi! I am wondering if there is a way to manually create, read, update and delete rows in a database during development and testing. I could not find that part in tutorials.

Thank you 🙂

---

<div class="post-metadata">

**Author:** ![kristian](https://dub1.discourse-cdn.com/flex013/user_avatar/community.appfarm.io/kristian/32/58_2.png) [@kristian](https://community.appfarm.io/u/kristian)\
**Post date:** [June 20, 2023, 8:03am UTC](https://community.appfarm.io/t/crud-operations-manually-to-the-database/541/2 "2023-06-20T08:03:22Z")

</div>

Hi! There’s a few ways to generate testdata.

1. Use GraphQL, perform CRUD operations similar to SQL: [GraphQL - Appfarm Documentation](https://docs.appfarm.io/reference/global-data-model/graphql)
2. Create a new App, with actions just for creating and updating testdata, og using `Import Data` action node to import data from CSV

---

<div class="post-metadata">

**Author:** ![2ray](https://avatars.discourse-cdn.com/v4/letter/2/fbc32d/32.png) [@2ray](https://community.appfarm.io/u/2ray)\
**Post date:** [June 20, 2023, 10:37am UTC](https://community.appfarm.io/t/crud-operations-manually-to-the-database/541/3 "2023-06-20T10:37:53Z")

</div>

Oki! I used the “import data” action and now I have the “upload data from CSV” visible. What do I do next?

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/appfarm/original/1X/5924dd43e9d31b552e326ebbf7d705ca88748a5e.png)
