# Tunneling with database URLs \[Feb 22\] **URL:** \ **Category:** Discord-Discussions\ **Created:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194 "2022-11-03T07:59:04Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/1 "2022-11-03T07:59:04Z")
> πŸ™‹β€β™‚οΈ **Amin Debabeche** _asked_ ## Hi out there, #### #### I am searching for documentation on database URLs. Indeed I have set-up my Postgres on my own VM but I do not know how to include the tunneling with password in the URL. ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/2 "2022-11-03T07:59:05Z")
> πŸ’ **o1lab** _replied_ #### We use knexjs to connect to databases. #### #### See if you can figure the connection params from knexjs. On working, we can make it work for nocodb too # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/3 "2022-11-03T07:59:06Z")
> πŸ’ **o1lab** _replied_ #### [SQL Query Builder for Javascript | Knex.js](https://knexjs.org/#Installation-client) # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/4 "2022-11-03T07:59:08Z")
> πŸ™‹β€β™‚οΈ **Amin Debabeche** _replied_ #### Do you have an example of JSON file you are using, I find it a bit confusing as the knexjs are usually .js file # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/5 "2022-11-03T07:59:09Z")
> πŸ’ **o1lab** _replied_ #### you can specify NC\_DB\_JSON\_FILE in env variable instead of NC\_DB # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/6 "2022-11-03T07:59:10Z")
> πŸ’ **o1lab** _replied_ #### [https://docs.nocodb.com/getting-started/installation#environment-variables](https://docs.nocodb.com/getting-started/installation#environment-variables) # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/7 "2022-11-03T07:59:11Z")
> πŸ™‹β€β™‚οΈ **Amin Debabeche** _replied_ #### If not using ssh tunneling, what tech would you be using to connect to a postgres server ? # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/8 "2022-11-03T07:59:12Z")
> πŸ™‹β€β™‚οΈ **Amin Debabeche** _replied_ #### Yeah that is the matter with the environnement variable, it’s written to use a JSON file but I see only javascript file out there when used with knexjs # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/9 "2022-11-03T07:59:13Z")
> πŸ’ **o1lab** _replied_ #### knexjs takes an object, so the JSON file contents will be translated into an object # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/10 "2022-11-03T07:59:15Z")
> πŸ’ **o1lab** _replied_ #### hope it makes sense # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/11 "2022-11-03T07:59:16Z")
> πŸ™‹β€β™‚οΈ **Amin Debabeche** _replied_ #### okok # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/12 "2022-11-03T07:59:18Z")
> πŸ™‹β€β™‚οΈ **Amin Debabeche** _replied_ #### because it does not seem the simpliest way # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/13 "2022-11-03T07:59:19Z")
> πŸ’ **o1lab** _replied_ #### sorry, i didnt get what you mean by tunneling # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/14 "2022-11-03T07:59:20Z")
> πŸ’ **o1lab** _replied_ #### like connecting via ssh keys ? # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/15 "2022-11-03T07:59:21Z")
> πŸ™‹β€β™‚οΈ **Amin Debabeche** _replied_ #### I do not think that ssh keys are accessible on my side, it seems like we prefer to have it disabled as a security reason. # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/16 "2022-11-03T07:59:23Z")
> πŸ™‹β€β™‚οΈ **Amin Debabeche** _replied_ #### because I am hosting my own postgres server but I have some difficulties accessing as not all service (such as NocoDB) offer the possibility to connect via ssh # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/17 "2022-11-03T07:59:24Z")
> πŸ’ **o1lab** _replied_ #### [SSL metadata DB Β· nocodb/nocodb Β· Discussion #838 Β· GitHub](https://github.com/nocodb/nocodb/discussions/838) # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:59am UTC](https://community.nocodb.com/t/tunneling-with-database-urls-feb-22/194/18 "2022-11-03T07:59:25Z")
[Autogenerated from discord](https://discord.com/channels/661905455894888490/945294983756398623) * * * #### Join [NocoDB’s](http://www.nocodb.com/) community [Discord](https://discord.gg/5RgZmkW) β€’ [Twitter](https://twitter.com/nocodb) β€’ [Reddit](https://www.reddit.com/r/NocoDB/) β€’ [Docs](https://docs.nocodb.com/)