influxdb

Master InfluxDB with our comprehensive cheatsheet. Learn essential commands for connecting, creating databases, managing measurements, and querying data.

InfluxDB Cheatsheet

InfluxDB Cheatsheet

This cheatsheet provides essential InfluxDB commands for efficient database management and data querying. InfluxDB is a popular open-source time series database designed for handling high-volume data from applications, IoT devices, and monitoring systems.

Connect to InfluxDB

Use the InfluxDB CLI to connect to your running InfluxDB instance.

$ influx

Create Database

Create a new database to store your time series data.

> create database test

List Databases

View all existing databases on your InfluxDB instance.

> show databases

Select a Database

Switch to a specific database to perform operations within it.

> use test

List Measurements

Display all available measurements within the currently selected database.

> show measurements

Query Data from a Measurement

Retrieve all data points from a specific measurement. Replace 'bar' with your measurement name.

> select * from bar

Drop a Measurement

Remove a measurement and all its associated data. Use with caution.

> drop measurement bar

Show Field Keys

Inspect the field keys (columns) present in a specific measurement.

> show field keys from "bar-A1"

Further Resources