MySQL connection

Retired Boards Appdev Graphql Basics And Troubleshooting

Topic 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.

Summarized with AI on January 28. AI used: gpt-5.
1

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

2

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