TiDBTiDB Docs Dash 2024

Jan 9 - Jan 12 (UTC)
Join us to improve docs and win a prize!
Sign InTry Free

TiDB Cloud Serverless Driver Node.js Tutorial

This tutorial describes how to use TiDB Cloud serverless driver in a local Node.js project.

Before you begin

To complete this step-by-step tutorial, you need the following:

Step 1. Create a local Node.js project

  1. Create a project named node-example:

    mkdir node-example cd node-example
  2. Install the TiDB Cloud serverless driver using npm or your preferred package manager.

    The following command takes installation with npm as an example. Executing this command will create a node_modules directory and a package.json file in your project directory.

    npm install @tidbcloud/serverless

Step 2. Use the serverless driver

The serverless driver supports both CommonJS and ES modules. The following steps take the usage of the ES module as an example.

  1. On the overview page of your TiDB Cloud Serverless cluster, click Connect in the upper-right corner, and then get the connection string for your database from the displayed dialog. The connection string looks like this:

    mysql://[username]:[password]@[host]/[database]
  2. In the package.json file, specify the ES module by adding type: "module".

    For example:

    { "type": "module", "dependencies": { "@tidbcloud/serverless": "^0.0.7", } }
  3. Create a file named index.js in your project directory and add the following code:

    import { connect } from '@tidbcloud/serverless' const conn = connect({url: 'mysql://[username]:[password]@[host]/[database]'}) // replace with your TiDB Serverless cluster information console.log(await conn.execute("show tables"))
  4. Run your project with the following command:

    node index.js

Compatability with earlier versions of Node.js

If you are using Node.js earlier than 18.0.0, which does not have a global fetch function, you can take the following steps to get fetch:

  1. Install a package that provides fetch, such as undici:

    npm install undici
  2. Pass the fetch function to the connect function:

    import { connect } from '@tidbcloud/serverless' import { fetch } from 'undici' const conn = connect({url: 'mysql://[username]:[password]@[host]/[database]',fetch})

Was this page helpful?

Download PDFRequest docs changesAsk questions on Discord
Playground
New
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
Products
TiDB
TiDB Dedicated
TiDB Serverless
Pricing
Get Demo
Get Started
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.