Skip to main content

Node.js Driver for Databend

The official Node.js driver providing TypeScript support and Promise-based API for modern JavaScript applications.

Installation

npm install databend-driver

Connection String: See Drivers Overview for DSN format and connection examples.


Key Features

  • TypeScript Support: Full TypeScript definitions included
  • Promise-based API: Modern async/await support
  • Streaming Results: Efficient handling of large result sets
  • Connection Pooling: Built-in connection management

Data Type Mappings

DatabendNode.jsNotes
Basic Types
BOOLEANboolean
TINYINTnumber
SMALLINTnumber
INTnumber
BIGINTnumber
FLOATnumber
DOUBLEnumber
DECIMALstringPrecision preserved
STRINGstring
Date/Time
DATEDate
TIMESTAMPDate
Complex Types
ARRAY(T)Array
TUPLE(...)Array
MAP(K,V)Object
VARIANTstringJSON encoded
BINARYBuffer
BITMAPstringBase64 encoded

Basic Usage

const { Client } = require('databend-driver');

// Connect to Databend
const client = new Client('<your-dsn>');
const conn = await client.getConn();

// DDL: Create table
await conn.exec(`CREATE TABLE users (
id INT,
name STRING,
email STRING
)`);

// Write: Insert data
await conn.exec("INSERT INTO users VALUES (?, ?, ?)", [1, "Alice", "alice@example.com"]);

// Query: Select data
const rows = await conn.queryIter("SELECT id, name, email FROM users WHERE id = ?", [1]);
for await (const row of rows) {
console.log(row.values());
}

conn.close();

Resources

Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today