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"