# Connect to remote database

**URL:** <https://forum.wixstudio.com/t/connect-to-remote-database/25879>\
**Category:** Ask the community\
**Tags:** code\
**Created:** [January 13, 2018, 6:32am UTC](https://forum.wixstudio.com/t/connect-to-remote-database/25879 "2018-01-13T06:32:35Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![brian-alderson](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/brian-alderson/32/780_2.png) [@brian-alderson](https://forum.wixstudio.com/u/brian-alderson)\
**Post date:** [January 13, 2018, 6:32am UTC](https://forum.wixstudio.com/t/connect-to-remote-database/25879/1 "2018-01-13T06:32:35Z")

</div>

It would be great if developers could connect and send SQL queries to their own remote databases like mySQl. MSSQL etc. instead of importing csv files.

I had to write an API to access my remote DB which took a while.

---

<div class="post-metadata">

**Author:** ![apostolis-stephanou0](https://avatars.discourse-cdn.com/v4/letter/a/e9a140/32.png) [@apostolis-stephanou0](https://forum.wixstudio.com/u/apostolis-stephanou0)\
**Post date:** [February 8, 2018, 7:50pm UTC](https://forum.wixstudio.com/t/connect-to-remote-database/25879/2 "2018-02-08T19:50:54Z")

</div>

I agree. Wix Code is amazing but I feel this is an essential feature since we can already create HTTP endpoints for our data.

This is currently the primary (only in some cases) reason for not using wix for some projects.

---

<div class="post-metadata">

**Author:** ![dotnetindo](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/dotnetindo/32/3964_2.png) [@dotnetindo](https://forum.wixstudio.com/u/dotnetindo)\
**Post date:** [May 19, 2018, 1:46am UTC](https://forum.wixstudio.com/t/connect-to-remote-database/25879/3 "2018-05-19T01:46:36Z")

</div>

yes im expecting this feature also, please make it happen

---

<div class="post-metadata">

**Author:** ![miguelesvida](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/miguelesvida/32/6756_2.png) [@miguelesvida](https://forum.wixstudio.com/u/miguelesvida)\
**Post date:** [November 15, 2018, 5:42pm UTC](https://forum.wixstudio.com/t/connect-to-remote-database/25879/4 "2018-11-15T17:42:17Z")

</div>

UPDATE {}  
if you connect a rest api to your sql database you can access json responses to query with wix a remote database. Only wix code for now which is also just javascript.

if you want to connect a remote app like a java interface you can build an api for your wix website inside the wix platform with http-function from wix code too. From there you can start the http function to query and fetch data inside java

---

<div class="post-metadata">

**Author:** ![miguelesvida](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/miguelesvida/32/6756_2.png) [@miguelesvida](https://forum.wixstudio.com/u/miguelesvida)\
**Post date:** [November 15, 2018, 5:43pm UTC](https://forum.wixstudio.com/t/connect-to-remote-database/25879/5 "2018-11-15T17:43:30Z")

</div>

So you can access remote databases and query externally your wix collections… I am new to javascript but I didnt rest to find a way out. Yes you need to use the wix code, yes I don’t work for wix, And yes I read the whole wix documentation for wixcode

---

<div class="post-metadata">

**Author:** ![\_dan-1](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/_dan-1/32/1737_2.png) [@\_dan-1](https://forum.wixstudio.com/u/_dan-1)\
**Post date:** [November 20, 2018, 9:36am UTC](https://forum.wixstudio.com/t/connect-to-remote-database/25879/6 "2018-11-20T09:36:52Z")

</div>

You can install mysql, mongodb, GoogleCloud or AWS NPM packages, and access you remote DB from your backend code. To do that, click the plus sign (+) next to the “backend” code on the left panel, and choose “Install NPM package”.  
You can then import it from your backend code and use it as you want.  
If you’re missing a specific NPM for your DB, you can ask Wix to add it from within the NPM install dialog.

---

<div class="post-metadata">

**Author:** ![miguelesvida](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/miguelesvida/32/6756_2.png) [@miguelesvida](https://forum.wixstudio.com/u/miguelesvida)\
**Post date:** [November 21, 2018, 7:25am UTC](https://forum.wixstudio.com/t/connect-to-remote-database/25879/7 "2018-11-21T07:25:22Z")

</div>

Yes this would be the best way

see

> **[GitHub - mysqljs/mysql: A pure node.js JavaScript Client implementing the...](https://github.com/mysqljs/mysql#readme)**
>
> A pure node.js JavaScript Client implementing the MySQL protocol. - GitHub - mysqljs/mysql: A pure node.js JavaScript Client implementing the MySQL protocol.

---

<div class="post-metadata">

**Author:** ![polignano\_francis](https://avatars.discourse-cdn.com/v4/letter/p/43a26b/32.png) [@polignano\_francis](https://forum.wixstudio.com/u/polignano_francis)\
**Post date:** [December 17, 2018, 8:32pm UTC](https://forum.wixstudio.com/t/connect-to-remote-database/25879/8 "2018-12-17T20:32:24Z")

</div>

Hi - I’m in the process of trying to connect to an external mysql DB. Is using NPM mysql the best way to do this currently? I’ve installed it on the backend but get an error “require” is not defined when I try to use the code from here [mysql - npm](https://www.npmjs.com/package/mysql)

---

<div class="post-metadata">

**Author:** ![admin18466](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/admin18466/32/7956_2.png) [@admin18466](https://forum.wixstudio.com/u/admin18466)\
**Post date:** [January 5, 2019, 2:47pm UTC](https://forum.wixstudio.com/t/connect-to-remote-database/25879/9 "2019-01-05T14:47:00Z")

</div>

Or… Wix support for Zapier, as a standard offering vs. the current Wix answer of developing Wix API code.

---

<div class="post-metadata">

**Author:** ![yoav-wix](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/yoav-wix/32/674_2.png) [@yoav-wix](https://forum.wixstudio.com/u/yoav-wix)\
**Post date:** [August 22, 2019, 8:34am UTC](https://forum.wixstudio.com/t/connect-to-remote-database/25879/10 "2019-08-22T08:34:47Z")

</div>

Hey, you can connect to an external database - check it out here -  
[https://www.wix.com/corvid/feature/external-database-collections](https://www.wix.com/corvid/feature/external-database-collections)
