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"