Database Nodes

Connect your flows to various database systems. From lightweight embedded SQLite for edge devices to enterprise PostgreSQL and time-series InfluxDB for sensor data.

6 Databases

5 Types

SQL & NoSQL

Types:

Embedded No server needed

Relational SQL databases

NoSQL Document stores

Cache In-memory

Time Series Metrics & IoT

Jump to:

sqlite postgresql mysql mongodb redis influxdb

sqlite

Popular Embedded

Lightweight embedded database perfect for edge devices. No server required.

Type Embedded file-based

Storage Single .db file

Transactions Full ACID

Size Limit 281 TB

Configuration

{cfg.key} string Path to .db file

{cfg.key} string "query" | "batch" | "prepared"

{cfg.key} string SQL statement

{cfg.key} array Query parameters

Output Example

{node.details.output}

Perfect for edge devices. Zero config - just specify file path. Use WAL mode for better read performance.

postgresql

Popular Relational

Connect to PostgreSQL databases for enterprise-grade data storage.

Protocol PostgreSQL wire

SSL/TLS Full encryption

Pooling Configurable

Features JSONB, arrays

Configuration

{cfg.key} string Database hostname

{cfg.key} number 5432 (default)

{cfg.key} string Database name

{cfg.key} boolean Enable TLS

Output Example

{node.details.output}

Use connection pooling for high-throughput flows. Supports parameterized queries for security.

mysql

Relational

MySQL/MariaDB database connectivity for web applications.

Protocol MySQL protocol

Compatible MySQL 5.7+

SSL/TLS Secure connections

Charset UTF-8 default

Configuration

{cfg.key} string Database hostname

{cfg.key} number 3306 (default)

{cfg.key} string Database name

{cfg.key} string "utf8mb4" recommended

Output Example

{node.details.output}

Use utf8mb4 charset for full emoji/unicode support. MariaDB is fully compatible.

mongodb

NoSQL

NoSQL document database for flexible schema-less data storage.

Type Document NoSQL

Schema Flexible, dynamic

Operations CRUD, aggregate

Indexes Text, geo, compound

Configuration

{cfg.key} string mongodb://host:27017/db

{cfg.key} string Collection name

{cfg.key} string "find" | "insert" | "update"

{cfg.key} object MongoDB query object

Output Example

{node.details.output}

Great for variable sensor data schemas. Use aggregation pipeline for complex analytics.

redis

Popular Cache

In-memory data store for caching, queuing, and real-time analytics.

Type In-memory KV

Structures Strings, lists, sets

Pub/Sub Built-in messaging

Persistence RDB, AOF

Configuration

{cfg.key} string Redis hostname

{cfg.key} number 6379 (default)

{cfg.key} string GET, SET, HSET, etc.

{cfg.key} number Expiration seconds

Output Example

{node.details.output}

Ideal for caching API responses. Use TTL to auto-expire stale data. Pub/Sub for real-time messaging.

influxdb

Popular Time Series

Time-series database optimized for IoT sensor data and metrics.

Type Time-series DB

Query InfluxQL, Flux

Retention Auto expiration

Compression High ratio

Configuration

{cfg.key} string http://localhost:8086

{cfg.key} string API token (v2)

{cfg.key} string Bucket name

{cfg.key} string Measurement name

Output Example

{node.details.output}

Purpose-built for IoT sensor data. Set retention policies to auto-delete old data. Integrates with Grafana.

Which Database Should I Use?

sqlite → Edge devices, local storage, prototyping

Zero configuration, file-based. Perfect for Raspberry Pi and offline-capable systems.

influxdb → Sensor data, metrics, time-series

Purpose-built for IoT. Automatic downsampling, retention policies, and Grafana integration.

redis → Caching, real-time, message queues

Blazing fast in-memory storage. Use for caching API responses or inter-flow communication.

postgresql → Production apps, complex queries, ACID

Enterprise-grade reliability. Supports JSON, full-text search, and advanced features.

Best Practices

Batch Writes

Use the batch node before database writes to reduce query overhead and improve throughput.

Secure Credentials

Store credentials in environment variables, not in node configuration. Use secrets management.

SQL Injection

All database nodes support parameterized queries. Never concatenate user input into SQL strings.

Connection Pooling

Enable connection pooling for high-throughput flows to avoid the overhead of creating new connections.

Continue Learning

Cloud Storage Store files in S3, GCS, and more

Sensor Nodes Collect data to store in databases