# MySQL connection

**URL:** <https://community.shopify.com/t/mysql-connection/211151>\
**Category:** Graphql Basics And Troubleshooting\
**Tags:** Setting-Up\
**Created:** [April 25, 2023, 3:09pm UTC](https://community.shopify.com/t/mysql-connection/211151 "2023-04-25T15:09:29Z")\
**Posts on this page:** 2\
**Page:** 1

## AI-generated summary

- Goal: Connect directly to a Shopify store’s database (via host/port/username/password) to run SQL, avoiding REST or GraphQL.

- Constraint: Shopify is a closed SaaS platform and does not expose its underlying database (e.g., MySQL) for direct connections.

- Access methods: The only supported ways to retrieve data are through Shopify’s APIs:
  - REST API (a web interface using HTTP endpoints).
  - GraphQL API (a query language for APIs that lets clients request specific data shapes).

- Outcome: Direct MySQL access is not possible; using Shopify’s official APIs is required for any data retrieval.

- Status: Resolved with a definitive answer; no DB credentials can be used to connect, and the suggested alternative is to use REST or GraphQL APIs.

<div class="post-metadata">

**Author:** ![Davidifrah](https://avatars.discourse-cdn.com/v4/letter/d/a6a055/32.png) [@Davidifrah](https://community.shopify.com/u/Davidifrah)\
**Post date:** [April 25, 2023, 3:09pm UTC](https://community.shopify.com/t/mysql-connection/211151/1 "2023-04-25T15:09:29Z")

</div>

Hi,

Do you know how I can connect a database management platform to my Shopify store database. I want to retrieve my data by connecting with host/port/username/password to the Shopify MySQL database and then use SQL. I do not want to use REST API or GraphQL.

Best,

David

---

<div class="post-metadata">

**Author:** ![garyrgilbert](https://yyz1.discourse-cdn.com/shopifyforum/user_avatar/community.shopify.com/garyrgilbert/32/193485_2.png) [@garyrgilbert](https://community.shopify.com/u/garyrgilbert)\
**Post date:** [April 27, 2023, 6:11pm UTC](https://community.shopify.com/t/mysql-connection/211151/2 "2023-04-27T18:11:31Z")

</div>

I don’t think you are going to have luck with that.

Shopify is a closed system, the ONLY way to access anything in shopify is through the API’s. You will never gain access to Shopify’s underlying database… ever… I think hell will first feeze over before they give anyone access.

Cheers,

Gary
