# Sql database

**URL:** <https://community.shopify.com/t/sql-database/72380>\
**Category:** Graphql Basics And Troubleshooting\
**Created:** [October 16, 2021, 6:05pm UTC](https://community.shopify.com/t/sql-database/72380 "2021-10-16T18:05:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Stam2](https://avatars.discourse-cdn.com/v4/letter/s/bc79bd/32.png) [@Stam2](https://community.shopify.com/u/Stam2)\
**Post date:** [October 16, 2021, 6:05pm UTC](https://community.shopify.com/t/sql-database/72380/1 "2021-10-16T18:05:14Z")

</div>

What is the best way to connect a physical retail stores SQL database to Shopify.

Want to send SQL data like Product features, prices, inventory levels, (from SQL to SHOPIFY)

Want to send SHOPIFY data like Customer info, Orders, etc. (from SHOPIFY to SQL)

and can this be setup to work instantaneously.

???

---

<div class="post-metadata">

**Author:** ![BundleSync](https://yyz1.discourse-cdn.com/shopifyforum/user_avatar/community.shopify.com/bundlesync/32/155643_2.png) [@BundleSync](https://community.shopify.com/u/BundleSync)\
**Post date:** [October 18, 2021, 5:03am UTC](https://community.shopify.com/t/sql-database/72380/2 "2021-10-18T05:03:01Z")

</div>

Hi

If on premises rather than cloud based you would need to develop a native app and connect the data with Shopify API: [https://shopify.dev/api/admin](https://shopify.dev/api/admin)

If the SQL database is cloud based I’m guessing it must be used by some sort of software to access it. You need to check if that software has any integration possibilities via API etc which could then be used to link data to Shopify.

Regards

Tom
